What you will get from this guide
Marketplace payouts look simple in your bank account, but accounting needs the full breakdown: gross sales, fees, refunds, taxes/VAT, and the net payout.
This guide covers the practical workflow to export the right reports, keep the key identifiers, and produce a CSV that imports cleanly into common accounting tools.
Step-by-step
1. Export the source reports (not just the bank statement)
Use the marketplace settlement/payout exports so you have gross, fees, refunds and tax lines. The bank statement typically only shows the net payout.
2. Normalize a consistent column set
Keep payout/settlement ID, date, gross, fees, taxes, refunds, and net payout as separate fields. This makes reconciliation and VAT reporting easier.
3. Convert PDFs (if needed) and pick an accounting export profile
If you only have PDFs, upload them to KontoCSV and export as CSV/Excel. Use DATEV/Lexoffice profiles to avoid manual mapping.
Best practices
- Keep payout IDs in the reference field so you can match lines to your bank statement payout.
- Separate fees and refunds instead of posting everything as one net amount.
- For multi-currency, retain original currency and settlement currency where available.
FAQ
Is the bank statement enough for accounting?
Usually not. The bank statement only shows the net payout. Settlement reports provide the required breakdown for fees, refunds, and VAT.
How do I import this into DATEV or Lexoffice?
Use an export profile that matches your tool (DATEV/Lexoffice). Then do a small test import first to confirm date and amount signs are correct.
German original (more detail)
If you want the full German version with screenshots and extra edge cases, open the original guide here: