US Tax Balance Adjustment Flow

Use the US Tax Balance Adjustment flow to perform a mass balance adjustment for tax balances, such as after a credit-reduction rate change. This process generates a balance adjustment batch file that you then process through HCM Data Loader (HDL).

To run this process:

1. From My Client Groups, click Payroll.

2. Click Submit a Flow.

3. Select your US legislative data group (LDG).

4. Search for and select US Tax Balance Adjustment.

Before You Begin

Before starting this flow, you must define a formula for the appropriate tax balance. Some sample formulas are available for your reference on Customer Connect and My Oracle Support. For further info, see Sample Tax Balance Adjustment Formulas (2470020.1) on My Oracle Support.

Note: This doesn't apply to FUTA balances. This process uses a FUTA formula by default.

To make your formula available for use with this process:

1. Start the Calculations Value Definitions task.

2. Click Create.

3. Enter a meaningful name, and select your US LDG.

4. Select Use existing value definition group.

5. Select the US Tax Balance Adjustment value definition group.

6. Select the Text calculation type

7. In Calculation Values, click Add Row and attach the formula as text.

   Field name	What you enter
   From Value	0
   To Value	99999
   Text Value	Your formula name

8. Save your changes.

Process Parameters

Effective Date

Enter the effective date of the adjustment.

Payroll

Select the payroll run you're adjusting.

Payroll Relationship Group

Select the payroll relationship group name if you 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.

Consolidation Group

To run the report against the members of a consolidation group, select it here. 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 the payroll statutory unit (PSU) of the people whose tax balances you're adjusting.

Tax Reporting Unit

Select the tax reporting unit (TRU) of the people whose tax balances you're adjusting.

Balance Adjustment Level

Select the jurisdiction level of the taxes you're adjusting.

State

For nonfederal tax adjustments, select the state.

Mode

Search for and select the tax balance formula you defined. If you leave this blank, the process runs the default FUTA formula.

Multiple Batches by Date

Select Yes to create separate batches by date. The process automatically populates the effective date for all lines in the batch with the effective date you provided.

When adjusting balances for terminated employees, the process might use the final close date instead of the effective date to create the separate batches. It does so when the final close date is earlier than the effective date.

Perform the Balance Adjustment

After running this flow:

1. Use the balance adjustment batch output to review the info for accuracy before transferring and processing it.

2. Download the batch to the HDL. There's no separate audit report.

3. Verify the batch through HDL.

4. Run the Transfer Batch Process.

5. Run the Adjust Multiple Balances process.

   This process pushes the HCM Data Loader values to Oracle Cloud.