Zurcher Kantonalbank Statement to Excel Converter

ClearlyLedger converts Zurcher Kantonalbank (Switzerland) PDF statements into clean Excel and CSV files. This guide covers the common ZKB pdf layout, DD.MM.YYYY dates and CHF amounts. Exports are released only when verification checks pass. Most ZKB statements (2-18 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-09-03

What does a ZKB statement PDF look like?

Printed structure: PDF with Buchungsdatum, Valuta, Text, Belastung, Gutschrift, Saldo

Date notation: DD.MM.YYYY. Money notation: CHF CHF. Observed statement size: 2-18 pages.

Amounts may use an apostrophe thousands separator (1'234.56); this is normalised to a plain decimal.

In German, this document is a Kontoauszug. Die Zürcher Kantonalbank gehört vollständig dem Kanton Zürich mit staatlicher Garantie und ist die grösste Kantonalbank der Schweiz; der Kontoauszug verwendet Buchungsdatum, Valuta, Text, Belastung, Gutschrift und Saldo.

What fields does Zurcher Kantonalbank print on each transaction row?

The profile uses the bank-specific observations below as review checkpoints. They describe the source document rather than making a generic promise about every PDF:

  • ZKB checkpoint 1: Wholly owned by the Canton of Zurich with a state guarantee behind it — a 'cantonal bank' (Kantonalbank), a distinctly Swiss category of publicly owned regional bank separate from UBS, Credit Suisse or private banks
  • ZKB checkpoint 2: German banking labels need mapping to debit and credit columns
  • ZKB checkpoint 3: CHF apostrophe thousands separators must parse as numeric values
  • ZKB checkpoint 4: Interest and fee rows should remain separate for accounting review

How do I check a ZKB conversion before using it?

A typical Zurcher Kantonalbank file runs 2-18 pages. Confirm its DD.MM.YYYY dates, CHF signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Wholly owned by the Canton of Zurich with a state guarantee behind it — a 'cantonal bank' (Kantonalbank), a distinctly Swiss category of publicly owned regional bank separate from UBS, Credit Suisse or private banks. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the Zurcher Kantonalbank PDF.
  2. Inspect the documented ZKB row patterns.
  3. Reconcile the CHF transaction math.
  4. Download verified ZKB Excel or CSV data.

Which accounting tools accept ZKB Excel or CSV files?

Excel suits source-document review and coding. CSV suits mapped imports into Bexio, Abacus, Banana or Sage. Those routes preserve the DD.MM.YYYY interpretation and CHF values established from the Zurcher Kantonalbank source.

Is my ZKB statement data kept private?

The ZKB PDF is processed in memory and deleted after conversion. The ZKB transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around the Swiss FADP for Switzerland account holders.

ZKB conversion FAQ

Which ZKB statement layouts can ClearlyLedger convert?

Zurcher Kantonalbank statements typically arrive as PDF with Buchungsdatum, Valuta, Text, Belastung, Gutschrift, Saldo. ClearlyLedger's ZKB profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle ZKB-specific quirks?

This guide highlights common ZKB statement characteristics — for example: Wholly owned by the Canton of Zurich with a state guarantee behind it — a 'cantonal bank' (Kantonalbank), a distinctly Swiss category of publicly owned regional bank separate from UBS, Credit Suisse or private banks. The conversion is released only after its verification checks pass.

Can I import a converted ZKB statement into Bexio?

Yes. Export to CSV and import into Bexio, Abacus, Banana or any tool that accepts a transaction file. The DD.MM.YYYY dates and CHF amounts are normalised so the import maps cleanly.

Related ClearlyLedger resources

Use these canonical pages to compare formats, verify data handling, and move from PDF extraction into accounting review.

Loading interactive converter… Try ClearlyLedger free