Insight into QuickBooks Payroll tax tables
Being a QuickBooks Payroll user, it is important to be aware with the QuickBooks Payroll tax tables. To provide the users with the proper knowledge of QuickBooks Payroll tax tables, we have come up with this article. At the end of this article, the reader would be well versed in downloading, installing, and verifying QuickBooks Payroll Tax Table. Therefore, stick to the article until the end.
However, for any query associated with QuickBooks Payroll tax tables, you can simply consult our QuickBooks Payroll customer support team.
Understand QuickBooks Payroll Tax Tables
Before digging in deep and exploring the steps to download, install, and verify QuickBooks Payroll Tax Tables, it is better to understand what it actually means. To define Payroll tax table, it can be stated that it is a chart that characteristic different columns, assisting to find out the apt taxes to be suspended from the employee’s paycheck.
It should be noted that the withholding taxes are generally affected by numerous factors just like, the income sum, the marital status of the worker, and also the payment schedule, just like bi-weekly, monthly, etc.
Important points to remember
Before downloading, installing, and verifying the QB Payroll Tax Table, the user is required to keep in mind certain factors, such as:
- The user is required to have an active payroll subscription, if they wish to update the tax table.
- It is recommended by Intuit that the user should download the tax table at least within 45 days, or they can update the same every time they make payment to their employees.
- Lastly, the user is required to turn on the automatic updates feature in QuickBooks Desktop, if they want to receive the payroll tax table updates automatically, the moment the update releases.
Procedure to download the QuickBooks tax table updates
Undoubtedly, it is essential to download or install the newest available QuickBooks Payroll Tax Table updates, in order to safeguard that the Payroll has precise information. Being a QuickBooks Payroll user, all you need to do is follow certain steps, and you are good to go.
- To begin with, opt for ‘Employees‘ and after that select ‘Get Payroll Updates‘.
- Moving forward, the user is required to select ‘Download entire payroll update‘.
- Tap on ‘Update‘ button
- Once the downloading procedure comes to an end, a pop-up message will appear stating “A new tax table and updates to your payroll tax forms have been installed on your Desktop. Click OK to read about the modification.”
- Considering the prompts, hit ‘OK‘ and you are good to go.
Steps to Install a Payroll Tax Table update from a CD (Disk Delivery Service:)
- To start with, the user needs to insert the ‘Payroll Update CD‘.
- Once done with that, open the ‘Get Payroll Updates‘ option.
- QuickBooks Desktop Pro and Premier: The user is required to choose the ‘Employees‘ option and after that the option stating ‘get payroll updates‘.
- Moving forward, if the user is prompted to locate the ‘update.dat‘ or ‘data file‘ in the ‘Install Payroll Update window‘, then he/she is required to take the necessary actions and respond to the prompts.
- Once you have completed that, tap on ‘Browse‘.
- Tap to choose CD drive from the ‘Look in the drop-down arrow‘, in the install from window.
- Now, either select the ‘date or update3.dat‘ from the ‘Payroll Update Disk‘ and after that click on ‘Open‘ to proceed.
- The next step is to choose between the ‘update.dat or update3.dat‘.
- Now, hit the ‘Open‘ option.
- After that, the user is required to move on to the ‘Payroll Update Window‘, and then tap on ‘OK‘.
Note: In case the user receives a pop-up message displayed on the screen which says “File Not Found” go through your CD drive by following the below-enumerated steps:
- Firstly, the user is required to ‘close‘ the QuickBooks Desktop and after that hit the ‘Start Button‘, once done with that, select ‘My Computer‘.
- Moving ahead, right-click the ‘CD drive‘ and after that select the option “If you cannot see the files, test the CD on a second desktop.” In case the files are visible on the second desktop, then there might be some issue with the hardware on the first desktop.
Whereas, if the user is unable to see the file on both the desktops, then he/she is required to order a new payroll update disk.
How to verify QuickBooks Payroll Tax Tables:
Now comes the verification process
- The user is required to authenticate, in the ‘install confirmation window‘ that the user is installing the accurate location and that the ‘tax table versions‘ in the current and new fields are precise.
- The next step is to click when the update is complete, or a message appears stating ‘A new tax table has been installed on your desktop‘.
- The next step is to click ‘OK‘ in order to read about the modification.
- The last step of the verification process is that in case the tax table version has not modified, a pop up message will appear on the screen stating that “You have successfully installed payroll update”.
How to Download the latest payroll tax table update?
The payroll tax table update will provide the user with the accurate and updated rates and calculations for:
- E-file options
- Supported provincial and federal tax tables
- Payroll tax forms
How to find out the version of QuickBooks?
- Included in the new update: July 2018 payroll tax tables updated
- Current Version: Version 108
- Release date: June 28, 2018
- Effective date: July 1, 2018, to December 31, 2018
To check the version of QuickBooks, the user is required to follow the following steps:
- The first step is to go to the ‘Employees menu‘ in QuickBooks, after that select the ‘My Payroll Services‘.
- In the next step, the user is required to select the ‘Tax table information‘.
- The first three number reflects the tax table version in “You are using Tax table version”.
Note: The user should be QuickBooks 2024 or QuickBooks Desktop 2024 or QuickBooks Desktop Enterprise Solution 24.0 to download the tax table update.
Check out the Current and historical TD1, CPP & EI amounts:
TD1 Amounts:
| Effective date | 7/1/2018 | 1/1/2018 | 7/1/2017 | 1/1/2017 | 7/1/2016 | 1/1/2016 | 7/01/2015 | 1/1/2015 |
| Tax table version # | 108 | 107 | 106 | 105 | 104 | 103 | 101 | 100 |
TD1 Amounts
| Federal | 11,809 | 11,809 | 11,635 | 11,635 | 11,474 | 11,474 | 11,327 | 11,327 |
| AB | 18,915 | 18,915 | 18,690 | 18,690 | 18,451 | 18,451 | 18,214 | 18,214 |
| BC | 10,412 | 10,412 | 10,208 | 10,208 | 10,027 | 10,027 | 9,938 | 9,938 |
| MB | 9,382 | 9,382 | 9,271 | 9,271 | 9,134 | 9,134 | 9,134 | 9,134 |
| NB | 10,043 | 10,043 | 9,895 | 9,895 | 9,758 | 9,758 | 9,633 | 9,633 |
| NL | 9,247 | 9,247 | 8,978 | 8,978 | 8,802 | 8,802 | 8,767 | 8,767 |
| NT | 14,492 | 14,492 | 14,278 | 14,278 | 14,081 | 14,081 | 13,900 | 13,900 |
| NU | 13,325 | 13,325 | 13,128 | 13,128 | 12,947 | 12,947 | 12,781 | 12,781 |
| ON | 10,354 | 10,354 | 10,171 | 10,171 | 10,011 | 10,011 | 9,863 | 9,863 |
| PE | 9,160 | 8,160 | 8,320 | 8,000 | 8,292 | 7,708 | 7,708 | 7,708 |
| QC | 15,012 | 15,012 | 11,635 | 11,635 | 11,550 | 11,550 | 11,425 | 11,425 |
| SK | 16,065 | 16,065 | 16,065 | 16,065 | 15,843 | 15,843 | 15,639 | 15,639 |
| YT | 11,809 | 11,809 | 11,635 | 11,635 | 11,474 | 11,474 | 11,327 | 11,327 |
| ZZ (employees outside Canada) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Canada Pension Plan (CPP)
| Effective date | 7/1/2018 | 1/1/2018 | 7/1/2017 | 1/1/2017 | 7/1/2016 | 1/1/2016 | 7/01/2015 | 1/1/2015 |
| Tax table version # | 108 | 107 | 106 | 105 | 104 | 103 | 101 | 100 |
Canada Pension Plan (CPP) – outside Québec
| Maximum Pensionable Earnings | 55,900 | 55,900 | 55,300 | 55,300 | 54,900 | 54,900 | 53,600 | 53,600 |
| Basic Exemption | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 |
| Contribution Rate | 4.95% | 4.95% | 4.95% | 4.95% | 4.95% | 4.95% | 4.95% | 4.95% |
| Maximum Contribution (EE) | 2,593.80 | 2,593.80 | 2,564.10 | 2,564.10 | 2,544.30 | 2,544.30 | 2,479.95 | 2,479.95 |
| Maximum Contribution (ER) | 2,593.80 | 2,593.80 | 2,564.10 | 2,564.10 | 2,544.30 | 2,544.30 | 2,479.95 | 2,479.95 |
EI amounts:
| Employment Insurance (EI) – outside Québec | ||||||||
| Maximum Insurable Earnings | 51,700 | 51,700 | 51,300 | 51,300 | 50,800 | 50,800 | 49,500 | 49,500 |
| Premium EI Rate (EE) | 1.66% | 1.66% | 1.63% | 1.63% | 1.88% | 1.88% | 1.88% | 1.88% |
| Premium EI Rate (ER) (1.4EE) | 2.62% | 2.62% | 2.62% | 2.62% | 2.62% | 2.62% | 2.62% | 2.62% |
| Maximum Premium (EE) | 858.22 | 858.22 | 836.19 | 836.19 | 955.04 | 955.04 | 930.60 | 930.60 |
| Maximum Premium (ER) (1.4EE) | 1,201.51 | 1,201.51 | 1,170.67 | 1,170.67 | 1,337.06 | 1,337.06 | 1,302.84 | 1,302.84 |
Québec Pension Plan (QPP)
| Maximum Pensionable Earnings | 55,900 | 55,900 | 55,300 | 55,300 | 54,900 | 54,900 | 53,600 | 53,600 |
| Basic Exemption | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 | 3,500 |
| Contribution Rate | 5.40% | 5.40% | 5.40% | 5.40% | 5.33% | 5.33% | 5.25% | 5.25% |
| Maximum Contribution (EE) | 2,829.60 | 2,829.60 | 2,797.20 | 2,797.20 | 2,737.05 | 2,737.05 | 2,630.25 | 2,630.25 |
| Maximum Contribution (ER) | 2,829.60 | 2,829.60 | 2,797.20 | 2,797.20 | 2,737.05 | 2,737.05 | 2,630.25 | 2,630.25 |
Employment Insurance (EI) – Québec only
| Maximum Insurable Earnings | 51,700 | 51,700 | 51,300 | 51,300 | 50,800 | 50,800 | 49,500 | 49,500 |
| Premium EI Rate (EE) | 1.30% | 1.30% | 1.27% | 1.27% | 1.52% | 1.52% | 1.54% | 1.54% |
| Premium EI Rate (ER) (1.4EE) | 1.820% | 1.820% | 1.778% | 1.778% | 2.13% | 2.13% | 2.16% | 2.16% |
| Maximum Premium (EE) | 672.10 | 672.10 | 651.51 | 651.51 | 772.16 | 772.16 | 762.30 | 762.30 |
| Maximum Premium (ER) (1.4EE) | 940.94 | 940.94 | 912.11 | 912.11 | 1,081.02 | 1,081.02 | 1,067.22 | 1,067.22 |
Québec Parental Insurance Plan (QPIP)
| Maximum Insurable Earnings | 74,000 | 74,000 | 72,500 | 72,500 | 71,500 | 71,500 | 70,000 | 70,000 |
| Contribution Rate (EE) | 0.548% | 0.548% | 0.548% | 0.548% | 0.548% | 0.548% | 0.559% | 0.559% |
| Contribution Rate (ER) (1.4EE) | 0.767% | 0.767% | 0.767% | 0.767% | 0.770% | 0.770% | 0.782% | 0.782% |
| Maximum Contribution (EE) | 405.52 | 405.52 | 397.30 | 397.3 | 391.82 | 391.82 | 391.30 | 391.30 |
| Maximum Contribution (ER) (1.4EE) | 567.58 | 567.58 | 556.08 | 556.08 | 548.81 | 548.81 | 547.40 | 547.40 |
Commission des normes du travail (CNT)
| Maximum earnings subject to CNT | 74,000 | 74,000 | 72,500 | 72,500 | 71,500 | 71,500 | 70,000 | 70,000 |
Fix QuickBooks Payroll update issues:
- If the TD1 amounts are not updated even after installing the latest tax table update, the user is required to perform the following checks:
- The user is required to ‘confirm the tax table effective date‘, whether it is on or after the date.
- After downloading the product update that contains the new tax tables, the user is required to start with payroll, or open and close the QuickBooks Desktop for the TD1 amounts to update.
- If in case the user has ever manually updated the TD1 amounts for an employee, the new tax table would not dominate any previously adjusted amounts.
- Employees set up over the basic TD1 amounts? ‘Yes‘, or ‘No‘
- The reason is that the QuickBooks Desktop will update TD1 amounts on its own, only for the employees with the basic amounts for the previous tax tables.
Payroll tax table is now out of date: One of the most commonly encountered error
When the user opens the payroll tax table on the computer, he/she might encounter the pop-up stating the Payroll tax table is now out of date. It should be noted that any of the calculations that the users perform using this tax table will be either zero or will show as $0.00. There can be various reasons behind this error, a few of which are listed below:
- The very first reason can be that the QuickBooks Desktop is not updated to the latest payroll tax table release.
- Or in case the user is using QuickBooks in a multi-user network environment, this error might be encountered.
- The last reason can be that not all the versions of QuickBooks located within the network might have been updated to the latest tax table.
How to rectify this commonly encountered error?
- The very first thing is to analyze the QuickBooks Desktop and check whether it is using the latest product update or not. The next step is to check whether all the versions are located on the network or not, especially in the case you have the multi-user network.
- The next thing the user has to do is to equate the product release number of the currently installed product with the product update page at the time when the user is working in QuickBooks. After that, the user is required to press F2 key to view the release reference number.
- Lastly, if the user hasn’t updated its product to the latest release, it would be better to update it first, in order to resolve the error. The user can get rid of the error and backup the file first, by clean uninstall and reinstall of QuickBooks Desktop.
We conclude this article, with the hope that it might help you to download the latest QuickBooks Payroll tax table and also get a better insight into the same. After reading this article, you might be able to deal with the errors that you may stumble upon and many other related information.
However, in case of any difficulty, our QuickBooks support team is there to guide you. You can consult our team of experts at our toll-free number.
Few other helpful articles:
How to solve QuickBooks Error 15106?
