AU
Upload a Commonwealth Bank statement PDF and every transaction comes back as clean rows — date, description, debit, credit and the running balance — checked so the closing figure ties out. Export to Excel, CSV, or an import file for Xero, MYOB or QuickBooks.
CommBank statements are clear enough to read, but a PDF is a document, not data. Australian sole traders and bookkeepers reconciling a quarter's worth of transactions need them as rows they can sort, total and import — not as pages to retype.
What a Commonwealth Bank statement looks like
A CommBank transaction account statement uses these columns:
Column | What's in it |
|---|---|
Date | `DD Mon YYYY`, Australian format |
Transaction | The payee, plus a description of how it was paid |
Debit | Money out |
Credit | Money in |
Balance | Running balance after the transaction |
The Transaction column carries the detail that matters at tax time — whether a payment was an EFTPOS purchase, a direct debit, a BPAY payment, an ATM withdrawal or a transfer. That description often wraps across two lines, and a rough export splits it into a second half-row. The converter joins it back so each payment reads as one entry.
Where to download your Commonwealth Bank statement
- NetBank: log in at commbank.com.au, choose the account, open Statements, select the period and download the PDF.
- CommBank app: tap the account, go to Statements, pick a statement and save the PDF.
A statement downloaded from NetBank is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo of a mailed statement, the converter reads it with OCR — that just takes a little longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
- Xero or MYOB — an import-ready bank file so the lines arrive as statement entries to reconcile.
- QuickBooks, Zoho and others — the same data in each one's format.
Before you download, the maths is checked: opening balance, plus credits, minus debits, has to land on the closing balance. On a statement covering a full BAS quarter, that check is what catches a single line dropped between pages.
Handy at BAS and tax time
Most people converting a CommBank statement are doing it for a reason: a quarterly BAS, a year-end return, or handing a clean set of numbers to a bookkeeper. A PDF makes that slow — you can't sort it, you can't total a column, and GST-relevant payments are buried in the transaction text. As rows in Excel you can filter EFTPOS purchases, tag BPAY bills, and total debits and credits in seconds. If you keep your books in Xero or MYOB, importing the bank file means the transactions arrive ready to reconcile against invoices and bills rather than being keyed in one by one.
Common snags with Commonwealth Bank statements
- Wrapped transaction descriptions. Long payee and reference lines get rejoined to the right transaction.
- Debit and credit in separate columns. Each amount stays on the correct side so your totals aren't reversed.
- Business accounts. CommBank business transaction-account statements use the same layout, so the same conversion works.
Frequently asked questions
Can I convert a Commonwealth Bank statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
Where do I download my CommBank statement?keyboard_arrow_down
In NetBank or the CommBank app: choose the account, open Statements, pick the period and download the PDF. That digital PDF converts cleaner than a scan.
Can I import it into Xero or MYOB?keyboard_arrow_down
Yes. Export an import-ready bank file and the transactions arrive as statement lines you reconcile as usual in Xero, MYOB or QuickBooks.
Does it read scanned CommBank statements?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from NetBank will always convert faster and cleaner than a scan or photo.
Can I use it for my BAS or tax return?keyboard_arrow_down
Yes. A clean CSV or Xero/MYOB import gives you every debit and credit as sorted rows, which is far faster to reconcile for a BAS quarter or year-end than working from the PDF.
