Skip to main content

📒 Transactional reports

💡 A transactional report is a summary created by us, for which you need source data from orders on Kaufland.de. In it, you can find a summary of all your orders made in a given month. The report is mainly intended for accountants to calculate the costs of selling goods and to provide a better overview of the breakdown of an order into individual items (revenue, shipping costs, commissions, promotions, etc.).

  1. The first sheet provides a detailed breakdown of the costs of selling goods, including promotional tools.

  2. The source sheet then serves as a tool for accountants to gain a better overview of the breakdown of an order into individual items (revenue, commissions, shipping costs, etc.).

Legend

  • Freigabe - order value

  • Erstattung Bestell - returned orders

  • Storno Freigabe - cancellation

  • Bezahlung Zusatzleistungen - account management fee

  • Nettotransaktionsgebuehren - fee associated with returned orders

  • Auszahlung - revenue payout

Procedure for generating the report👇

  1. Log in to your account on Kaufland.de.

  2. Side pop-up panel on the left → “Reports”

  3. First tab → “Bookings” → check the first box “Your bookings as CSV file (new business model as of 2.7.2018)”.

  4. Select the payout period.

    ☝ From the date of the second-to-last payout to the date of the last payout (inclusive).

    ❓ If you don't know the dates of the individual payouts, download the report for a long period, and the individual Auszahlung rows correspond to the payouts.

  5. Switch to “Processed reports” → wait, refresh, and generate the report.

  6. Download the report to the PC.

  7. Create a copy of the Template >>

  8. Change the date to the current month - in the “Kaufland” sheet in the format “04/2022”. to the current month - in the “Kaufland” sheet in the format “04/2022”.

  9. Copy the data into the prepared template three times.

    ❗In the downloaded data matrix, find "Auszahlung" in column B → copy the data up to the next payout (Auszahlung) – do not include orders after the payout/before the next payout.

    • Columns A to B

    • Columns D to F

    • Columns J to the end

Data matrix

Template

The empty columns contain formulas and generate data automatically, so it's essential not to enter anything into them.

Final report

The highlighted columns are automatically generated.

What to watch out for:

  • Ensure formulas cover the entire template area.

  • Check if the report contains new items.

  • Make sure all items are listed in the summary sheet “KAUFLAND.”

  • Ensure the value of “Paid Amounts” matches the actual paid amount “Auszahlung.”

Related Articles
Did this answer your question?