What you will get from this guide
Credit card providers often don"t offer a usable CSV export. What you usually get is a PDF statement with multiple currencies, fees, and sometimes chargebacks or refunds.
If you need a clean spreadsheet or an accounting import (DATEV/Lexware), converting the PDF into a structured CSV is the fastest path.
Step-by-step
1. Download your statement PDF
Get the monthly statement from your bank portal or email. For corporate cards, export the full billing period so refunds and fees are included.
2. Upload to a statement converter (OCR for scans)
Upload the PDF to KontoCSV. If the statement is scanned, AI/OCR extracts the text and table structure.
3. Choose an export profile and download
Download CSV/Excel. For accounting, pick DATEV or Lexware export profiles so delimiter/columns match the import template.
Best practices
- Reconcile totals: compare statement total vs. CSV sum (including fees and refunds).
- Foreign currency: keep both original currency and EUR amount if your statement provides it.
- Chargebacks/refunds: ensure they keep the correct sign so your bookkeeping stays consistent.
FAQ
Do you support Visa, Mastercard, and American Express PDFs?
Yes. KontoCSV is designed for common German bank layouts and card statements. If your PDF format is unusual, OCR still extracts the table and you can validate the output in the preview.
How are foreign currency transactions handled?
Most statements include the EUR booking amount and sometimes the original currency. Exports work best when both values are present; otherwise the EUR amount is still usable for accounting.
Can I import the CSV into DATEV?
Yes. Use the DATEV export profile so delimiter and columns match the expected import format.
German original (more detail)
If you want the full German version with screenshots and extra edge cases, open the original guide here: