This example creates a batch header and group record, with various lines and values
to adjust some Quebec Labour Standards balances for one employee - indemnities for damages –
with excess remuneration.
At year-end, if any wages are adjusted, you must also adjust the related Quebec Labour
Standards balances. In this case, the Indemnities for Damages balance is adjusted by
$20,000. Other QLS balances are adjusted as required. In this example, the annual
maximum limit is $78,500. No adjustments are required to Gross Earnings.
Balance Name |
Indemnities for Damages |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
20,000 |
YTD Balance After Adjusting |
20,000 |
Notes |
Adjusted amount to $20,000. This adds to QLS gross. |
Balance Name |
Quebec Labour Standards Gross |
YTD Balance Prior to Adjusting |
75,000 |
Adjustment Value |
20,000 |
YTD Balance After Adjusting |
95,000 |
Notes |
Adjusted since Indemnities for Damages was adjusted, it adds to QLS
gross. |
Balance Name |
Quebec Labour Standards Subject |
YTD Balance Prior to Adjusting |
75,000 |
Adjustment Value |
20,000 |
YTD Balance After Adjusting |
95,000 |
Notes |
Adjusted to reflect increase in QLS gross. |
Balance Name |
Quebec Labour Standards Exempt |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
N/A |
YTD Balance After Adjusting |
0 |
Notes |
No adjustment necessary, no exempt wages. |
Balance Name |
Quebec Labour Standards Excess |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
16,500 |
YTD Balance After Adjusting |
16,500 |
Notes |
Adjusted to reflect amount over the annual limit (95,000 –
78,500). |
Balance Name |
Quebec Labour Standards Taxable |
YTD Balance Prior to Adjusting |
75,000 |
Adjustment Value |
3,500 |
YTD Balance After Adjusting |
78,500 |
Notes |
Adjusted to reflect subject amount, up to the limit. |
Balance Name |
Quebec Labour Standards Liability |
YTD Balance Prior to Adjusting |
52.50 |
Adjustment Value |
2.45 |
YTD Balance After Adjusting |
54.95 |
Notes |
Adjusted to reflect calculated value (78,500 * .0007 =
54.95). |
Note: When adjusting balances you may 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|CA LDG|INDEM_DAM_EXCESS_RENUM
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|CA LDG|INDEM_DAM_EXCESS_RENUM|2020/12/31|CA Semimonthly|CA Semimonthly Consolidation Set|N|N
Load the Balance Adjustment Lines and Values
The Balance Adjustment Lines files lines specify the element you will supply
values for:
Batch Line Sequence |
Assignment Number |
Element Name |
Tax Reporting Unit Name |
1 |
E192278 |
Quebec Labour Standards Results |
CA Tax Reporting Unit |
The Balance Adjustment Value file lines specify the input values for the element
named in the line record. The Entry Value is the value for the Input Value Name of
the Element Name. For example in the fourth line below, the Entry Value of 20,000 is
the value specified for the Indemnities for Damages input value for the Quebec
Labour Standards Results element.
You must also specify the contexts for the Province, Quebec Identification Number,
and Reporting Type.
Batch Line Sequence |
Element Name |
|
|
1 |
Quebec Labour Standards Results |
Province |
19 |
Quebec Identification Number |
7453627101RS0001 |
Reporting Type |
T4_RL1 |
Indemnities for Damages |
20000 |
Quebec Labour Standards Gross |
20000 |
Quebec Labour Standards Subject |
20000 |
Quebec Labour Standards Excess |
16500 |
Quebec Labour Standards Taxable |
3500 |
Quebec Labour Standards Liability |
2.45 |
Use the BalanceAdjustmentLine.dat file to create the batch line and value
records.
METADATA|BalanceAdjustmentLine|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|AssignmentNumber|ElementName|TaxReportingUnitName
MERGE|BalanceAdjustmentLine|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|E192278|Quebec Labour Standards Results|CA Tax Reporting Name
METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|InputValueName|EntryValue|ElementName
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Province|19|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Identification Number|7453627101RS0001|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Reporting Type|T4_RL1|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Indemnities for Damages|20000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Gross|20000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Subject|20000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Excess|16500|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Taxable|3500|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|INDEM_DAM_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Liability|2.45|Quebec Labour Standards Results