Example of Loading US Balance Adjustments
This example creates a batch header and group record, with various lines and values.
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
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