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 a SumUp or Zettle export – or PDF conversion via KontoCSV – you get structured transaction data. Fees, sales, tips and payout amounts are retained when the source clearly exposes them as separate values. Review the mapping before cash reporting, EÜR or DATEV import.