Card terminals deduct fees directly and pay out a collective amount. For the cash report and accounting, gross sales, fees and payment dates must be separated. How to export SumUp and Zettle data correctly.
- Don't hide fees in sales
- Payout date ≠ sales day
- Leave tips separate
SumUp CSV export
- SumUp Dashboard → Reports → Transactions.
- select period, Export click.
- Download CSV, check columns (amount, fee, payout).
- Adjust time/time zone for end-of-day closing.
Zettle CSV export
- Zettle (Web or App) → Reports → Sales.
- set a period, Export select.
- Download CSV or save monthly PDF.
- Columns: Amount, Fee, VAT, Payout, Tip.
PDF statements with KontoCSV
If you only have PDF statements, KontoCSV will convert them into a structured CSV/DATEV file:
1. Upload PDF
Select SumUp or Zettle PDF.
2. Select export profile
Use DATEV, Lexware or Excel profile.
3. Check fees
Fees, sales and tips separately.
Fees & cash report
SKR03: 4400 proceeds, 4970 fees, 1890 tips
SKR04: 8400 proceeds, 6825 fees, 1891 tips
Cash report: Separate daily sales vs. payout date
Gross, VAT, fee, tip, payout
Keep payout reference for bank reconciliation
Check time zone (UTC vs. local time)
Import into DATEV/Excel
- Semicolon as separator, UTF-8 encoding.
- Date format DD.MM.YYYY for booking date/payout.
- Book the tip column separately, do not offset it against sales.
- For collective payouts, keep the reference number for bank reconciliation.
Common problems
FAQ
Conclusion
With SumUp or Zettle export – or PDF conversion via KontoCSV – you get a CSV that separates fees, sales, tip and payout amount. This is how the cash report, the EÜR and the DATEV import work without manual rework.