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 |