Welcome to the Fit Small Business QuickBooks Online training course! In this lesson, we’re going to cover how to set up your customers in QuickBooks Online. We’ll explain how to manually add customers and how to upload customer data from an Excel or CSV file.
To complete this lesson, you can either watch the video below, read through the step-by-step instructions, or do both. Let’s begin!
Before we get started with the lesson, it’s worth mentioning that there are affordable virtual bookkeepers that can set-up and manage your QuickBooks for you. They will even help you get caught up if you are behind. For example, SmartBooks offers help with cash flow management, monthly financial statements, payroll processing and more starting at $250/month. Get a free consultation to learn more.
Why Is It Important to Set Up Customers in QuickBooks Online?
If you invoice customers, then you definitely want to set up profiles for your customers in QuickBooks. Setting up your customers will allow you to do the following:
- Quickly create invoices for your customers since all of your customer data like billing address, shipping address, and due date will automatically populate from the customer profile.
- Easily track sales by customer, which could be a great way to get to know what your customers like so you can market to them strategically.
First, we’ll explain how to manually set up customers in QuickBooks. However, if you have more than 10 customers to set up in QuickBooks, I recommend that you proceed to the next section of this lesson, How to Set Up Customers Using an Excel or CSV file.
How to Manually Set Up Customers in QuickBooks Online
Step 1 – Navigate to the Customer Center
To set up your customers in your company file, navigate to the customer center by clicking on Customers on the left menu bar:
Step 2 – Create New Customer
Click the blue New Customer button in the upper right hand corner as indicated below.
Step 3 – Enter Customer Information
Below is a sample customer that we are setting up for our fictitious company, Paul’s Plumbing.
Below are the fields that you need to complete and an explanation of how that information will be used by QuickBooks:
- First & Last Name – complete this for individual customers; this info will appear on all sales forms (i.e. Invoices, sales receipts and estimates).
- Company – complete this for your commercial or business clients; this info will appear on all sales forms (i.e. invoices, sales receipts and estimates).
- Display name as – this field will auto-populate based on the info entered in the Customer Name field. This is how your customer will show up on your Customer list in QuickBooks.
- Print on check as – if you have to write your customer a check for any reason then this field allows you to change the payee name if it is different from the customer’s name.
- The Address tab is where you enter the billing address of your customer. This should be the mailing address where you send your customers their invoices.
- Shipping address – this is the address that will be used to ship products to your customers. If you do not ship products to your customers then just leave the default setting which is to make the shipping address the same as the billing address.
- Email – the email address that is entered here will be used to send customers their invoices if you choose to email them and not mail them.
- Phone/Mobile/Fax – enter the contact telephone numbers provided by your customers.
Step 4 – Payment and Billing Info
- Preferred payment method – you can indicate here what method your customer prefers to pay with. If it is a credit card, then you can enter the credit card information here so that you have it on file.
A WORD OF CAUTION: While it is convenient to keep your customer’s credit card information on file so that you don’t have to ask for it every time, it is also imperative that you safeguard this information. For example, if you have multiple users who access QuickBooks data, be sure that you limit access to only those who actually need this information.
- Preferred delivery method – you can indicate here what method your customer prefers to receive invoices. During the lesson on How to Setup Your Invoices, we set up a default delivery method for all customers. If you want to change the default delivery method for any customer, you can do so here in the customer profile.
- Payment Terms – In the Setting Up Invoices lesson, we set up default payment terms for all customers. If you want to change the default payment terms for any customer, you can do so here in the customer profile.
- Opening balance – This field can be used to enter an outstanding balance for a customer. For example, if you are converting from another bookkeeping system to QuickBooks and your customer has some outstanding invoices, then you can enter the total outstanding balance here when you set them up in QuickBooks. When that customer sends you a check, you can apply it to this opening balance in QuickBooks.
If you’d like to learn more about offering payment terms and invoicing customers, click here.
Step 5 – Other Customer Info
Here is some additional information that you may want to keep track of in QuickBooks:
- Notes – Enter any additional information here that you would like to keep track for your customer (e.g. additional contact names or numbers). This information is for internal purposes and will not be visible to your customers.
- Tax Info – Enter your customer’s resale permit info here if they are not subject to sales tax.
- Attachments – Attach any documents that you would like to keep on file for this customer (e.g. signed contracts or copy of email correspondence).
Step 6 – Review Customer Set Up
Now that you have completed the customer set up, the customer will appear in the Customer Center as indicated below.
When to Import Customer Info Using an Excel or CSV File
Setting up customer profiles in QuickBooks Online allows you to quickly pre-populate invoices with customer data and track sales by customer.
If you have more than 10 customers to set up, I would recommend that you put the information in an Excel document and import the data into QuickBooks Online. This will save you a lot of time over manual entry, which we discussed in the first part of this lesson.
How Do I Import Customer Info Using an Excel or CSV File?
QuickBooks allows you to capture a lot of data about your customers, but the key fields that you should include in your Excel or CSV file are as follows:
- First/Last Name for Individual clients or Company name for a business
- Billing address
Don’t worry about the format of the spreadsheet, just make sure that you have the above key fields in the spreadsheet.
Once you have your spreadsheet ready, follow the instructions below to import the data into QuickBooks.
Step 1 – Navigate to Import Screen
To import into QuickBooks, click the drop down arrow to the right of the blue New customer button and select Import Customers as indicated below.
Step 2 – Select the Excel document to Upload
Click the Browse button to locate your excel file, as indicated below & go to the next screen.
TIP: If you want to see a sample Excel file, just click the Download a sample file link as indicated below. Keep in mind that there is no need to reformat your spreadsheet. In the next step, we are going to map the data so that QuickBooks will pull the right data from your spreadsheet.
Step 3 – Map your Data
In this screen, we will tell QuickBooks which field in our spreadsheet to pull the customer info from. By doing this, we will ensure that the information is imported into the right fields in QuickBooks.
- QuickBooks Field – This is the field in QuickBooks where the data will import.
- Your Field – From the dropdown, select the field in your spreadsheet that matches the QuickBooks field (i.e. the field where the info should import to).
TIP#1: The fields in your spreadsheet do not have to match the field names in QuickBooks like the above screenshot. For example, in QuickBooks there is a field called Mobile. In your spreadsheet, you may call it Cell phone. As long as you map the Cellphone field in your spreadsheet to the Mobile QuickBooks field, the data will import fine.
TIP#2: Don’t worry about having more fields in your spreadsheet than what you see in QuickBooks. The only data that will import into QuickBooks are the fields that you match to the QuickBooks fields. You can indicate No Match for the fields that you do not wish to import into QuickBooks, as indicated above.
Once you have completed mapping your data, go to the next screen.
Step 4 – Final Review of Data before Import
This is your final opportunity to review the data and how it will import into QuickBooks. Be sure that you double check the following:
- The number of records agrees with your spreadsheet
- Verify that the info is in the right fields. (i.e. Email address is in the Email field etc;)
If something is not right, click the Back button to go back and make any necessary changes. Select Import once you are ready to proceed.
Step 5 – Import is Complete
Once the import is complete, QuickBooks will provide you with a message like the following: 10 out of 10 customers have been successfully imported!
How Do You Modify Customer Info in QuickBooks Online?
You can change or update customer information anytime. From the Customer Center, click on the customer’s name as indicated below. Make any necessary changes to the customer profile.
How Do You Delete a Customer in QuickBooks Online?
Similar to Products and Services, you cannot delete a customer once you have used them in a transaction. For example, once you have created an invoice for a customer, that is considered a transaction. This invoice (transaction) is linked to financial statements and those financial statements will be used when you file your taxes.
However, if you decide that you no longer will do business with a customer, you can inactivate a customer just like you can for products and services. Inactivate will simply hide the customer from the Customer Center but they will still appear in all financial records if there’s been a transaction.
To inactivate a customer from the Customer Center, select the customer and click on the drop down arrow next to Create Invoice and select Make Inactive as indicated below.
Confirm that you want to inactivate the customer by selecting Yes:
That wraps up the section on how to set up customers in QuickBooks Online. The next lesson in our QuickBooks Online Training Course is How to Import Vendors in QuickBooks Online. This lesson will cover how to add vendor information to your QuickBooks Online account. To access this lesson or any of the others in the series, click here.
Our Recommended QuickBooks Apps