In this example, you create balance initialization records to initialize termination
and superannuation 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_TERMPAY|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 Gratuity Computation Salary balance
to:
Attribute |
Value |
LineSequence |
1 |
BalanceName |
Gratuity Computation Salary |
DimensionName |
Relationship Last April 1 Month |
Value |
7001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Gratuity Computation Salary balance
to:
Attribute |
Value |
LineSequence |
2 |
BalanceName |
Gratuity Computation Salary |
DimensionName |
Relationship Last May 1 Month |
Value |
7002 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Gratuity Computation Salary balance
to:
Attribute |
Value |
LineSequence |
3 |
BalanceName |
Gratuity Computation Salary |
DimensionName |
Relationship Last June 1 Month |
Value |
7003 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Gratuity Computation Salary balance
to:
Attribute |
Value |
LineSequence |
4 |
BalanceName |
Gratuity Computation Salary |
DimensionName |
Relationship Last July 1 Month |
Value |
7004 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Gratuity Computation Salary balance
to:
Attribute |
Value |
LineSequence |
5 |
BalanceName |
Gratuity Computation Salary |
DimensionName |
Relationship Last Month |
Value |
7004 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Gratuity Amount balance to:
Attribute |
Value |
LineSequence |
6 |
BalanceName |
Gratuity Amount |
DimensionName |
Relationship Tax Year to Date |
Value |
8001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Gratuity Amount Nontaxable balance
to:
Attribute |
Value |
LineSequence |
7 |
BalanceName |
Gratuity Amount Nontaxable |
DimensionName |
Relationship Tax Year to Date |
Value |
|8001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Leave Encashment Computation Salary
balance to:
Attribute |
Value |
LineSequence |
8 |
BalanceName |
Leave Encashment Computation Salary |
DimensionName |
Relationship Last Month |
Value |
9001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Leave Encashment balance to:
Attribute |
Value |
LineSequence |
9 |
BalanceName |
Leave Encashment |
DimensionName |
Relationship Tax Year to Date |
Value |
9013 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Leave Encashment Amount Nontaxable
balance to:
Attribute |
Value |
LineSequence |
10 |
BalanceName |
Leave Encashment Amount Nontaxable |
DimensionName |
Relationship Tax Year to Date |
Value |
9013 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Retrenchment Compensation Computation
Salary balance to:
Attribute |
Value |
LineSequence |
11 |
BalanceName |
Retrenchment Compensation Computation Salary |
DimensionName |
Relationship Last Month |
Value |
6002 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Retrenchment Compensation Nontaxable
balance to:
Attribute |
Value |
LineSequence |
12 |
BalanceName |
Retrenchment Compensation Nontaxable |
DimensionName |
Relationship Tax Year to Date |
Value |
6013 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Retrenchment Compensation Amount balance
to:
Attribute |
Value |
LineSequence |
13 |
BalanceName |
Retrenchment Compensation Amount |
DimensionName |
Relationship Tax Year to Date |
Value |
7000 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Commuted Pension balance to:
Attribute |
Value |
LineSequence |
14 |
BalanceName |
Commuted Pension |
DimensionName |
Relationship Tax Year to Date |
Value |
80001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Commuted Pension Nontaxable balance
to:
Attribute |
Value |
LineSequence |
15 |
BalanceName |
Commuted Pension Nontaxable |
DimensionName |
Relationship Tax Year to Date |
Value |
80001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the VRS Amount balance to:
Attribute |
Value |
LineSequence |
16 |
BalanceName |
VRS Amount |
DimensionName |
Relationship Tax Year to Date |
Value |
70001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the VRS Amount Nontaxable balance
to:
Attribute |
Value |
LineSequence |
17 |
BalanceName |
VRS Amount Nontaxable |
DimensionName |
Relationship Tax Year to Date |
Value |
70001 |
ContextOneName |
|
ContextOneValue |
|
Load these details to initialize the Superannuation Contribution balance
to:
Attribute |
Value |
LineSequence |
18 |
BalanceName |
Superannuation Contribution |
DimensionName |
Relationship Tax Year to Date |
Value |
55000 |
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_TERMPAY|1|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Gratuity Computation Salary|Relationship Last April 1 Month|7001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|2|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Gratuity Computation Salary|Relationship Last May 1 Month|7002|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|3|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Gratuity Computation Salary|Relationship Last June 1 Month|7003|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|4|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Gratuity Computation Salary|Relationship Last July 1 Month|7004|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|5|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Gratuity Computation Salary|Relationship Last Month|7004|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|6|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Gratuity Amount|Relationship Tax Year to Date|8001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|7|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Gratuity Amount Nontaxable|Relationship Tax Year to Date|8001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|8|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Leave Encashment Computation Salary|Relationship Last Month|9001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|9|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Leave Encashment|Relationship Tax Year to Date|9013|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|10|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Leave Encashment Amount Nontaxable|Relationship Tax Year to Date|9013|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|11|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Retrenchment Compensation Computation Salary|Relationship Last Month|6001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|12|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Retrenchment Compensation Nontaxable|Relationship Tax Year to Date|6013|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|13|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Retrenchment Compensation Amount|Relationship Tax Year to Date|7000|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|14|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Commuted Pension|Relationship Tax Year to Date|80001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|15|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Commuted Pension Nontaxable|Relationship Tax Year to Date|80001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|16|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||VRS Amount|Relationship Tax Year to Date|70001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|17|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||VRS Amount Nontaxable|Relationship Tax Year to Date|70001|||
MERGE|InitializeBalanceBatchLine|ZHRX_IN_LDG|BALANCE_INIT_TERMPAY|18|955160008194736|ET955160008194736|E955160008194736|IN MONTHLY PAYROLL 2021||Superannuation Contribution|Relationship Tax Year to Date|55000|||