QuickBooks HelpQuickBooksHelpIntuit

Organize or sort customers by type in QuickBooks Online

by Intuit104 Updated 2 days ago

Assign customers a type in QuickBooks Online to group customers in reports and identify customers in your list.

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

Step 1: Create customer types

Start by creating one or more types.

  1. Go to Sales or Customers & leads, then select Customers (Take me there).
  2. From the Customers screen, select Customer types.
  3. Select New customer type.
  4. Enter a name for the customer type, then Save.

Note: To see each customer’s type in your Customer list, select Settings⚙ in the the Action column and check the Customer Type checkbox.

Make customer types you no longer need inactive to remove them from the list of options. Inactive types can be made active again later.

  1. Go to Sales or Customers & leads, then select Customers (Take me there).
  2. From the Customers screen, select Customer types.
  3. In the dropdown ▼ for the type you want to delete, select Make inactive.

Note: To restore an inactive customer type, select Make active in its row of the Action column.

Step 2: Assign customer types

  1. Go to Sales or Customers & leads, then select Customers (Take me there).
  2. Select the customer, then select Edit.
  3. Go to the Additional info tab and select the type you want to assign from the Customer type dropdown ▼. 
  4. Select Save.

You can assign a type to more than one customer at a time.

  1. Go to Sales and select Customers (Take me there).
  2. Select the checkbox next to each customer you want to assign the same customer type.
  3. In the Batch actions ▼ dropdown, select Select customer type.
  4. In the Select customer type window, select the type you want to assign from the dropdown.
  5. Select Apply.

Step 3: Use customer types in reports

Sort your reports or filter reports that list individual customers by customer type. Not all reports support this. Examples of standard reports that use Customer type by default include: 

  • Sales by Customer Type Detail report
  • Sales by Customer Detail report grouped by customer type
  • Customer Contact List report customized to add a customer type column

To group or sort by customer type in a report that supports it:

  1. Go to Reports (Take me there).
  2. Go to the Sales and Customers section. 
  3. Choose a report that displays customers as rows, or create a new custom report.
  4. If you see Switch to modern view, select it.
  5. Select Columns. If you don’t see Customer type as an option, select More columns, then under Customers select Show more.
  6. Check the box next to Customer type.
  7. Select Filter or Grouped by, as needed, and check the box next to Customer type.

Related links

QuickBooks Online AdvancedQuickBooks 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.

More like this