PC.2.I.2 - Importing a customer list
- 9 steps
Fast & Easy QBO
QuickBooks
1
First you will need to download the customer list. In the task section of the ProAdvisor Challenge, click the button, "Craig’s customer list" to download the file. Or [click here.](https://live.intuittrainingplatform.com/filestore/AssetFiles/3563/2131/Craig%20customer%20list.xlsx)
The Sample Company
2
To complete the remainder of this exercise, you must be in the Sample company. To get into it, click on the Gear icon on the top right corner of the screen, then select Sample company.
Note that you will be logged out of your current account. If you are sure, click "Continue" to confirm.
Hands On Practice
Now let's get started with the exercise.
3
From the left navigation bar, hover over Sales, then select "Customers".
4
Click the "down arrow" next to New customer, then select "Import customers".
5
Click "Browse".
6
Find the Excel file "Craig customer list" on your computer (this is likely in your Downloads folder). Click the file name, then click "Open".
7
Click "Next".
8
Ensure the columns are mapping correctly, then click "Next".
9
Ensure the data is mapping correctly, then click "Import".
The customer list has been imported and all three customers are now showing: Dick Tse, Lawrence Tran, Paul Simmons (the last two are not shown in the screenshot).
🏋️♀️ Get More Practice
This exercise was featured as an Exercise of the Week in the QBO Gym. Do more hands-on exercises just like this by joining our FREE, 5-day Bookkeeping Challenge. [Just click here.](https://www.fastandeasyqbo.com/gym5)
📝 Feedback
Questions/Problems/Concerns? [Send Feedback](https://www.bookwidgets.com/play/k6rmQMKk-iQAEzXMdagAAA/BEXUQBE/feedback-scrib?teacher_id=6434462993219584)