The sales data template is case sensitive, so it’s easiest to fill it out with caps lock on.
Download the template here.
The template has two pages. The first is where you’ll be adding your data. The second contains short descriptions of what you need to add in each column.
The Columns
Date
This is the date the transaction completed and will be the month of processing. Please add it to the template in the DD/MM/YYYY format.
Order Number/REF/ID
The reference for the transaction.
Transaction Type
We need you to tell us what type of transaction you’re reporting. Choose either:
- SALE
- REFUND
- STOCK MOVEMENT
This column is case sensitive, so your choice needs to be in capital letters.
SKU (Stock Keeping Unit)
The unique code you use for your products.
Description
A description of your product.
Quantity
The number of items in this transaction. This figure must be a whole number.
Order Total
The total (gross) amount the customer has paid. This needs to be written as a decimal number (e.g.125.00 instead of 125). If the transaction is a refund, include the minus symbol (e.g. -125.00).
If the transaction is a stock movement, the order total is the value of the stock movement. For example, if you move 10 items with a cost of £5, the order value would be £50.
Currency
The currency the transaction was made in. This needs to be written in capital letters, as the 3-digit ISO 4217 code.
Country |
Currency |
Code |
|---|---|---|
Australia |
Australian Dollar |
AUD |
Canada |
Canadian Dollar |
CAD |
Japan |
Japanese Yen |
JPY |
Norway |
Norwegian Krone |
NOK |
Saudi Arabia |
Saudi Riyal |
SAR |
Switzerland |
Swiss Franc |
CHF |
UAE |
UAE Dirham |
AED |
UK |
Pound Sterling |
GBP |
USA |
US Dollar |
USD |
Austria |
Euro |
EUR |
Belgium |
Euro |
EUR |
Czech Republic |
Czech Koruna |
CZK |
Denmark |
Danish Krone |
DKK |
Finland |
Euro |
EUR |
France |
Euro |
EUR |
Germany |
Euro |
EUR |
Ireland |
Euro |
EUR |
Italy |
Euro |
EUR |
Netherlands |
Euro |
EUR |
Poland |
Polish Złoty |
PLN |
Spain |
Euro |
EUR |
Sweden |
Swedish Krona |
SEK |
Sale Departure Country/Fulfilment Country
The departure/fulfilment country for the transaction. This must be written in capital letters, as the ISO 3166 2-digit country code in the table below.
Sale Arrival Country/Destination Country
The arrival/destination country for the transactions. This must be written in capital letters, as the ISO 3166 2-digit country code in the table below.
Country |
Code |
|---|---|
Australia |
AU |
Canada |
CA |
Japan |
JP |
Norway |
NO |
Saudi Arabia |
SA |
Switzerland |
CH |
United Arab Emirates |
AE |
United Kingdom |
GB |
United States |
US |
Austria |
AT |
Belgium |
BE |
Czech Republic |
CZ |
Denmark |
DK |
Finland |
FI |
France |
FR |
Germany |
DE |
Ireland |
IE |
Italy |
IT |
Netherlands |
NL |
Poland |
PL |
Spain |
ES |
Sweden |
SE |
Tax Rate
The VAT rate where the transaction will be taxed. If the transaction is a B2C sale, this will be the country where your customer is based.
This must be written as a decimal, either equal to or greater than 0. Please don’t include the % symbol. For example: 13.5, not 13.5%
Buyer VAT Number
If your customer is VAT registered, please input their international VAT number, with the 2-letter country code. For example: DE1234567. This column is case sensitive, so please make sure that the country code is in capital letters.
Shipping Address 1, Shipping Address 2, Shipping Address 3, Shipping City, Shipping Country
These columns are the shipping address of your customer. Shipping Address 3 is for the postcode. These columns are case sensitive, so please make sure the address is written in capital letters.
Tax Collection Responsibility
This column is where you’ll tell us who’s responsible for collecting the VAT on the transaction. Choose either:
- SELLER
- MARKETPLACE
This column is case sensitive, so your choice needs to be in capital letters. If your customer is the Importer of Record, choose MARKETPLACE.
Marketplace
The platform where the transaction was made e.g. Amazon, Shopify, WooCommerce, eBay.