Example of Quebec Pension Plan Below the Year’s Maximum Pensionable Earnings (YMPE)
In this example, you create balance initialization records to initialize a Quebec employee’s QPP balances where the wages are below the 2024 YMPE ($68,500.00).
Note that in this example there's no need to initialize any of the QPP2 balances because the balances are below the YMPE.
Note: These are only examples, and you may require other balances to be initialized
depending on your unique requirements.
| Balance Name | Value |
|---|---|
| QPP Employee Gross | 60000.00 |
| QPP Employee Subject | 60000.00 |
| QPP Employee Reduced Subject | 60000.00 |
| QPP Employee Taxable | 60000.00 |
| QPP Employee Regular Taxable | 60000.00 |
| QPP Employee Basic Exemption | 2625.00 |
| QPP Employee Withheld | 2019.20 |
| QPP Employer Gross | 60000.00 |
| QPP Employer Subject | 60000.00 |
| QPP Employer Reduced Subject | 60000.00 |
| QPP Employer Taxable | 60000.00 |
| QPP Employer Regular Taxable | 60000.00 |
| QPP Employer Basic Exemption | 2625.00 |
| QPP Employer Liability | 2019.20 |
Load the Initialize Balance Batch Header
Use the InitializeBalanceBatchHeader.dat file to create the batch
header.
METADATA|InitializeBalanceBatchHeader|BatchName|UploadDate|LegislativeDataGroupName
MERGE|InitializeBalanceBatchHeader|EQPP1B|2024/01/01|ZHRX_CAVS_ST_LDGMAIN
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
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|1|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employee Gross|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|2|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employee Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|3|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employee Reduced Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|4|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employee Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|5|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employee Regular Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|5|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU| QPP Employee Basic Exemption|Relationship Tax Unit, Province, Statutory Report Type Year to Date|2625.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|6|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employee Withheld|Relationship Tax Unit, Province, Statutory Report Type Year to Date|2019.20|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|7|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employer Gross|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|8|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employer Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|9|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employer Reduced Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|10|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employer Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|11|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employer Regular Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60000.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|5|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU| QPP Employer Basic Exemption|Relationship Tax Unit, Province, Statutory Report Type Year to Date|2625.00|19|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|EQPP1B|12|955160008195634|ET955160008195634|E955160008195634|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|QPP Employer Liability|Relationship Tax Unit, Province, Statutory Report Type Year to Date|2019.20|19|Year End Forms|T4_RL1