cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Learn about the Paycheck Protection Program application with QuickBooks. Start now.
Level 1

How to show sales tax in sales by customer detail report?

I want to have a report with the customer, sales tax, taxable amount, invoice amount. I figure the easiest way to do this is to customize the sales by customer report but I don't have the option to add any tax items as a column.
Solved
Best answer 12-10-2018

Best Answers
Highlighted
Level 15

How to show sales tax in sales by customer detail report?

No there is no way to get that, sales are income and sales tax collected is a liability so intuit did not include that as an option in reporting on sales.

Would be nice though, use the help menu>submit feedback and explain what you want

View solution in original post

9 Comments
Highlighted
Level 2

How to show sales tax in sales by customer detail report?

Is there an update on the status of this report? I would like to have it as well.
Highlighted
Level 15

How to show sales tax in sales by customer detail report?

No there is no way to get that, sales are income and sales tax collected is a liability so intuit did not include that as an option in reporting on sales.

Would be nice though, use the help menu>submit feedback and explain what you want

View solution in original post

Highlighted
Level 1

How to show sales tax in sales by customer detail report?

For QB Desktop, Try this -

Reports, Accountant & Taxes - Transaction Detail by Account

Filter - Account - Multiple - Accounts Receivable and Sales tax payable

Filter - Type - Invoice & Credit 

 

The sales tax will be below the sales but you can export to excel, copy and paste sales tax next to sales amount.

 

Highlighted
Level 1

How to show sales tax in sales by customer detail report?

For QB Desktop, Try this -

Reports, Accountant & Taxes - Transaction Detail by Account

Filter - Account - Multiple - Accounts Receivable and Sales tax payable

Filter - Type - Invoice & Credit 

 

The sales tax will be below the sales but you can export to excel, copy and paste sales tax next to sales amount.

Highlighted
Level 15

How to show sales tax in sales by customer detail report?

You run Sales by Customer Summary, Columns by Item Type. Now Filter and Remove the Item Filter entirely. Now you see the Sales Tax as a column. This works for the detail report, for sales by items, and you can always run a report on the sales tax item(s), of course.

 

Please see my attachment.

Highlighted
Level 1

How to show sales tax in sales by customer detail report?

THANK YOU!! Your solution is perfect! I don't have sales items, just a single service, but I stepped through the setup detail that you gave and got customer, service, sales tax for the quarter. Exactly what I needed. It's good to have a quick way to double check QB on sales tax as it's easy to get crosswise with that calculation!

Highlighted
Level 1

How to show sales tax in sales by customer detail report?

I can't download your attachment and I'd really like to see how you did this report with sales tax. Are you using Desktop or Online? Because I can't make my sales by customer report show sales tax and I'm using Online.

Highlighted
QuickBooks Team

How to show sales tax in sales by customer detail report?

Hi @cmeaston,

 

I'm here to take care of your query regarding a report showing your sales taxes in QuickBooks Online.

 

I suggest you run the Sales Tax Liability report instead.

 

Let me show you how:

  1. Click the Reports tab.
  2. On the search box, type in Sales Tax Liability.
  3. Change the Report period if necessary.

Learn how to customize your reports in QuickBooks Online by following the steps listed on the link I provided. There's a short video along with some screenshots that you'll find in the article I mentioned for your reference.

 

Don't hesitate to leave a comment below if you have any other questions in mind. I'll get back to you as soon as I can.

Highlighted
Level 1

How to show sales tax in sales by customer detail report?

THANK YOU!!! This was exactly what I needed.

Need to get in touch?

Contact us