Payroll Activity Report

Use the Payroll Activity Report to to view and reconcile the payroll balances information with the data archived by the periodic payroll archieve process.

The Payroll Activity Report provides a high-level summary of all relationship-level balances across various balance categories, payroll statutory units (PSUs), and tax reporting units (TRUs). Use the Payroll Activity report to list for a given time:

Balance adjustments for all employees
Gross earning calculations
Reversals
Balance initialization for a selected employee or all employees
Payroll or QuickPay runs

Use any of these tasks to run the Payroll Activity Report and view latest process year-to-date and periodic balances.

Report Task Name	Purpose
Run Payroll Activity Report	Use this task to run the legacy report.
Run Payroll Activity Report for the Latest Process	Use this task to extract the year-to-date (YTD) payroll balances for large volumes of data. The report runs much faster than the legacy report and includes year-to-date totals from the last process run for a person prior to the specified end date, such as the last process run for each TRU. The results are the same as running the legacy report with the Latest Process YTD Total Only parameter set to Yes.
Run Periodic Payroll Activity Report	Use this task to extract the periodic payroll balances for large volumes of data. The report runs much faster than the legacy report. The results are the same as running the legacy report with the Latest Process YTD Total Only parameter set to No.

Report Task Name

Purpose

Run Payroll Activity Report

Use this task to run the legacy report.

Run Payroll Activity Report for the Latest Process

Use this task to extract the year-to-date (YTD) payroll balances for large volumes of data. The report runs much faster than the legacy report and includes year-to-date totals from the last process run for a person prior to the specified end date, such as the last process run for each TRU.

The results are the same as running the legacy report with the Latest Process YTD Total Only parameter set to Yes.

Run Periodic Payroll Activity Report

Use this task to extract the periodic payroll balances for large volumes of data. The report runs much faster than the legacy report.

The results are the same as running the legacy report with the Latest Process YTD Total Only parameter set to No.

When to Run Report

Run the report to verify, validate, and audit run results before processing payments.

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 Activity Report Parameters

Parameter Name	Description
Scope	Use this field to control the results of the report. Select Summary to view a summary of payroll relationship level balances across all workers by balance category, balance type, TRU, and payroll activity. Select Detail to view the detail of each payroll relationship level balance for every worker in every payroll activity.
Process Type	The options that you can select include: Payroll Calculation Quick-Pay Reversal Balance Adjustment Balance Initialization Calculate Gross Earning
Person Page Break	If you select Yes, the report is generated with details per person per page. The default value is No and this field is disabled for the summary report.
Hide Records with Zero Value	If you select Yes, balances with zero values aren’t displayed in the report.
Latest Process YTD Total Only	If you select Yes, the summary report includes year-to-date total from the last process run for a person prior to the specified end date, such as the last process run for each TRU.
Balances Reported	Use this field to run this report for these types of balances: Payment Balances, Nonpayment Balances, or both Select Payment Balances to display balances included in the payments process. Select Nonpayment Balances to display balances that aren’t included in the payments process. Leave the field blank to include all balances. Note: This field is disabled if Latest Process YTD Total Only is set to Yes and all balances are included in the report.
Display All Hours	Select Yesto 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.

Dynamic Payroll Relationship Group Support

Use payroll relationship groups to define a set of people for payroll processing, data entry, or reporting. When you create a payroll relationship group from the Object Groups page, select the Payroll Relationship Group formula type.

The Payroll Relationship Group formula type restricts the payroll process to a specific set of employees based on assignment and person-level attributes. The formula contains the criteria that defines the group.

By default, you create formulas of this type using the Expression editor on the Create Fast Formula page. However, you can use the text editor to create more complex formulas, if required.

Report Output

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

Summary Report

The summary report has these sections:

Summary for Balance Categories
Summary for Balances
Summary for Balances by PSU and TRU
Balances by Payroll and Process Type Summary

Balances by Payroll and Process Type Summary are displayed when Latest Process YTD Total Only is set to No or left blank.

Detail Report

The detail report includes the above three sections followed by a fourth section that has employee level balances information displayed separately for payment and nonpayment balances.

The balances are reported separately for unpaid Balance Adjustments when ‘Include adjustment in payment balance’ is set as No during balance adjustments, and unpaid Reversals.