cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

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:

  • 11230003 (QuickBooks Desktop 2020) - released on June 23, 2020 and is effective from July 1, 2020, to December 31, 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  11230003 . You may already have release 112 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 or QuickBooks QuickBooks Desktop Enterprise Solutions 20.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.

What's included in the current payroll tax table update?

July 2020 Payroll tax table updates.

Effective Date 7/1/2020 1/1/2020
Tax Table version # 112 110
TD1 Amounts    
Federal 12,298 12,298
AB 19,369 19,369
BC 10,949 10,949
MB 9,838 9,838
NB 10,459 10,459
NL 9,498 9,498
NS Click here to learn how to calculate
NT 15,093 15,093
NU 16,304 16,304
ON 10,783 10,783
PE 10,000 1,000
QC 15,532 15,532
 SK 16,065 16,065
YT 14,160 12,298
ZZ (employees outside Canada) 0 0
Effective Date 7/1/2020 1/1/2020
Tax Table version # 112 110
Canada Pension Plan (CPP) - outside Quebec
Maximum Pensionable Earnings 58,700 58,700
Basic Exemption 3,500 3,500
Contribution Rate 5.25% 5.25%
Maximim Contribution (EE) 2,898 2,898
Maximim Contribution (ER) 2,898 2,898
Employment Insurance (EI) - outside Quebec
Maximum Insurable Earnings 54,200 54,200
Premium EI Rate (EE) 1.58% 1.58%
Premium EI Rate (ER) (1.4*EE) 2.62% 2.62%
Maximum Premium (EE) 856.36 856.36
Maximum Premium (ER) 1,420.04 1,420.04
Effective Date 7/1/2020 1/1/2020
Tax Table version # 112 110
Quebec Pension Plan (QPP)
Maximum Pensionable Earnings 58,700 58,700
Basic Exemption 3,500 3,500
Contribution Rate 5.70% 5.70%
Maximum Contribution (EE) 3,146.40 3,146.40
Maximum Contribution (ER) 3,146.40 3,146.40
Employment Insurance (EI - Quebec only
Maximum Insurable Earnings 54,200 54,200
Premium EI Rate (EE) 1.20% 1.20%
Premium EI Rate (ER) (1.4*EE) 1.68% 1.68%
Maximum Premium (EE) 650.40 650.40
Maximum Premium (ER) (1.4*EE) 910.56 910.56
Quebec Parental Insurance Plan (QPIP)
Maximum Insurable Earnings 78,500 78,500
Contribution Rate (EE) 0.494% 0.494%
Contribution Rate (ER) (1.4*EE) 0.692% 0.692%
Maximum Contribution (EE) 387.79 387.79
Maximum Contribution (ER) (1.4*EE) 543.22 543.22
Commission des normes du travail (CNT)
Maximum earnings subject to CNT 78,500 78,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 112 on June 20, 2020, you will not see the updated amounts until the tax table becomes effective July 1, 2020.
  • After July 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