Summary of Payroll Calculation and Balancing Reports

As a payroll manager, you can use these reports to identify and verify payroll calculations and payroll run results.

Report

Purpose

When to Run

Example of Usage

Deduction Report

View details of payroll deduction amounts processed every pay period.

Run every pay period.

Validate the deduction amounts processed.

Element Results Register

View a list of elements and their primary output values for processes that generate run results.

Usually run every pay period after running the Payroll Activity Report.

Review run results for payroll processes. Create a pivot table to obtain totals.

During implementation, reconcile run results with the results produced by your legacy payroll.

Payroll Register Report

Verify, validate, and audit payroll calculations.

After calculating payroll and archiving periodic payroll results.

Use the summary report to verify total payment amounts per balance category for a payroll period for a payroll statutory unit or a tax reporting unit.

Use the detail report to review the complete payroll run details for each employee to balance and reconcile payroll and to compare the payment values to previous periods.

The report lists the current and year-to-date hours worked for each person included in the report.

Payroll Register Report for the Latest Process Verify, validate, and audit payroll calculations. After calculating payroll and archiving periodic payroll results.

Use this report to extract the year-to-date (YTD) payroll balances for large volumes of data.

Periodic Payroll Register Report Verify, validate, and audit payroll calculations. After calculating payroll and archiving periodic payroll results. Use this report to extract the periodic payroll balances for large volumes of data.

Statutory Deduction Register

View statutory deductions such as employee and employer tax liabilities.

Run every pay period.

Review and validate Period-to-Date and Year-to-Date information of deductions listed against each employee categorized by PSU, TRU and element classification.

Statutory Deduction Register for the Latest Process View statutory deductions such as employee and employer tax liabilities. Run every pay period. Use this report to extract the year-to-date (YTD) payroll balances for large volumes of data.
Periodic Statutory Deduction Register View statutory deductions such as employee and employer tax liabilities. Run every pay period. Use this report to extract the periodic payroll balances for large volumes of data.

Gross-to-Net Report

View summary or detail listings for the total results calculated in the payroll run.

Control which results to view by specifying a date range that includes the process dates of the payroll calculations. The report displays the balances for the payroll period in which the process date occurs.

Run after each payroll run or, at a minimum, on a quarterly basis.

Review balances generated from payroll run, QuickPay, and payroll reversal calculations before calculating prepayments.

Payroll Activity Report

View details of the payroll run, QuickPay, such as balance adjustments, reversals, and balance initializations, taxes withheld, earnings, deductions, payment information, employer liability, and quarter and year-to-date details.

Run the report before processing prepayments.

Verify, validate, and audit run results before processing payments.

Payroll Activity Report for the Latest Process Run the report before processing prepayments. Use this report to extract the year-to-date (YTD) payroll balances for large volumes of data.
Periodic Payroll Activity Report Run the report before processing prepayments. Use this report to extract the periodic payroll balances for large volumes of data.

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

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.

Payroll Messages Report

View details of error, warning, and information messages from payroll processes.

Run the report as needed for diagnostic purposes.

View and analyze the errors and warnings generated for a specific flow or for all processes within a specific period.

HCM Extract and/or Fusion Analytic Warehouse (FAW) are the only supported tools for payroll balance reporting.
Note: HCM Extract and/or Fusion Analytic Warehouse (FAW) are the only supported tools for payroll balance reporting.