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 wages – 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 several balances are adjusted that reduce subject, and affect QLS
gross. 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 |
5,000 |
YTD Balance After Adjusting |
5,000 |
Notes |
Adjusted amount to $5,000. This is an exempt balance and reduces
subject. |
Balance Name |
RL-1 Box A Adjustment |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
-5,000 |
YTD Balance After Adjusting |
-5,000 |
Notes |
Adjusted amount to $-5,000. This reduces QLS gross. |
Balance Name |
RL-1 Box R Employment Income Adjustment |
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 |
70,000 |
Adjustment Value |
15,000 |
YTD Balance After Adjusting |
85,000 |
Notes |
Adjusted for net of $15,000 (of RL-1 Box Adjustments). |
Balance Name |
Quebec Labour Standards Subject |
YTD Balance Prior to Adjusting |
70,000 |
Adjustment Value |
10,000 |
YTD Balance After Adjusting |
80,00 |
Notes |
Adjusted to reflect QLS gross – exempt. |
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 reflect exempt wages. |
Balance Name |
Quebec Labour Standards Excess |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
1,500 |
YTD Balance After Adjusting |
1,500 |
Notes |
Adjusted to reflect amount over the annual limit (80,000 –
78,500). |
Balance Name |
Quebec Labour Standards Taxable |
YTD Balance Prior to Adjusting |
70,000 |
Adjustment Value |
8,500 |
YTD Balance After Adjusting |
78,500 |
Notes |
Adjusted to reflect subject, up to limit. |
Balance Name |
Quebec Labour Standards Liability |
YTD Balance Prior to Adjusting |
49 |
Adjustment Value |
5.95 |
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|EARN_EXMPT_WAGE_EXCESS_REMUN
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|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 5,000 is
the value specified for the CCQ Employee Wages 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 |
5,000 |
RL-1 Box A Adjustment |
-5,000 |
RL-1 Box R Employment Income Adjustment |
20,000 |
Quebec Labour Standards Gross |
15,000 |
Quebec Labour Standards Subject |
10,000 |
Quebec Labour Standards Exempt |
5,000 |
Quebec Labour Standards Excess |
1,500 |
Quebec Labour Standards Taxable |
8,500 |
Quebec Labour Standards Liability |
5.95 |
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|EARN_EXMPT_WAGE_EXCESS_REMUN|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|EntryValue|ElementName
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Province|19|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Identification Number|7453627101RS0001|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Reporting Type|T4_RL1|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|CCQ Employee Wages|5000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|RL-1 Box A Adjustment|-5000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|RL-1 Box R Employment Income Adjustment|20000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Gross|15000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Subject|10000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Exempt|5000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Excess|1500|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Taxable|8500|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EARN_EXMPT_WAGE_EXCESS_REMUN|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Liability|5.95|Quebec Labour Standards Results