Overview
Need bunq or Holvi transactions in Excel, Google Sheets, or your accounting tool? The fastest route is usually a native CSV export for recent periods.
For older periods and archives, statements are often only available as PDFs. KontoCSV converts those files into clean CSV/Excel outputs for stable imports.
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. Export CSV from online banking (if available)
Look for an "Export", "Download", or "Transactions" section. Native CSV exports are often limited by date range.
2. Convert statement PDFs for archives
Upload PDFs to KontoCSV. Parsing removes headers and footers, preserves amount signs, and merges multi-page statements.
3. Select target profile and import
Choose QuickBooks, Lexoffice, or another target format to reduce manual column mapping in your tool.
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.
- Keep both booking date and value date when your workflow requires them.
- Avoid manual copy/paste from PDF into spreadsheets for recurring processes.
- If balances are included, validate opening and closing values after conversion.
FAQ
Can I export CSV directly from bunq and Holvi?
Often yes for recent activity. For archives, PDF conversion is commonly required.
Why use KontoCSV instead of generic converters?
Generic tools often break columns in statement PDFs. KontoCSV is optimized for statement layout stability and accounting exports.
Which format should I use for QuickBooks imports?
Use the dedicated QuickBooks profile in KontoCSV so delimiter and column structure match common QuickBooks workflows.
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: