cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Find the help you need to prepare your business, communicate with customers, and support your employees during the COVID-19 outbreak in our resource centre.
Intuit
6 helpful votes

Download the latest payroll tax table update

QuickBooks Desktop provides payroll updates with the most current and accurate rates and calculations for supported provincial and federal tax tables, payroll tax forms and EFILE options to active Payroll subscription customers.

Important: If you have employees in Nova Scotia you may need to manually enter their Provincial TD1 amounts in QuickBooks Desktop. See Changes to TD1 Basic Personal Amount calculation for employees in Nova Scotia for detailed instructions.

The current payroll tax table is version:

  •  11029003 (QuickBooks Desktop 2019) or
  •  11030003 (QuickBooks Desktop 2020).

It was released on December 23, 2019, and is effective from January 1, 2020, to June 30, 2020.

    • To check which version you have:
      • In QuickBooks, from the Employees menu, choose My Payroll Service, then Tax Table Information.
      • The first 3 numbers under "You are using tax table version:" reflect your tax table version and should read 11029003 if you’re using the 2019 version or 11030003 if you’re using the 2020 version. You may already have release 110 if you updated your product earlier this year. In order to apply bug fixes and other improvements, we recommend you update your product with the links below.
    • Reminder:  you'll need to be using QuickBooks Desktop 2020, QuickBooks QuickBooks Desktop Enterprise Solutions 20.0, QuickBooks Desktop 2019 or QuickBooks Desktop Enterprise Solutions 19.0 to download this tax table update.

If you subscribe to QuickBooks Payroll, you can download your updates over the Internet.

  • The easiest way to do this is to set up automatic updates so that QuickBooks downloads payroll updates automatically as soon as they are available.
  • You can also download the latest payroll update anytime while in QuickBooks.
    1. From the Help menu, select Update QuickBooks.
    2. Go to the Update Now tab.
    3. Select Get Updates.
    4. Once the download is complete, exit QuickBooks Desktop.
  • If you have already installed QuickBooks 2019 or QuickBooks 2020 and wish to download the updates manually, use the link for your version of QuickBooks Desktop below.
Effective date 1/1/2020 7/1/2019 7/1/2018 1/1/2018 7/1/2017 1/1/2017
Tax table version # 110 109 108 107 106 105
TD1 Amounts
Federal 12,298 12,069 11,809 11,809 11,635 11,635
AB 19,369 19,369 18,915 18,915 18,690 18,690
BC 10,949 10,682 10,412 10,412 10,208 10,208
MB 9,838 9,626 9,382 9,382 9,271 9,271
NB 10,459 10,264 10,043 10,043 9,895 9,895
NL 9,498 9,414 9,247 9,247 8,978 8,978
NS Click here to learn  how to calculate Click here to learn  how to calculate Click here to learn  how to calculate Click here to learn  how to calculate 8,481 8,481
NT 15,093 14,811 14,492 14,492 14,278 14,278
NU 16,304 13,618 13,325 13,325 13,128 13,128
ON 10,783 10,582 10,354 10,354 10,171 10,171
PE 10,000 9,160 9,160 8,160 8,320 8,000
QC 15,532 15,269 15,012 15,012 11,635 11,635
SK 16,065 16,065 16,065 16,065 16,065 16,065
YT 12,298 12,069 11,809 11,809 11,635 11,635
ZZ (employees outside Canada) 0 0 0 0 0 0
Effective date 1/1/2020 7/1/2019 7/1/2018 1/1/2018 7/1/2017 1/1/2017
Tax table version # 110 109 108 107 106 105
Canada Pension Plan (CPP) - outside Québec
Maximum Pensionable Earnings 58,700 57,400 55,900 55,900 55,300 55,300
Basic Exemption 3,500 3,500 3,500 3,500 3,500 3,500
Contribution Rate 5.25% 5.1% 4.95% 4.95% 4.95% 4.95%
Maximum Contribution (EE) 2,898.20 2748.90 2,593.80 2,593.80 2,564.10 2,564.10
Maximum Contribution (ER) 2,898.20 2748.90 2,593.80 2,593.80 2,564.10 2,564.10
Employment Insurance (EI) - outside Québec
Maximum Insurable Earnings 54,200 53,100 51,700 51,700 51,300 51,300
Premium EI Rate (EE) 1.58% 1.62% 1.66% 1.66% 1.63% 1.63%
Premium EI Rate (ER) (1.4*EE) 2.62% 2.62% 2.62% 2.62% 2.62% 2.62%
Maximum Premium (EE) 856.36 860.22 858.22 858.22 836.19 836.19
Maximum Premium (ER) (1.4*EE) 1,420.04 1,204.31 1,201.51 1,201.51 1,170.67 1,170.67
Effective date 1/1/2020 7/1/2019 7/1/2018 1/1/2018 7/1/2017 1/1/2017
Tax table version # 110 109 108 107 106 105
Québec Pension Plan (QPP)
Maximum Pensionable Earnings 58,700 57,400 55,900 55,900 55,300 55,300
Basic Exemption 3,500 3,500 3,500 3,500 3,500 3,500
Contribution Rate 5.70% 5.55% 5.40% 5.40% 5.40% 5.40%
Maximum Contribution (EE) 3,146.40 2,991.45 2,829.60 2,829.60 2,797.20 2,797.20
Maximum Contribution (ER) 3,146.40 2.991.45 2,829.60 2,829.60 2,797.20 2,797.20
Employment Insurance (EI) - Québec only
Maximum Insurable Earnings 54,200 53,100 51,700 51,700 51,300 51,300
Premium EI Rate (EE) 1.20% 1.25% 1.30% 1.30% 1.27% 1.27%
Premium EI Rate (ER) (1.4*EE) 1.68% 1.75% 1.820% 1.820% 1.778% 1.778%
Maximum Premium (EE) 650.40 663.75 672.10 672.10 651.51 651.51
Maximum Premium (ER) (1.4*EE) 910.56 929.25 940.94 940.94 912.11 912.11
Québec Parental Insurance Plan (QPIP)
Maximum Insurable Earnings 78,500 76,500 74,000 74,000 72,500 72,500
Contribution Rate (EE) .494% .526% 0.548% 0.548% 0.548% 0.548%
Contribution Rate (ER) (1.4*EE) .692% .736% 0.767% 0.767% 0.767% 0.767%
Maximum Contribution (EE) 387.79 402.39 405.52 405.52 397.30 397.3
Maximum Contribution (ER) (1.4*EE) 543.22 563.04 567.58 567.58 556.08 556.08
Commission des normes du travail (CNT)
Maximum earnings subject to CNT 78,500 76,500 74,000 74,000 72,500 72,500

If your TD1 amounts are not updated after installing the latest tax table update, perform the following checks:

  • Is it on or after the tax table effective date? For example, if you downloaded tax table version 110 on December 23 2019, you will not see the updated amounts until the tax table becomes effective January 1, 2020.
  • After January 1, 2020, once you have downloaded the product update containing the new tax tables, you'll need to start a payroll or open and close QuickBooks Desktop for the TD1 amounts to update.
  • Have you had to manually adjust the TD1 amounts at any time in the past or after setting up a new employee? If you have ever manually updated the TD1 amounts for an employee, the new tax table will not override any previously adjusted amounts. You will need to manually update the TD1 amounts going forward.
  • Are any of your employees set up over the basic TD1 amounts? QuickBooks Desktop will automatically update TD1 amounts only for those employees with the basic amounts for the previous tax tables.

Please continue to visit this page for important updates about the payroll tax table updates for QuickBooks Desktop Canada.

Was this helpful?

You must sign in to vote, reply, or post