Overview of Payroll Balances Reports

Use the payroll balances reports to view the balance calculations of the payroll run. It helps you compare the details of the balance results with the archived data and also detect overpayments or underpayments for a payroll run.

This table lists the payroll balance reports.

Report	Purpose	When to Run	Example of Usage
Payroll Balance Report	View balance results of the payroll run. Extracts the run balance results for a specific period. Supplies detailed balance information for a specific employee over a defined period of time.	Run as needed for diagnostic purposes.	Verify the values of other reports. You can use this report to pinpoint a problem discovered by another report.
Employee Active Payroll Balance Report	View the current values for any given list of employee balances. Compare this data against the archived data to assist in reconciling your periodic payrolls and quarterly and year-end balances. This report also helps you to determine if you have any tax balances over the statutory limits, such as Social Security.	Run the report after successful completion of any payroll action, such as a payroll run, QuickPay, reversal, balance adjustment, or balance initialization.	View live payroll balances for matching employees, filtered by parameters and time-frames.
Balance Exception Report	Run this report to identify potentially incorrect payments or amounts withheld. The report identifies values that vary for the same balance dimension. This variance could indicate overpayments or underpayments.	Run the report after successful completion of a payroll run or QuickPay.	You can create a balance exception and run this report to compare the total payments made to your employees for the current payroll period with the payments you made in the previous payroll period.

Payroll Balance Report

Use this report to view detailed balance information for a person over a defined period of time. You can compare this information with the archived data for validating and reconciling periodic payroll balances.

When to Run Report

You can run this report as needed for diagnostic purposes.

Parameters to Consider

Parameter values determine which records to include in a report. Most parameters are self-explanatory, but some of them, as mentioned in this table have special meaning in the context of the report.

Payroll Balance Report Parameters

Parameter Name	Description
Balance Category	Use this field to run this report for a specific balance category including information balances. Before you use this field, you must configure the balance group usage item to display information balances in this report.
Display All Hours	Select Yes to include hours from Supplemental Earnings and other element classifications. The default value is No and only hours from Regular or Standard Earnings and Absence Earnings are shown in the report.

Report Output

The report provides details of payroll balance results for matching persons, filtered by the specified time frame and the selected parameters. The output file includes:

• Payroll Statutory Unit
• Employee Name

• Tax Reporting Unit

• Employment Number
• Run Type
• Balance Category

• Balance Name

• Balance Amount

Employee Active Payroll Balance Report

Run the Employee Active Payroll Balance report to view the current values for any given list of employee balances. Compare this data against the archived data to assist in reconciling your periodic payrolls and quarterly and year-end balances. This report also helps you to determine if you have any tax balances over the statutory limits, such as Social Security.

When to Run Report

Run this report after successful completion of any payroll action, such as a payroll run, QuickPay, reversal, balance adjustment, or balance initialization.

Parameters to Consider

Parameter values determine which records to include in a report. Most parameters are self-explanatory, but some of them, as mentioned in this table have special meaning in the context of the report.

Employee Active Payroll Balance Report Parameters

Parameter Name	Description
Start Date	If you include the Run Balance values, specify the start date. This date must coincide with the date of the selected payroll run.
End Date	Specify the effective date for balance retrieval. When you capture balance values across a range of dates, this represents the end of the range.
Balance Dimension	Select any of these balance dimension you want to review: Run Month Year Note: The Run option can cause performance issues if your selection results include many people, and span a long period of time, as indicated by the Start Date and End Date parameters.

Report Output

This report produces a pipe-delimited text file containing all live payroll balances for matching employees, filtered by parameters and time-frames. You can open this file in Microsoft Excel for additional filtering. If no employee balances match your report parameter criteria, the report returns an output file with no data.

For example, if you don’t select Yes for any of the Include Balance Values fields, the report captures no balances. The output file is empty.

The output file includes:

• Payroll balance information
• Tax Reporting Unit
• Employee name and number
• Payroll relationship number
• Run type (Run level only)

Balance Exception Report

Use the Balance Exception Report to identify potentially incorrect payments or amounts withheld. The report identifies values that vary for the same balance dimension. This variance could indicate overpayments or underpayments.

For more details on Balance Exceptions, refer the How do I set up and report balance exceptions? playbook.