Adjust Employer Taxes that Use State Miscellaneous Employer Balances
In this example, you need to adjust an employer tax. However, this tax uses the State Miscellaneous Employer balances, such as Massachusetts Employer Medical Assistance Contribution (EMAC) and Vermont Child Care Contribution (CCC). In this case, you adjust it using HCM Data Loader (HDL) to update the balances.
Here are employer taxes that use these balances. When adjusting them, you need to populate PayrollComponentCode in the balance adjustment HDL file with the identifying value.
|
State |
Tax |
Value |
|---|---|---|
|
Massachusetts |
EMAC |
EMAC |
|
Vermont |
CCC |
CHILD_CARE |
The following sample HDL file includes entries for both taxes.
BalanceAdjustmentHeader.dat
METADATA|BalanceAdjustmentHeader|BalAdjBatchId|BatchName|LegislativeDataGroupName
MERGE|BalanceAdjustmentHeader||Batch1|US LDG
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|EffectiveDate|BatchName|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|US LDG|2026/01/01|Batch1|US Semimonthly|US_Consolidation|Y|
BalanceAdjustmentLine.dat
METADATA|BalanceAdjustmentLine|BatchName|LegislativeDataGroupName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|AssignmentNumber|ElementName|TaxReportingUnitName|BalanceDate|ThirdPartyPayeeName|TimeDefinitionName|PayrollComponentCode
MERGE|BalanceAdjustmentLine|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|E123|State Miscellaneous Employer Liability|TRU1|2026/01/01|||EMAC
MERGE|BalanceAdjustmentLine|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|E234|State Miscellaneous Employer Liability|TRU1|2026/01/01|||CHILD_CARE
METADATA|BalanceAdjustmentValue|BatchName|LegislativeDataGroupName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|InputValueName|EntryValue|ElementName
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|State|22|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Gross|12000|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Exempt|1000|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Subject Withholdable|10500|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Subject Not Withholdable|500|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Reduced Subject Withholdable|8400|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Section 125 Reductions|100|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Deferred Compensation 401K Reductions|200|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Deferred Compensation 403B Reductions|300|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Deferred Compensation 457 Reductions|400|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Dependent Care Reductions|500|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Other Pretax Reductions|600|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Tax Calculated|100|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Excess|1000|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|1|Taxable|8400|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|State|46|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Gross|12000|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Exempt|1000|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Subject Withholdable|10500|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Subject Not Withholdable|500|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Reduced Subject Withholdable|8400|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Section 125 Reductions|100|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Deferred Compensation 401K Reductions|200|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Deferred Compensation 403B Reductions|300|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Deferred Compensation 457 Reductions|400|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Dependent Care Reductions|500|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Other Pretax Reductions|600|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Tax Calculated|100|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Excess|1000|State Miscellaneous Employer Liability
MERGE|BalanceAdjustmentValue|Batch1|US LDG|US Semimonthly|US_Consolidation|2026/01/01|2|Taxable|8400|State Miscellaneous Employer Liability