Employee Active Payroll Balance Report for the US

The Employee Active Payroll Balance Report flow displays the current values for any given list of employee balances.

This report helps you with:

• Reconciling your periodic payrolls and quarterly and year-end balances

  Compare this report's data against the archived data.

• Determining if you have any tax balances over the statutory limits, such as Social Security and deferred compensation

• Determining if any of the tax liability balances are improperly calculated

  This includes Social Security, Medicare, and FUTA.

For further info, see the following on My Oracle Support.

• Oracle Cloud Human Capital Management for the US: Balance Adjustments (1600728.1)

• Oracle Cloud Human Capital Management for the US: Batch Balance Adjustments (2053488.1)

• Oracle Cloud Human Capital Management for the US: Payroll Reconciliation (2086251.1)

To assist with reconciliation and balancing of your data, run this report before generating your employee Forms W-2, W-2GU, and W-2PR and running the Third-Party Quarterly Tax Filing Interface.

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 Employee Active Payroll Balance Report.

Before You Start

Successfully complete any payroll action, such as a payroll run, QuickPay, reversal, balance adjustment, or balance initialization.

Report Parameters

Payroll Flow

Name of your payroll flow.

Start Date

If you're including Run balance values, enter the start date. This date must coincide with the date of the selected payroll run.

End Date

Enter the effective date for balance retrieval. When capturing balance values across a range of dates, this represents the end of the range.

Payroll

To run report against a specific payroll run, enter it here.

Consolidation Group

To run the report against the members of a consolidation group, select it here.

For further info, see Consolidation Groups for the US in the Help Center.

Tax Reporting Unit

To include all employees in a tax reporting unit (TRU) in your report results, select it here. Click Search to locate the TRU.

Payroll Relationship Group

Select the name of the payroll relationship group if you have defined one. Payroll relationship groups limit the persons processed by payroll, data entry, and reporting. This can be a dynamic payroll relationship group.

Note: Use the Object Groups task to define the payroll relationship group before you can select it here.

Employee Name

To run this report for a specific employee, select their name here. Click Search to locate the correct employee.

Balance Dimension

Select the balance dimension you want to review.

• Inception-to-date

  Use to run this report against a user-defined balance group.

  Note: This can cause performance issues if your selection results in reporting against large number of people.

• Month

• Quarter

• Quarter and year

• Run

• Year

Quarter

Select the quarter you want to review.

Balance Group Usages

Select the balance group to include balance values in the report output. The available values depend on the balance dimension you selected.

Balance dimension	Balance group usages
Inception-to-date	Select the user-defined balance group Note: This can cause performance issues if your selection results in reporting against large number of people.
Month	Pennsylvania local month balances State month balances
Run	City run balances County run balances Federal run balances Pennsylvania local run balances School district run balances State run balances
Quarter	Archive state quarter-to-date balances City quarter balances County quarter balances Federal quarter balances Pennsylvania local quarter balances School district quarter balances State quarter balances
Quarter and year	City quarter and year balances County quarter and year balances Federal quarter and year balances Pennsylvania local quarter and year balances School district quarter and year balances State quarter and year balances
Year	City employee balances in end-of-year archive City miscellaneous employee balances in end-of-year archive City TCD employee balances in end-of-year archive City year balances County employee balances in end-of-year archive County year balances Federal employee balances in end-of-year archive Federal year balances Local employee balances in end-of-year archive Pennsylvania local year balances School district employee balances in end-of-year archive School district TCD employee balances in end-of-year archive School district year balances State year-to-date balances in end-of-year archive State employee balances in end-of-year archive State year balances

Note: You can view a list of balances organized by group usage from the Balance Group Usage task. For further info, see Balance Group Usages for the US in the Help Center.

Hide Records with Zero Values

Select if you don't want records with 0 balances to show in this report.

Process Configuration Group

Select the process configuration group name if you have defined one. This parameter is used for logging and reporting purposes.

Report Output

This report produces a pipe-delimited text file containing all active payroll balances for matching employees, filtered by parameters and time-frames. You can open this file in Microsoft Excel for additional filtering. If no employee balances match your report parameter criteria, the report returns an output file with no data.

The output file includes:

• Payroll balance info

• TRU

• Employee name and number

• Payroll relationship number

• Run type (Run level only)

• Applicable federal, state, county, city, school district, and Pennsylvania locals