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.
Susan607
Level 5

Sales tax - original amt vs credit amt do not match

I'm trying to understand why this sales tax do not match is some of these columns.  This is on a cash basis:

.Screenshot 2023-03-03 at 12.46.56 PM.png

And all of our tax codes are 8% yet on Sales Tax Liability not all the taxes collected are 8% of the taxable sales.                                                                                  Taxable Sales          Collected Tax

Screenshot 2023-03-03 at 12.55.41 PM.png

ITH is correct; SCHY should be 262.46; STEU is correct; TOMP should be 858.42

I've gone through the associated invoices which have all been paid in full and get the original amount column totals and not the credit amount totals which seem to be the ones that are off.  

Thanks for any help on this.

3 Comments 3
Archie_B
QuickBooks Team

Sales tax - original amt vs credit amt do not match

Good day, Susan607. I'll add some information to make sure your sales taxes are accurate.

 

I agree with @Shelby31 about reviewing the invoices, there might be an error when the sales tax was set up. 

 

Another possibility as to why the sales taxes aren't showing the correct calculation is a Sales Tax Adjustment. This can also affect the figures shown in your reports.

 

If you have reviewed all the invoices and the problem persists, we can use the Verify and Rebuild Tools to check and repair any potential data damage as suggested. I'll show you how to do it.

 

To verify:

 

  1. Go to File, then choose Utilities.
  2. Select Verify Data.
  3. Click on  OK to close all windows. If you see “Your data has failed the integrity check” you need to rebuild your file. If there are no problems with your data, you’re done.

 

To rebuild:

 

  1. Click on File, then Utilities.
  2. Choose Rebuild Data
  3. Select OK to close all windows.
  4. QuickBooks will ask you to make a backup before rebuilding your company file, select OK. If you don’t want to do a backup, select Cancel to continue rebuilding your company file.
  5. Once the rebuild's finished, hit OK.

 

For more details about the verify and rebuild process, check out this link: Verify and rebuild data in QuickBooks Desktop for Mac.

 

To learn more about the sales tax setup, you can visit this article: Set up sales tax in QuickBooks Desktop for Mac.

 

Let me know if you have any further questions or concerns about the sales tax. I'll be checking in on your response. Take care!

Susan607
Level 5

Sales tax - original amt vs credit amt do not match

Thank you all for getting  back to me.  I've verified and rebuilt the QB file regularly after making changes to invoices and generating new sales tax liability reports.  

I've got two tax codes that are still not resolving after going through each individual invoice for the specified time period.  The first one has a limited number of invoices with only two customers with taxable sales.  I've made sure they are taxable and have the tax charged on all of their invoices as well as the one credit memo.  See below.

I'm stuck on why the total sales tax stipulated on the report is not correct.  Thank you once again.

Sales Tax due 2022 annual.png

For SCHY tax code:

Sales Tax 2022 invoices.png

Associated SCHY invoices for the tax period:

Sales Tax 2022 collected.png

ZackE
Moderator

Sales tax - original amt vs credit amt do not match

Thanks for following up with the Community, Susan607. I appreciate your detailed information.
 

Since you're still seeing two tax codes showing incorrect amounts on the report you're working with, I'd recommend getting in touch with our Customer Care team. They'll be able to pull up your account in a secure environment and conduct further research with you.
 

They can be reached while using QuickBooks.
 

Here's how:

 

  1. In your top menu bar, go to Help, then QuickBooks Desktop Help.


     
  2. Click Contact Us.


     
  3. Enter a brief description of the issue in our Ask a question (or tell us what's wrong) field, then hit Continue.


     
  4. Select We’ll contact you for a callback or Message Us to start an instant messaging session.

 

Be sure to review their support hours so you'll know when agents are available.
 

If there's any questions, I'm just a post away. Have an awesome day!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us