Example of Adjusting National Insurance Balances for the UK
In this example, the requirement is to reduce the balances for category D and increase the balance values for Category A.
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|UK LDG|NI Adjustment
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|UK LDG|NI Adjustment|2022/04/06|UK Engineering Monthly||Y|Y
Load the Balance Adjustment Line and Values
The line record specifies the element used to adjust the balances.
| Line Sequence | 1 |
| Batch Name | NI Employee Adjustment |
| Payroll Name | UK Engineering Monthly |
| Consolidation Set Name | N/A |
| Effective Date | 2022/04/06 |
| Assignment Number | E8184963 |
| Element Name | NI Employee Adjustment |
| Tax Reporting Unit Name | UK Engineering Ltd |
Balance Adjustment Values Data
| Category | A |
| Pension | Not contracted out |
| Statutory Deduction Card id | 300012010991367 |
| NIable LEL | 150.00 |
| NIable LEL Calculation | 120.00 |
| NIable PT | 100.00 |
| NIable UAP | 0.00 |
| NIable UEL | 25.00 |
| NIable UEL | 25.00 |
| NIable AUEL | 0.00 |
| NIable | 425.00 |
| NIable for Off Payroll Worker | 0.00 |
| Pay Value | 450.00 |
| NI Employee UEL | 0.00 |
| NI Employee AUEL | 0.00 |
| NI Employee | 345.00 |
| NI Employee UAP | 0.00 |
| NI Employee for Off Payroll Worker | 0.00 |
| Director | No |
| Category | D |
| Pension | Contracted out |
| Statutory Deduction Card id | 300012010991367 |
| NIable LEL | -150.00 |
| NIable LEL Calculation | -120.00 |
| NIable PT | -100.00 |
| NIable UAP | 0.00 |
| NIable UEL | -25.00 |
| NIable AUEL | 0.00 |
| NIable | -425.00 |
| NIable for Off Payroll Worker | 0.00 |
| Pay Value | -450.00 |
| NI Employee UEL | 0.00 |
| NI Employee AUEL | 0.00 |
| NI Employee | -345.00 |
| NI Employee UAP | 0.00 |
| NI Employee for Off Payroll Worker | 0.00 |
| Director | No |
Use the BalanceAdjusmentLine.dat file to create batch line and value records:
METADATA|BalanceAdjustmentLine|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|ElementName|AssignmentNumber|TaxReportingUnitName
MERGE|BalanceAdjustmentLine|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|E8184963|UK Engineering Ltd
METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|ElementName|InputValueName|EntryValue
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|Category|A
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1| NI Employee Adjustment|Pension|Not Contracted Out
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1| NI Employee Adjustment|Statutory Deduction Card Id|300012010991367
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NIable LEL|150
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1| NI Employee Adjustment|NIable LEL Calculation|120
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NIable PT|100
Monthly||2022/04/06|1|NI Employee Adjustment|NIable UAP|0
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NIable UEL|25
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NIable|425
Monthly||2022/04/06|1|NI Employee Adjustment|NIable for Off Payroll Worker|0
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|Pay Value|450
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NI Employee UEL|0
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NI Employee AUEL|0
Monthly||2022/04/06|1|NI Employee Adjustment|NI Employee|345
M Monthly||2022/04/06|1|NI Employee Adjustment|NI Employee UAP|0
onthly||2022/04/06|1|NI Employee Adjustment|NI Employee for Off Payroll Worker |0
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|Director|No
METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|ElementName|InputValueName|EntryValue
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|Category|D
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1| NI Employee Adjustment|Pension|Contracted Out
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1| NI Employee Adjustment|Statutory Deduction Card Id|300012010991367
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NIable LEL|-150
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1| NI Employee Adjustment|NIable LEL Calculation|-120
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NIable PT|-100
Monthly||2022/04/06|1|NI Employee Adjustment|NIable UAP|0
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NIable UEL|-25
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NIable|425
Monthly||2022/04/06|1|NI Employee Adjustment|NIable for Off Payroll Worker|0
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|Pay Value|-450
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NI Employee UEL|0
MERGE|BalanceAdjustmentValue|UK LDG|NI Adjustment|UK Engineering Monthly||2022/04/06|1|NI Employee Adjustment|NI Employee AUEL|0
Monthly||2022/04/06|1|NI Employee Adjustment|NI Employee|-345
M Monthly||2022/04/06|1|NI Employee Adjustment|NI Employee UAP|0
onthly||2022/04/06|1|NI Employee Adjustment|NI Employee for Off Payroll Worker |0