Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
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.
gtmobileautorepair
Level 1

I am pulling a custom report and the taxable amount has non taxable items in it. I use this for sales tax and just noticed it was doing it but not on all invoices.

I use this as a backup to make sure the sales tax is calculating correctly but haven't had to in a while since they did an update. I just noticed it about a month ago. I have removed and added the column back and that makes no change.
1 Comment 1
JamesDuanT
Moderator

I am pulling a custom report and the taxable amount has non taxable items in it. I use this for sales tax and just noticed it was doing it but not on all invoices.

There are multiple factors that affect the sales tax calculation on a sales transaction, gtmobileautorepair. Let me share some insights on this.

 

Sales tax is calculated based on these details:

 

  • Customer's tax exempt status
  • Billing and shipping addresses
  • The details of the item you're selling

 

The calculation of the transactions created prior to the program update will not be affected. Thus, we'll have to open the transactions in question and update the details manually. Let's take an invoice as an example.

 

  1. Locate and open an invoice.
  2. Change/Toggle the sales tax rates and other details.
  3. Click Save to apply the updated information.
  4. Select Yes to save the changes.

 

The next time you pull up the customer report, it should now provide you an updated data. You can check out these links to see how sales tax is calculated in QuickBooks Online:

 

 

Note that adding or removing columns from the report will not change the amounts. This is because the amounts are dependent on the recorded transactions. Thus, we need to go back and update them one at a time. You can follow the steps in this article to locate the invoices that needs correction: Correct invoices created without sales tax in QuickBooks Online.

 

Are you looking for ways to take your QuickBooks experience to the next level? I'm excited to share that you can connect with our QuickBooks Live Expert Assisted team. They are here to help you generate reports you need to manage your finances effectively. Let us support you on your journey to financial success.

 

Keep in mind that the custom report should be properly filtered so we can see the specific data. Keep us posted if you need additional assistance in doing this.

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

Need to get in touch?

Contact us