Sales guide ยท section 16 of 18

Fill in customer billing and contacts from QuickBooks or a spreadsheet

Bring the billing and shipping addresses, email, phone and contacts your company already keeps in QuickBooks or a spreadsheet into the customer master, so every order for that customer has them.

Before you start

Steps

In the pictures, a numbered red box marks where to click or type. Where a picture has more than one box, the numbers give the order.

  1. Select Clients, then a client marked In customer master. Its billing address and contacts come from the customer master. Here they are still blank, and the note offers an Import shortcut.

    Screenshot for: Select Clients, then a client marked In customer master. Its billing address and contacts come from the customer master. Here they are still blank, and the note offers an Import shortcut. Numbered boxes 1, 2 mark where to click or type.
  2. Select Import billing & contacts.

    Screenshot for: Select Import billing & contacts. Numbered boxes 1 mark where to click or type.
  3. Export your customer list from QuickBooks as a CSV file, as the dialog describes. Select Choose CSV file and pick it, or copy the rows from Excel, header row included, and paste them into the box.

    Screenshot for: Export your customer list from QuickBooks as a CSV file, as the dialog describes. Select Choose CSV file and pick it, or copy the rows from Excel, header row included, and paste them into the box. Numbered boxes 1, 2 mark where to click or type.
  4. Select Preview. Nothing is written yet. The summary says how many blank fields would be filled, and on how many customers.

    Screenshot for: Select Preview. Nothing is written yet. The summary says how many blank fields would be filled, and on how many customers. Numbered boxes 1, 2 mark where to click or type.
  5. Read the table. Each row of your file shows its result, the master customer it matched, and what would change. A value the master already holds is kept, and the row says so.

    Screenshot for: Read the table. Each row of your file shows its result, the master customer it matched, and what would change. A value the master already holds is kept, and the row says so. Numbered boxes 1 mark where to click or type.
  6. When the preview is what you expect, select Fill. It names how many customers it will fill.

    Screenshot for: When the preview is what you expect, select Fill. It names how many customers it will fill. Numbered boxes 1 mark where to click or type.
  7. The summary now says what was filled. Select Done.

    Screenshot for: The summary now says what was filled. Select Done. Numbered boxes 1, 2 mark where to click or type.
  8. Select the client again. Its billing and shipping addresses and contacts now show beside its orders.

    Screenshot for: Select the client again. Its billing and shipping addresses and contacts now show beside its orders. Numbered boxes 1 mark where to click or type.

Tips