This page (revision-15) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by jmyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
15 26-Nov-2021 10:22 12 KB jmyers to previous
14 26-Nov-2021 10:22 10 KB jmyers to previous | to last
13 26-Nov-2021 10:22 8 KB jmyers to previous | to last
12 26-Nov-2021 10:22 8 KB jmyers to previous | to last
11 26-Nov-2021 10:22 8 KB jmyers to previous | to last
10 26-Nov-2021 10:22 8 KB jmyers to previous | to last
9 26-Nov-2021 10:22 8 KB jmyers to previous | to last
8 26-Nov-2021 10:22 8 KB jmyers to previous | to last
7 26-Nov-2021 10:22 8 KB jmyers to previous | to last
6 26-Nov-2021 10:22 8 KB jmyers to previous | to last
5 26-Nov-2021 10:22 8 KB jmyers to previous | to last
4 26-Nov-2021 10:22 8 KB jmyers to previous | to last
3 26-Nov-2021 10:22 8 KB jmyers to previous | to last
2 26-Nov-2021 10:22 9 KB jmyers to previous | to last
1 26-Nov-2021 10:22 1 KB jmyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed 28 lines
!!CDN FEDERAL PAY COMPONENT USAGES
||Usage|| Description||Pay Component|| Element
|5101| T4 Deduction – Federal Tax| | N/A
|5104| T4 Addn. Tax Deduction - Federal Tax | |
|5100| T4 Earnings – Federal Tax | |N/A
|5111| Pre-T4 Earnings – Federal Tax (PPE)| |
|5115| Pre-T4 Earnings – Federal Tax% (PPE)| |
|5112| Pre-T4 Earnings – Supplemental Tax (PPE) | |
| | | |
|5103| T4A Deduction – Federal Tax | |N/A
|5105| T4A Addn Tax Dedn - Federal Tax | |
|5102| T4A Earnings – Federal Tax | |N/A
|5114| Pre-T4A Earning – Lump Sum Tax (PPE)| |
| | | |
|5113| Taxable Benefit (PPE)| |
|5116| RPP Total Contributions (PPE) | |
|5117| Alimony Total Payments (PPE) | |
|5118| Union Dues Total Deductions (PPE) | |
| | | |
|5023| EI Employee Deduction | |N/A
|5024| EI Employer Contribution | |N/A
|5021| EI Earnings (PPE)| |
|5022| EI Hours (PPE) | |
| | | |
|5003| CPP Employee Deduction | |N/A
|5004| CPP Employer Contribution | |N/A
|5001| CPP Earnings (PPE) | |
|5002| CPP Hours (PPE) | |
[{TableOfContents }]
At line 3 added 2 lines
!!!CANADA LEGISLATION
!!Government Calculation PC Usages
At line 31 changed 15 lines
CANADA LEGISLATION –
Government Calculation PC Usages
||Usage Level||Element||Canada Legislation Usage Description
||Usage||Level||Element||Canada Legislation Usage Description
At line 47 changed one line
|5002| CPP|CCPPHOUR| Canada Pension Plan hours
|5002| CPP|CCPPHOUR| Canada Pension Plan Hours
At line 52 changed one line
|5012| QPP|CQPPHOUR| Quebec Pension Plan hours
|5012| QPP|CQPPHOUR| Quebec Pension Plan Hours
At line 56 changed 2 lines
|5021| EI|CEIEARN |Earnings subject to Employment Insurance
|5022| EI|CEIHRS |Hours eligible for Employment Insurance
|5021| EI|CEIEARN |Earnings Subject to Employment Insurance
|5022| EI|CEIHRS |Hours Eligible for Employment Insurance
At line 60 changed one line
|5031| QPIP|CQPIPEARN| Earnings subject to Quebec Parental Insurance Plan (QPIP)
|5031| QPIP|CQPIPEARN|Earnings Subject to Quebec Parental Insurance Plan (QPIP)
At line 69 changed one line
|5081| WCB|CWCBEARN|Canada Workmen’s Compensation Earnings
|5081| WCB|CWCBEARN|Canada Workmen's Compensation Earnings
At line 72 removed one line
At line 74 changed one line
CANADA LEGISLATION – Federal Tax Calculation PC Usages
!!Federal Tax Calculation PC Usages
At line 76 changed 71 lines
Usage Level Element Federal Tax Usage Description
5100 Fed Federal Taxable Earnings (T4)
5101 Fed Federal Tax Deduction (T4)
5102 Fed Federal Taxable Earnings (T4A)
5103 Fed Federal Tax Deduction (T4A)
5104 Fed T4 Federal Additional Tax Deduction (T4)
5105 Fed T4A Federal Additional Tax Deduction (T4A)
5111 Fed CFTXREG Federal Tax – Regular Taxable Earnings
Regular Earnings that are taxed by normal tax method.
CFTXREG earnings are annualized in the tax formula.
Exclude overtime or one-time earnings that are not paid on regular basis
5112 Fed CFTXSUPL Federal Tax – Supl Earnings that are not paid on regular basis
Supplemental earnings are taxes by “Bonus tax calculation method”.
These earnings are not annualized and are treated as one-time additional earnings that are added to the estimated annual gross.
Include overtime payments, one-time bonus or retroactive pay increases.
5113 Fed CFTXBEN Taxable Benefits that are to be taxed along with CFTXREG or CFTXSUPL.
In a timesheet, CFTXBEN is added to CFTXREG for tax calculation unless when CFTXREG is zero and CFTXSUPL is greater than zero.
In that case, the CFTXBEN is applicable to CFTXSUPL only and therefore CFTXBEN is added to CFTXSUPL tax calculation
5114 Fed CFTXLUMP-T4A Federal Tax – Lump Sum Method payment – T4A Reporting
Special payments that are taxed by Lump Sum Method only.
Please refer to Employers’ Guide to Payroll Deductions for payments.
These payments are reported on T4A
5115 Fed CFTXPERC Federal Tax – Percentage Method
These earnings are taxed by employee specified % or Company specified %
5116 Fed CFTXRPP Federal Tax – RPP contribution subject to tax credit
MC guide factor F
5117 Fed CFTXALMY Federal Tax – Alimony payments subject to tax reduction
MC guide factor F2
5118 Fed CFTXDUES Federal Tax – Union Dues subject to tax exemption
MC guide factor U1
5119 Fed CFTXFUND Federal Tax – Federal Tax Labour Fund Deductions (PPE)
MC guide factor LCF
5120 Fed CPTXFUND Federal Tax – Provincial Tax Labour Fund Deductions (PPE)
MC guide factor LCP
5121 Fed CFTXLUMP-T4 Federal Tax – Lump Sum Method payment – T4 Reporting
Special payments that are taxed by Lump Sum Method only.
These payments are reported on T4
5300 Fed CFTXT4ANR T4A-NR Earnings - Federal Tax
These earnings are taxed by employee specified % or Company specified T4A-NR% or default T4A-NR % supplied by govt
5301 Fed T4A-NR Deduction - Federal Tax
5311 Fed CFTXNR4-1 NR4 Earnings 1 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5312 Fed CFTXNR4-2 NR4 Earnings 2 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5313 Fed CFTXNR4-3 NR4 Earnings 3 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5314 Fed CFTXNR4-4 NR4 Earnings 4 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5315 Fed CFTXNR4-5 NR4 Earnings 5 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5316 Fed CFTXNR4-6 NR4 Earnings 6 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5317 Fed CFTXNR4-7 NR4 Earnings 7 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5318 Fed CFTXNR4-8 NR4 Earnings 8 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5319 Fed CFTXNR4-9 NR4 Earnings 9 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5320 Fed CFTXNR4-10 NR4 Earnings 10 - Federal Tax
These earnings are taxed by employee specified % or Company specified NR4% or default NR4 % supplied by govt
5351 Fed NR4 Deduction 1 - Federal Tax
5352 Fed NR4 Deduction 2 - Federal Tax
5353 Fed NR4 Deduction 3 - Federal Tax
5354 Fed NR4 Deduction 4 - Federal Tax
5355 Fed NR4 Deduction 5 - Federal Tax
5356 Fed NR4 Deduction 6 - Federal Tax
5357 Fed NR4 Deduction 7 - Federal Tax
5358 Fed NR4 Deduction 8 - Federal Tax
5359 Fed NR4 Deduction 9 - Federal Tax
5360 Fed NR4 Deduction 10 - Federal Tax
||Usage||Level||Element||Federal Tax Usage Description
|5100|Fed| |Federal Taxable Earnings (T4)
|5101|Fed| |Federal Tax Deduction (T4)
|5102|Fed| |Federal Taxable Earnings (T4A)
|5103|Fed| |Federal Tax Deduction (T4A)
|5104|Fed| |T4 Federal Additional Tax Deduction (T4)
|5105|Fed| |T4A Federal Additional Tax Deduction (T4A)
|5111|Fed|CFTXREG|Federal Tax - Regular Taxable Earnings\\ \\Regular Earnings that are taxed by normal tax method.\\ \\CFTXREG earnings are annualized in the tax formula.\\ \\Exclude overtime or one-time earnings that are not paid on regular basis.
|5112|Fed|CFTXSUPL|Federal Tax - Supl Earnings that are not paid on regular basis\\ \\Supplemental earnings are taxes by "Bonus Tax Calculation" method.\\ \\These earnings are not annualized and are treated as one-time additional earnings that are added to the estimated annual gross.\\ \\Include overtime payments, one-time bonus or retroactive pay increases.
|5113|Fed|CFTXBEN|Taxable Benefits that are to be taxed along with CFTXREG or CFTXSUPL.\\ \\In a timesheet, CFTXBEN is added to CFTXREG for tax calculation unless when CFTXREG is zero and CFTXSUPL is greater than zero.\\ \\In that case, the CFTXBEN is applicable to CFTXSUPL only and therefore CFTXBEN is added to CFTXSUPL tax calculation.
|5114|Fed|CFTXLUMP-T4A|Federal Tax - Lump Sum Method Payment - T4A Reporting\\ \\Special payments that are taxed by Lump Sum method only.\\ \\Please refer to Employers' Guide to Payroll Deductions for payments.\\ \\These payments are reported on T4A
|5115|Fed|CFTXPERC|Federal Tax - Percentage Method\\ \\These earnings are taxed by employee specified % or company specified %
|5116|Fed|CFTXRPP|Federal Tax - RPP Contribution Subject to Tax Credit\\ \\MC guide factor F\\ \\An employee can make RPP/RRSP contribution for Regular Earnings, or for Regular + Bonus Earnings or for Bonus Earnings only\\ \\Usage 5116 CFTXRPP can be used to include contribution for Regular Earnings only OR for both Regular + Bonus Earnings contribution.\\ \\Usage 5122 CFTXRPP_SUP must be used to include contribution for Bonus Earnings only. To use this element, the user must maintain different pay components to store the RPP/RRSP portion of the contribution for Bonus Earnings.\\ \\If Usage 5122 CFTXRPP_SUP element is NOT SET UP, this means Usage 5116 CFTXRPP contains total RPP/RRSP contributions, therefore CFTXRPP will be prorated among CFTXREG and CFTXSUPL.\\ \\If the user does not want to prorate Usage 5116 CFTXRPP among CFTXREG and CFTXSUPL, set up an empty element for Usage 5122 CFTXRPP_SUP with no pay component.\\ \\Note: Usage 5116 CFTXRPP and Usage 5122 CFTXRPP_SUP must not contain the same pay components in both elements.
|5117|Fed|CFTXALMY|Federal Tax - Alimony Payments Subject to Tax Reduction\\ \\MC guide factor F2
|5118|Fed|CFTXDUES|Federal Tax - Union Dues Subject to Tax Exemption\\ \\MC guide factor U1
|5119|Fed|CFTXFUND|Federal Tax - Federal Tax Labour Fund Deductions (PPE)\\ \\MC guide factor LCF
|5120|Fed|CPTXFUND|Federal Tax - Provincial Tax Labour Fund Deductions (PPE)\\ \\MC guide factor LCP
|5121|Fed|CFTXLUMP-T4|Federal Tax - Lump Sum Method Payment - T4 Reporting\\ \\Special payments that are taxed by Lump Sum method only.\\ \\These payments are reported on T4.
|5122|Fed|CFTXRPP_SUP|Federal Tax – RPP contribution subject to tax credit for Supplemental pay, MC guide factor F\\ \\If this element is SET UP, this means Usage 5122 CFTXRPP_SUP contains the RPP/RRSP pay components that are calculated from Supplemental pay, therefore, Usage 5116 CFTXRPP will NOT be prorated among CFTXREG and CFTXSUPL\\ \\If this element is NOT SET UP, this means Usage 5116 CFTXRPP contains total RPP/RRSP contributions, therefore CFTXRPP will be prorated among CFTXREG and CFTXSUPL\\ \\If the user does not want to prorate Usage 5116 CFTXRPP among CFTXREG and CFTXSUPL, set up an empty element for Usage 5122 CFTXRPP_SUP with no pay component.\\ \\Note: Usage 5116 CFTXRPP and Usage 5122 CFTXRPP_SUP must not contain the same pay components in both elements.
|5300|Fed|CFTXT4ANR|T4A-NR Earnings - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified T4A-NR% or default T4A-NR % supplied by government.
|5301|Fed| |T4A-NR Deduction - Federal Tax
|5311|Fed|CFTXNR4-1|NR4 Earnings 1 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5312|Fed|CFTXNR4-2|NR4 Earnings 2 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5313|Fed|CFTXNR4-3|NR4 Earnings 3 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5314|Fed|CFTXNR4-4|NR4 Earnings 4 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5315|Fed|CFTXNR4-5|NR4 Earnings 5 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5316|Fed|CFTXNR4-6|NR4 Earnings 6 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5317|Fed|CFTXNR4-7|NR4 Earnings 7 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5318|Fed|CFTXNR4-8|NR4 Earnings 8 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5319|Fed|CFTXNR4-9|NR4 Earnings 9 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5320|Fed|CFTXNR4-10|NR4 Earnings 10 - Federal Tax\\ \\These earnings are taxed by employee specified % or company specified NR4% or default NR4 % supplied by government.
|5351|Fed| |NR4 Deduction 1 - Federal Tax
|5352|Fed| |NR4 Deduction 2 - Federal Tax
|5353|Fed| |NR4 Deduction 3 - Federal Tax
|5354|Fed| |NR4 Deduction 4 - Federal Tax
|5355|Fed| |NR4 Deduction 5 - Federal Tax
|5356|Fed| |NR4 Deduction 6 - Federal Tax
|5357|Fed| |NR4 Deduction 7 - Federal Tax
|5358|Fed| |NR4 Deduction 8 - Federal Tax
|5359|Fed| |NR4 Deduction 9 - Federal Tax
|5360|Fed| |NR4 Deduction 10 - Federal Tax
At line 148 changed one line
CANADA LEGISLATION – Quebec Tax Calculation PC Usages
!!Quebec Tax Calculation PC Usages
||Usage||Level||Element||Quebec Tax Usage Description
|5200| Quebec| |Quebec Taxable Earnings (Releve 1)
|5201| Quebec| |Quebec Tax Deduction (Releve 1)
|5202| Quebec| |Quebec Taxable Earnings (Releve 2)
|5203| Quebec| |Quebec Tax Deduction (Releve 2)
|5204| Quebec| |Quebec Additional Tax Deduction (Releve 1)
|5205| Quebec| |Quebec Additional Tax Deduction (Releve 2)
|5211| Quebec| CQTXREG |Quebec Tax - Regular Taxable Earnings\\ \\Regular Earnings that are taxed by normal tax method.\\ \\CQTXREG earnings are annualized in the tax formula.\\ \\\Exclude overtime or one-time earnings that are not paid on regular basis.
|5212|Quebec|CQTXSUPL|Quebec Tax - Supl Earnings that are not paid on regular basis\\ \\Supplemental earnings are taxes by "Bonus Tax Calculation" method.\\ \\These earnings are not annualized and are treated as one-time additional earnings that are added to the estimated annual gross.\\ \\Include overtime payments, one-time bonus or retroactive pay increases.
|5213| Quebec| CQTXBEN |Taxable Benefits that are to be taxed along with CFTXREG or CFTXSUPL.\\ \\In a timesheet, CFTXBEN is added to CFTXREG for tax calculation unless when CFTXREG is zero and CFTXSUPL is greater than zero.\\ \\In that case, the CFTXBEN is applicable to CFTXSUPL only and therefore CFTXBEN is added to CFTXSUPL tax calculation.
|5214|Quebec|CQTXLUMP-R2|Quebec Tax "Lump Sum Method Payment" Releve 2 Reporting\\ \\Special payments that are taxed by Lump Sum Method only.\\ \\Please refer to "Guide for Employers" for payments.\\ \\These payments are always reported on Releve 2.
|5215| Quebec| CQTXPERC|Quebec Tax - Percentage Method\\ \\These earnings are taxed by employee specified % or company specified %.
|5216| Quebec| CQTXRPP |Quebec Tax - RPP contribution subject to tax calculation\\ \\An employee can make RPP/RRSP contribution for Regular Earnings,for Regular + Bonus Earnings or for Bonus Earnings only.\\ \\Usage 5216 CQTXRPP can be used to include contribution for Regular Earnings only OR for both Regular + Bonus Earnings contribution.\\ \\Usage 5221 CQTXRPP_SUP must be used to include contribution for Bonus Earnings only. To use this element, the user must maintain different pay components to store the RPP/RRSP portion of the contribution for Bonus Earnings.\\ \\If Usage 5221 CFTXRPP_SUP element is NOT SET UP, this means Usage 5216 CQTXRPP contains total RPP/RRSP contributions, therefore CQTXRPP will be prorated among CQTXREG and CQTXSUPL.\\ \\If the user does not want to prorate Usage 5216 CFTXRPP among CQTXREG and CQTXSUPL, set up an empty element for Usage 5221 CQTXRPP_SUP with no pay component.\\ \\Note: Usage 5216 CQTXRPP and Usage 5221 CQTXRPP_SUP must not contain the same pay components in both elements.
|5217| Quebec| CQTXFOND|Quebec Tax - Amount paid to purchase shares in FTQ or foundation
|5218| Quebec| CQTXDUES|Quebec Tax - Union Dues subject to tax calculation, factor Q
|5219| Quebec| CQTXFOND1|Quebec Tax - Amount paid to purchase Class A or Class B shares in FTQ or Foundation, factor Q1 of tax formula.
|5220| Quebec| CQTXLUMP-R1|Quebec Tax - Lump Sum Method payment- Releve 1 Reporting\\ \\Special payments that are taxed by Lump Sum Method only.\\ \\Please refer to "Guide for Employers" for payments.\\ \\These payments are always reported on Releve 1
|5221|Quebec|CQTXRPP_SUP|Quebec Tax – RPP contribution subject to tax calculation for Supplemental pay\\ \\If this element is SET UP, this means Usage 5221 CQTXRPP_SUP contains the RPP/RRSP pay components that are calculated from Supplemental pay, therefore, Usage 5216 CQTXRPP will NOT be prorated among CQTXREG and CQTXSUPL.\\ \\If this element is NOT SET UP, this means Usage 5216 CQTXRPP contains total RPP/RRSP contributions, therefore CQTXRPP will be prorated among CQTXREG and CQTXSUPL.\\ \\If the user does not want to prorate Usage 5216 CQTXRPP among CQTXREG and CQTXSUPL, set up an empty element for Usage 5221 CQTXRPP_SUP with no pay component.\\ \\Note: Usage 5216 CQTXRPP and Usage 5221 CQTXRPP_SUP must not contain the same pay components in both elements.
At line 151 removed 33 lines
Usage Level Element Quebec Tax Usage Description
5200 Quebec Quebec Taxable Earnings (Releve 1)
5201 Quebec Quebec Tax Deduction (Releve 1)
5202 Quebec Quebec Taxable Earnings (Releve 2)
5203 Quebec Quebec Tax Deduction (Releve 2)
5204 Quebec Quebec Additional Tax Deduction (Releve 1)
5205 Quebec Quebec Additional Tax Deduction (Releve 2)
5211 Quebec CQTXREG Quebec Tax – Regular Taxable Earnings
Regular Earnings that are taxed by normal tax method.
CQTXREG earnings are annualized in the tax formula.
Exclude overtime or one-time earnings that are not paid on regular basis
5212 Quebec CQTXSUPL Quebec Tax – Supl Earnings that are not paid on regular basis
Supplemental earnings are taxes by “Bonus tax calculation method”.
These earnings are not annualized and are treated as one-time additional earnings that are added to the estimated annual gross.
Include overtime payments, one-time bonus or retroactive pay increases.
5213 Quebec CQTXBEN Taxable Benefits that are to be taxed along with CFTXREG or CFTXSUPL.
In a timesheet, CFTXBEN is added to CFTXREG for tax calculation unless when CFTXREG is zero and CFTXSUPL is greater than zero.
In that case, the CFTXBEN is applicable to CFTXSUPL only and therefore CFTXBEN is added to CFTXSUPL tax calculation
5214 Quebec CQTXLUMP-R2 Quebec Tax – Lump Sum Method payment – Releve 2 Reporting
Special payments that are taxed by Lump Sum Method only.
Please refer to ‘Guide for Employers’ for payments.
These payments are always reported on Releve 2
5215 Quebec CQTXPERC Quebec Tax – Percentage Method
These earnings are taxed by employee specified % or Company specified %
5216 Quebec CQTXRPP Quebec Tax – RPP contribution subject to tax calculation
5217 Quebec CQTXFOND Quebec Tax – Amount paid to purchase shares in FTQ or Fondation.
5218 Quebec CQTXDUES Quebec Tax – Union Dues subject to tax calculation, factor Q
5219 Quebec CQTXFOND1 Quebec Tax – Amount paid to purchase Class A or Class B shares in FTQ or Fondation, factor Q1 of tax formula
5220 Quebec CQTXLUMP-R1 Quebec Tax – Lump Sum Method payment – Releve 1 Reporting
Special payments that are taxed by Lump Sum Method only.
Please refer to ‘Guide for Employers’ for payments.
These payments are always reported on Releve 1