cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Need help updating to Desktop 2022? Visit our updates page to get started.
QuickBooksHelp
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 article Changes to TD1 Basic Personal Amount calculation for employees in Nova Scotia for detailed instructions.

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

The current payroll tax table is version:

  • 11430003 (QuickBooks Desktop 2021) released on June 24, 2021 and is effective from July 1, 2021 to December 31, 2021.

To check which version you have:

In QuickBooks, from the Employees menu, choose My Payroll Service, then Tax Table Information.

The first three numbers under "You are using tax table version" reflect your tax table version and should read 11430003. You may already have release 114 if you updated your product earlier this year.

Reminder: Make sure you are using QuickBooks Desktop 2021 or QuickBooks Desktop Enterprise Solutions 21.0 to download this tax table update.

Please visit the Downloads & Updates page to 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. Select Update QuickBooks from the Help menu.
  2. Go to the Update Now tab.
  3. Select Get Updates.
  4. Select File, then Exit.
  5. Restart QuickBooks Desktop.

For the July 2021 tax table update there are no new updates from the January 2021 payroll tax table update.

 

Effective Date 7/1/2021 1/1/2021
Tax Table version #  114 113
TD1 Amounts    
Federal 13, 808 13, 800
AB 19, 369 19, 369
BC  11, 070 11, 070
MB  9, 936 9, 936
NB  10, 564 10, 564
NL  9, 536 9, 536
NS Click here to learn how to calculate
NT  15, 243 15, 243
NU  16, 647 16, 647
ON  10, 880 10, 880
PE  10, 500 10, 500
QC  15, 532 15, 532
 SK  16, 225 16, 225
YT  BPAYT BPAYT
ZZ (employees outside Canada)  0 0
Effective Date  7/1/2021 1/1/2021
Tax Table version #  114 113
Canada Pension Plan (CPP) - outside Quebec
Maximum Pensionable Earnings  61, 600 61, 600
Basic Exemption  3, 500 3, 500
Contribution Rate  5.45% 5.45%
Maximum Contribution (EE)  3, 166.45 3, 166.45
Maximum Contribution (ER)  3, 166.45 3, 166.45
Employment Insurance (EI) - outside Quebec
Maximum Insurable Earnings  56, 300 56, 300
Premium EI Rate (EE)  1.58% 1.58%
Premium EI Rate (ER) (1.4*EE)  2.21% 2.21%
Maximum Premium (EE)  889.54 889.54
Maximum Premium (ER)  1, 245.36 1, 245.36
Effective Date  7/1/2021 1/1/2021
Tax Table version #  114 113
Quebec Pension Plan (QPP)
Maximum Pensionable Earnings  61, 600 61, 600
Basic Exemption  3, 500 3, 500
Contribution Rate  5.90% 5.90%
Maximum Contribution (EE)  3, 427.90 3, 427.90
Maximum Contribution (ER)  3, 427.90 3, 427.90
Employment Insurance (EI - Quebec only)
Maximum Insurable Earnings  56, 300 56, 300
Premium EI Rate (EE)  1.18% 1.18%
Premium EI Rate (ER) (1.4*EE)  1.65% 1.65%
Maximum Premium (EE)  664.34 664.34
Maximum Premium (ER) (1.4*EE)  930.08 930.08
Quebec Parental Insurance Plan (QPIP)
Maximum Insurable Earnings  83, 500 83, 500
Contribution Rate (EE)  0.49% 0.49%
Contribution Rate (ER) (1.4*EE)  0.69% 0.69%
Maximum Contribution (EE)  412.49 412.49
Maximum Contribution (ER) (1.4*EE)  577.82 577.82
Commission des normes du travail (CNT)
Maximum earnings subject to CNT  83, 500 83, 500

Perform the following checks if your TD1 amounts are not updated after installing the latest tax table updates:

  • Is it on or after the tax table effective date? For example, if you downloaded tax table version 114 on June 24, 2021, you will not see the updated amounts until the tax table becomes effective July 1, 2021.

    After July 1, 2021, once you have downloaded the product update containing the new tax tables:
  • 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.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us