QuickBooks HelpQuickBooksHelpIntuit

Add and manage customers in QuickBooks Online

SOLVEDby QuickBooksQuickBooks Online180Updated 5 days ago

Learn how to add, edit, delete, or merge customers in QuickBooks Online.

As your business grows, it's important to stay organized and keep track of your customers. In QuickBooks Online, you can add customer profiles so you can add them to transactions or invoices. Here's how to add customers and keep your customer list up-to-date.

Add a new customer

Add your customers to the customer list so you can track their future transactions in QuickBooks Online.

Here’s how:

  1. Go to Get paid & pay and select Customers (Take me there).
  2. Select New customer.
  3. In the Customer display name field, enter what you want to display for the customer. (this is a required field)
  4. Then, review each section and enter any other important customer info.
  5. Select Save.

Import customers from an Excel file

If you have a spreadsheet with your customer info, you can import it into QuickBooks Online all at once.

When your Excel sheet is ready, follow the steps below to import into QuickBooks Online:

  1. Go to Get paid & pay and select Customers (Take me there).
  2. Select the dropdown ▼ next to New customer, then Import customers.
  3. Select Browse.
  4. Follow the steps to upload your Excel file, then select Next.
  5. Map the fields in your file to the fields in QuickBooks Online, then select Next.
  6. Select the customers to be imported, then select Import.

Add a sub-customer

You have the option to create sub-customers under your top-level customers (also known as parent customers). This is useful if you want to track individual customers who are also part of a group or a large organization.

While you can have unlimited sub-customers, parent accounts can only have sub-customers up to four levels deep.

If you haven’t added the parent customer yet, add them as a new customer first (see steps above). Then add each sub-customer as follows:

  1. Go to Get paid & pay and select Customers (Take me there).
  2. Select New customer.
  3. Enter the sub-customer’s name and contact info.
  4. Select the Is a sub-customer checkbox.
  5. From the Parent customer ▼dropdown, select the parent account.
  6. Select Bill parent customer if you want to bill the customer with the parent. Leave this unchecked if you want to bill the sub-customer themselves.
  7. Enter the sub-customer’s info.
  8. Select Save.

Note: If you need to change a sub-customer into a top-level customer in the future, simply edit the sub-customer's profile and uncheck the Is a sub-customer checkbox.

Edit a customer

When you edit customer information, the changes will be reflected in other areas of your company file including previously sent invoices. QuickBooks Online also updates any recurring templates that use previous information like billing, shipping, and email addresses, and the preferred payment method and terms. 

Here’s how to edit a customer’s info:

  1. Go to ​Get paid & pay and select Customers (Take me there).
  2. Select the customer you want to update.
  3. Select Edit.
  4. Make any changes.
  5. Select Save.

Delete a customer

To remove a customer, you can make them inactive which hides them from lists and menus. Even if a customer is inactive, all their transactions will still be available on reports.

Important: If you delete a parent customer, you also delete their sub-customers. But, if the customer has a project attached, it can't be made inactive. To make the customer inactive, delete any projects attached to the customer.

  1. Go to Get paid & pay and select Customers (Take me there).
  2. Select the customer's name to open their profile.
  3. Select the dropdown ▼ next to Edit.
  4. Select Make inactive and Yes, make inactive to confirm.

Note: If you see a transaction for an inactive customer, it displays as "Name (deleted)."

  1. Go to Get paid & pay and select Customers (Take me there).
  2. Select the Settings ⚙ icon above the action column. Then select the Include inactive checkbox.
  3. Look for the inactive customer on the list.
  4. In the Action column, select Make active.

Merge duplicate customers

If you have duplicate customers, you can merge their profiles. This deletes one profile and moves their existing data into the profile you want to keep.

Note: Make sure neither customer has any sub-customers. If they do, you’ll need to make their sub-customers into regular customers first.

  1. Go to Get paid & pay and select Customers (Take me there).
  2. Select and open the customer profile you don’t want to keep.
  3. Select Edit.
  4. In the Customer display name field, enter the name of the duplicate customer profile you want to keep. The names need to match exactly.
  5. Select Save.
  6. When asked if you want to merge the two profiles, select Yes.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this