Sales & Refunds are transactions related to your business, where you sell to a business or person outside Amazon and you want to include these in your VAT returns. In the Manual Order Upload you can copy your data from these sale or refund invoices and fill it in the template.
We have prefilled a Sales template and a Refund template with all the mandatory fields for you, they can be downloaded here: Sale & Refund template. Replace the example data with your data and check the comments for help.
Following fields are mandatory:
Channel ID must be filled in, in the short form, e.g. AMZ; you can find the entire list of channel ID's here.
VAT reporting date
Buyer billing name must be filled in.
Other related field: hellotax product ID or SKU, fill in one or the other
Item VAT rate
The only difference between Refund and Sales is the following: Item gross unit price must be a negative number (-) in case of a Refund and Item gross unit price must be a positive number (+) in case of a Sale
Field Type Invoice number
hellotax Product ID SKU Item VAT rate VAT country Channel ID Buyer billing name Format and value that should be filled in sale, refund, 1231-1235, can be a number series with "-" in-between, that appears on the actual invoice yyyy-mm-dd,
the country where the goods are shipped to,
ISO code e.g DE, FR
the country from where the goods are shipped, ISO code e.g DE, FR currency you use to report your transactions, ISO 3 letters code e.g. EUR, USD Product ID that you can find in the hellotax "Products menu" stock keeping unit, a machine readable code that you assign to your products Item vat rate is a number between 1-100, it is the vat rate of the country where it is taxed the country where the goods are taxed 3 letter form, e.g. AMZ the name of buyer as it appear on the actual invoice
In case you do not fill out those fields, you won't be able to upload the file and you will receive an error.
In case you do not have all the mandatory data you can upload data as RAW data, this means that our software will calculate automatically the missing fields, read more here.
Important information if you fill in optional fields:
Original currency - optional to fill in
If the original currency is provided by you, the report currency must be a different one.
Want to upload RAW data, read how here.
Want to upload movement of goods invoices, read how here.
Want to upload expenses invoices, read how here.