cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
marmathsen
Level 2

Sales tax math "error" from invoice line item credit

I have a small tax error I can't seem to figure out. I created an invoice for $8,410.98 + $883.15 (10.5%) sales tax for a total of $9,294.13. In this invoice there is a line item credit of $126.36 for a non-inventory part (income account) that was returned.

 

Our books are cash basis

 

What confuses me is when I pull a Sales Tax Liability report that includes the date of this invoice, this invoice is increasing the the tax collected by a weird amount ($11.85). This is weird amount because 10.5% of $126.36 should be $13.27.

 

1.Why is this increasing the tax liability on the creation date rather than the payment date (Cash Basis remember)

2. Why is it a weird amount?

 

What am I missing?

1 Comment 1
Ivan_G
QuickBooks Team

Sales tax math "error" from invoice line item credit

There are several reasons why your Sales Tax Liability entries increase in unusual value or period, marmathsen. I'm here to discuss them below and provide fixes for this matter.

 

In Cash-based (Cash Basis) accounting, your sales tax liability should increase only when a payment is received. In this case, let's double-check if you've selected the correct sales tax setup. It could be the factor that causes you to see incorrect data in a given period.

 

Here's how:

 

  1. Go to the Edit menu, then Preferences.
  2. Hover to the Sales Tax tab, then select Company Preferences.
  3. From the When Do You Owe Sales Tax section, ensure the Upon receipt of payment (Cash Basis) option is enabled.
  4. After that, click OK.
    Sales Tax company preferences.png

 

On top of that, your customer's information could also affect how your taxes are calculated when creating an invoice for them. That said, make sure you've applied the accurate customer details and tax setup:

 

  1. Go to the Customers menu, then Customer Center.
  2. Double-click your customer's name from the list (the customer for whom the invoice was generated).
  3. Ensure that the Address Info and Sales Tax Settings are accurate.
    Address info.png
    Sales tax settings.png
  4. Once done, hit OK.

 

After that, I recommend creating a dummy invoice and payment to see if the taxes are showing accurately on the Sales Tax Liability report.

 

On the other hand, partial payment for completely taxable or non-taxable items or invoices with applied credit could also influence how your tax is shown and dealt with. For a complete reference on managing these scenarios, check out this article: Handle cash basis sales tax.

 

However, if the issue persists, I recommend Verifying and Rebuilding your data to narrow down the result. The Verify tool locates the issue on a company file, and the Rebuild tool fixes it.

 

I'm also adding these resources you may find handy when you need to apply for exemptions and refund or manage adjustments to your sales taxes:

 

 

Our doors are always open to help you with your taxes in QuickBooks. Just hit the Reply button, and we'll get back to you promptly.

Log in today
Get expert help and peer support to tackle all your QuickBooks questions effortlessly.

Need to get in touch?

Contact us