QuickBooks Payroll Tax Tables: Download, Install and Verify

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-800-880-6389.

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‘.
QuickBooks Payroll Tax Updates - Screenshot
  • 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 ‘OKand 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 thedate or update3.dat‘ from the ‘Payroll Update Disk‘ and after that click on ‘Opento 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 2018 or QuickBooks Desktop 2018 or QuickBooks Desktop Enterprise Solution 18.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.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 Earnings55,90055,90055,30055,30054,90054,90053,60053,600
Basic Exemption3,5003,5003,5003,5003,5003,5003,5003,500
Contribution Rate5.40%5.40%5.40%5.40%5.33%5.33%5.25%5.25%
Maximum Contribution (EE)2,829.602,829.602,797.202,797.202,737.052,737.052,630.252,630.25
Maximum Contribution (ER)2,829.602,829.602,797.202,797.202,737.052,737.052,630.252,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 Earnings74,00074,00072,50072,50071,50071,50070,00070,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.52405.52397.30397.3391.82391.82391.30391.30
Maximum Contribution (ER) (1.4*EE)567.58567.58556.08556.08548.81548.81547.40547.40
Commission des normes du travail (CNT)
Maximum earnings subject to CNT74,00074,00072,50072,50071,50071,50070,00070,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 .i.e.+1-800-880-6389.

 

Few other helpful articles:



Leave a Reply

error: Content is Protected !!