This page is about how an Avalara MRS customer should complete their AvaTemplate Excel File for VAT Reporting.
|A video introduction on to how to get up and running with the AvaTemplate.|
The following table contains definitions of each column in the AvaTemplate.
A unique sequential code that is normally automatically issued by your invoicing software and assigned to VAT invoices for sales. Or for purchases, the invoice number issued by the party for goods or service you are buying.
If the tax point of a certain supply of goods/services is different than the invoice date, the system will account for this date as the time of supply. For instance, this date could be the payment date, if a client is using the cash-accounting scheme.
The date of the invoice i.e date of issue.
The currency the invoice is issued in.
Please use the drop-down menu to select the transaction type.
To be used for Sales and Credit notes
To be used for purchases from suppliers within the same country or from suppliers without VAT numbers
To be used for purchases from suppliers outside the EU. Import documents should also be sent to Avalara (to accompany the AvaTemplate).
To be used then you have transferred own goods between 2 EU Member States. Please only fill in the EC Sale Side of the transactions.
To be used when you have sold to another business across border.
To be used for purchases from VAT-registered suppliers in another country.
To be used for Mini One Stop Shop transactions.
*Please note that only GB based MOSS transaction are processed by VAT Reporting.
DOMESTIC REVERSE CHARGE
To be used when a domestic sales transactions is subject to reverse charge.
Click on this link for a guide to UK Domestic Reverse Charge. Section 5 gives an example of how Domestic Reverse Charge works in the UK.
The country from which the goods are being shipped or the country where the service is being enjoyed.
The country to which the goods are being shipped or the country where the service is being enjoyed.
The name of the Supplier / Exporter / Seller
|I||Seller VAT Number||
The VAT Number* of the Supplier / Exporter / Seller.
*The VAT number used should be from the country from which you dispatched the goods, unless your business is distance selling and is taxed in an arrival country (due to opting, or the VAT Threshold in that country being exceeded).
|J||Customer VAT Number||
This is the VAT number of your Customer, if your are making B2B sales or purchases.
This is the name of the Customer, Importer or Consumer
Use the drop-down menu to select Goods or Service.
Is it or Goods or Services? For anything relating to sale of products (via Amazon or similar websites), this will always be Goods.
The NET value of the transaction shown on the invoice.
Enter the value of VAT charged
Enter the GROSS Sale/Purchase price
The VAT rate being charged, expressed as a percentage.