Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
ANNESMITH
Level 1

sales tax report in quickbooks online

Clients based in IL.  Upgraded from QBDT to QBO Advanced - looking for a way of breaking down the "non-tax" sales as IL sales tax reporting requires that breakdown between services, exempt, resale etc.  Does anyone have a solution other than tagging?

1 Comment 1
AljhonC
QuickBooks Team

sales tax report in quickbooks online

Having a report that breaks down non-tax sales by categories can be a great option, and I'd gladly help you submit this feature suggestion to our product engineer, Anne.
 

Currently, QuickBooks Online does not offer a specific report to directly view non-taxable sales broken down by categories such as services, exempt, and resale. To achieve this, you need to ensure that each transaction includes both taxable and non-taxable line items as appropriate.

 

After that, let's run and customize a Taxable Detail report:

 

  1. Click Reports.
  2. Select Standard reports and search for Taxable Sales Detail.
  3. Switch to Classic view and select Customize.
  4. Click on Filter.
  5. Distribution Account click the arrow and select All Income/Expense Accounts.
  6. Customer Taxable click the arrow and select Non-Taxable.
  7. Product/Service Taxable click the arrow and select All.
  8. Click Run report.

 

 

Once done, export this report to Excel and remove the taxable line items.
 

Moreover, I encourage you to send feedback directly to our product development team so they can consider adding more granular tax categorization features in the future:

 

  1. Go to the Gear icon at the top.
  2. Select Feedback.
  3. Type in your feedback and product suggestions.
  4. Click Next to submit them.

 

Your feedback on this is greatly appreciated, and it helps QuickBooks consider such scenarios for potential updates. If you'd like to track the status of your feedback, please visit our QuickBooks Customer Feedback page.
 

Additionally, consider saving this report customization for future use.

 

Should you need more detailed guidance on customizing reports or any other features, please don't hesitate to reach out. Our support team is here to ensure you make the most out of your accounting software. 

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

Need to get in touch?

Contact us