Third-Party Payment Register Report
Use the Third-Party Payment Register Report to generate a listing of all third-party payments.
To run this report:
-
From My Client Groups, click Payroll.
-
Click Submit a Flow.
-
Select your US legislative data group.
-
Search for and select Third-Party Payment Register Report.
Before You Start
Run the report after calculating and verifying prepayments and generating the payments.
For further info, see the following in the Help Center.
-
Calculate and Validate Payroll Payment Distributions for the US
-
Payroll Payments Distribution for the US
Report Parameters
The parameter values determine which records to include in the report. For example, you can run this report for a specific consolidation group or payroll relationship group. You must predefine these groups before you can use them. Most parameters are self-explanatory, while the following have special meaning in the context of this report.
Scope
You control the results of the report by specifying the scope of the report, as given in this table.
What you set |
What it does |
---|---|
Summary |
Provides a list of payments by payee. |
Detail |
Provides details of employee and deduction information for third-party payments. |
Process Start Date
Enter a start date to define the date range of this process.
Process End Date
Enter an end date to define the date range of this process.
Payroll
Select the required payroll name. The report is generated for the selected payroll run.
Consolidation Group
Select a consolidation group to view the payments for all payrolls that are included in this consolidation group. If you don't select a value, the process uses the default consolidation group assigned to the payroll.
For further info, see Consolidation Groups for the US in the Help Center.
Payroll Statutory Unit
Select a payroll statutory unit (PSU) to view the payments for a specific PSU.
Tax Reporting Unit
Select a tax reporting unit (TRU) to view the payments for a specific TRU.
Payroll Relationship Group
Select the payroll relationship group name, if you have defined one. Payroll relationship groups limit the persons processed for payroll, data entry, and reporting. For example, you can create a group to process the report for terminated employees.
Person
Select the person number to validate payments for each employee, including the payment amount, bank, and check info, as reported in the detailed report.
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 the payroll relationship group or the process configuration group, before you can select it here.
Payee
Select the payee for which the check payment process is run, to view the payment details of individual and rollup payments made for each payee.
Use these parameters to view a list of individual payments, including total amounts paid by payment category, type, status, and method.
-
Payment Category
-
Payment Method
-
Payment Process
-
Payment Type
-
Payment Status
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 results of the report depend on the scope value you select while running the report, as given below. Both the formats have a page break after every payee, so you can provide the payment details separately to each payee.
Report name |
What it contains |
---|---|
Summary Report |
Displays the payments made to each payee by the payment source, payment status, and payment category. The report doesn't show PSU, TRU, and employee and deduction info. This is because the rollup payments include employees across PSUs and TRUs. |
Detail Report |
Returns a multiple-tier layout that includes:
|
You can create your own template for a tabular output of data in Microsoft Excel file format for both the summary and detail reports. For further info, see Generating Payroll Reports in Microsoft Excel Format in the Help Center.