Categories
Reports

How to create Sales by Customer Detail report that only shows one line per item invoiced

Sales by Customer Detail report (screenshot 1) is for both income and COGS for inventory items (screenshot 2). That’s why the report is showing positive and negative numbers.
To show one line per item in essence for income only, you will need to customize the report.
Click the customize button > Go to Lists section > Distribution Account > select “All Income Account” (see screenshot 3) > Run Report

New customized report will show just one line per item invoiced (see screenshot 4).

sales by customer detail 1
sales by customer detail 1
sales by customer detail 2
sales by customer detail 2
sales by customer detail 3
sales by customer detail 3
sales by customer detail 4
sales by customer detail 4

 

If you found our answers useful then please contribute a few bucks to support this forum. Thank you!





Thank you!






Sign up QuickBooks USA