At year-end, if any wages are adjusted, you must also adjust the related Quebec
Labour Standards balances.
This example creates a batch header and group record, with various lines and values to
adjust some Quebec Labour Standards balances for one employee. In this case, the CCQ
Employee Wages is adjusted by $5,000. Other related 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 |
CCQ Employee Wages |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
5,000 |
YTD Balance After Adjusting |
5,000 |
Notes |
Adjusted amount to $5,000. This is an exempt balance and reduces
subject. |
Balance Name |
Quebec Labour Standards Gross |
YTD Balance Prior to Adjusting |
85,000 |
Adjustment Value |
N/A |
YTD Balance After Adjusting |
85,000 |
Notes |
No changes required because Quebec Labour Standards Exempt was
adjusted. |
Balance Name |
Quebec Labour Standards Subject |
YTD Balance Prior to Adjusting |
85,000 |
Adjustment Value |
-5,000 |
YTD Balance After Adjusting |
80,000 |
Notes |
Adjusted to reduce for exempt wages. |
Balance Name |
Quebec Labour Standards Exempt |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
5,000 |
YTD Balance After Adjusting |
5,000 |
Notes |
Adjusted to include as exempt wages. |
Balance Name |
Quebec Labour Standards Excess |
YTD Balance Prior to Adjusting |
6,500 |
Adjustment Value |
-5,000 |
YTD Balance After Adjusting |
1,500 |
Notes |
Adjustment to reduce the same as subject amount. |
Balance Name |
Quebec Labour Standards Taxable |
YTD Balance Prior to Adjusting |
78,500 |
Adjustment Value |
N/A |
YTD Balance After Adjusting |
78,500 |
Notes |
Taxable is capped at 2020 annual maximum limit. |
Balance Name |
Quebec Labour Standards Liability |
YTD Balance Prior to Adjusting |
54.95 |
Adjustment Value |
N/A |
YTD Balance After Adjusting |
54.95 |
Notes |
Liability is capped at 2020 annual maximum limit. |
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|EX_CCQ_EXCESS_RENUMERATION
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|CA LDG|EX_CCQ_EXCESS_RENUMERATION|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 third line below, the Entry Value of -5,000 is
the value specified for the Quebec Labour Standards Subject 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 |
CCQ Employee Wages |
5000 |
Quebec Labour Standards Subject |
-5000 |
Quebec Labour Standards Exempt |
5000 |
Quebec Labour Standards Excess |
-5000 |
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|EX_CCQ_EXCESS_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|E192278|Quebec Labour Standards Results|CA Tax Reporting Unit
METADATA|BalanceAdjustmentValue|LegislativeDataGroupName|BatchName|PayrollName|ConsolidationSetName|EffectiveDate|BatchLineSequence|InputValueName|ElementName|EntryValue
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Province|Quebec Labour Standards Results|19
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Identification Number|Quebec Labour Standards Results|7453627101RS0001
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Reporting Type|Quebec Labour Standards Results|T4_RL1
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|CCQ Employee Wages|Quebec Labour Standards Results|5000
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Subject|Quebec Labour Standards Results|-5000
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Exempt|Quebec Labour Standards Results|5000
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Excess|Quebec Labour Standards Results|-5000