Skip to main content
Avalara Help Center

Fix Transaction Import Errors

This article applies to:Avalara AvaTax Update

When you import transactions:

  • Try a trial import of a few records to increase your familiarity of the import process before importing larger numbers of records
  • Adhere to size limits for each data field
  • If an import contains errors, an error file lists the rows that didn't successfully import. All rows not listed in the error file were imported

Troubleshoot file imports

To troubleshoot an unsuccessful transactionHoverTT.png import, examine the resulting error file from the import status screen.

  1. Go to Transactions > Transaction Import History.
  2. On the Transaction Import History screen, in the Error File column for an imported file, click the Download icon. The Error.csv file downloads.
  3. Open Error.csv and view the error message in the last column for each record that failed to import.
  4. Make the necessary corrections to the records, and then delete the last column (the one with error messages).
  5. Save the file with a new name and import it.

Transaction import error messages

After importing, some records may cause error messages that you need to troubleshoot. TransactionHoverTT.png import error messages and their probable causes are listed below:

Error Message
Error Condition
AddressNoStreetError The ZIP/Postal Code exists but no streets begin with the same letter in that ZIP/Postal Code.
AddressRangeError The address was found but the street number in the input address was not between the low and high range of the post office database. 
AddressUnknownStreetError An exact street name match could not be found and phonetically matching the street name resulted in either no matches or matches to more than one street name. 
CityError The city name or code was not recognized, check the spelling.
CompanyNotFoundError Company used in the transaction does not exist.
CountryError The country name or code was not recognized.
CurrencyCodeError Currency code is either invalid or missing. Add the correct currency code.
DateError A required date was not submitted or was invalid. Dates must be submitted in MM/DD/YY format.
DestinationJurisdictionError No jurisdictions were found for the destination address.
DocStatusError There is a duplicate of a document and therefore cannot be saved. You need to use a unique doc code.
DuplicateLineNoError One or more line numbers are duplicates. All line numbers must be unique within the document.
JurisdictionNotFoundError Unable to determine the taxing jurisdictions. To resolve, verify the state abbreviation.
LengthError

The maximum length of a field in the GetTax request is exceeded. Verify maximum length in the Type (Size) column of the import transactions template.

NonDeliverableAddressError The physical location exists but there are no homes on this street. One reason might be railroad tracks or rivers running alongside this street, as they would prevent construction of homes in this location. 
PostalCodeError

The ZIP/Postal Code does not exist and could not be determined by the city/municipality and state/province.

If the ZIP/Postal Code starts with a zero, Excel may remove it, which causes an address error. To resolve this, change the cell format to postal code or enter an apostrophe ( ' ) in front of the zero (for example, 01234 would be entered as '01234).

RangeError A value of one field in the GetTax request was not within the required range of values. 
RegionCodeError The two-digit state code was not specified or was invalid. To resolve, verify the state abbreviation.
RequiredError One of the required fields is missing in the GetTax request. For a list of required fields, read format the important transactions template.
SSTItemError SST requires an audit trail of the mapping of item codes (SKUs) to system tax codes. You have to put an item description if you are making it non-taxable. To resolve, read format the important transactions template.
TaxAddressError

Address is incomplete or invalid.
An incomplete or invalid origin or destination address was given. A taxable address must include a (line, city, and region (state)) or a (line and zip) or a (region (state) and postal code). 

TaxIncludedError TaxIncluded is not supported in combination with caps, thresholds, or base rules.
TaxOverrideError Invalid/Wrong Tax Override or TaxOverride is applied in an invalid way. Verify is the state has sales tax and that you have nexus in that state.
TaxRegionError Invalid TaxRegion is provided in the import file. To resolve, verify the state abbreviation.