Skip to main content
Avalara Help Center

Import Schedules Using Data File Upload

This article applies to:Excise


This site is only for Avalara customers licensed for Returns Excise, AvaTax Excise and Government. 
Documentation of operation, usage and release dates is confidential and proprietary information of Avalara.
Content last updated: April 7, 2016

► A WalkMe tutorial is available for this topic.

Download a template 

Each taxpayer type within a jurisdiction has its own Excel template, containing required fields for the tax return.  Here is how to retrieve a template specific to your return.

  1. Click the tax session line row and click Data File Upload.
    PRO USER0026.png
  2. Click Download template and save it to your computer.

  3. The file name will reflect the taxpayer type and jurisdiction by default.  You can change the file name but do not change the value in Save as type.

  4. Do not reformat the template cells or columns.

Import the data file 

Edit section

This step loads your prepared Excel or CSV file into the tax session manually from the menu option to an existing tax session.  Click here to learn how to populate the import file using the Avalara template.

  1. Click the tax session line row and click Data File Upload.
    PRO USER0026.png
  2. Click Select and navigate to the location of the import file.
  3. In the Avalara - Data File Upload window, select 1 of these 2 options from the drop-down menu.
    • Insert All (can result in duplicates) - select this option for your initial import, or to add records to those previously imported.
    • Delete all existing transactions and reload - deletes all previously imported records and loads a new file.
      • When the dot next to the file is green, that means it is a valid file type and it will import.  This does not mean that the file contents have been validated, only that it is an acceptable file extension, in this case CSV. 
      • When the dot is red, it is an invalid file type and will not import.  Click Remove and select a different file.  If you are using an Open Data Source version, make sure you have saved your file as .xlsx or .csv file type.
  4. Click Upload.
    PRO USER0029.png
  5. You will see the message "File has been successfully uploaded".
    • If you chose the wrong month or jurisdiction, it will upload successfully, but show errors.  The next section details how to troubleshoot errors.
  6. To close the window, click X in the upper right corner.
  7. To track its progress, click on Go to the System Activity link in the upload window.   You can also click on the main menu item Admin > System Activity to access the activity page.
  8. The Status column will update when the file is completed.
    PRO USER0030.png
  9. The Description column of the System Activity page details how many records were successfully loaded.

Troubleshoot the file import 

Edit section
  1. Check your record count of transactions loaded against your upload file.  If the file bypasses loading records to your session it  means that critical field information is missing.
    • Check your import file for lines with information not formatted correctly.  
    • The header line identifying the field columns is bypassed.
  2. Your tax session's grid column Critical Schedule Errors will show you if there are errors in your file.  

Tax Sessions > Transactions Validation will point you to those specific line items on your transactions that have errors.

  • Click here to continue on to the steps for Transactions Validation.

  • Was this article helpful?