Skip to main content
Avalara Help Center

Add or Import Company Locations

This article applies to:Avalara AvaTax

Add locations manually one at a time or import multiple locations at the same time.

For more information, learn how to manage locations or check out our frequently asked questions about locations.

Add a location

Learn how to add a company locationHoverTT.png in order to accurately calculate tax.

  1. On the Organization tab, click the Locations button Picture of the Locations button for a company.
  2. On the Locations screen, click New.
    AvaTaxCalc-Organization-Locations-ClickNewLocation.png
  3. On the New: Location screen, complete the required fields at a minimum:
    1. Location Code: The internal code used by a company with multiple retail (brick and mortar) stores or multiple places of fulfillment (warehouses) to uniquely identify the location associated with the transaction. The location code must be the same as the code passed as part of the transaction. Use the information provided by the state DOR for the Location Code and Location Description. For example, in AZ, use the 3-digit ADOR location number(s) from your Transaction Privilege Tax (TPT) License, located below the address.
    2. Location Description: A text description of the location that may contain information about physical storefront locations, sales personnel, warehouses, etc.
    3. Type: A selection indicating the type of location. Select from the following:
      • Location (default)
      • Salesperson
    4. Category: The grouping for the location, depending on the type selected for the location.

      Select a Location and then select one of the following Category types:

      • Storefront (location where you are selling your goods)
      • Main Office
      • Warehouse (location where you are storing your goods)
      • Other
    5. Start Date: The date the location takes effect. Once the location information is saved, the start date can't be edited.
    6. End Date: The date the location expires.
    7. County: The jurisdiction of the location.
    8. Address Information: The address of the location. Click Validate to validate the address.
      AvaTaxCalc-Organization-Locations-AddressInformation.png
  4. For some State (Province) choices requiring Additional Location Information, click Next. Otherwise, click Save.
  5. If Next is clicked on the New: Location screen, AvaTax selects and displays the Tax Jurisdictions for this location.
  6. If you are:
    • Not a Returns client: When asked, “Is this specific location registered with the proper taxing authorities to report sales and use tax?” simply accept the default value of No and click Save to complete the process.
    • A Returns client: When asked, “Is this specific location registered with the proper taxing authorities to report sales and use tax?” provide the requested information associated with this location. If you don't have this information, select No, and then click Save to complete the process.
    • Generally, a good resource for this information is the hard copy return provided by the taxing jurisdiction. The required information can be found in the company location additional information matrix.
  7. Click Save.

Import company locations

 Import a large number of predefined company locationsHoverTT.png using the Import Data tool. Import company locations in either an Excel (.xls or .xlsx)  format or a Comma Separated Value (.csv) format. Download the import help file from the Admin Console. The maximum number of lines allowed in one import file is 100,000. Validate the addresses of company locations as they're imported by selecting the Validate Address check box. Validated addresses may not be exactly the same as imported addresses.

How to format the company location import template

The column headings in the import file must use the labels exactly as shown below. The individual data fields must conform to the Type (Size) and Use restrictions listed.

Column Column Heading Type (Size) Use Description
A CompanyLocationId Integer Required Location record number. This field is not imported, but is used to identify records.
B LocationCode Text (50) Required Unique location code specific to a company recorded within the organization tab. This value is passed either as a salesperson code, location code, or address code. Use the information provided by the state DOR for the Location Code and Location Description. For example, in AZ, use the 3-digit ADOR location number(s) from your Transaction Privilege Tax (TPT) License, located below the address.
C Description Text (255) Optional Description for location code. This is useful for identifying a specific location.
D AddressTypeId Integer Required Type of location:

1) Location (requires AddressCategoryId of Storefront, Main Office, Warehouse, or Other)

2) Salesperson (requires AddressCategoryId of Salesperson)

E AddressCategoryId Integer Required Category of location:

1) Storefront

2) Main Office

3) Warehouse

4) Salesperson

5) Other

F Line1 Text (50) Required Address line 1 for the location
G Line2 Text (50) Optional Address line 2 for the location
H Line3 Text (50) Optional Address line 3 for the location
I City Text (50) Required City name for the location
J County Text (50) Optional County name for the location
K Region Text (2) Required The two character region (state, province, or territory) ISO code
L PostalCode Text (10) Required ZIP code or postal code for the location
M Country Text (2) Required The two character country abbreviation for the location
  • US = United States
  • CA = Canada
N IsDefault Integer Required Default outlet code (Requires type location)

0) Not default

1) Default outlet code (only one default per company)

O IsRegistered Integer Required Indicates if location is registered with the taxing authority. If IsRegistered = 1, OutletName and the appropriate CompanyLocationSetting fields become required.

0) Not registered

1) Registered

P DBAName Text(100) Optional "Does Business As" name
Q OutletName Text(100) Optional Outlet name (required if IsRegistered = 1)
R CompanyLocationSettingType1 Integer Optional An integer that indicates what type of location information this represents (e.g., Account Number or Outlet No). See the company location additional information matrix for more information on the values that may appear in this field.
S CompanyLocationSettingJurisType1 Text(3) Optional One of the following values, STA=State, CTY=County, or CIT=City. Required field if CompanyLocationSettingType1 field is used.
See the company location additional information matrix for more information on the values that may appear in this field.
T CompanyLocationSettingValue1 Text(50) Optional Value for the location information specified. Required field if CompanyLocationSettingType1 field is used.
U CompanyLocationSettingType2 Integer Optional An integer that indicates what type of location information this represents (e.g., Account Number or Outlet No). See the company location additional information matrix for more information on the values that may appear in this field.
V CompanyLocationSettingJurisType2 Text(3) Optional One of the following values, STA=State, CTY=County, or CIT=City. Required field if CompanyLocationSettingType2 field is used.
See the company location additional information matrix for more information on the values that may appear in this field.
W CompanyLocationSettingValue2 Text(50) Optional Value for the location information specified. Required field if CompanyLocationSettingType2 field is used.
X CompanyLocationSettingType3 Integer Optional An integer that indicates what type of location information this represents (e.g., Account Number or Outlet No). See the company location additional information matrix for more information on the values that may appear in this field.
Y CompanyLocationSettingJurisType3 Text(3) Optional One of the following values, STA=State, CTY=County, or CIT=City. Required field if CompanyLocationSettingType3 field is used.
See the company location additional information matrix for more information on the values that may appear in this field.
Z CompanyLocationSettingValue3 Text(50) Optional Value for the location information specified. Required field if CompanyLocationSettingType3 field is used.
AA StartDate Date(10) Optional Effective date for the location in yyyy-mm-dd or mm/dd/yyyy format. If not present, defaults to today.
AB EndDate Date(10) Optional End date for the location in yyyy-mm-dd or mm/dd/yyyy format. If not present, defaults to 12/31/2099.

How to import a file of company locations

To add many locationsHoverTT.png at one time, import a file of locations. Download the import help file from the Admin Console. For information on the required format for a file of locations, and to learn more about the import process, see company location import format. 

  1. On the Organization tab, click the Locations button inet_earth_clear.pngfor a company.
  2. On the Locations screen, click Import.
  3. On the New: File Import screen, confirm:
    • Company Locations is selected for Type
    • The correct Company is selected for Company

  4. Click Browse to select the file to import.
  5. Click Upload.