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

How would I create a report showing sales by qty for a top sales report?

 
2 Comments 2
ShiellaGraceA
QuickBooks Team

How would I create a report showing sales by qty for a top sales report?

Hi steve21,

 

You can use the Sales by Customer Detail report to view the sales by quantity. Then, export it to Excel so you can sort for the top sales.

 

Here's how to get it:

 

  1. Click Reports.
  2. In the Find report by name field, enter Sales by Customer Detail.
  3. Click Customize.
  4. Click Rows/Columns. Then, mark the QTY box.
  5. Click Run report.
  6. Click the Export icon beside the Printer icon.
  7. Choose Export to Excel

Just click the Reply button if you have other questions.

sbeverage
Level 1

How would I create a report showing sales by qty for a top sales report?


@ShiellaGraceA wrote:

Hi steve21,

 

You can use the Sales by Customer Detail report to view the sales by quantity. Then, export it to Excel so you can sort for the top sales.

 

Here's how to get it:

 

  1. Click Reports.
  2. In the Find report by name field, enter Sales by Customer Detail.
  3. Click Customize.
  4. Click Rows/Columns. Then, mark the QTY box.
  5. Click Run report.
  6. Click the Export icon beside the Printer icon.
  7. Choose Export to Excel

Just click the Reply button if you have other questions.


 

Sales by customer didn't work, but you can go to the General Ledger account and add Qty and Products and service. Then, just export to Excel and delete everything but invoices. This will show you how much quantity in a given time.

Need to get in touch?

Contact us