Payroll Register Reports
Use the Payroll Register Report, Payroll Register Report for the Latest Process, or the Periodic Payroll Register Report to review the reported earnings, taxes, deductions, and employer liabilities archived in the periodic archive process.
The report has both a summary and detail mode.
Verify total payment amounts per balance category and compare payment values to previous periods.
To run this report, use Submit a Flow under Payroll in My Client Groups on the Home page.
| Report Task Name | Purpose |
|---|---|
| Run Payroll Register Report | Use this task to run the legacy report. |
| Run Payroll Register 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 Register 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. |
Before You Begin
Run this report after you run the payroll archive process.
You must have successfully completed archival of your periodic payroll data. This usually occurs during your payroll flow. For further info, see Archive Periodic Payroll Results in the Help Center.
Report Parameters
The parameter values determine which records to include in the report. Most parameters are self-explanatory, while the following have special meaning in the context of this report.
Scope
Select the scope of this report. Select Detail to generate a report that includes details of deductions listed for each employee. Otherwise, select Summary.
Process Start and End Date
Select the range of dates that capture the reporting period.
Payroll
To run this report for a single payroll, select the required payroll name. If you leave the field blank, the report runs for all payrolls.
Consolidation Group
Use this field to run the report against a consolidation group. A consolidation group defines a grouping of different payrolls for reporting purposes. For example, you can use this field to run this report for a subset of payrolls. You can select a value only if you have a predefined consolidation group. If you leave the field blank, the report runs for all the consolidation groups.
Payroll Statutory Unit
Select a value to report on the balances of employees in a specific payroll statutory unit (PSU). If you leave the field blank, the report runs for all PSUs.
Tax Reporting Unit
Select a value to report on the balances of employees in a specific tax reporting unit (TRU). If you leave the field blank, the report runs for all the TRUs.
Person
Use this field to limit the report results to a single person. If you leave the field blank, the report runs for all people included in the selected payroll run.
Payroll Relationship Group
Use this field to verify deduction balances for persons belonging to a specific payroll relationship group. You can specify a value only if you have a predefined payroll relationship group. If you leave the field blank, the report runs for all the defined payroll relationship groups.
Person Page Break
Select Yes to display the report output in a separate page for each person. This field isn't available for the Summary report.
Process Configuration Group
Use this field to run the report for a specific process configuration group, instead of the default one. A process configuration group is used to set rules for payroll processes, such as enabling logging or setting the number of threads. You can select a value only if you have a predefined process configuration group.
Latest Process YTD Total Only
If you select No, the report lists current (run) balances based on the Balances Reported value against every process the report parameters include. For example, assume there are three payroll calculations run between the start and end dates of the report. The report lists the statutory deduction balances in three sets, one for each process.
If you select Yes, the report includes year-to-date totals from only the last process run before the specified end date, such as the last process run for each TRU or PSU. However, it's recommended to run the Statutory Deduction Register for the latest process instead.
Balances Reported
Use this field to run this report for payment balances, nonpayment balances, or both, as given here.
Payment Only: Includes balances included in the payments process.
Nonpayment Only: Includes balances that aren't included in the payments process.
If you leave the field blank, the report includes all balances.
Report Category
A report category is a group of delivery options. Select a value to determine the set of delivery options for this report submission. You can define your own delivery option and include it in the report category. For example, you can define a report category to use a combination of both PDF and Excel delivery options for a single submission of the report.
For further info, see Delivery Options for Extract-Based Payroll Reports in the Help Center.
Run Mode
Use this parameter to decide if the report must retain or discard the transient data it creates during the report execution. If the default value is Normal, the temporary transient data produced during report execution is discarded.
Select Debug only to investigate an issue with the report output or when instructed by Oracle Support.
The Normal option discards the temporary data.
Report Results
This process generates either a Summary or Detail output report, depending on the Scope you select.
Summary
Use the summary report to verify total payment amounts per balance category for a payroll period for a PSU or TRU. The summary report provides a list of balances by:
Balance Category
PSU and TRU
Balance Name
References
Current Amount
The PDF output has these summary sections with subtotals in each section as given here:
Balance Categories Summary
Balances Summary with subtotals for each balance category
Balances by PSU and TRU Summary with subtotals for each balance category within each PSU
Detail Report
In addition to the summary balances shown by the Summary report, the detail report also includes the following employee-level deductions info:
Balance Category
Balance Name
Total Deduction Amount
The PDF output has these summary sections with subtotals in each section as given here:
Balances and Balance Categories Summary with subtotals for each balance category.
Balances Summary for each balance category.
Balances by PSU and TRU Summary with subtotals for each balance category within each PSU.
Balance Details for a Person with subtotals for each balance and balance category. This section also includes:
-
Payroll relationship number
-
Run type
-
Payroll period
-
Calculation breakdown ID
-
Year-to-date deduction amount
-
The detail report is sorted in the order of PSU, TRU, person name, payroll, pay period, balance category, and balance.