Payroll Balance Report in Oracle Fusion HCM

The Payroll Balance Report in Oracle Fusion HCM is designed to help payroll administrators and auditors view and reconcile payroll balances over time. Here's a detailed overview:

---

Purpose

· View detailed balance information for employees over a defined period.

· Compare live vs. archived balances to validate and reconcile payroll data.

· Useful for quarterly and year-end audits, and for identifying discrepancies.

---

Key Report Types

1. Payroll Balance Report

· Shows detailed balance data for a person across a specified time frame.

· Helps validate and reconcile periodic payroll balances 

2. Employee Active Payroll Balance Report

· Displays current values for selected employee balances.

· Useful for checking statutory limits (e.g., Social Security caps).

· Can be filtered by: 

o Payroll

o Tax Reporting Unit (TRU)

o Payroll Relationship Group

o Balance Dimension (e.g., Run, Month, Year)

o Balance Group 
2

---

⚙️ How to Run the Report

1. Go to My Client Groups > Payroll > Submit a Flow.

2. Select: 

o Run Payroll Balance Report

o or Run Employee Active Payroll Balance Report

3. Enter parameters: 

o Payroll Flow

o Start and End Dates

o Employee or Group

o Balance Dimension

o Balance Group

o Optionally hide zero-value records

---

Output

· A pipe-delimited text file that can be opened in Excel.

· Includes: 

o Payroll balance values

o Employee details

o Payroll relationship numbers

o TRU information