年度追加最大年金対象支給額を超えるカナダ年金プランの例(YAMPE)
この例では、バランス初期化レコードを作成して、従業員のCPPおよびCPP2バランスを初期化し、賃金が2024年のYAMPE($73,200.00)を上回ります。
ノート: これらは単なる例であり、固有の要件に応じて他の残高を初期化する必要がある場合があります。
| バランス名 | 値 |
|---|---|
| CPP従業員総額 | 75000.00 |
| CPP従業員件名 | 75000.00 |
| CPP従業員減額対象 | 75000.00 |
| CPP従業員課税対象 | 68500.00 |
| CPP従業員通常課税対象 | 68500.00 |
| CPP従業員超過 | 6500.00 |
| CPP従業員基本控除 | 2625.00 |
| CPP従業員源泉徴収 | 3867.50 |
| CPP事業主総額 | 75000.00 |
| CPP事業主件名 | 75000.00 |
| CPP事業主減額対象 | 75000.00 |
| CPP事業主課税対象 | 68500.00 |
| CPP事業主通常課税対象 | 68500.00 |
| CPP事業主超過 | 6500.00 |
| CPP事業主基本控除 | 2625.00 |
| CPP事業主責任 | 3867.50 |
| CPP2従業員課税対象 | 4700.00 |
| CPP2従業員通常課税対象 | 4700.00 |
| CPP2従業員超過 | 1800.00 |
| CPP2従業員源泉徴収 | 188.00 |
| CPP2事業主課税対象 | 4700.00 |
| CPP2事業主通常課税対象 | 4700.00 |
| CPP2事業主超過 | 1800.00 |
| CPP2事業主責任 | 188.00 |
バランス・バッチ・ヘッダー初期化のロード
InitializeBalanceBatchHeader.datファイルを使用してバッチ・ヘッダーを作成します。
METADATA|InitializeBalanceBatchHeader|BatchName|UploadDate|LegislativeDataGroupName
MERGE|InitializeBalanceBatchHeader|ECPP4|2024/01/01|ZHRX_CAVS_ST_LDGMAIN
バランス・バッチ・ラインの初期化のロード
このInitializeBalanceBatchLine.datファイルを使用して、バッチ・ラインを作成します。
METADATA|InitializeBalanceBatchLine|LegislativeDataGroupName|BatchName|LineSequence|PayrollRelationshipNumber|TermNumber|AssignmentNumber|PayrollName|TaxUnitName|BalanceName|DimensionName|Value|AreaOne|ContextOneName|ContextOneValue
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|1|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Gross|Relationship Tax Unit, Province, Statutory Report Type Year to Date|75000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|2|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|75000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|3|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Reduced Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|75000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|4|955160008195631|ET955160008195631|E955160008195631|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|ECPP4|5|955160008195631|ET955160008195631|E955160008195631|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|ECPP4|6|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employee Excess|Relationship Tax Unit, Province, Statutory Report Type Year to Date|6500.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|ECPP4|7|955160008195631|ET955160008195631|E955160008195631|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|ECPP4|8|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Gross|Relationship Tax Unit, Province, Statutory Report Type Year to Date|75000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|9|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|75000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|10|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Reduced Subject|Relationship Tax Unit, Province, Statutory Report Type Year to Date|75000.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|11|955160008195631|ET955160008195631|E955160008195631|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|ECPP4|12|955160008195631|ET955160008195631|E955160008195631|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|ECPP4|13|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP Employer Excess|Relationship Tax Unit, Province, Statutory Report Type Year to Date|6500.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|ECPP4|14|955160008195631|ET955160008195631|E955160008195631|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|ECPP4|15|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employee Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|4700.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|16|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employee Regular Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|4700.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|17|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employee Excess|Relationship Tax Unit, Province, Statutory Report Type Year to Date|1800.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|18|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employee Withheld|Relationship Tax Unit, Province, Statutory Report Type Year to Date|188.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|19|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employer Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|4700.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|20|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employer Regular Taxable|Relationship Tax Unit, Province, Statutory Report Type Year to Date|4700.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|21|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employer Excess|Relationship Tax Unit, Province, Statutory Report Type Year to Date|1800.00|15|Year End Forms|T4_RL1
MERGE|InitializeBalanceBatchLine|ZHRX_CAVS_ST_LDGMAIN|ECPP4|22|955160008195631|ET955160008195631|E955160008195631|SD R13 Semimonthly|ZHRX_CAVS_ST_MULTITRU|CPP2 Employer Liability|Relationship Tax Unit, Province, Statutory Report Type Year to Date|188.00|15|Year End Forms|T4_RL1