Commonwealth Bank Statement to Excel Converter

ClearlyLedger converts Commonwealth Bank of Australia PDF statements into clean Excel and CSV files for accounting, lending, and tax workflows. The parser handles CommBank date formats, NetBank narration, BPAY references, and running balances with verification before export.

Last updated 2026-06-03

What does a Commonwealth Bank PDF statement look like?

Commonwealth Bank statements usually present DD/MM/YYYY or DD MMM YYYY dates, transaction descriptions with merchant or transfer context, debit and credit amount columns, and a running balance in Australian dollars.

ClearlyLedger's Commonwealth Bank profile preserves NetBank references, BPAY biller details, PayID transfers, direct debits, and merchant descriptions while mapping everything to a consistent Excel or CSV structure.

How does ClearlyLedger verify balances for accountant-grade exports?

A Commonwealth Bank statement can look extracted even when one wrapped narration line or page break causes a row to disappear. ClearlyLedger verifies that opening balance + credits - debits equals the printed closing balance before you export.

That verification matters for BAS prep, loan underwriting packs, bookkeeping catch-up work, and audit support because it surfaces extraction mistakes before they reach Xero, MYOB, or your spreadsheet model.

Which export should I use for Xero or MYOB?

Use Excel when you want to review or annotate the statement first. Use CSV when you need a lightweight import file for reconciliation or accounting software.

ClearlyLedger keeps Australian date conventions, preserves reference fields where possible, and standardizes debit, credit, and balance columns so Commonwealth Bank data is easier to import into Xero and MYOB.

Commonwealth Bank source profile used by this guide

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

Source conventions: DD MMM YYYY dates, A$ AUD amounts, and 4–15 pages.

CommBank observations to sample during review

  • Started life in 1911 as an Australian government-owned bank and was fully privatised through a series of share sales completed by 1996; it's now Australia's largest bank by market value
  • Pending and processed sections separated within the same statement
  • Foreign currency transactions include AUD equivalent on second line
  • BPAY and Osko transactions identified by prefix in description

These CommBank details identify the rows most likely to need inspection after extraction. Review the first and final transaction, each PDF page boundary, and any row affected by the observations above before using the spreadsheet in an accounting import.

Related workflows

Continue from this guide into the matching converter, accounting import, security, or country hub pages so crawlers and readers can follow the full workflow.

Frequently asked questions

How do I convert a Commonwealth Bank statement to Excel?

Upload your Commonwealth Bank PDF to ClearlyLedger. The CommBank format is detected automatically, transactions are extracted with Australian date and amount handling, the balance is verified, and your Excel file is generated in under a minute for typical statements.

Can I convert Commonwealth Bank statements to CSV for Xero?

Yes. ClearlyLedger exports Commonwealth Bank transactions to CSV with structured date, description, debit, credit, and balance fields that are easier to map into Xero or other bookkeeping workflows.

Does ClearlyLedger handle NetBank and BPAY references?

Yes. The Commonwealth Bank parser is designed to preserve transaction context such as NetBank transfers, BPAY biller details, and other narration fields that help with reconciliation.

Is my Commonwealth Bank statement stored after conversion?

No. ClearlyLedger processes uploaded PDFs in memory and deletes them after conversion. The platform is designed for privacy-sensitive financial document workflows.

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