Skip to main content
Avalara Help Center

Set up the Avalara Extractor for Amazon

Connect the Avalara Extractor for Amazon to automatically add your Fulfillment by Amazon (FBA) or Fulfillment by Merchant (FBM) transactions to AvaTax so they're included on your returns. 

Learn more about how company locations in AvaTax. For questions about the Amazon Sales Tax Report, refer to the Fulfillment by Amazon documentation maintained by Amazon.

Set up an extractor

Connect your Amazon account to sync transactions with AvaTax.

  1. Log in to Avalara Account and click Integrations.
  2. Click Authorize AvaTax for Use with Amazon.
  3. Choose how AvaTax should handle tax on your transactions:
    • Keep the tax calculated outside AvaTax - AvaTax keeps the tax as calculated in Amazon
    • Recalculate the tax in AvaTax when transactions sync - AvaTax replaces the tax amount with our own calculation 
  4. Select a Start Date so AvaTax knows how far back to retrieve transactions.
  5. If you have multiple companies, select the company that Amazon transactions should be added to.
    • You'll set up separate extractors for each when working with multiple companies
  6. Click Connect.
  7. Grant AvaTax permission to retrieve your Amazon transaction data:
    • Sign up for an Amazon Marketplace Web Service with your Seller Central credentials
    • Select I want to use an application to access my Amazon seller account with MWS
    • Enter the Application Name and Developer Account Number
    • Accept the license agreement and then click Next
    • On the confirmation page, note the Seller ID, Marketplace ID Name, and MWS Authorization token for the next step
  8. Enter the Seller ID, Marketplace ID Name, and MWS Authorization Token from your confirmation page and then click Submit.

AvaTax syncs your Amazon transactions immediately. Find newly added transactions in AvaTax.

View extractor logs or pause an extractor

  1. Log in to Avalara Account and click Integrations.
  2. Click View Logs to review Extractor activity.
  3. Click On/Off to enable or pause an extractor.
  4. Extractors can only be deleted when they're Off.

Fix extractor errors

Failed extractor transactions are collected in Avalara Account. Download the transaction data, make corrections, and then manually import the transactions to AvaTax

A yellow outline and a Generate Error File button means you have new extractor errors.

Click Generate Error File to collect transactions in a .csv file so you can correct errors and manually import them to AvaTax.

AvaTaxUpdate-Extractor-NewErrors.png

 

No yellow outline or Generate Error File button means the latest errors have already been generated into a .csv file. 

This doesn't mean the failed transactions have already been corrected and uploaded. Filter your transactions to make sure they're in AvaTax.

AvaTaxUpdate-Extractor-OldErrors.png

  1. Log in to Avalara Account and click Integrations.
  2. Locate your extractor and click Error Files to view transactions that weren't added to AvaTax. 
  3. Click Generate File to collect the failed transactions into a .csv file.
    • Refresh the page if the error file isn't available to download after 30 seconds
  4. The final column of the .csv file contains error details.

Import transactions to AvaTax

To import transactions:

  1. Fix the errors described in the final column.
  2. Delete the error column from the spreadsheet and save the file.
  3. Sign into AvaTax. On the Tools tab, click Import Data.
  4. On the New: File Import screen, from the Type list, select Transaction Import.
  5. Click Next, and then select the company the transactions should be added to.
  6. Click Choose File, browse to select the file for import.
  7. Click Upload. The file uploads and the Import Status screen opens.
  8. If the Status column for the file displays Error, fix your transaction import errors.
Error Fix

Tax override cannot be applied

Nexus is not configured for (State or Region name)

Review Nexus settings for where you're collecting tax.

This also happens when:

  1. An Item Code is mapped to a Tax Code that isn't taxable
  2. The target state doesn't have a state tax
JAAS address validation exception

There's a problem with the addresses involved in the transaction. Check the addresses and make any needed corrections.

Test an address in the Tax Calculator or look up the address with the United States Postal Service.

Example issue: Address Line 1 contains a company name instead of the correct street information.

Invalid or missing State/Province Make sure the address has a state or province and that it's spelled correctly
The city could not be determined Make sure the address has a city and that it's spelled correctly
The address value was incomplete

AvaTax needs one of the following to properly calculate tax on an address:

  1. A zip/postal code
  2. Street address, city, and region
  3. Street address and zip/postal code

The address number is out of range

Address not geocoded

Unable to determine the taxing jurisdictions

Invalid Zip/Postal code

Make sure the address number is correct.

Look up the address with USPS and use the most accurate Zip code available.

If the address is for new construction and hasn't been added to the USPS system, use General Delivery on Address Line 2 until the address is available.

Field 'postalCode' has an invalid length

Check the field for errors and typos.

Look up the address with USPS and use the most accurate Zip code available.

 

Find extractor transactions in AvaTax

  1. Log in to AvaTax and click Transactions.
  2. Add "Amazon" or your marketplace location code to the filters above your transactions. Click the search button.
  3. A unique value is applied to the location and document code of all extractor transactions.

 

 

  • Was this article helpful?