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:
-
From My Client Groups, click Payroll.
-
Click Submit a Flow.
-
Select your US legislative data group.
-
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.
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
Note:This can cause performance issues if your selection results include many people and span a long period of time, as indicated by the Start Date and End Date parameters.
-
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 |
|
Run |
Note:
This can cause performance issues if your selection results include many people and span a long period of time, as indicated by the Start Date and End Date parameters. |
Quarter |
|
Quarter and year |
|
Year |
|
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