ARCHIVED - Payroll Deductions Formulas for Computer Programs - 99th Edition Effective Sept 1, 2014

Archived

This page has been archived on the Web.

T4127(E) Rev. 14

La version française de cette publication est intitulée Formules pour le calcul informatisé des retenues sur la paie – 99e édition.

Table of contents

• Is this guide for you?
• Distribution of this guide
• Electronic mailing lists - more ways to serve you!
• Payroll Deductions Online Calculator
• Payroll Deductions Tables
• What's new for September 1, 2014?
• Changes included in this edition
  • Provincial and territorial tax changes
    • Ontario
• Chapter 1 – Claim codes
  • Federal, provincial, and territorial claim codes
• Chapter 2 – Glossary
• Chapter 3 – Option 1 – Tax formula
  • Formula to calculate annual taxable income (A)
  • Formula to calculate basic federal tax (T3)
  • Formula to calculate annual basic provincial or territorial tax (T2)
    • Ontario:
• Chapter 4 – Option 2 – Tax formula based on cumulative averaging
  • Formula to calculate provincial and territorial tax payable (T2)
    • Ontario:

Is this guide for you?

Use this guide if you are a payroll software provider or a company which develops its own in-house payroll solution.

This guide has the formulas you need to determine federal, provincial (except Quebec), and territorial income taxes, Canada Pension Plan (CPP) contributions, and employment insurance (EI) premium deductions. The formulas also let you calculate payroll deductions for special cases such as commission, pension income, bonuses, and retroactive pay increases.

The formulas used in this guide to calculate statutory deductions have been approved for purposes of the Income Tax Act, the Canada Pension Plan, and the Employment Insurance Act, as well as their related regulations and any amendments proposed to these acts.

For more information on income amounts that are subject to payroll deductions, see Publication T4001, Employers' Guide – Payroll Deductions and Remittances. For more details on deducting, remitting, and reporting payroll deductions, visit our Web site at www.cra.gc.ca/payroll.

If you have questions about the formulas in this guide, contact your tax services office or tax centre. For the address and telephone numbers of your tax services office or tax centre, see the listings in the government section of your telephone book or visit our Web site at www.cra.gc.ca.

Distribution of this guide

This guide is available in electronic format only.

Electronic mailing lists – more ways to serve you!

We provide an electronic service that can notify you immediately, free of charge, of any changes for payroll deductions.

To subscribe, go to www.cra.gc.ca/lists and enter your business's email address for each mailing list that you want to join.

Payroll Deductions Online Calculator

For your payroll deductions, you can use our Payroll Deductions Online Calculator (PDOC). The calculator includes an option to help you make sure that enough Canada Pension Plan contributions and employment insurance premiums have been withheld for full-year employees. It calculates payroll deductions for the most common pay periods, as well as the applicable province (except Quebec) or territory. The calculation is based on exact salary figures.

PDOC is available at www.cra.gc.ca/pdoc.

Payroll Deductions Tables

You can download Publication T4032, Payroll Deductions Tables and Publication T4008, Payroll Deductions Supplementary Tables, from our Web site at www.cra.gc.ca/payroll. You can also choose to print only the pages or information that you need.

What's new for September 1, 2014?

This guide reflects some income tax changes recently announced which, if enacted as proposed, would be effective September 1, 2014. At the time of publishing, these proposed changes were not law. We recommend that you use the Payroll Deductions Online Calculator (PDOC), Publication T4032, Payroll Deductions Tables, or Publication T4008, Payroll Deductions Supplementary Tables, and the formulas in this guide for withholding, starting with your first payroll in September 2014.

Changes included in this edition

There are no changes to the federal tax rates, income thresholds, or personal amounts required for September 1, 2014. However, some provincial and territorial changes have been announced for September 1, 2014. As a result, we have not revised the entire guide, but we have provided this updated edition, which contains the provincial changes for Ontario.

For formulas and factors not included in this edition, see guide T4127, Payroll Deductions Formulas for Computer Programs – 98th Edition, effective January 1, 2014.

Provincial and territorial tax changes

You will find below the provincial and territorial tax changes effective September 1, 2014.

Ontario

In the provincial Budget 2014 of July 14, 2014, changes were announced to the provincial tax rates and income thresholds. Effective September 1, 2014, the rates and income thresholds for Option 1 are as follows:

• 5.05% on income less than or equal to $40,120;
• 9.15% on income greater than $40,120, but less than or equal to $80,242;
• 11.16% on income greater than $80,242, but less than or equal to $150,000;
• 14.16% on income greater than $150,000, but less than or equal to $220,000;
• 17.16% on income greater than $220,000, but less than or equal to $514,090;
• 13.16% on income greater than $514,090. 

Chapter 1 – Claim codes

Federal, provincial, and territorial claim codes

The Federal, provincial and territorial claim codes are not changed. Therefore we are not reproducing the charts in this edition.

Chapter 2 – Glossary

All factor definitions appear only in the Glossary unless further details are required in specific situations.

Factor	Meaning (for complete details, see the formulas)
A	Annual taxable income
B	Gross bonus, retroactive pay increase, vacation pay when vacation is not taken, and accumulated overtime payment payable now.
B1	Gross bonus, retroactive pay increase, or other non-periodic payments year-to-date (before the pay period)
C	Canada (or Quebec) Pension Plan contributions for the pay period
D	Employee's year-to-date Canada Pension Plan contribution with the employer (cannot be more than the annual maximum.)
D1	Employee's year-to-date employment insurance premium with the employer
E	Total commission expenses deductions reported on Form TD1X
EI	Employment insurance premiums for the pay period
F	Payroll deductions for the pay period for employee contributions to a registered pension plan (RPP) for current and past services, a registered retirement savings plan (RRSP), or a retirement compensation arrangement (RCA). For tax deduction purposes, employers can deduct amounts contributed to an RPP, RRSP, or RCA by or on behalf of an employee to determine the employee's taxable income.
F1	Annual deductions such as child care expenses and support payments, requested by an employee or pensioner and authorized by a tax services office or tax centre
F2	Alimony or maintenance payments required by a legal document dated before May 1, 1997, to be payroll-deducted authorized by a tax services office or tax centre
F3	Employee registered pension plan or registered retirement savings plan contributions deducted from the current non-periodic payment. You can also use this field or design another to apply other tax-deductible amounts to the non-periodic payment, such as union dues.
F4	Employee registered pension plan or registered retirement savings plan contributions deducted from the year-to-date non-periodic payments. You can also use this field or design another to apply other tax-deductible amounts to the non-periodic payment, such as union dues.
G	Gross commission amount including gross salary at the time of payment, plus any taxable benefits for commission-remunerated employees who have filled out Form TD1X. When an employee has not filed Form TD1X, tax is calculated the regular way.
HD	Annual deduction for living in a prescribed zone, as shown on Form TD1
I	Gross remuneration for the pay period. This includes overtime earned and paid in the same pay period, pension income, qualified pension income, and taxable benefits, but does not include bonuses, retroactive pay increases, or other non-periodic payments.
I1	Total remuneration for the year reported on Form TD1X. This include commission payments, salary (where applicable), non-periodic payments, and taxable benefits.
IE	Insurable earnings for the pay period including insurable taxable benefits, bonuses, and retroactive pay increases
K	Federal constant. The constant is the tax overcharged when applying the 22%, 26% and 29% rates to the annual taxable income A.
KP	Provincial or territorial constant
K1	Federal non-refundable personal tax credit (the lowest federal tax rate is used to calculate this credit)
K1P	Provincial or territorial non-refundable personal tax credit (the lowest tax rate is used to calculate this credit)
K2	Federal Canada (or Quebec) Pension Plan contributions and employment insurance premiums tax credits for the year (the lowest federal tax rate is used to calculate this credit). Note: If an employee has already contributed the maximum CPP, EI, or QPIP for the year with the employer, use the maximum CPP, EI, or QPIP deduction to determine the credit for the rest of the year. If, during the pay period in which the employee reaches the maximum, the CPP, EI, or QPIP, when annualized, is less than the annual maximum, use the maximum annual deduction(s) in that pay period.
K2P	Provincial or territorial Canada Pension Plan contributions and employment insurance premiums tax credits for the year (the lowest provincial or territorial tax rate is used to calculate this credit). If an employee reaches the maximum CPP or EI for the year with an employer, the instructions in the note for the K2 factor also apply to the K2P factor. For employees paid by commission, use the federal K2 formula for commissions and replace the lowest federal rate in the K2 formula with the lowest provincial or territorial tax rate.
K2Q	Quebec Pension Plan contributions, employment insurance premiums, and Quebec Parental Insurance Plan premiums federal tax credits for the year (the lowest federal tax rate is used to calculate this credit)
K3	Other federal tax credits (such as medical expenses and charitable donations) authorized by a tax services office or tax centre.
K3P	Other provincial or territorial tax credits (such as medical expenses and charitable donations) authorized by a tax services office or tax centre.
K4	Canada employment credit (the lowest federal tax rate is used to calculate this credit)
K4P	Provincial or territorial Canada employment credit (only applies to Yukon)
L	Additional tax deductions for the pay period requested by the employee or pensioner as shown on Form TD1.
LCF	Federal labour-sponsored funds tax credit
LCP	Provincial or territorial labour-sponsored funds tax credit (only applies to Newfoundland and Labrador, Nova Scotia, Ontario, Manitoba, Saskatchewan, British Columbia, and Yukon)
M	Accumulated federal and provincial or territorial tax deductions (if any) to the end of the last pay period
M1	Year-to-date tax deducted on all payments included in B year-to-date
N	The number of days since the last commission payment. The minimum basic exemption amount of $67.30 is included in the formula in line with CPP legislation.
P	The number of pay periods in the year
PI	Pensionable income for the pay period, or the gross income plus any taxable benefits for the pay period, including bonuses and retroactive pay increases where applicable
PR	The number of pay periods left in the year (doesn't include the current pay period)
R	Federal tax rate that applies to the annual taxable income A
S	Provincial tax reduction (only applies to Ontario and British Columbia)
S1	Annualizing factor
T	Estimated federal and provincial or territorial tax deductions for the pay period
T1	Annual federal tax deduction
T2	Annual provincial or territorial tax deduction (except Quebec)
T3	Annual basic federal tax
T4	Annual basic provincial or territorial tax
TB	Tax deductions, i.e., bonuses or retroactive pay increases, payable now
TC	“Total claim amount” reported on federal Form TD1. If Form TD1 is not filed by the employee or pensioner, TC is the basic personal amount, and for non-resident individuals, TC is $0. If the claim code is E, T = $0. If the province is Ontario, even if the claim code is E, the Ontario Health Premium is payable on annual income over $20,000.
TCP	“Total claim amount” reported on the provincial or territorial Form TD1. If that form is not filed, TCP is the provincial or territorial basic personal amount.
U1	Union dues for the pay period paid to a trade union, an association of public servants, or dues required under the law of a province to a parity or advisory committee or similar body.
V	Provincial or territorial tax rate for the year (does not apply to Quebec, outside Canada, or in Canada beyond the limits of any province or territory)
V1	Provincial or territorial surtax calculated on the basic provincial or territorial tax (only applies to Prince Edward Island, Ontario, and Yukon)
V2	Additional tax calculated on taxable income (only applies to Ontario Health Premium)
Y	Additional provincial or territorial tax reduction based on applicable amounts reported on the provincial or territorial Form TD1
YTD	Year-to-date

Chapter 3 – Option 1 – Tax formula

Formula to calculate annual taxable income (A)

As the formula to calculate the annual taxable income and the explanatory variables have not changed, they have not been reproduced.

Formula to calculate basic federal tax (T3)

As the formula to calculate the basic federal tax and the explanatory variables have not changed, they have not been reproduced.

Formula to calculate annual basic provincial or territorial tax (T2)

As Ontario is the only province or territory to have a provincial/territorial change, we are only reproducing their calculations.

Ontario:

T2 = T4 + V1 + V2 − S − LCP

If the result is negative, T2 = $0.

Where:

T4 =  (V × A) − KP − K1P − K2P − K3P

Where V and KP are based on the value of A in the September 2014 Ontario tax rates and income thresholds Option 1 table.

September 2014 Ontario tax rates and income thresholds - Option 1

Annual taxable income (A) More than – Not more than ($)	Rate (V)	Constant ($) (KP)
0 – 40,120	0.0505	0
40,120 – 80,242	0.0915	1,645
80,242 – 150,000	0.1116	3,258
150,000 – 220,000	0.1416	7,758
220,000 – 514,090	0.1716	14,358
514,090 – and over	0.1316	- 6,206

K1P = 0.0505 × TCP

K2P = [(0.0505 × (P × C, maximum $2,425.50)) + (0.0505 × (P × EI, maximum $913.68))]*

V1 = Where T4 ≤ 4,331,

V1 = $0

Where T4 > $4,331 ≤ $5,543,

V1 = 0.20 × (T4 − $4,331)

Where T4 > $5,543,

V1 = 0.20 × (T4 − $4,331) + 0.36 × (T4 − $5,543)

V2 = Where A ≤ $20,000, V2 = $0

Where A > $20,000 ≤ $36,000, V2 = the lesser of:

1. $300; and
2. 0.06 × (A − $20,000).

Where A > $36,000 ≤ $48,000, V2 = the lesser of:

1. $450; and
2. $300 + (0.06 × (A − $36,000)).

Where A > $48,000 ≤ $72,000, V2 = the lesser of:

1. $600; and
2. $450 + (0.25 × (A − $48,000)).

Where A > $72,000 ≤ $200,000, V2 = the lesser of:

1. $750; and
2. $600 + (0.25 × (A − $72,000)).

Where A > $200,000, V2 = the lesser of:

1. $900; and
2. $750 + (0.25 × (A − $200,000)).

S  = The lesser of:

1. T4 + V1; and
2. [2 × ($223 + Y)] − [T4 + V1].

If the result is negative, S = $0.

Where:

Y  = The total of the following amounts:

$413 multiplied by the number of disabled dependants as shown on Form TD1ON; and

$413 multiplied by the number of dependants under age 19 for which the employee or pensioner has made a request.

LCP = $0

Chapter 4 – Option 2 – Tax formula based on cumulative averaging

There are no changes to the federal tax rates, income thresholds, or personal amounts required for Semptember 1, 2014.

Formula to calculate provincial and territorial tax payable (T2)

As Ontario is the only province or territory to have a change, we are only reproducing their calculations.

Ontario:

T2 = T4 + V1 + V2 − S − LCP

If the result is negative, T2 = $0.

Where:

T4 = (V × A) – KP − K1P − K2P − K3P

Where V and KP are based on the value of A in the September 2014 Ontario tax rates and income thresholds - Option 2 table.

September 2014 Ontario tax rates and income thresholds - Option 2

Annual taxable income (A) More than – Not more than ($)	Rate (V)	Constant ($) (KP)
0 – 40,120	0.0505	0
40,120 – 80,242	0.0915	1,645
80,242 – 150,000	0.1116	3,258
150,000 – 220,000	0.1216	4,758
220,000 – and over	0.1316	6,958

K1P = 0.0505 × TCP

K2P = [(0.0505 × (P × C, maximum $2,425.50)) + (0.0505 × (P × EI, maximum $913.68))]*

V1 = Where T4 ≤ $4,331,

V1 = $0

Where T4 > $4,331 ≤ $5,543,

V1 = 0.20 × (T4 – $4,331)

Where T4 > $5,543,

V1 = 0.20 × (T4 – $4,331) + 0.36 × (T4 – $5,543)

V2 = Where A ≤ $20,000, V2 = $0

Where A > $20,000 ≤ $36,000, V2 = the lesser of:

1. $300; and
2. 0.06 × (A – $20,000).

Where A > $36,000 ≤ $48,000, V2 = the lesser of:

1. $450; and
2. $300 + (0.06 × (A – $36,000)).

Where A > $48,000 ≤ $72,000, V2 = the lesser of:

1. $600; and
2. $450 + (0.25 × (A – $48,000)).

Where A > $72,000 ≤ $200,000, V2 = the lesser of:

1. $750; and
2. $600 + (0.25 × (A – $72,000)).

Where A > $200,000, V2 = the lesser of:

1. $900; and
2. $750 + (0.25 × (A – $200,000)).

S  = The lesser of:

1. T4 + V1; and
2. (ii) [2 × ($223 + Y)] – [T4 + V1].

If the result is negative, S = $0.

Where:

Y  = The total of the following amounts:

$413 multiplied by the number of disabled dependants as shown on Form TD1ON; and

$413 multiplied by the number of dependants under age 19 for which the employee or pensioner has made a request.

LCP = $0

Date modified:

2014-07-23