Skip to main content
L
leelee3
April 20, 2022
Solved

Invoice Line Total Calculating Incorrect when using QST Tax Code

  • April 20, 2022
  • 2 replies
  • 0 views

Hello,

 

We have an issue where the invoice line total is calculating incorrectly when we change the default tax code to QST.  This only happens with the QST tax code.  The code was set up using the QB Tax Wizard and all rates are correct.

 

For example - 49.5 hours at a rate of $131.91414 should equal $6,529.75.  However, the total on the line changes to $6,546.02 when the QST tax code is used.  

 

How is QB calculating incorrectly with this one tax code and how do we fix this?  There has been no modification to the sales item and this only happens with the QST code, all other codes are fine.

 

Thanks!

Best answer by LeithG

Hi LeeLee3

 

Under the QST setup is the rate entered as the full 9.975?

2 replies

A
Alex M
April 20, 2022

Hi there leelee3,

 

It's vital that all your transactions be entered properly so that your customers can pay the right balance. QuickBooks Desktop is a great tool able to help you create invoices so you can send them to your clients so they can know how much they owe you for your services. I can point you in the right direction for assistance with taxes.

 

For assistance in making sure your tax code is being applied correctly to transactions, I recommend reaching out to the QuickBooks Desktop support team. They'll be able to analyze the transaction itself, your account's settings as well as how this tax code was set up in a secure setting in order to make sure that all transactions created with this tax code can be accurately represented. You can reach out to them using the methods provided in the QuickBooks Desktop support policies.

 

If you have any other questions, feel free to reach out here.

LeithG
LeithG
April 20, 2022

Hi leelee3

 

Double-check your item/service price; it seems like the price is rounded to the nearest penny:

49.5 x 131.92 = 6,546.02

 

Leith

L
leelee3Author
April 20, 2022

Thanks Leith G, however its not a rounding issue.  The difference is $16.27.  All of our rates display that many decimal places and the line total only calculates incorrectly with the QST tax code.

LeithG
LeithGAnswer
April 20, 2022

Hi LeeLee3

 

Under the QST setup is the rate entered as the full 9.975?

Terms & ConditionsAccessibility statement