QuickBooks HelpQuickBooksHelpIntuit

Organize or sort customers by type in QuickBooks Online

by Intuit•10• Updated 1 week ago

Learn how to organize and sort customers by type in QuickBooks Online Plus and QuickBooks Online Advanced.

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

Step 1: Create customer types

Start by creating one or more types.

Follow this link to complete the steps in product Open this link in a new window

  1. From the Customers window, select Customer types.
  2. Select New customer type.
  3. Enter a name for the customer type, then Save.

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

Delete customer types

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

Follow this link to complete the steps in product Open this link in a new window

  1. From the Customers screen, select Customer types.
  2. In the Edit dropdown Dropdown arrow icon. for the type you want to delete, select Make inactive.
  3. Select Yes to confirm.

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

Step 2: Assign customer types

Assign types to individual customers

Follow this link to complete the steps in product Open this link in a new window

  1. Find and select the customer. Then select Edit.
  2. Go to the Additional info section and select the type you want to assign from the Customer type dropdown ▼. 
  3. Select Save.

Assign types to multiple customers

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

Follow this link to complete the steps in product Open this link in a new window

  1. Select the checkbox next to each customer you want to assign the same customer type.
  2. In the Batch actions â–Ľ dropdown, select Select customer type.
  3. In the Select customer type window, select the type you want to assign from the dropdown.
  4. 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:

Follow this link to complete the steps in product Open this link in a new window

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

Related links