Export Customer List From QuickBooks® Desktop
  • 05 Jun 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Export Customer List From QuickBooks® Desktop

  • Dark
    Light
  • PDF

Article summary

If you use QuickBooks Desktop and are now setting up Restaurant365, moving your Customer List over is easy. When importing a Customer List, it is important to consolidate and update the list before importing into R365. Follow the instructions below to help prepare a successful file for import. 


Download Customer List from QuickBooks Desktop

Navigate to 'Reports' in the left navigation and click 'List'. A listing of all report lists will be displayed.

The first List will be labeled 'Customer'. Find the 'Customer Contact List' report, select the desired date range, and click 'Run'.

On this report, click on the 'Excel' menu at the top of the window and choose 'Create New Worksheet'.

On the prompt that appears, select 'Create a comma separated values (.csv) file' and then click 'Export'. A system dialog will appear where you can give the file a name and determine where the file will be saved.


Consolidate Customer List

It is important to make a consolidated list of all Customers. To do so, make sure to:

  1.  Open your downloaded file and delete Customers that you do not currently do business with

  2.  Delete duplicate Customers (this includes Customers that may be spelled differently, but are the same entity). Click here to follow the steps needed to remove duplicate Customers

  3.  Reformat your file to this structure: Name (required), Number (personalized), Phone, Email, Street1, Street2, City, State, Zip, Fax, Primary Contact, Payment Terms, Terms Discount Account, Taxable, Discount %, and Franchisee Location

    Only the Name of each Customer is required, but including as much information from your QuickBooks Customer List will benefit you when you fully transfer over to R365

  4.  Save your CSV file


Import Consolidated Customer List into R365

To import your Customer List, hover over 'Administration' in the top ribbon and click 'Import'.

When the Import window opens, type in 'Customer' in the 'Options' field and then 'Create New' in the 'Type' field. Once uploaded, click 'Upload File' and browse to your CSV file. After uploading your file, click 'Next' and verify the 'Map Fields' step. The final tab will bring you to the final import page, where you will click the 'Import' button to upload the file.

Click here for additional information on the Import Tool or how to resolve Import Issues.


Was this article helpful?