cancel
Showing results for 
Search instead for 
Did you mean: 
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. Then, the Rebuild tool fixes the detected and confirmed problems.

 

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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us