ZKB Bank Statement to Excel & CSV

Profile review and source checks

Reviewed 2026-10-19. Zurcher Kantonalbank, Switzerland: layout notes reviewed; not a conversion test of every statement or a bank endorsement. Confirm the period and headers.

Synthetic CHF example for Zurcher Kantonalbank: opening 1,000.00 + receipt 100.00 - payment 100.00 = closing 1,000.00. Omitting both rows still balances.

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.

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?

Check these Zurcher Kantonalbank layout details against your PDF:

• ZKB checkpoint 1: German banking labels need mapping to debit and credit columns
• ZKB checkpoint 2: CHF apostrophe thousands separators must parse as numeric values
• ZKB checkpoint 3: Interest and fee rows should remain separate for accounting review

Checkpoint for Zurcher Kantonalbank

Before importing CHF values, review this source feature: German banking labels need mapping to debit and credit columns. Keep the DD.MM.YYYY date column and original narration together while comparing the 2-18 pages with the PDF.

Reviewing Zurcher Kantonalbank output

Compare DD.MM.YYYY dates, CHF signs and page boundaries with the Zurcher Kantonalbank PDF. Check the first and final transactions; reconciliation alone cannot prove completeness.

Zurcher Kantonalbank export and review resources

• Import ZKB statement into QuickBooks
• Switzerland bank statement converter hub

For data handling, read our security policy and privacy policy. For download restrictions, see source review and reconciliation limits.