Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
Showing results for 
Search instead for 
Did you mean: 
Level 1

I have 5 customers (apartment buildings) each with about 25 customers (tenants) to create

I figured out how to create customers and sub customers one at a time (Sales/Customers/New Customer, then for me I need to fill in First, Last name, phone, place check mark  if sub customer to a building and also select bill this customer.


I have tenant lists in Excel but not in an addressbook .csv to import.  Is there quicker to type all the tenants info in one place or do I have to select "new customer" and "save" for each of them?


thank you

1 Comment

I have 5 customers (apartment buildings) each with about 25 customers (tenants) to create

It's nice to see you here in the Community, @Metro Management.


Good to know that you already figured out how to enter customers in QuickBooks Online (QBO). I can share some information about how you can save time importing customer lists from Excel compared to manually entering them.


Yes! There's a quicker way and that is importing your customer lists from Excel. All you need to do is to save the Excel spreadsheet it as .xls or .xlsx instead of .cvs file format. Please note that you can't import sub customers. You'll need to change them to customers (Parent customer) before you import, and back again after.


In this case, I'd suggest creating your 5 parent customers first manually. Then once the import is done, assign each sub customers to their respective parent customers.


Here's how to import customer lists from Excel to QBO:


1. Review your Excel file, then save the Excel spreadsheet as an .xls or an .xlsx file and take note of its location

2. Sign in to your QBO company and complete the import.

  • Click the Gear icon at the top.
  • Under Tools, choose Import Data.
  • From the list, select Customers, then click the Browse button.
  • Locate the Excel file, click Open then choose Next to continue.
  • Map your data then Next.
  • Adjust your data if necessary, then select Import.

For additional guidance, you can refer to this article: Import customer, vendor, or vendor contacts from Outlook, Excel or Gmail.


To assign sub customers, here's how:


1. Go to Sales menu on the left pane, then select Customers.

2. Click the customers that you've imported on by one.

3. On the Customer Details tab, select Edit.

4. Put a check mark on Is sub-customer, then choose the Parent Customer.

5. Once done, click Save.


That'll do it! Please let me know how it goes after following these steps. I'm only a post away if I can be of additional assistance. Have a great weekend ahead!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us