Payment Register Report
Use this report for the verification, reconciliation, and audit of payment distributions.
This report doesn't include payments made to third parties. Such payments are listed on the Third-Party Payment Register.
You can generate the report manually or as a part of the payroll process.
To run this report:
-
From My Client Groups, click Payroll.
-
Click Submit a Flow.
-
Select your US legislative data group (LDG).
-
Search for and select Payment Register Report.
Before You Start
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 for the US in the Help Center.
Report Parameters
Scope
Control the results of the report by specifying its scope.
What you set |
What it does |
---|---|
Summary |
Provides a summary of the total amounts paid by payment category, payment type, status, and payment method. |
Detail |
In addition to the Summary report, it includes the complete details for each employee. Use this validate payments for each employee, including the payment amount, bank, and check info. For further info, see Oracle Cloud Human Capital Management for United States: Payroll Reconciliation (2086251.1) on My Oracle Support. |
Process Start Date
Use this field to set the first effective date of the payroll process to include in the report. The report includes all processes with an effective date on or after this date.
Process End Date
Use this field to set the last effective date of the payroll process to include in the report. For payroll runs, this is its payroll run date. The report includes all processes with an effective date on or before this date.
Payroll
Use this field to limit the results to a single payroll definition.
Leave blank to report all of them.
Payment Process
Use this field to limit the results to a specific payroll or QuickPay run.
Leave blank to report all of them.
Consolidation Group
Use this field to limit the results to a consolidation group.
Leave blank to report all of them.
For further info, see Consolidation Groups for the US in the Help Center.
Payroll Statutory UnitUse this field to limit the results to a specific payroll statutory unit (PSU).
Leave blank to report all of them.
Tax Reporting Unit
Use this field to limit the results to a specific tax reporting unit (TRU).
Leave blank to report all of them.
Payroll Relationship Group
Use this field to verify deduction balances for persons belonging to a specific payroll relationship group.
Person
Use this field to limit the results to a single person.
Payment Type
Use this field to limit the results to a specific payment type.
Leave blank to report all of them.
Payment Method
Use this field to limit the results to a specific payment type.
Leave blank to report all of them.
Location
Use this field to limit the results to a specific location.
Payment Status
Select the status you want to report on.
What you select |
What it means |
---|---|
Canceled and can't be reissued |
You have marked the payment as Void, rolled back the prepayment process, and reversed the calculation of the payroll run results. |
Paid |
You processed and issued the payment without error. |
Paid externally |
You processed the payment was processed but generated it externally. This includes hand-written checks for terminated employees. |
Unpaid |
You processed the payment was processed, but it was incomplete or detected errors during payment. |
Void |
You marked the payment as Void, but it's eligible for reissue. This includes replacing a lost payroll check. |
You can configure these statuses in the PAY_STATUS lookup. For further info, see Payment Statuses in the Help Center.
Leave blank to report all of them.
Process Configuration Group
Use this field to verify deduction balances for persons belonging to a specific payroll relationship group.
Use the Object Groups task to define a payroll relationship group before you can use it here.
Report Category
If you have defined a report category for delivery of output in multiple formats, select it here.
For further info, see Delivery Options for Extract-Based Payroll Reports for the US in the Help Center.
Run Mode
Use to control whether the report retains or discards the transient data it creates when producing the output file.
Select the Debug option only to investigate an issue with the report output or when instructed by Oracle Support.
The Normal option discards the temporary transient data.
Report Results
The report provides details of the selected payment status for matching persons, filtered by the specified time frame and other parameters.
Report name |
What it contains |
---|---|
Summary |
Provides sections on:
|
Detail |
Provides sections on:
Use this validate payments for each employee, including the payment amount, bank, and check info. For further info, see Oracle Cloud Human Capital Management for United States: Payroll Reconciliation (2086251.1) on My Oracle Support. |