Skip to main content

Purpose

The purpose of this quick reference guide is to step through the process of creating a Variance Report within a Pay Batch. The intended audience for this document is Standard Payroll Users. This report is only able to be run from the Pay Batch Manager page and is normally done before the Pay Batch is Payment File Released, to identify variances between the current Pay Batch and another previously processed Pay Batch.

Steps

Create a Variance Report

To create a Variance Report, the following steps should be completed. Please skip to step 4, if you already have the Pay Batch Manager UI open on your screen:
  1. Click on the App Launcher icon (see Figure 1).
Screenshot from QRG Create a Variance Report
  1. Go to the Pay Batches object by using the Search function (see Figure 2).
Screenshot from QRG Create a Variance Report
  1. From the List View, select the Pay Batch you want to review with a status of Calculated, Finalised, Pay Advices Created, or Payment File Created, and click the Launch button (see Figure 3).
Screenshot from QRG Create a Variance Report
  1. Click on the Reporting navigation icon (see Figure 2).
Screenshot from QRG Create a Variance Report
  1. On the Reporting page, the following required fields must be populated: (see Figure 3)
    1. Pay Run 1 defaults to the current Pay Batch and is not able to be changed.
    2. Variance Type may be pre-populated already if this is defined on the related Pay Schedule. If this is blank, or you want to make a change for the current report you will be generating, Users should select from the available picklist values.
    3. Variance Threshold may be pre-populated already if this is defined on the related Pay Schedule. If this is blank or you want to make a change for the current report you will be generating, Users should populate with the Value or Percentage.
    4. Pay Run 2 must be populated with the Pay Batch to be used to compare with Pay Run 1.
Screenshot from QRG Create a Variance Report
  1. Click on the Generate button (see Figure 4).
Screenshot from QRG Create a Variance Report
  1. The Variance Report creation process will begin (see Figure 5).
Screenshot from QRG Create a Variance Report
  1. You will see a confirmation message displayed briefly in the Pay Batch Manager heading once the Variance Report has been created. A new Variance Report CSV file will appear at the bottom of the page. Please click on the CSV file link to download it (see Figure 6).
Screenshot from QRG Create a Variance Report
  1. Each report created from a Pay Batch will remain appearing on the Reporting page, with the identifier between the reports being the date and time it was run within the name on the Report (see Figure 7).
  2. Open the CSV file to review the data displayed in the Variance Report within Excel.
Screenshot from QRG Create a Variance Report

Field Descriptions

Further Information