cancel
Showing results for 
Search instead for 
Did you mean: 
bd201
Level 1

Sales Tax

Good afternoon,

I am trying to run a report that has both invoices and the sales tax from those invoices. I attached an image of what I am trying to say. What would I need to do in order to get both sales tax amounts from the invoices along with the invoices in one report?

 

Thank you.

4 Comments
BigRedConsulting
Community Champion

Sales Tax

How is your example different functionally than the defaults sales tax reports already in QB?

What's missing from them that you need?  (They seem to be about the same to me.)

bd201
Level 1

Sales Tax

The example I provided was in Excel and I manually went through each individual invoice and calculated all the totals myself. I just thought that there could be an easier way than to run a general report and then calculate it myself. I also could not find any QB reports that would include both the invoices along with their sales tax.

katherinejoyceO
QuickBooks Team

Sales Tax

Welcome to the Community, @bd201

 

You can run the Sales by Customer Summary report. Then, use filters to select columns by item type. Here's how: 

 

  1. Go to the Reports menu, then select Sales and choose Sales by Customer Detail.
  2. Click Customize Report.
  3. Go to the Filters tab.
  4. Select Item and click Remove Selected Filter
  5. Click OK

 

Now you'll see the Sales Tax as a column. You can also run a report on the sales tax item(s). See attached screenshots for visual guidance: 

 

reports.JPG

 

For future reference, read through this article: Create, access, and modify memorized reports. It helps you learn about how to save reports so you can pull them up should you want the same settings the way it's customized. 

 

Feel free to message again if you have more questions. We're always delighted to help.

bd201
Level 1

Sales Tax

Okay! Thank you!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us