Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
joshbrown
Level 3

Sales Tax Not Calculating Correctly on mark up

This issue is partly resolved for me.

It now calculates the sales tax correctly, but only if I add the billable expense (unbilled income) in a specific way. Let me explain, as there are two ways I typically add those to an invoice. One will work correctly and the other will not. I am unsure as to why it doesn't work both ways.

Hopefully Intuit can remedy the situation further so that it always works correctly.

 

Scenario #1:

Create a New Invoice using a blank invoice and then add the customer name. This will then give a list of suggested items to add to the invoice from the unbilled income (billable expenses) attached to that customer.

When you add these to the invoice they will work exactly as expected, and the sales tax will calculate accurately for both the product line item and the markup line item (which is a hidden item from the customer).

 

Scenario #2:

Starting from the list of unbilled income select "Create Invoice" from an unbilled income product/service.

This will then start a new invoice and automatically fill in the customer information. It will also give you the option of adding other "suggested items" to the invoice. However, the tax will be calculated incorrectly for the line item that you added initially, but all of the additional added from within the invoice will be calculated correctly.

 

So, in conclusion this issue is almost resolved.

I would like to have more peace of mind that when I add items to an invoice that the math is working correctly.

Simple math like tax percentage should not be something that is failing. I understand that the tax portion is not as simple as the math, but when I have marked it as taxable and I even had changed it to not use the Automatic Calculation and it still wasn't doing the math correctly, there is a major issue. Especially as Intuit and Quickbooks Online pushes the users to utilize more "Automated" tasks taking the user out of the responsibility of entering and verifying everything prior to sending invoices, payments, etc. and asks us the users to trust that it is doing the job correctly.

AnaRose_Q
QuickBooks Team

Sales Tax Not Calculating Correctly on mark up

We know the importance of accuracy in every detail and calculation, Josh. Please be assured that our committed team is attentively working on it to address the situation straight away.

If you're dealing with sales tax for your products or services, you don't need to worry about determining each tax rate on your own. Our software simplifies this process seamlessly. Allow me to explain how it works.

QuickBooks Online calculates sales tax based on the following criteria:

 

  • Your customer's tax-exempt status
  • Where you sell and where you ship
  • What you sell

 

To enhance your understanding and receive better guidance, I recommend reaching out to your accountant, as they possess greater expertise in this area and can offer a more effective solution.

 

If the issue persists, I suggest reaching out to our Live Support team. They have the necessary tools to diagnose the problem and can also provide a screen-sharing session for a deeper investigation.

 

For complete guidance on how QuickBooks Online calculates sales tax, you can refer to this link: Learn how QuickBooks Online calculates sales tax.

 

As for reference on how to automatically set up sales tax, check out this article: Set up and use automated sales tax in QuickBooks Online.

 

I value the time you've spent through the process, please know that we can always assist you at your convenient time.

joshbrown
Level 3

Sales Tax Not Calculating Correctly on mark up

That is not the issue here. Obviously AnaRose_Q is either a Bot or did not read my response to the issue that has been on going.

It is exactly these types of replies from the "Quickbooks Team" that are unhelpful, and to be honest downright unintelligent about their own product, how it works, and the issues that the users are facing.

As not only a user, but a reseller of the product, I would like to be using the community forum for solving problems and assisting the user base with real answers or at least pushing the issues to the Intuit developers/software engineers who can remedy the situation.

andreablundell
Level 2

Sales Tax Not Calculating Correctly on mark up

@joshbrownThank you so much for posting this workaround! I just ran into this issue today when I had to delete and reenter a paid invoice from December, and my sales tax wasn't matching up. I ended up entering it manually and then went on to start my January invoices, with my radar up to possible issues, and lo and behold, the sales tax was incorrect on my new invoice as well. The "See the Math" is about worthless other than to let me know that it wasn't taxing correctly. The QB responses on here are pretty appalling for such a major issue with their program - and it is an issue within the program, not caches, not browsers, etc. I am now concerned as to how long this has been going on, unbeknownst to me. I'll have to get in the habit of doing a new invoice from the main screen rather than the customer's page, but I so appreciate you sharing this information!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us