The Amazon VAT Transactions report provides detailed information for sales, returns, refunds, cross border inbound, and cross border fulfillment center transfers generated through Amazon’s European websites (amazon.co.uk, amazon.de, amazon.fr, amazon.it, amazon.es), Webstore by Amazon (WBA), and Amazon European Fulfillment Network (FBA and multi-channel fulfillment). These details can be helpful for the seller in fulfilling his VAT reporting obligations in Europe.
You are responsible for the accuracy of your data used for any reporting or tax purposes.
Detailed column information can be found in the FAQ below: What is each column in the report and what does it contain?
Specific activity types included in the report are:
This report does not contain information related to the fees charged by Amazon to the seller or ending inventory status.
The Amazon VAT Transactions report will not have any fee details that are charged by Amazon to a seller. Information related to the fees charged to your Selling on Amazon account is located in Seller Central in the Monthly Detail and Monthly Summary reports. To access these reports, go to Reports, click Payments, and select Date Range Reports.
Information related to reimbursements from Amazon, such as lost or damaged inventory, is not contained within the Amazon VAT Transactions report. You can locate reimbursements for your account in Seller Central in the Monthly Detail and Monthly Summary reports. To access these reports go to Reports, click Payments, and select Date Range Reports.
There are several reports located in the Inventory section. To access inventory specific reports in Seller Central, go to Reports and select Fulfilment by Amazon.
You can use the Transaction Event ID to search detailed information in Seller Central. The most common information searched for an item is Order number (which also contains refund information). To search by Order number in Seller Central, go to Orders, click Manage Orders, select Order ID in the drop down and enter the Order number.
If you have an external tax advisor, you should follow their instructions on how to provide this data to them. For the privacy and security of your account, Amazon cannot share this information directly with your tax advisor. You are responsible for the accuracy of your data used for any reporting or tax purposes.
Amazon cannot help you understand your tax obligations. We provide high-level information on Europe Tax and Regulatory Considerations when selling in Europe, but if you need further assistance on analyzing your business VAT activities, seek advice from a tax advisor. We provide a list of External Tax Advisors for Europe that form part of Amazon’s Solution Provider network.
This is considered a transfer of own goods for you, and you should report this in your returns for both the EU Member States. Removal of orders is currently not included in AVTR because we do not have all the details to update the VAT reports. You are required to work with your external tax provider to include such transactions for calculations when you file your VAT reports.
The Amazon VAT Transactions report will contain data from August 2016. You can access this data any time from Seller Central. Data before August 2016 is not currently available.
No, currently reports are available with all columns present.
You can obtain certain information from the following reports for all activity. For FBA only reports, see the second section.
For MFN and AFN activity:
For AFN (FBA) Activity Only:
The Cross-Border Inventory Movement report contains information related to Fulfillment by Amazon (FBA) international cross-border shipments only. It does not contain any information related to Merchant Fulfillment Network (MFN) or domestic transactions. Amazon VAT Transactions report is a more comprehensive report detailing a greater amount of information.
For the purpose of the Amazon VAT Transactions report:
If an item was returned after a refund was complete, you can see the return information in a different monthly report.
Returns are represented with no monetary information in the report because they deal with movement of goods only. If there are amounts refunded for a ‘return’ they are reported in associated ‘refund’ transaction types.
Return delivery fee: For FBA transactions, a buyer can choose to have the amount of return delivery charges deducted from their refund. The seller will be charged the full refund and the return delivery paid by the buyer is retained by Amazon. The amount reflected in the report is the gross amount of the refund as it impacted your seller balance.
For example, buyer purchases a 100€ FBA item. The buyer does not like the item and decides to return it. The cost for the return delivery is 8€. The EU Transaction Activity report will show 100€ The 8€ is a charge retained by Amazon from the buyer and is not passed to the seller.
Disbursements to buyer for goodwill or return delivery: For MFN transactions, a seller could refund a buyer above the original price paid. Any amount refunded to the seller above the original sales price will not be included in the report.
For example, buyer purchases a 100€ MFN item. The buyer received the wrong item and the seller would like it returned. The cost for the return delivery is 10€ and the seller gives this amount in addition to the 100€ to the buyer. The EU Transaction Activity report will show 100€ and the Order Detail page will show a refund of 110€ refund.
For certain transactions, MFN sellers may choose to add Restocking fees to refunds. This amount is deducted from the buyer refund and is kept by the seller. The net amount of the refund and restocking fee is available within the report.
Amazon may not have information regarding certain fields within the report. Amazon populates the report with the best information that we have in relation to the transaction. You should review blank fields to determine if there is any information missing. These fields are present to provide sellers a location to track data for their records should they have the information.
Address fields: Amazon may not have the accurate address information since it is not aware of the movement details for any transaction that departs from the seller or buyer. Always provide departure information.
VAT and VAT exclusive fields: The service made available by Amazon does not currently calculate VAT between the seller and buyer, for sellers who have not activated VAT Calculation services.
VAT amount fields: The VAT amount charged or refunded to the buyer by the seller.
VAT exclusive fields: The value of the item price charged or refunded by the buyer, excluding VAT.
Statistical fields: The service made available by Amazon does not offer the functionality to capture statistical information associated with a transaction.
Date fields: Some date fields may be blank if Amazon does not have information on the arrival or departure date. The service made available by Amazon does not currently calculate VAT between seller and buyer, for sellers who have not activated VAT Calculation Services.
The fields for the supplier name and supplier VAT number are only required for the acquisitions of items from another 3P seller (or Amazon Retail), and so will only be populated for Sellers participating in the FBA virtual tracking program (for COMMINGLING_BUY transactions).
To allow for accurate calculation and totaling of financial values in the report, you will see negative values for refunds. You will also see negative values for promotion amounts related to sales activity.
To standardize the report across different regions and to allow sellers to import the activity into different types of software programs, all monetary values are represented with decimal points. Currency symbols are not contained within the report, but the currency code is detailed for each transaction if Amazon has the information.
For example: 1,299.99€ would be represented as 1299.99 in the report.
The Transaction Event ID can be searched in Seller Central and is a high level identifier for all activity associated with a transaction. Activity Transaction ID is an identifier that relates to the lower level activity to detail multiple activities for an event. For example, Transaction Event ID can be an Order Number and the Activity Transaction ID can be a Refund ID or Shipment ID.
SELLER_DEPART_VAT_NUMBER_COUNTRY is the Country associated with the SELLER_DEPART_COUNTRY_VAT_NUMBER. SELLER_DEPART_COUNTRY_VAT_NUMBER is the VAT number associated with the movement. For example, if SELLER_DEPART_COUNTRY_VAT_NUMBER is DE123456789 the SELLER_DEPART_VAT_NUMBER_COUNTRY would be DE.
|VAT Number Fields||VAT Number Country Fields|
DEPARTURE_COUNTRY and ARRIVAL_COUNTRY are associated with the country of departure and arrival relating to the reported transaction.
SALE_DEPART_COUNTRY and SALE_ARRIVAL_COUNTRY are associated with original sale activity associated with this transaction in the report. It is present for Sale, Return, and Refund transactions. For Sale, Virtual Tracking Sell and Virtual Tracking Buy transactions, SALE_DEPART_COUNTRY and SALE_ARRIVAL_COUNTRY will be the same as DEPARTURE_COUNTRY and ARRIVAL_COUNTRY. However, for return, and refund transactions, SALE_DEPART_COUNTRY and SALE_ARRIVAL_COUNTRY will be the reverse of DEPARTURE_COUNTRY and ARRIVAL_COUNTRY.
You may see dates from prior months in your report if the activity had associated activity in the past. For example, if a movement started on 30 September but was delivered on 2 October, you will see both dates in your report.
A TRANSACTION_COMPLETE_DATE tells you when a transaction is contained in your report.
According to the reporting determination logic of the Amazon VAT Transactions report, we cannot report some transactions in the specific month (for example, order not yet shipped, AFN return not yet received at FC).
If you believe your report contains incorrect information, reach out to Selling Partner Support. To ensure proper routing of your concern, reference the name of the report: Amazon VAT Transactions report.
Refer to the table to check if the date that determines the reporting month of the Amazon VAT Transactions report differs from the one used in the other reports in Seller Central.
This can lead to a reporting time difference between the Amazon VAT Transactions report and other reports.
|Transaction type||Date determining reporting month of Amazon VAT Transactions report||Date determining reporting month of other reports|
|MFN SALES||Shipment date||Order date/Last updated date (FBA All Orders)|
|AFN SALES||Shipment date||reporting-date (Amazon Fulfilled Shipment report)|
|MCF SALES||Shipment date||reporting-date (Amazon Fulfilled Shipments report)|
|Refund||Refund completion date||Event posting date in GMT time zone (Payment report)|
|AFN Returns||Received date at Fulfillment Center||RETURNED_DATE (FBA Returns report)|
In the Amazon VAT Transactions report the shipments with a complete check in process in a fulfillment center, within the selected month are counted for the given month.
We do not include the shipments with "receiving" status (the shipments which are still in the process of check in), because the recorded quantities for the shipments are not finalized by the "receiving" state. This can be an important reason for the difference.
For more information, refer to the definitions table.
This might be due to a sale or a refund issued through Amazon, but not all the information which is required to calculate VAT on the transaction is available in the VAT calculation services. In this case, you might need to manually add the data. Only the VAT-inclusive price of the item will be populated (the gross item price). If you are using the VAT services on Amazon, you have to add the missing information in accordance with the instructions provided in the Additional Data template.
For example, if you have enabled Pan-EU FBA, but you have not updated your VAT numbers for your location, no tax calculation will be performed for the locations:
In this case, if you use Amazon VAT services, you have to update the data for your VAT number manually, by using the Additional Data template before the Amazon VAT services process your VAT filings.
If you participate in the FBA virtual tracking program, items in your inventory may be swapped with identical items owned by Amazon Retail or other FBA sellers who have also decided to participate in the program.
When an order is fulfilled with a virtually tracked item, two (additional) VAT transactions must be reported:
When you prepare your VAT report, treat these transactions the same as any of your other sale (for COMMINGLING_SELL) and purchase (for COMMINGLING_BUY) transactions. However, they are labeled separately as COMMINGLING_SELL and COMMINGLING_BUY in the TRANSACTION_TYPE field so you can track the movement of your goods in and out of the virtual tracking inventory pool.
You must report the transaction to your customer. These transactions are reported in the Amazon VAT Transactions report as usual.
For more information, go to Commingled Inventory with the Manufacturer Barcode.