Example of Canada Pension Plan Between the Year’s Maximum Pensionable Earnings (YMPE) and the Year’s Additional Maximum Pensionable Earnings (YAMPE)
In this example, you create balance initialization records to initialize an employee’s CPP and CPP2 balances where the wages are between the 2024 YMPE ($68,500.00) and the 2024 YAMPE ($73,200.00).
Note: These are only examples, and you may require other balances to be initialized
depending on your unique requirements.
| Balance Name | Value |
|---|---|
| CPP Employee Gross | 70000.00 |
| CPP Employee Subject | 70000.00 |
| CPP Employee Reduced Subject | 70000.00 |
| CPP Employee Taxable | 68500.00 |
| CPP Employee Regular Taxable | 68500.00 |
| CPP Employee Excess | 1500.00 |
| CPP Employee Basic Exemption | 2625.00 |
| CPP Employee Withheld | 3867.50 |
| CPP Employer Gross | 70000.00 |
| CPP Employer Subject | 70000.00 |
| CPP Employer Reduced Subject | 70000.00 |
| CPP Employer Taxable | 68500.00 |
| CPP Employer Regular Taxable | 68500.00 |
| CPP Employer Excess | 1500.00 |
| CPP Employer Basic Exemption | 2625.00 |
| CPP Employer Liability | 3867.50 |
| CPP2 Employee Taxable | 1500.00 |
| CPP2 Employee Regular Taxable | 1500.00 |
| CPP2 Employee Withheld | 60.00 |
| CPP2 Employer Taxable | 1500.00 |
| CPP2 Employer Regular Taxable | 1500.00 |
| CPP2 Employer Liability | 60.00 |
Load the Initialize Balance Batch Header
Use the InitializeBalanceBatchHeader.dat file to create the batch
header.
METADATA|InitializeBalanceBatchHeader|BatchName|UploadDate|LegislativeDataGroupName
MERGE|InitializeBalanceBatchHeader|ECPP3|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|ECPP3|1|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Gross|Relationship Tax Unit, Province, Statutory Report Type Year to Date|70000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|2|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|70000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|3|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Reduced Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|70000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|4|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|68500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|5|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Regular Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|68500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|6|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Excess|Relationship Tax Unit, Province, Statutory Report Type Year to Date|1500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|7|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU| CPP Employee Basic Exemption|Relationship Tax Unit, Province, Statutory Report Type Year to Date|2625.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|7|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Withheld|Relationship Tax Unit, Province, Statutory Report Type Year to Date|3867.50|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|8|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Gross|Relationship Tax Unit, Province, Statutory Report Type Year to Date|70000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|9|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|70000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|10|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Reduced Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|70000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|11|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|68500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|12|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Regular Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|68500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|13|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Excess|Relationship Tax Unit, Province, Statutory Report Type Year to Date|1500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|7|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU| CPP Employer Basic Exemption|Relationship Tax Unit, Province, Statutory Report Type Year to Date|2625.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|14|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Liability|Relationship Tax Unit, Province, Statutory Report Type Year to Date|3867.50|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|14|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employee Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|1500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|16|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employee Regular Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|1500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|17|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employee Withheld|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|18|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employer Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|1500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|19|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employer Regular Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|1500.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP3|20|955160008195630|ET955160008195630|E955160008195630|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employer Liability|Relationship Tax Unit, Province, Statutory Report Type Year to Date|60.00|15|Year End Forms|T4_RL1