Skip to main content
Avalara Help Center

Completing the Avatemplate

When you get started with Avalara VAT Returns you will need to get your data into the system via data import.

We have templates available to help you get the data in the correct format.

We have added some helpful comments in the top row of the spreadsheet to explain the requirements for each column.

This page will provide further information on the columns in the Avatemplate.

Required fields and headings

Column Name / Heading Details and additional information
Seller Name

Enter the name of the supplier, exporter or seller. 

For sales enter the name of your own company for which you are reporting.

For purchases enter the name of the supplier you have purchased from.

This is a mandatory field with a max 200 characters.

Seller VAT Number

For sales enter the VAT number of your own company for which you are reporting. For purchases enter the VAT number provided on the supplier's invoice. For MOSS transactions enter your VAT MOSS number. Where an import supplier does not have VAT number, leave it blank. 

Otherwise, this is a mandatory field. 
Do not insert spaces. 
Max 50 characters. 

Which VAT number to enter?

The VAT number used should be from the country of taxation (the country from which goods were dispatched unless taxing in destination country due to opting or a threshold breach.

For example: 

A sale from GB to FR, with the distance selling threshold to France not breached, you would enter your GB VAT number.

A sale from GB to ES, with the distance selling threshold breached, you would enter your ES VAT number.

Customer VAT Number

Enter the VAT number of your customer if you are making business to business sales or purchases.

If the transaction is business to customer or MOSS, enter PRIVATE INDIVIDUAL.

For import, purchase or EC-Acquisitions transactions, enter your VAT number from the country of arrival here.

Leave this field blank for export transactions. This is a mandatory field for all other transaction types.

Do not insert any spaces in this column. Max 100 characters. 

Customer Name

The VAT number of your customer if you are making B2B sales or purchases.

If the transaction is B2C or MOSS, enter PRIVATE INDIVIDUAL.

For import, purchase or EC-ACQ transactions, enter your VAT number from the country of arrival here.

Leave this field blank for export transactions.

Otherwise, this is a mandatory field. 

Do not insert spaces. 

Max 100 characters. 

Description

The name of the customer or importer.

For purchases enter your own company, for which you are reporting. For sales enter the B2B client’s name.

If the transaction is B2C, and you are unable to get the customer name, enter PRIVATE INDIVIDUAL.

This is a mandatory field.

Max 100 characters.

Taxable Basis

Use the drop-down menu to select goods or services.

This is a mandatory field. 

For anything relating to sale of products (via Amazon or similar websites), this will always be goods.

Value VAT

The NET value of the transaction shown on the invoice.

This figure EXCLUDES any VAT.

This is a mandatory field.

Total

The value of VAT charged.

This is the VAT amount stated on the invoice. In case of reverse charge, enter a zero.

This is a mandatory field.

VAT Rate

The VAT rate being charged, expressed as a percentage, this column is automatically populated and does not need to be manually filled.

GTU Code

For Polish VAT returns only.

If your transaction meets certain criteria you need to enter a GTU code here. Only enter the alpha-numeric code, eg GTU_01.

Definitions:
GTU_01  Alcohol
GTU_02  Oil and fuel
GTU_03  Heating oil
GTU_04  Tobacco
GTU_05  Waste
GTU_06  Electronic devices
GTU_07  Vehicles and car parts
GTU_08  Precious and base metals
GTU_09  Medicines 
GTU_10  Buildings and land
GTU_11  Greenhouse gas emission trading
GTU_12  Intangible services
GTU_13  Transport

Please see this page for more detailed descriptions.

Document Code

For Polish VAT returns only. 

If your transaction meets certain criteria you need to enter a document code here. 

The codes are: 7, 13, 14, 15, 16.

Please see this page for more details.

 

  • Was this article helpful?