A Payroll Variation Report is available in Payroll > [Payroll frequency] > Reports. It allows you to identify the differences in key components of Payroll between This Period and Last Period. It can help Payroll personnel to better review what has been processed in Payroll.
Selection Screen
When you select Payroll Variation Report from the Reports menu, the report selection screen appears, as shown in Report Selection Screen. Here you can select the periods you wish to compare with the key components of payroll. The key components you select are based on the payroll region you are using; for example, Report Selection Screen shows the US Region screen. Samples of the remaining Region screens are shown in the next section.
Report Selection Screen
Field Definitions
This Period
Last Period
Enter the periods to use for comparison. This Period does not need to be a posted period; however, only calculated data are included.
Data for any employee is included in This Period. If an employee does not have data in the Last Period, it is displayed as $0.
For any region that allows multiple payroll cheques in a single period, you should only evaluate Cheque 1 for This Period to Cheque 1 for Last Period.
INCLUDE
The options you can select under INCLUDE are as follows:
Gross – Shows the variation for the Gross Item on the report.
Net Pay – Shows the variation for the Net Pay Item on the report.
Burden – Shows the variation for the Burden Item on the report.
FWT – Shows the variation for the FWT Item on the report.
SWT – Shows the variation for the SWT Item on the report.
Sort Order
If TS Input Groups are not in use or This Payroll is posted, sorting is done by Payroll Component by Employee.
Report Layout
A report is created after you fill out the report selection screen and select Next. A sample of the US Region report layout is shown in Sample Report Layout (US Region).
Various subtotals that may be shown on the report are as follows:
Subtotal by TS Input Group by Pay Component
Subtotal by TS Input Group
Grand Total
Sample Report Layout (US Region)
Report Column Definitions (Selected)
YTD Amount
The YTD Amount for component for employee including This Period payroll, if unposted.
Last Pay Amount
The Per Cheque amount for Cheque 1 from the Last Period (from selection criteria).
This Pay Amount
The Per Cheque amount for Cheque 1 for This Period (from selection criteria).
Variance
This Pay Amount less Last Pay Amount.
Variance Percentage
The Variance / Last Pay Amount.