Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
Hi LeeLee3
Under the QST setup is the rate entered as the full 9.975?
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.
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
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.
Hi LeeLee3
Under the QST setup is the rate entered as the full 9.975?
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!
Happy to help! Don't forget to mark your question resolved so others can take advantage of the answer too!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here