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 at +1-844-499-6700.
See Also: How to Fix QuickBooks Error 6000?
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 payroll tax tables 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.
Read Also: How to Fix Most Technical Errors in QuickBooks Desktop Enterprise?
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.
Read Also: How to Fix QuickBooks Error 1334?
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 2018 or QuickBooks Desktop 2018 or QuickBooks Desktop Enterprise Solution 18.0 to download the tax table update.
You may also like: What is the Best Ways to Fix QuickBooks Error QBW32.exe?
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.4*EE) | 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.4*EE) | 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.4*EE) | 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.4*EE) | 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.4*EE) | 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.4*EE) | 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.
You may also read: How to Fix QuickBooks Desktop Installation Errors?
Winding Up!
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 .i.e. +1-844-499-6700.
Few other helpful articles:
How to Fix QuickBooks Payroll “Failed to send usage data” While Update?
How to Add an EIN to existing QuickBooks Desktop Payroll Basic, Standard or Enhanced subscription?
Steps to solve QuickBooks Error 15106
Some FAQs Related to QuickBooks payroll tax tables
To update your QuickBooks payroll tax tables, simply navigate to the “Employees” menu, select “Get Payroll Updates,” and follow the prompts. Regularly updating your tax tables ensures that you are using the most current tax rates and calculations, allowing for accurate payroll processing. Don’t forget to keep an eye on tax-related news and announcements to stay informed about changes to tax laws.
If you experience any difficulties or have questions while updating your payroll tax tables, don’t hesitate to reach out to our expert support team at our toll-free number +1-844-499-6700. We are available to assist you and ensure that your payroll tax tables are up-to-date and functioning correctly.
QuickBooks payroll tax tables are designed to be automatically updated through the “Get Payroll Updates” feature. However, if you need to make manual adjustments, we recommend consulting with a tax professional or contacting our support team for guidance. Making manual changes without proper knowledge can result in inaccurate payroll calculations and potential compliance issues.
It’s essential to update your QuickBooks payroll tax tables at least once every 45 days to ensure the most accurate tax calculations for your employees. Keep in mind that tax rates and regulations can change frequently, so staying updated is crucial for maintaining compliance and avoiding potential penalties.
To confirm that your QuickBooks payroll tax tables are current, navigate to the “Employees” menu, select “Get Payroll Updates,” and check the “You are using tax table version” section. The displayed version should be the most recent one available. If you’re unsure whether you have the latest tax table version, feel free to contact our support team at our toll-free number +1-844-499-6700, and we’ll be happy to assist you.