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:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US legislative data group.

4. 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.

Note: 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: Payment details of individual and roll-up payments made for each payee Within each payee report, the payments are further segregated into: Employee deduction info for individual payments, including single deductions and multiple deductions Employee deduction info for roll-up payments Consolidated totals of all multiple-deduction and rollup payments Deduction reference details for involuntary deductions stored on the calculation card It displays a blank deduction reference if the details aren't available. Element name of voluntary deductions

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.