Skip to main content
Avalara Help Center

Import multiple customers with a template

This article applies to:Avalara CertCapture

After you configure your CertCapture company, add customer records. If it's the first time you're adding customers to CertCapture, the quickest way to transfer all exempt customers from your business application into CertCapture is via an import spreadsheet. Customer information includes contact details and whether customers were billed for or shipped goods.

Exempt customers in your business application and CertCapture should match. Transfer customer records from your business application to CertCapture on a regular basis to keep it up to date. Since you process transactions in your business application, use that customer list as the source of truth. 

Before you begin

  • Import files larger than 50 MB or with more than 40,000 lines can't be imported
  • Column header titles cannot be modified
  • If you add a customer number to a template and that customer number already exists in CertCapture, data in the spreadsheet will override existing information for that customer

Steps

  1. In CertCapture, go to Customers > Import Customers.
  2. Download an import template:
    • Download the Basic Information template if your accounting software stores customer billing records and shipping states under a single customer number.
      • Each row in this template contains that billing customer's details and a field for the state where their goods were shipped. If a billing customer ships goods to more than one state, duplicate that customer row and update the Shipping Customer State field.
      • Use this table as a guide.
    • Download the Full Information template if your accounting software stores customer billing records and shipping records under separate customer numbers.
      • Each row in this template contains a billing customer's details and corresponding shipping customer's details, so you'll need more information for both. If the billing customer has multiple shipping addresses, duplicate that customer row and update the shipping details. Don't forget about the shipping customer number!
      • Use this table as a guide.
  3. Gather your customer information. Export the customer info from your accounting software if necessary. We'll transfer that data to a template before we import.
  4. Save your spreadsheet, and then select Choose File to add the spreadsheet from its location on your computer.
  5. Select Upload, and then select Import Customer Data to begin the upload. We'll email you when it's done.

After you receive the confirmation email, search for any of the customer records you just created to confirm that the customer details are what you expect.

If everything looks correct, begin uploading and validating compliance document for the customers you've added. If you're missing some, send a document request.

  • Was this article helpful?