Example of Adjusting Earning Element Balances for the UK
This balance adjustment example creates a batch header and group record for an employee to adjust the following balances using an earnings element.
The element input values will adjust the following balances:
- Gross pay and earnings
- Taxable pay
- NIable earnings
- Pensionable pay
- Attachable earnings
Note: When adjusting balances, you might also need to adjust any related balances, depending
on your business needs. This is simply an example to illustrate the process.
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|Salary Adjustment
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|UK LDG|Salary Adjustment|2022/04/06|UK Engineering Monthly||Y|N
Load the Balance Adjustment Line and Value
| Line Sequence | 1 |
| Batch Name | Salary Adjustment |
| Payroll Name | UK Engineering Monthly |
| Consolidation Set Name | N/A |
| Effective Date | 2022/04/06 |
| Assignment Number | E955160008184963 |
| Element Name | UK Salary Payment |
| Tax Reporting Unit Name | UK Engineering Ltd. |
Note: The line records specify the element for which you will supply the values for in
the value record.
Balance Adjustment Value Data
| Line Sequence | Input Value name | Entry Value |
|---|---|---|
| 1 | Amount to Pay | 1200 |
| 2 | Reporting Unit | None |
| 3 | Periodicity | Calendar Month |
| 4 | Periodicity Conversion Rule | Standard Rate Annualized |
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
- Payroll Name
- Consolidation Set Name
- Effective Date
- Element Name
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|Salary Adjustment|UK Engineering Monthly||2022/04/06|1|UK Salary Payment|E8184963|UK Engineering Ltd
METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|ElementName|InputValueName|EntryValue
MERGE|BalanceAdjustmentValue|UK LDG|Salary Adjustment|UK Engineering Monthly||2022/04/06|1|UK Salary Payment|Amount to Pay|1200
MERGE|BalanceAdjustmentValue|UK LDG|Salary Adjustment|UK Engineering Monthly||2022/04/06|2|UK Salary Payment|Reporting Unit|None
MERGE|BalanceAdjustmentValue|UK LDG|Salary Adjustment|UK Engineering Monthly||2022/04/06|3|UK Salary Payment|Periodicity|Calendar Month
MERGE|BalanceAdjustmentValue|UK LDG|Salary Adjustment|UK Engineering Monthly||2022/04/06|4|UK Salary Payment|Periodicity Conversion Rule|Standard Rate Annualized