Overview
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 (QuickBooks/Xero), converting the PDF into a structured CSV is the fastest path.
Quick summary:
- PDF statements are usually the most stable source for consistent imports.
- Structured conversion reduces manual cleanup in recurring monthly workflows.
- CSV, Excel, QuickBooks, and Xero can be handled in one process.
3 methods at a glance
KontoCSV
PDF-first conversion with consistent output fields.
Typically ~30 sec per page
Bank export
Native and free, but often limited by period or format.
Typically ~10 min
Manual entry
Works for tiny datasets, scales poorly for multi-page statements.
Typically ~5 min per page
Method 1: KontoCSV (Recommended)
- Automatic parsing of bank-specific PDF structures
- Stable columns for recurring monthly and quarterly runs
- Target profiles for CSV, Excel, QuickBooks, and Xero
- Lower manual correction effort after import
- Use original bank PDFs whenever possible
- Choose target profile explicitly for mixed currency workflows
- Run a short plausibility check before final booking
Method 2: Native banking export
Typical flow:
- Sign in to online banking and open the account
- Select period and open the export section
- Export and validate columns in your target system
Native exports are useful but not always consistent across periods and statement variants. For PDF-heavy bookkeeping, a standardized PDF-to-CSV workflow is often more reliable.
Method 3: Manual entry
Manual copy/paste can work for one-offs but becomes fragile quickly. Error risk rises with each additional page, especially for date, sign, amount, and balance consistency.
Method comparison
KontoCSV
Fast, consistent, and scalable for recurring imports.
Bank export
Free, but often constrained by period and layout changes.
Manual
Best reserved for exceptions, not recurring bookkeeping.
Step-by-step with KontoCSV
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 QuickBooks or Xero export profiles so delimiter/columns match the import template.
Best practices
- Use consistent file naming per client/account and month.
- Validate date, amount, sign, and balance before final posting.
- Keep one output profile per recurring workflow to reduce remapping.
- 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 QuickBooks?
Yes. Use the QuickBooks export profile so delimiter and columns match the expected import format.
Conclusion
For PDF-based statement workflows, a standardized conversion process is usually the most reliable option for clean, repeatable imports.
It improves consistency across recurring monthly runs and reduces manual follow-up in accounting tools.
Try KontoCSVGerman original (more detail)
For the full German version with deeper context and local wording, open the original article: