QuickBooks HelpQuickBooksHelpIntuit

Get the total number of customers in QuickBooks Online

by Intuit•1• Updated about 8 hours ago

You can view the total number of customers in QuickBooks Online through the Customer list or by generating a report. This allows you to track your business growth and manage your customer data efficiently.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view Open this link in a new window

Some of your reports will look different depending on whether they're in the classic view or new enhanced experience. Learn more about the new enhanced experience.


View your total number of customers

Use the Customer list to filter data and see your total customer count.

  1. Go to All apps A bunch of numbers and letters on a tile wall., select Customer Hub, then select Customers & leads (Take me there).
  2. Select the settings icon âš™ above the Action column to filter your customer data.
  3. Select all the customer data you want to view.
  4. Select the Include inactive or Include projects checkbox if you want to include them in your total.
  5. Select your preferred page size.
  6. Scroll down to view the total number of customers.


Export your customer contact list to Excel

You can export a report to Excel to create a mailing list or keep all customer data in one place.

  1. Go to Reports Icon image of the Reports menu. and select Standard reports (Take me there).
  2. From the Type report name here â–Ľ dropdown, search for and select the Customer Contact List report.
  3. Customize your report if needed.
  4. Select the export icon , then select Export to Excel.
  5. Follow the steps to save the file.

Note: You may also select Export as CSV or Print/Save as PDF based on your preferences.

Once you have exported the file to Excel, you can sort the data based on the columns you see in the report.



Email the report

  1. Select the email icon .
  2. Enter all the info needed, then select Send email.