Amazon VAT Calculation report field definitions

The following fields are available in the VAT Calculation report.

Field name	Definition	Example
Marketplace ID	The marketplace on which the order was placed	DE/FR/UK/IT/ES/NL/SE
Merchant ID	An unique alphanumeric identifier for your account	ATVPDKIKX0DER
Order date	Date the order was placed.	01/01/2020
Transaction type	Values can be shipment, refund or return depending on the type of transaction	SHIPMENT/RETURN/REFUND
Is Invoice corrected	Flag indicating whether transaction is invoice correction transaction or not	TRUE/ FALSE
Order ID	Amazon's unique identifying number for the order. Used for shipping confirmation and post- order processing.	736-3563777-5518068
Shipment date	Date of dispatch of this shipment	01/01/2020
Shipment ID	Shipping Id for this shipment	409302382
Transaction ID	An unique transaction id for shipments	409302382 (if it is a shipment); amzn1:crow:A0f6kWaFSV6ymAlMHe4VJ w (if return or refund. In case of return/refund, this will be a unique transaction Id in alphanumeric format)
ASIN	ASIN of the product	AY39345YE8K
SKU	Stock-keeping unit. Seller-defined unique identifier for a product	SKU123
Quantity	Quantity purchased	1
Tax calculation date	The date that is used to calculate the VAT	01/01/2020
Tax rate	The VAT rate percentage applied to the transaction	0.2
Product Tax Code	A Product Tax Code (PTC) is an Amazon-defined code that has the correct set of VAT rates across the EU for a specific product category	A_GEN_STANDARD
Currency	The currency used for the transaction	EUR
Tax type	Type of tax applied on the transaction	VAT
Tax calculation reason code	The reason for tax calculation e.g. Taxable or Tax exempt	Taxable
Tax address role	The address used for Tax calculation e.g. Ship To address	Ship To/ Ship From
Jurisdiction level	Level corresponding to tax jurisdiction authority	Country
Jurisdiction name	Name of the tax jurisdiction authority	United Kingdom
OUR_PRICE tax inclusive selling price	VAT inclusive sale price for the item. All amounts are aggregates of the quantity, not unit prices.	120
OUR_PRICE tax amount	VAT amount of Item price	20
OUR_PRICE tax exclusive selling price	VAT exclusive sale price for the item. All amounts are aggregates of the quantity, not unit prices.	100
OUR_PRICE Tax inclusive promo amount	VAT Inclusive sale price for the item discounted of promotion.	120
OUR_PRICE tax amount promo	VAT amount of promotion	20
OUR_PRICE tax exclusive promo amount	VAT exclusive sale price for the item discounted of promotion	100
SHIPPING tax inclusive selling price	VAT inclusive shipping price for the item	12
SHIPPING tax amount	VAT amount on shipping price	2
SHIPPING tax exclusive selling price	VAT exclusive shipping price	10
SHIPPING tax inclusive promo amount	VAT inclusive shipping price discounted of promotion	12
SHIPPING tax amount promo	VAT amount on shipping promotion.	2
SHIPPING tax exclusive promo amount	VAT exclusive shipping price discounted of promotion	10
GIFTWRAP tax inclusive selling price	VAT inclusive giftwrap price for the item	12
GIFTWRAP tax amount	VAT amount on giftwrap price	2
GIFTWRAP tax exclusive selling price	VAT exclusive giftwrap price	10
GIFTWRAP tax inclusive promo amount	VAT inclusive giftwrap price discounted of promotion	12
GIFTWRAP tax amount promo	VAT amount on giftwrap promotion.	2
GIFTWRAP tax exclusive promo amount	VAT exclusive giftwrap price discounted of promotion	10
Seller tax registration	VAT registration number of the seller used in VAT calculation	DE12345678
Seller tax registration Jurisdiction	The country associated with the seller's VAT registration number	DE
Buyer tax registration	VAT registration number of the buyer used in VAT calculation	GB12345678
Buyer tax registration Jurisdiction	The country associated with the buyer's VAT registration number	GB
Buyer tax registration type	The tax type of the customer (if the customer has a VAT registration number).	VAT/BusinessReg/CitizenId. In ES and IT, Businesses could have Business Registration number (BusinessReg) or individuals could have tax Ids (CitizenId).
Buyer E Invoice account Id	The e-invoice account Id of the Customer. This will be populated if the customer has provided an e- invoice account Id (which can be used to send the invoice to Sistema di Interscambio (SdI), if required). This column is specifically added for Italy e-invoicing law that came into effect in 2019, so that sellers can upload invoices to SdI.	XXXXXXX
Invoice level currency code	The currency used for the invoice	EUR
Invoice level exchange rate	The exchange rate used to convert the invoice amount to invoice currency.	1.1
Invoice level exchange rate date	The date of the exchange rate used to convert the invoice amount to invoice currency.	01/01/2020
Converted tax amount	Total VAT amount in invoice currency	22
VAT invoice number	The sequential VAT invoice number or credit note number or tax document	INV-GB-1234567890-2020-1
Invoice Url	URL link for the seller to download or view the invoice/credit note/ tax document	https://amazon.com/gp/invoice/download.html?v=urn%3aalx%3aver%3ace5bcdba-192d-41f9-a2dd-00f526bfd1eb&t=EU_Retail_Forward
Export outside EU	Indicates whether or not an item was shipped from a EU27 member country to a country outside the EU27 member countries.	TRUE/ FALSE
Ship from city	City of "Ship from" address	Munich
Ship from state	State of "Ship from" address	Bavaria
Ship from country	Country of "Ship from" address	Germany
Ship from postal code	Postal Code of "Ship from" address	80801
Ship from tax location code	Code that describes the location of the "Ship from" address used to determine the tax jurisdictions	803800000
Ship to city	City of "Ship to" address.	London
Ship to state	State of "Ship to" address.
Ship to country	Country of "Ship to" address	United Kingdom
Ship to postal code	Postal Code of "ship to" address	SW1A 0AA
Ship to location code	Code that describes the location of the "Ship to" address used to determine the tax jurisdictions	808260000
Return Fc country	Country of "Return FC"	United Kingdom
Is Amazon invoiced	Is Amazon supposed to create an Invoice for this transaction? This will be true if seller uses VCS and chooses the option to allow Amazon to create the Invoices, or if Amazon World Imports buys from the seller. Seller should not create Invoices for these transactions. Amazon will generate an invoice and make it available to the seller.	TRUE/ FALSE
Original VAT Invoice Number	Original VAT invoice number that has been amended. This is only applicable for Invoice amendment transaction.	INV-GB-1234567890-2020-1
Invoice correction details	Invoice amendment details describing changes on the invoice. This is only applicable for invoice amendment transaction.	New Invoice issued after amending billing address and billing name on original VAT invoice
SDI invoice delivery status	Shows the e-Invoice SDI validation and delivery status. It has 5 status values: 1 Rejected: Status when e-Invoice failed validation by SDI 2 Accepted: Status when e-invoice validated successfully 3 Pending: Status when validation awaiting 4 (Blank): Status for other PDF invoices 5 Accepted but failed to deliver: Status when received receipt of delivery impossibility This is only applicable for IT e-invoices where e-invoice issued for transactions between resident businesses in Italy with valid intra-community VAT registration number.	Rejected
SDI Invoice Error Code	Error code returned by SDI for rejecting e-Invoice. This is only applicable for IT e-invoices.	Error (00301)
SDI Invoice Error Description	Error description associated with error code returned by the SDI. This is only applicable for IT e-invoices.	Error (00301): 1.2.1.1.2 <IdCodice> non valido : 345678TEST. Suggerimento: Verificare che il campo IdFiscaleIVA/IdCodice del "CedentePrestatore" sia valido.
SDI invoice status last updated date	Date of SDI invoice Delivery Status. This is only applicable for IT e-invoices.	29-Oct-2020 UTC
E Invoice URL	Url to the e-Invoice that is transmitted to SDI for validation and delivery. This is only applicable for IT e-invoices.	https://amazon.com/gp/invoice/download.html?v=urn%3aalx%3aver%3ace5bcdba-192d-41f9-a2dd-00f526bfd1eb&t=EU_Retail_Forward

Reach Hundreds of Millions of Customers

Start Selling on Amazon