This example creates a batch header and group record, with various lines and values
to adjust some Quebec Labour Standards balances for one employee - exempt CCQ employee wages
– without excess remuneration.
At year-end, if any wages are adjusted, you must also adjust the related Quebec Labour
Standards balances.
In this case, the CCQ Employee Wages is adjusted by $10,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 |
CCQ Employee Wages |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
10,000 |
YTD Balance After Adjusting |
10,000 |
Notes |
Adjusted amount to $10,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 |
-10,000 |
YTD Balance After Adjusting |
75,000 |
Notes |
Adjusted to reduce for exempt wages. |
Balance Name |
Quebec Labour Standards Exempt |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
10,000 |
YTD Balance After Adjusting |
10,000 |
Notes |
Adjusted to include as exempt wages. |
Balance Name |
Quebec Labour Standards Excess |
YTD Balance Prior to Adjusting |
6,500 |
Adjustment Value |
-6,500 |
YTD Balance After Adjusting |
0 |
Notes |
Adjustment to reduce the same as subject amount. |
Balance Name |
Quebec Labour Standards Taxable |
YTD Balance Prior to Adjusting |
78,500 |
Adjustment Value |
-3,500 |
YTD Balance After Adjusting |
74,000 |
Notes |
Adjusted to reduce to match taxable. |
Balance Name |
Quebec Labour Standards Liability |
YTD Balance Prior to Adjusting |
54.95 |
Adjustment Value |
-2.45 |
YTD Balance After Adjusting |
52.50 |
Notes |
Adjusted to reflect calculated value (75,000 * .0007 = 52.50) |
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_WO_RENUMERATION
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|CA LDG|EX_CCQ_EXCESS_WO_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 |
10,000 |
Quebec Labour Standards Subject |
-10,000 |
Quebec Labour Standards Exempt |
10,000 |
Quebec Labour Standards Excess |
-6,500 |
Quebec Labour Standards Taxable |
-3,500 |
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|EX_CCQ_EXCESS_WO_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_WO_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Province|Quebec Labour Standards Results|19
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_WO_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_WO_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_WO_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|CCQ Employee Wages|Quebec Labour Standards Results|10000
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_WO_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Subject|Quebec Labour Standards Results|-10000
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_WO_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Exempt|Quebec Labour Standards Results|10000
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_WO_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Excess|Quebec Labour Standards Results|-6500
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_WO_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Taxable|Quebec Labour Standards Results|-3500
MERGE|BalanceAdjustmentValue|CA LDG|EX_CCQ_EXCESS_WO_RENUMERATION|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Liability|Quebec Labour Standards Results|-2.45