Commonwealth Bank Statement to Excel Converter

ClearlyLedger converts Commonwealth Bank (Australia) PDF statements into clean Excel and CSV files. This guide covers the common CommBank pdf layout, DD MMM YYYY dates and AUD amounts. Exports are released only when verification checks pass. Most CommBank statements (4–15 pages) finish in under 60 seconds with no signup required for your first file.

Last updated 2026-08-07

Read the CommBank source layout correctly

Printed structure: PDF with Date, Transaction, Debit, Credit, Balance — separate Opening and Closing balance rows

Date notation: DD MMM YYYY. Money notation: A$ AUD. Observed statement size: 4–15 pages.

Amounts use a period decimal; Osko/PayID and BSB-linked narrations are kept intact.

Fields and row patterns found in Commonwealth Bank PDFs

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:

  • CommBank checkpoint 1: Pending and processed sections separated within the same statement
  • CommBank checkpoint 2: Foreign currency transactions include AUD equivalent on second line
  • CommBank checkpoint 3: BPAY and Osko transactions identified by prefix in description

Review the CommBank extraction

A typical Commonwealth Bank file runs 4–15 pages. Confirm its DD MMM YYYY dates, AUD signs, first and final transactions, and page boundaries. Balance review is especially important on this layout. Pending and processed sections separated within the same statement. The PDF remains the source; the spreadsheet is the reviewable working copy.

  1. Upload the Commonwealth Bank PDF.
  2. Inspect the documented CommBank row patterns.
  3. Reconcile the AUD transaction math.
  4. Download verified CommBank Excel or CSV data.

Use the CommBank output in Australia

Excel suits source-document review and coding. CSV suits mapped imports into Xero, MYOB, QuickBooks or Reckon. Those routes preserve the DD MMM YYYY interpretation and AUD values established from the Commonwealth Bank source.

CommBank privacy and retention

The CommBank PDF is processed in memory and deleted after conversion. The CommBank transaction data is not used to train AI models. TLS protects the upload in transit, while the workflow is designed around the Australian Privacy Act 1988 for Australia account holders.

CommBank conversion FAQ

Which CommBank statement layouts can ClearlyLedger convert?

Commonwealth Bank statements typically arrive as PDF with Date, Transaction, Debit, Credit, Balance — separate Opening and Closing balance rows. ClearlyLedger's CommBank profile reads that layout, plus scanned and password-protected exports, and reconstructs Date, Description, Debit, Credit and Balance columns.

How does ClearlyLedger handle CommBank-specific quirks?

This guide highlights common CommBank statement characteristics — for example: Pending and processed sections separated within the same statement. The conversion is released only after its verification checks pass.

Can I import a converted CommBank statement into Xero?

Yes. Export to CSV and import into Xero, MYOB, QuickBooks or any tool that accepts a transaction file. The DD MMM YYYY dates and AUD 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