Example of Adjusting Tax Calculation Balances for China
This balance adjustment example creates a batch header and group record to adjust the following balances using a regular tax element.
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|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|EffectiveDate|BatchName|PayrollName|ConsolidationSetName
MERGE|BalanceAdjustmentGroup|A-ZHRX-CN-DD-LDG1|2024/03/31|202403 Balance Adjustment 1|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1Load the Balance Adjustment Lines and Values
Use the BalanceAdjustmentLine.dat file to create the batch lines.
| Attribute | Value |
| LegislativeDataGroupName | A-ZHRX-CN-DD-LDG1 |
| BatchName | 202403 Balance Adjustment 1 |
| EffectiveDate | 2024/03/31 |
| PayrollName | LL Monthly Payroll No Offset |
| ConsolidationSetName | ZHRX-CN-DD-CG1 |
| AssignmentNumber | E123457193 |
| TaxReportingUnitName | ZHRX-CN-DD-LRU-BJ1 |
| ElementName | Regular Tax |
| ElementName | Children Education Fee |
| ElementName | Housing mortgage interest |
Note: The line records specify the element for which you will supply the values for in
the value record.
Balance Adjustment Value Data
| BatchLineSequence | Input Value name | Entry Value |
|---|---|---|
| 1 | Income | 30000 |
| 1 | Tax Base | 30000 |
| 1 | Nontaxable Income | 3000 |
| 1 | Tax Payable | 225 |
| 1 | Reduced Tax Payable | 225 |
| 1 | Pay Value | 225 |
| 2 | Children Education Fee Pay Value | -1500 |
| 3 | Housing mortgage interest Pay Value | -3000 |
For a balance adjustment value to be correctly associated with its parent balance adjustment line, these attributes on both lines must have identical values:
- Batch Name
- Batch Line Sequence
- Effective Date
- Payroll Name
- Consolidation Set Name
- Element Name
Use the AdjustBalanceBatchLine.dat file to load the balance initialization lines defined above:
METADATA|BalanceAdjustmentLine|LegislativeDataGroupName|BatchName|BatchLineSequence|EffectiveDate|PayrollName|ConsolidationSetName|AssignmentNumber|TaxReportingUnitName|ElementName
MERGE|BalanceAdjustmentLine|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|1|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|E123457193|ZHRX-CN-DD-LRU-BJ1|Regular Tax
MERGE|BalanceAdjustmentLine|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|2|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|E123457193|ZHRX-CN-DD-LRU-BJ1|ZHRX-CN-TB-Children education fee
MERGE|BalanceAdjustmentLine|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|3|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|E123457193|ZHRX-CN-DD-LRU-BJ1|ZHRX-CN-TB-Housing mortgage interest
METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName|BatchLineSequence|EffectiveDate|PayrollName|ConsolidationSetName|ElementName|InputValueName|EntryValue
MERGE|BalanceAdjustmentValue|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|1|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|Regular Tax|Income|30000
MERGE|BalanceAdjustmentValue|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|1|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|Regular Tax|Tax Base|30000
MERGE|BalanceAdjustmentValue|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|1|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|Regular Tax|Nontaxable Income|3000
MERGE|BalanceAdjustmentValue|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|1|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|Regular Tax|Tax Payable|225
MERGE|BalanceAdjustmentValue|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|1|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|Regular Tax|Reduced Tax Payable|225
MERGE|BalanceAdjustmentValue|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|1|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|Regular Tax|Pay Value|225
MERGE|BalanceAdjustmentValue|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|2|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|ZHRX-CN-TB-Children education fee|Pay Value|-1500
MERGE|BalanceAdjustmentValue|A-ZHRX-CN-DD-LDG1|202403 Balance Adjustment 1|3|2024/03/31|LL Monthly Payroll No Offset|ZHRX-CN-DD-CG1|ZHRX-CN-TB-Housing mortgage interest|Pay Value|-3000