How to Add Customers to QuickBooks
Don't have QuickBooks?
Open step-by-step instructions
Read step-by-step instructions
Access the Customer List
Access the Customer List from the left navigation bar.
Then click New Customer followed by Import Customer.
Format Your Spreadsheet
Organize your spreadsheet to match the format of the sample below. Make sure your column titles and the order of your columns match our example.
You can download this sample file here.
Upload Your File
On the Import Customers page, click Browse. Select your file and click Open.
Map Your Fields
For each QuickBooks field below, choose one of your spreadsheet columns. Then click Next.
Make sure you’ve checked a box on the left for each customer that you want to import. Then import them.
Add New Customer
Click Customers in the left Navigation Bar. Then click New Customer.
Enter New Customer Information
Fill out the Customer Information form. The only required field is Display name as but you can add as much information as you want. Click Save. Now that your customers are in QuickBooks, you can enter them into invoices, sales receipts and other forms.
Enter Customer Name
Type your customer’s name in the Choose a Customer field then click Save.
Finish your invoice then click Save at the bottom right of the screen.
Enter Customer Information
Return to the customer list and select the customer name.
Click Edit and add the new customer’s information. Click Save when you’re done. And that’s it! Now you can import customers using spreadsheets or by adding them one at a time whenever you need as your business grows.