Example of Loading Balance Adjustments
Vision Corp wants to create balance adjustment records to adjust the FIT Withheld balances for two of their employees. Using HCM Data Loader, they want to increase the withheld balance by 10.
Load the Balance Adjustment Header
Use this BalanceAdjustmentHeader.dat file to create the batch header.
METADATA|BalanceAdjustmentHeader|LegislativeDataGroupName|BatchName
MERGE|BalanceAdjustmentHeader|US LDG|FIT Adjustments
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|US LDG|FIT Adjustments|2019/04/30|Vision US Weekly|Vision Weekly|N|N
Load the Balance Adjustment Line and Value
For Employee 1 with Assignment number E3263769, load these details:
Data Column |
Value |
---|---|
Line Sequence |
1 |
Effective Date |
2010/04/30 |
Payroll |
Vision US Weekly |
Consolidation Group |
Vision Weekly |
Assignment Number |
E3263769 |
Include adjustment in costing process |
No |
Federal Income Tax, Tax Calculated |
10.00 |
Include adjustment in payment balance |
No |
For Employee 2 with Assignment number E5746169, load these details:
Data Column |
Value |
---|---|
Line Sequence |
2 |
Effective Date |
2010-04-30 |
Payroll |
Vision US Weekly |
Consolidation Group |
Vision Weekly |
Assignment Number |
E5746169 |
Include adjustment in costing process |
No |
Federal Income Tax, Tax Calculated |
10.00 |
Include adjustment in payment balance |
No |
Use this BalanceAdjustmentLine.dat file to create the batch lines:
METADATA|BalanceAdjustmentLine|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|AssignmentNumber|ElementName|TaxReportingUnitName
MERGE|BalanceAdjustmentLine|US LDG|FIT Adjustments|Vision US Weekly|Vision Weekly|2019/04/30|1|E263769|Federal Income Tax|US Tax Reporting Unit
MERGE|BalanceAdjustmentLine|US LDG|FIT Adjustments|Vision US Weekly|Vision Weekly|2019/04/30|2|E746169|Federal Income Tax|US Tax Reporting Unit
METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|InputValueName|EntryValue|ElementName
MERGE|BalanceAdjustmentValue|US LDG|FIT Adjustments|Vision US Weekly|Vision Weekly|2019/04/30|1|Tax Calculated|10|Federal Income Tax
MERGE|BalanceAdjustmentValue|US LDG|FIT Adjustments|Vision US Weekly|Vision Weekly|2019/04/30|2|Tax Calculated|10|Federal Income Tax
If you wish, you can also specify a calculation component. For example, customers in UK can specify a PAYE Component for the balance adjustment and customers in Canada can specify a Payroll Account Number (PAN). Here's a sample BalanceAdjustmentLine.dat file:
METADATA|BalanceAdjustmentLine|BatchName|LegislativeDataGroupName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|AssignmentNumber|ElementName|TaxReportingUnitName|BalanceDate|ThirdPartyPayeeName|TimeDefinitionName|CalcBreakdownId|CalculationComponent
MERGE|BalanceAdjustmentLine|HDL_Batch1|LDG UK1|Monthly PD|LDG CS UK1|2019/06/01|31|E955160008191984|Sample_Uk_Element|LE 2T|2019/06/01||UKBT_TD_WEEKLY||LE 2T
Load Balance Adjustment Costing
BalanceAdjustmentHeader.dat
METADATA|BalanceAdjustmentHeader|BatchName|LegislativeDataGroupName
MERGE|BalanceAdjustmentHeader|WK_BA_501_03012021|WK_US_LDG
METADATA|BalanceAdjustmentGroup|EffectiveDate|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|2021/03/01|WK_US_LDG|WK_BA_501_03012021|WK_Monthly|WK Consolidation Group|Y
WK_BA_501_03012021_header.zip UCMFA00151313 Success Success
BalanceAdjustmentLine.dat
METADATA|BalanceAdjustmentLine|BalanceDate|BatchLineSequence|LegislativeDataGroupName|EffectiveDate|BatchName|PayrollName|AssignmentNumber|ElementName|TaxReportingUnitName|ConsolidationSetName
MERGE|BalanceAdjustmentLine|2021/03/01|1|WK_US_LDG|2021/03/01|WK_BA_501_03012021|WK_Monthly|E501|Federal Income Tax|WK_US_LE|WK Consolidation Group
METADATA|BalanceAdjustmentValue|EntryValue|InputValueName|LegislativeDataGroupName|BatchName|BatchLineSequence|PayrollName|EffectiveDate|ConsolidationSetName|ElementName
MERGE|BalanceAdjustmentValue|-211|Gross|WK_US_LDG|WK_BA_501_03012021|1|WK_Monthly|2021/03/01|WK Consolidation Group|Federal Income Tax
MERGE|BalanceAdjustmentValue|-211|Tax Calculated|WK_US_LDG|WK_BA_501_03012021|1|WK_Monthly|2021/03/01|WK Consolidation Group|Federal Income Tax
WK_BA_890217_03012021_lines.zip UCMFA00151325 Success Success
CostAllocationV3.dat
METADATA|CostAllocationV3|BatchName|EffectiveStartDate|Consolidationsetname|BalAdjGrpEffectiveDate|Batchlinesequence|PayrollName|AssignmentNumber|LegislativeDataGroupName|SourceType
MERGE|CostAllocationV3|WK_BA_890217_03012021|2021/03/01|WK_Consolidation_Group|2021/03/01|1|WK_Payroll|E890217|WK_LDG|BA
WK_BA_890217_03012021_cost_alloc.zip UCMFA00485453 Success Success
CostAllocationAccountV3.dat
METADATA|CostAllocationAccountV3|SourceType|PayrollName|BatchName|EffectiveDate|BalAdjGrpEffectiveDate|Batchlinesequence|LegislativeDataGroupName|Consolidationsetname|SourceSubType|Proportion|SubTypeSequence|ConcatenatedSegment|Segment1|Segment2|Segment3
MERGE|CostAllocationAccountV3|BA|WK_Payroll|WK_BA_890217_03012021|2021/03/01|2021/03/01|1|WK_LDG|WK_Consolidation_Group|COST|1|1|000.1234.1515|000|1234|1515
WK_BA_890217_03012021_CostAllocAcct.zip UCMFA00485503 Success Success
Submit process