Limited time only. 90% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
leelee3
Level 2

Invoice Line Total Calculating Incorrect when using QST Tax Code

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!

Solved
Best answer April 20, 2022

Best Answers
LeithG
Level 7

Invoice Line Total Calculating Incorrect when using QST Tax Code

Hi LeeLee3

 

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

View solution in original post

6 Comments 6
Alex M
QuickBooks Team

Invoice Line Total Calculating Incorrect when using QST Tax Code

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
Level 7

Invoice Line Total Calculating Incorrect when using QST Tax Code

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

leelee3
Level 2

Invoice Line Total Calculating Incorrect when using QST Tax Code

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
Level 7

Invoice Line Total Calculating Incorrect when using QST Tax Code

Hi LeeLee3

 

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

leelee3
Level 2

Invoice Line Total Calculating Incorrect when using QST Tax Code

We did have he rate at 9.97% thinking that QB would not accept three decimals.  Its been changed to 9.975% and it appears that the issue is resolved.  Thank you!   

LeithG
Level 7

Invoice Line Total Calculating Incorrect when using QST Tax Code

Happy to help!  Don't forget to mark your question resolved so others can take advantage of the answer too!

Need to get in touch?

Contact us