Example of Loading Quebec Labour Standards Balances: Remuneration Subject to Contribution above the Maximum Limit With Exempt Wages
In this example, you create balance initialization records to initialize an employee’s QLS balances where the wages are above the 2020 annual maximum limit of $78,500 and exempt wages do exist.
Note: These are only examples and you may require other balances to be initialized depending
on your unique requirements. You may need to initialize other balances separately that
are part of QLS gross or QLS exempt earnings.
Balance Name | Value | Notes |
---|---|---|
Gross Earnings | 90,000 | N/A |
Quebec Labour Standards Gross | 90,000 | N/A |
Other Labour Standards Exempt Remuneration | 5,000 | N/A |
Quebec Labour Standards Subject | 85,000 | There are Quebec Labour Standard Exempt Wages, so Subject = Gross – Exempt Wages. |
Quebec Labour Standards Exempt | 5,000 | Gross – Subject |
Quebec Labour Standards Excess | 6,500 | Subject – Limit. For example, using the values for 2020: 85,000 – 78,500 = 6,500 |
Quebec Labour Standards Taxable | 78,500 | Subject amount up to the limit. For example, using the values for 2020: Subject is 85,000 but the limit = 78,500 so Taxable = 78,500 |
Quebec Labour Standards Liability | 54.95 | Calculated value of Taxable * rate. For example, using the values for 2020: 78,500 * 0.0007 = 54.95 |
Load the Initialize Balance Batch Header
Use the InitializeBalanceBatchHeader.dat file to create the batch header.
METADATA|InitializeBalanceBatchHeader|BatchName|UploadDate|LegislativeDataGroupName
MERGE|InitializeBalanceBatchHeader|QLS_REM_ABOVE_MAX_WTH|2020/01/01|CA LDG
Load the Initialize Balance Batch Lines
Use the InitializeBalanceBatchLine.dat file to create the batch
lines.
METADATA|InitializeBalanceBatchLine|LegislativeDataGroupName|BatchName|LineSequence|PayrollRelationshipNumber|TermNumber|AssignmentNumber|PayrollName|TaxUnitName|BalanceName|DimensionName|Value|AreaOne|ContextOneName|ContextOneValue|ContextTwoName|ContextTwoValue
MERGE|InitializeBalanceBatchLine|CA LDG|QLS_REM_ABOVE_MAX_WTH|1|192213|ET192213|E192213|CA Semimonthly|CA Tax Reporting Unit|Quebec Labour Standards Gross|Relationship Tax Unit, Province, Statutory Report Type, Statutory Report Code Year to Date| 90000 |19|Year End Forms|T4_RL1|Statutory Reporting Code|7453627101RS0001
MERGE|InitializeBalanceBatchLine|CA LDG|QLS_REM_ABOVE_MAX_WTH|2|192213|ET192213|E192213|CA Semimonthly|CA Tax Reporting Unit|Quebec Labour Standards Subject|Relationship Tax Unit, Province, Statutory Report Type, Statutory Report Code Year to Date| 85000 |19|Year End Forms|T4_RL1|Statutory Reporting Code|7453627101RS0001
MERGE|InitializeBalanceBatchLine|CA LDG|QLS_REM_ABOVE_MAX_WTH|3|192213|ET192213|E192213|CA Semimonthly|CA Tax Reporting Unit|Quebec Labour Standards Taxable|Relationship Tax Unit, Province, Statutory Report Type, Statutory Report Code Year to Date| 78500 |19|Year End Forms|T4_RL1|Statutory Reporting Code|7453627101RS0001
MERGE|InitializeBalanceBatchLine|CA LDG|QLS_REM_ABOVE_MAX_WTH|4|192213|ET192213|E192213|CA Semimonthly|CA Tax Reporting Unit|Quebec Labour Standards Liability|Relationship Tax Unit, Province, Statutory Report Type, Statutory Report Code Year to Date| 54.95 |19|Year End Forms|T4_RL1|Statutory Reporting Code|7453627101RS0001
MERGE|InitializeBalanceBatchLine|CA LDG|QLS_REM_ABOVE_MAX_WTH|5|192213|ET192213|E192213|CA Semimonthly|CA Tax Reporting Unit|Gross Earnings|Relationship Tax Unit, Province, Statutory Report Type Year to Date| 90000 |19|Year End Forms|T4_RL1||
MERGE|InitializeBalanceBatchLine|CA LDG|QLS_REM_ABOVE_MAX_WTH|6|192213|ET192213|E192213|CA Semimonthly|CA Tax Reporting Unit|Quebec Labour Standards Excess|Relationship Tax Unit, Province, Statutory Report Type, Statutory Report Code Year to Date| 6500 |19|Year End Forms|T4_RL1|Statutory Reporting Code|7453627101RS0001
MERGE|InitializeBalanceBatchLine|CA LDG|QLS_REM_ABOVE_MAX_WTH|7|192213|ET192213|E192213|CA Semimonthly|CA Tax Reporting Unit|Quebec Labour Standards Exempt|Relationship Tax Unit, Province, Statutory Report Type, Statutory Report Code Year to Date| 5000 |19|Year End Forms|T4_RL1|Statutory Reporting Code|7453627101RS0001
MERGE|InitializeBalanceBatchLine|CA LDG|QLS_REM_ABOVE_MAX_WTH|8|192213|ET192213|E192213|CA Semimonthly|CA Tax Reporting Unit|Other Labour Standards Exempt Remuneration|Relationship Tax Unit, Province, Statutory Report Type Year to Date| 5000 |19|Year End Forms|T4_RL1||