1. Administering Payroll for the United States
  2. Balance Exception Report for the US

Balance Exception Report for the US

Run the Balance Exception Report flow as part of your year-end balancing and reconciliation process.

Use this report to identify:

  • Incorrect tax amounts withheld

  • Wage over-the-limit situations

  • Any improperly calculated tax liability balances, such as Social Security, Medicare, or Federal Unemployment Tax Act (FUTA)

This report returns output in PDF, CSV, or Microsoft Excel output. The balances detected by this flow might require adjustment.

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

  • Oracle Cloud Human Capital Management for the United States: Balance Exception Report (2325520.1)

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

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

To assist with reconciliation and balancing of your data, run this report before generating your Employee W-2s and running the Third-Party 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 Balance Exception Report.

Before You Start

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.

Process Start Date

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

Process End Date

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

Balance Exception Report

Select the balance report you want to generate.

  • Deferred Compensation Over the Limit

  • Federal Exceptions

  • State Exceptions

Payroll

To run this report, select the specific payroll 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.

Payroll Statutory Unit

To include all employees in a payroll statutory unit (PSU) in your report results, select it here. Click Search to locate the PSU.

Leave blank to run against all PSUs.

Tax Reporting Unit

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

Leave blank to run against all TRUs.

Location

To include all employees assigned to a location in your report results, select it here.

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.

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

Process Configuration Group

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

Report Category

Select the output format for the report.

  • CSV

  • Microsoft Excel

  • PDF

Report Output

This report produces an output report in the format you select. It contains all live payroll balances for matching employees, filtered by parameters and time-frames. If no employee balances match your report parameter criteria, the report returns an output file with no data.

Related Topics