QuickBooks HelpQuickBooksHelpIntuit

Get the total number of customers in QuickBooks

by Intuit• Updated 1 month ago

Find out how to view your total number of customers in QuickBooks.

Note: This article is for customers using QuickBooks Online (Advanced, Essentials, Plus, and Simple Start) and QuickBooks Sole Trader.

In QuickBooks, you can easily track the total number of your customers. This can provide valuable insights into your growing business.

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.

Follow the steps below based on the product you are using.

View your total number of customers

To get your total number of customers, follow these steps:

  1. Go to Customers & leads and select Customers (Take me there).
  2. To filter your customer data, select the Gear ⚙ icon.
    1. Select all the customer data you want to view.
    2. Select Include inactive or Include projects if you want to include them in your total.
    3. Select your preferred page size.
  3. To view the total number of customers, scroll down.

Export your customer contact list to Excel

If you want to create a mailing list or have all your customers' data in one place, export it to Excel.

  1. Go to Reports (Take me there).
  2. From the Find report by name dropdown, search for and select the Customer Contact List report.
  3. Customise your report.
  4. Email, export, or print the report.
    1. To email the report, select the More actions dropdown, then select Email report. Enter all the info needed, then select Send email.
    2. To export/print, select the Export/Print dropdown, then select Export to Excel, and follow the steps to save it.
      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.

View your total number of customers

To get your total number of customers, follow these steps:

  1. Go to Customers and goals and select Customers.
  2. To filter your customer data, select the Gear ⚙ icon.
    1. Select all the customer data you want to view.
    2. Select Include inactive if you want to include them in your total.
    3. Select your preferred page size.
  3. To view the total number of customers, scroll down.
QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.