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-CG1
Load 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