Skip to main content
April 2, 2025
Question

reports for sales that also show sales tax

  • April 2, 2025
  • 1 reply
  • 0 views

Kentucky Sales & Use tax Audit and I need a report that shows the total sales along with the sales tax for the sales that had sales tax on them. Is this possible?

1 reply

April 2, 2025

Welcome to the QuickBooks Community! Currently, there isn't a report in QuickBooks that can create that. However, you could run two reports (Sales Tax Liability Report and Sales Tax Revenue Report ) and merge the reports in Excel. From there, you can customize and add/remove what is needed. Here's how:

 

  1. Go to Reports, then Reports Center.
  2. Find and double-click the report you want to export.
  3. Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
  4. If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
  5. When you’re ready to export, select OK.

 

When you are finished, follow the same steps for the other report but choose update existing Worksheet. 

 

Let me know if you have any other questions or concerns. I will do my best to help. See you soon.