In this example, you create balance initialization records to initialize HRA related
balances for India.
Load the Initialize Balance Batch Header
Use the InitializeBalanceBatchHeader.dat file to create the batch header.
METADATA|InitializeBalanceBatchHeader|BatchName|UploadDate|LegislativeDataGroupName
MERGE|InitializeBalanceBatchHeader|BALANCE_INIT_HRA|2023/08/01|ZHRX_IN_LDG
Load the Initialize Balance Batch Lines
In the following example, several balances are being initialized for the same
employee. The employee is identified by their payroll relationship number,
employment terms number, and assignment number.
Attribute |
Value |
PayrollRelationshipNumber |
955160008194736 |
TermNumber |
ET955160008194736 |
AssignmentNumber |
E955160008194736 |
The employee’s payroll and tax reporting unit must also be specified on every
initialize balance line.
Attribute |
Value |
PayrollName |
IN MONTHLY PAYROLL 2021 |
TaxUnitName |
|
Load these details to initialize the Salary for House Rent Allowance
Exemption balance to:
Attribute |
Value |
LineSequence |
1 |
BalanceName |
Salary for House Rent Allowance Exemption |
DimensionName |
Relationship Last April 1 Month |
Value |
30001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Salary for House Rent Allowance
Exemption balance to:
Attribute |
Value |
LineSequence |
2 |
BalanceName |
Salary for House Rent Allowance Exemption |
DimensionName |
Relationship Last May 1 Month |
Value |
30002 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Salary for House Rent Allowance
Exemption balance to:
Attribute |
Value |
LineSequence |
3 |
BalanceName |
Salary for House Rent Allowance Exemption |
DimensionName |
Relationship Last June 1 Month |
Value |
30002 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Salary for House Rent Allowance
Exemption balance to:
Attribute |
Value |
LineSequence |
4 |
BalanceName |
Salary for House Rent Allowance Exemption |
DimensionName |
Relationship Last July 1 Month |
Value |
30002 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Taxable House Rent Allowance balance
to:
Attribute |
Value |
LineSequence |
5 |
Tax Unit Name |
ZHRX_IN_TAX_TRU |
BalanceName |
Taxable House Rent Allowance |
DimensionName |
Relationship Tax Unit Tax Year to Date |
Value |
2400 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Taxable House Rent Allowance balance
to:
Attribute |
Value |
LineSequence |
6 |
BalanceName |
Taxable House Rent Allowance |
DimensionName |
Relationship Last April 1 Month |
Value |
600 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Taxable House Rent Allowance balance
to:
Attribute |
Value |
LineSequence |
7 |
BalanceName |
Taxable House Rent Allowance |
DimensionName |
Relationship Last May 1 Month |
Value |
600 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Taxable House Rent Allowance balance
to:
Attribute |
Value |
LineSequence |
8 |
BalanceName |
Taxable House Rent Allowance |
DimensionName |
Relationship Last June 1 Month |
Value |
600 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Taxable House Rent Allowance balance
to:
Attribute |
Value |
LineSequence |
9 |
BalanceName |
Taxable House Rent Allowance |
DimensionName |
Relationship Last July 1 Month |
Value |
600 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the House Rent Allowance Balance to:
Attribute |
Value |
LineSequence |
10 |
BalanceName |
House Rent Allowance Balance |
DimensionName |
Relationship Last April 1 Month |
Value |
800 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the House Rent Allowance Balance to:
Attribute |
Value |
LineSequence |
11 |
BalanceName |
House Rent Allowance Balance |
DimensionName |
Relationship Last May 1 Month |
Value |
800 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the House Rent Allowance balance to:
Attribute |
Value |
LineSequence |
12 |
BalanceName |
House Rent Allowance Balance |
DimensionName |
Relationship Last June 1 Month |
Value |
800 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the House Rent Allowance balance to:
Attribute |
Value |
LineSequence |
13 |
BalanceName |
House Rent Allowance Balance |
DimensionName |
Relationship Last July 1 Month |
Value |
800 |
ContextOneName |
|
ContextOneValue |
|
Use the InitializeBalanceBatchLine.dat file to load the balance initialization lines
defined above:
METADATA|InitializeBalanceBatchLine|LegislativeDataGroupName|BatchName|LineSequence|PayrollRelationshipNumber|TermNumber|AssignmentNumber|PayrollName|TaxUnitName|BalanceName|DimensionName|Value|ContextOneName|ContextOneValue|AreaOne
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|1|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Salary for House Rent Allowance Exemption|Relationship Last April 1 Month|30001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|2|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Salary for House Rent Allowance Exemption|Relationship Last May 1 Month|30002|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|3|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Salary for House Rent Allowance Exemption|Relationship Last June 1 Month|30002|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|4|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Salary for House Rent Allowance Exemption|Relationship Last July 1 Month|30002|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|5|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021|ZHRX_IN_TAX_TRU|Taxable House Rent Allowance|Relationship Tax Unit Tax Year to Date|2400|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|6|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Taxable House Rent Allowance|Relationship Last April 1 Month|600|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|7|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Taxable House Rent Allowance|Relationship Last May 1 Month|600|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|8|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Taxable House Rent Allowance|Relationship Last June 1 Month|600|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|9|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Taxable House Rent Allowance|Relationship Last July 1 Month|600|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|10|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||House Rent Allowance Balance|Relationship Last April 1 Month|800|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|11|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||House Rent Allowance Balance|Relationship Last May 1 Month|800|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|12|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||House Rent Allowance Balance|Relationship Last June 1 Month|800|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_HRA|13|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||House Rent Allowance Balance|Relationship Last July 1 Month|800|||