Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
The "improved" invoice not calculating sales tax correctly under the following situation
- Mix of taxable and untaxed line items
- A fixed dollar discount (as opposed to a percent discount)
- Apply Discount After Sales tax UNCHECKED
I have an invoice where the total sales are: $8371.97
The taxable sales are: $6271.97
The discount is: $372.80.
The net taxable sale is: $5,899.17
The sales tax rate is 8.75%
QBO is showing sales tax as $524.35 WHICH IS INCORRECT!!!!
The correct sales tax is $516.17!!!
There are so many user experience and functionality problems with the new invoices that it's difficult to find a place to begin. Not that your product team cares.
Please know that this isn't the experience we want you to have when calculating sales tax for your invoice transactions in QuickBooks Online (QBO), @jgenshlea.
QuickBooks calculates sales taxes for some reasons:
When you use the discount feature, please know that the program applies that amount to the total of the invoice, including the taxable and non-taxable items after the tax has been calculated. This the reason why the sales amount is showing as $524.35.
Since the sales tax calculation is incorrect, we can use the See the Math option to determine how QBO comes up with the specific amount.
I've attached screenshots for reference:
To change the sales tax calculations, we can override the amount by adjusting the sales tax manually.
Aside from that, you can consider creating a discount line item instead of utilizing the built-in feature. This way, it will calculate according to your preferences.
Moreover, you can use these articles to learn how to personalize your sales forms info and set up custom tax rates:
Feel free to comment below for any other questions regarding sales tax calculations. We're here to assist you.
This is happening because your discount is being applied evenly across your invoice, to both your taxable and non-taxable sales portions of the sale.
If you remove the non-taxable sales of $2,100 then the entire discount will be applied to the taxable $6,271.97 and the resulting tax is $516.18 - in my test.
Using QB Desktop you can control this by putting the discount line item after the taxable line and then listing the $2,100 non taxable sales after it. Then the discount is only applied to the taxable sales and the sales tax remains $516.18.
However, QB Online assumes that any discount is applied across the entire invoice. Which naturally does not reflect any sort of reality.
The way around this for QB Online is to use a service line item and call it "Discount" or similar and make it taxable. It'll then reduce the tax based on the full amount of the discount.
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