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 and earnings
– without excess remuneration.
In this case, the several exempt balances are adjusted. 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 |
Heavy Equipment Operator Wages |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
5,000 |
YTD Balance After Adjusting |
5,000 |
Notes |
No changes required because Quebec Labour Standards Exempt was
adjusted. Note: Only 50% of this amount is considered
subject. |
Balance Name |
Indemnities for Damages |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
5,000 |
YTD Balance After Adjusting |
5,000 |
Notes |
Adjusted amount to $5,000. This adds to QLS gross. |
Balance Name |
Quebec Labour Standards Gross |
YTD Balance Prior to Adjusting |
70,000 |
Adjustment Value |
5,000 |
YTD Balance After Adjusting |
75,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 |
70,000 |
Adjustment Value |
-2,500 |
YTD Balance After Adjusting |
67,500 |
Notes |
Adjustment = Indemnities for Damages (5,000) - CCQ Employee Wages
(5,000) - (0.5 * Heavy Equipment Operator Wages (5,000) ) =
-2,500
|
Balance Name |
Quebec Labour Standards Exempt |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
7,500 |
YTD Balance After Adjusting |
7,500 |
Notes |
Adjusted to reflect exempt wages. |
Balance Name |
Quebec Labour Standards Excess |
YTD Balance Prior to Adjusting |
0 |
Adjustment Value |
N/A |
YTD Balance After Adjusting |
0 |
Notes |
No adjustment necessary, subject is less than annual limit. |
Balance Name |
Quebec Labour Standards Taxable |
YTD Balance Prior to Adjusting |
70,000 |
Adjustment Value |
-2,500 |
YTD Balance After Adjusting |
67,500 |
Notes |
Adjusted to reflect subject. |
Balance Name |
Quebec Labour Standards Liability |
YTD Balance Prior to Adjusting |
49 |
Adjustment Value |
-1.75 |
YTD Balance After Adjusting |
47.25 |
Notes |
Adjusted to reflect calculated value (67,500 * .0007 =
47.25). |
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|EXMP_WG_EARN_WO_EXCESS_RENUM
METADATA|BalanceAdjustmentGroup|LegislativeDataGroupName|BatchName|EffectiveDate|PayrollName|ConsolidationSetName|PrepayFlag|BalanceAdjCostFlag
MERGE|BalanceAdjustmentGroup|ZHRX_CAVS_ST_LDGMAIN|EXMP_WG_EARN_WO_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 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 |
5000 |
Heavy Equipment Operator Wages |
5000 |
Indemnities for Damages |
5000 |
Quebec Labour Standards Gross |
5000 |
Quebec Labour Standards Subject |
-2500 |
Quebec Labour Standards Exempt |
7500 |
Quebec Labour Standards Taxable |
-2500 |
Quebec Labour Standards Liability |
-1.75 |
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|EXMP_WG_EARN_WO_EXCESS_RENUM|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|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Province|19|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Identification Number|7453627101RS0001|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Reporting Type|T4_RL1|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|CCQ Employee Wages|5000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Heavy Equipment Operator Wages|5000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Indemnities for Damages|5000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Gross|5000|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Subject|-2500|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Exempt|7500|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Taxable|-2500|Quebec Labour Standards Results
MERGE|BalanceAdjustmentValue|CA LDG|EXMP_WG_EARN_WO_EXCESS_RENUM|CA Semimonthly|CA Semimonthly Consolidation Set|2020/12/31|1|Quebec Labour Standards Liability|-1.75|Quebec Labour Standards Results