Example of Loading US Balance Adjustments

This example creates a batch header and group record, with various lines and values.

The following example helps you create a batch header and group record, with various lines and values to adjust the Federal Income Tax (FIT) Withheld and State Income Tax (SIT) Withheld balances for two employees to increase the withheld balances by $10.

Note: When adjusting balances you may also need to adjust any related balances, depending on your business needs. This is simply an example to illustrate the process.

Load the Balance Adjustment Header and Group

Use the BalanceAdjustmentHeader.dat file to create the batch header and group records.

METADATA|BalanceAdjustmentHeader|LegislativeDataGroupName|BatchName
MERGE|BalanceAdjustmentHeader|US LDG|FIT and SIT Adjustments

METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|US LDG|FIT and SIT Adjustments|2020/04/30|Vision US Weekly|Vision Weekly|N|N

Load the Balance Adjustment Lines and Values

The Balance Adjustment Lines files lines specify the element you will supply values for:

Batch Line Sequence	Assignment Number	Element Name	Tax Reporting Unit Name
1	E263769	Federal Income Tax	US Tax Reporting Unit
2	E746169	Federal Income Tax	US Tax Reporting Unit
3	E263769	Work State Income Tax	US Tax Reporting Unit
4	E746169	Work State Income Tax	US Tax Reporting Unit

The Balance Adjustment Values file lines specify the input values for the element named in the line record. The Entry Value is the value for the Input Value Name of the Element Name. For example, in the first line below, the Entry Value of $10 is the value specified for the Tax Calculated input value for the Federal Income Tax element.

For the Work State Income Tax element, you must specify the tax calculated amount, as well as the context of the state. That's why there are 2 value records for the 1 line record above for the Work State Income Tax element. In the value record below, where State is the Input Value Name, the Entry Value corresponds to the geography code relating to the value. For example, 5 is the geocode for California (CA).

Batch Line Sequence	Element Name	Input Value Name	Entry Value
1	Federal Income Tax	Tax Calculated	10
2	Federal Income Tax	Tax Calculated	10
3	Work State Income Tax	State	5
3	Work State Income Tax	Tax Calculated	10
4	Work State Income Tax	State	6
4	Work State Income Tax	Tax Calculated	10

Use the BalanceAdjustmentLine.dat file to create the batch line and value records.

METADATA|BalanceAdjustmentLine|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|AssignmentNumber|ElementName|TaxReportingUnitName
MERGE|BalanceAdjustmentLine|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|1|E263769|Federal Income Tax|US Tax Reporting Unit
MERGE|BalanceAdjustmentLine|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|2|E746169|Federal Income Tax|US Tax Reporting Unit
MERGE|BalanceAdjustmentLine|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|3|E263769|Work State Income Tax|US Tax Reporting Unit
MERGE|BalanceAdjustmentLine|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|4|E746169|Work State Income Tax|US Tax Reporting Unit

METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|InputValueName|ElementName|EntryValue
MERGE|BalanceAdjustmentValue|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|1|Tax Calculated|Federal Income Tax|10
MERGE|BalanceAdjustmentValue|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|2|Tax Calculated|Federal Income Tax|10
MERGE|BalanceAdjustmentValue|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|3|State|Work State Income Tax|5
MERGE|BalanceAdjustmentValue|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|3|Tax Calculated|Work State Income Tax|10
MERGE|BalanceAdjustmentValue|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|4|State|Work State Income Tax|6
MERGE|BalanceAdjustmentValue|US LDG|FIT and SIT Adjustments|Vision US Weekly|Vision Weekly|2020/04/30|4|Tax Calculated|Work State Income Tax|10