cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Have questions about what to do to prepare for tax time? Our year-end hub will walk you through the process.
Created with Sketch. Find out how to upgrade your subscription, manage your password, view account fees, request a refund, and much more on our account management page.
WLR1
Level 1

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

Anyone know CRA's online calculator is calculating different tax amount then QBD?   Using QB Premier Accountant 2020 and the tables are up to date, expire Dec 31/2020

10 Comments 10
LauraAB
QuickBooks Team

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

Hello WLR1,

 

You've got a sharp eye and it's good that you've noticed the discrepancies you're seeing with your QuickBooks Desktop Payroll tax tables early on. It's also good to hear that you've already double checked that the tax table did in fact update in your program. I know the accuracy of these numbers is essential so you don't run into trouble later and I'm here to help.

 

I haven't seen any other reports of issues with the tax table amounts being incorrect, so having more information about what's going on will be helpful to me and my team. The first place you can check in your books to make sure everything is lining up is the TD1 form on individual employee profiles. Here's how to find that.

  1. Select the Employees menu.
  2. Choose Employee Centre.
  3. Double click the name of an employee.
  4. Select the Payroll Info tab.
  5. Click the Taxes and TD1 button.
  6. Review the amount in the available fields.
  7. Edit the figures if necessary.
  8. Click OK.

Earlier this year, the Federal TD1 field in particular came on our radar as the CRA released an additional tax table update early in the year after the initial 2020 tables released in December were coded into the program. If what you're seeing in that field is wrong, the recommendation is to manually update the number. This should get things back in line with the CRA calculator.

 

If all your numbers are correct, but you're still coming across calculations that don't match what the CRA calculator has, I suggest getting in touch with the QuickBooks Desktop support team by dialing 1-833-317-2226. Agents are available from Monday to Friday between 9 a.m. and 8 p.m. ET. Simply follow the phone prompts to reach someone who can help.

 

Enjoy the rest of your day.

WLR1
Level 1

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

Hi Laura,

 

Thank you!  That's exactly what it is.  Am I to expect to find this in all my client files for the hundreds of employees?  Is there a fix? 

LauraAB
QuickBooks Team

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

You're welcome! Given the situation, it wouldn't hurt to verify the amounts in all the necessary files. I can absolutely see how this would take a lot of time though with hundreds of employees. When this situation originally occurred earlier in the year, our engineering department looked into it, but since it's coming up now as well, it's worth reporting again. I imagine you're not the only one in this situation.

 

A member of our phone support team can let you know if and how we're able to report this issue and gather all the necessary details from you. While the Community is a great resource, it's not quite built for this kind of reporting, so giving us a call is the best option. Don't hesitate to give us a shout!

WLR1
Level 1

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

Thanks again Laura....I will certainly put a call in since it's payroll week...ugh

LauraAB
QuickBooks Team

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

Sounds like a plan. Wishing you the best with this!

Card
Level 1

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

I have the same problem, QB update as the old amount in it and I have called CRA and they confirmed the amount changed Jan 1 2020

Card
Level 1

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

 
LauraAB
QuickBooks Team

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

Hello Card,

 

I appreciate you taking the time to comment on this thread and share you concerns. Having the correct calculations for your payroll is just as important as having the correct figures in other areas of your books when using QuickBooks Desktop, and I want to make sure you have the information you need about the TD1 figures currently available on employee profiles in the program.

 

QuickBooks Desktop's payroll team works closely with the CRA to ensure that the program has the latest figures when changes are made at the government level. As explained in the Recent updates to TD1 Basic personal amount on CRAs TD1 form article, since the amount has not yet passed into law, the update hasn't yet been implemented in QuickBooks Desktop. I recommend reading that article to learn more.

 

Feel free to use the steps outlined in my original response on this thread to change the amount manually on the TD1 forms in your books. If you're not certain if this is a change you should be making, an accountant is a good resource for helping you figure it out. QuickBooks can even help if you don't already have an accountant. Simply use our Find an Accountant page to search for a QuickBooks-certified professional near you.

 

I hope that helps!

SteveBKB
Level 1

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

Hi Laura,

 

We noticed this issue as well with QBD although the fact that the changes have not passed law didn't stop QBO from updating their payroll tax tables. Other payroll service providers like Wagepoint have also updated the amounts to match the CRA rates.

 

Is there a reason Intuit would update the rates for QBO and not QBD?

 

Thanks for your help.

Nick K
QuickBooks Team

Jul 01 Payroll Tax Tables doesn't match CRA online calculator

Hi SteveBKB,

 

Allow me to clarify this a bit for you to cover any misunderstandings. The QuickBooks Desktop payroll update is made from the information that the CRA sends to us while QuickBooks Online gets the information from the CRA payroll deductions online calculator. This is what would be causing the different numbers you see between the two products. 

You can update the TD1 amount in your desktop company file but i suggest reaching out to an accountant before making that change.

 

If you don't have an accountant you can find one nearby on our find an accountant page.

 

Hope that helped cover the difference between QuickBooks Online and QuickBooks Desktop.

Need to get in touch?

Contact us