What advantages does reporting offer?
A comprehensive view across countries and marketplaces
You can see the order trends over time
The app notifies you of new and unconfirmed orders
A transactional report that your accountants will appreciate
⚠️ This EXPANDO APP feature applies to all marketplaces, including Amazon, Kaufland, Alza, Mall, cDiscount, and eMag.
Reporting for Amazon
Transactional Report
💡 The transactional report is generated from Amazon. It provides a summary of all your orders made within a given month, broken down by the country of sale. The data source for this report is Amazon’s Payments Report.
📌 The report records orders based on their shipment date. For example, it may include orders received on March 31st but shipped in the following month on April 1st.
⏰ Reports are generated regularly between the 20th and 28th of the following month (for the previous month) and are stored in a shared folder.
What is the purpose of the report?
The report is primarily intended for accountants to calculate the costs of goods sold and to provide better insight into the breakdown of orders into individual items (revenue, shipping costs, commissions, promotions, etc.).
Source Sheets (e.g., DE-source) then serve as a tool for accountants to gain a better overview of the breakdown of orders into individual items (revenue, commissions, shipping costs, etc.).
Values in column G are presented in the local currency of the respective country.
Legend
Orders - orders
Refund - refunds
Unavailable balance - holdback for the next month
Transfer amount initiated - the amount of money Amazon will transfer to you
Amazon fees/Commission - Amazon’s commission (the percentage varies by category)
Amazon fees/Shipping holdback - Amazon's commission for shipping
Product charges - product price
Other/Shipping - shipping costs for the product
How to Generate the Report?
Video Tutorial 👇
Steps to Generate the Report 👇
1. To log in to your Amazon account, select the “Payments” tab.
2. Click on the “All Statements” window and download all reports that include data from the specific month. Typically, the data is divided into 3-4 exports.
Example: For the April 2023 report → download all reports that contain data from April 1st to April 30th, 2023 (see the video tutorial above).
3. To download the report, click on the “Download” button. Open the downloaded file, copy the data, and upload it to the source sheets.
4. Repeat this process for all marketplaces.
To ensure the data is calculated correctly in the initial sheets (UK, DE, IT, etc.), use the FIND/REPLACE function in the source sheets to remove periods and commas—so that all data is in the correct format (e.g., 1.56 or 2005.67). Otherwise, the formulas will not work!
5. Each month, check the exchange rates for the UK, SEK, PL, and others.
Reporting for Alza, Mall, and other marketplaces
a) EXPANDO APP
Our app provides native reports in the STATISTICS section.
b) Google Data Studio
It displays live statistics, allowing you to view the number of sales and orders for each marketplace over a specific period of your choice. (A sample online report can be found here).