Skip to main content
Avalara Help Center

How to read rate files

Overview

You want more information on the rate file format so you can read the Avatax  Rate files.

Environment

Rate File Emails (ISPI)

Resolution

  1. MS Access file headers describe what each column is for
  2. The csv and the flat rate (without commas) files require a rate layout and header file, attached here
    • If your file has commas, use the CSV File Layout tab to view column positions
    • If you have the 'flat' rate file, without commas or delimitation, use the Fixed File Layout tab
  3. The tab called 'Rate File Header' allows you to import your rate file (CSV or Flat) and view the file in the columns.
    • If you have the DIMASYS file for Infor, there is a specific tab for that.
    • Justthebasics+ and MS Access files have the header within the rate file. 
  4. If you purchase the zip+4 file, to view the layout for the file, please use the tab called Zip plus 4 Header File,
    • The file with rate information will be named 'Tax.zip'
    • The file with the zip+4 will be named Taxzipp4.zip
  5. In order to use the above mentioned attachment, you will need to import the file into Excel
  • Was this article helpful?