cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Stueagle
Level 1

I need to run a report that details the total revenue and number of invoices per client.

We are exploring selling our company, and the potential buyer has made a couple requests:

  • Volume of cases by state since 2020

I'd like to create a report with the following columns: Customer Names, Total # of Invoices, and Class (states)

 

  • Revenue and volume of cases by customer since 2020 with customer names included

I'd like to create a report with the following columns:  Customer Name, Total # of Invoices, Total Invoice amounts

 

  • EBITDA

How do I run this type of report?

1 Comment 1
MirriamM
Moderator

I need to run a report that details the total revenue and number of invoices per client.

I'm here to share some details about running the report you need, @Stueagle.

 

In QuickBooks Desktop (QBDT), we have the Sales by Customer Detail report that you can run. This report will show the total sales to each customer and job, broken down by transaction. Then, customize the column to display classes. 

 

However, there isn't a way to add to the Total # of Invoices column. As a workaround, you can consider exporting the information to Excel and manually counting the number of invoices from there. 

 

To pull up the report, here's what you'll need to do:

 

  1. On your QBDT account, go to the Reports menu at the top.
  2. Select Sales, and then click on Sales by Customer Detail.
  3. Click the Customize Report button and choose the Display tab.
  4. Set the report date range.
  5. Go to the Columns section and select TypeDateNumberNameClassPaid, and Amount.
  6. Click on the Filters tab and type Transaction Type in the Choose filter field.
  7. Select Invoice.
  8. Click OK.

 

After that, select Excel on the toolbar and choose to Create New Worksheet. Then, click on Export.

 

I can see the importance of running the report you need to provide to your potential buyer. Since it's not yet an option, I suggest sending a feedback request to our product developers. Here's how:

 

  1. Go to the Help menu and select Send Feedback Online.
  2. Click the Product Suggestion from the dropdown menu.
  3. Fill out the on-screen instructions in the QuickBooks Feedback window.
  4. After that, click Send Feedback.

 

You can also visit this page or the What's New section on your QBDT to get updates on our latest news about product improvements.

 

To learn more about running reports in QBDT and how you can personalize it to generate what you need, see these articles:

 

 

As always, feel free to check out our help articles in case you need tips and related links while working with QuickBooks in the future.

 

Let me know if you have other concerns while running reports or managing QuickBooks. I'll get back to you right away. Have a great day.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

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