Skip to main content
Avalara Help Center

Completing the Variable VAT Rate Template

The Variable VAT Rate Template is an MS Excel file used to report the variable VAT rate of certain goods. The Variable VAT Rate Template is available to download here: Variable VAT rates.xls. If you are required to submit this data, the team will reach out to you with further details. 

Tip icon

Tip

The template has helpful comments in the header row to explain the requirements for each column. Hover over the header row in the template to see these helpful tips.

Once the template has been successfully populated, it can be uploaded to Avalara Managed VAT Reporting.

clipboard_e2eae8147c091ea2dd4ed0b1209198ae3.png  

Important

Please ensure all data has been entered correctly before submitting. Errors in the data or template may cause delays with filing.

 

Tips for successfully completing the Variable VAT Rate Template

The following information will assist with completing the template correctly:

  • Only use the template provided.
  • Save and upload it as an .xls file, not .csv.
  • Please do not add new sheets, columns, total rows, or alter the format, structure, or headings of the template. Doing so renders the template incompatible with our system.
  • Please ensure ASIN numbers do not contain any spaces before, after, or within the number.
  • Please enter country codes using the appropriate two alphabetic character ISO Standard 3166 code.

Variable VAT Rate Template field and heading details

Tip icon

Tip

The Variable VAT Rate Template has helpful comments in the header row to explain the requirements for each column. Hover over the header row in the template to see these helpful tips.

This section will provide further information on the effective use of the Variable VAT Rate Template.

Column Name / Heading Details and additional information
ASIN

ASIN: Amazon Standard Identification Number.

A ten-digit alpha-numeric code, unique to every product. It is assigned when you create a new product in Amazon's catalog.

When entering, ensure ASIN numbers do not contain any spaces before, after, or within the number.

Country

Use ISO Alpha-2 country code e.g. GB, DE, FR.

See: ISO Standard 3166 code.

VAT Rate

The VAT rate being charged, expressed as a percentage.

Frequently asked questions about the Variable VAT Rate Template

 

  • Was this article helpful?