Skip to content
stmtai

Convert CommBank statement PDFs to Excel, Xero and CSV.
Xero, MYOB, QuickBooks Online files from the PDF.

CommBank statement PDFs are not password-protected. NetBank exports a transaction list as CSV, OFX or QIF from the Export link above the transactions, and the CSV does include a running balance, which is more than some banks manage.

Drop your CommBank statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in AUD.

Last updated

How to download a CommBank statement as a PDF

  1. Log on to NetBank on a desktop browser and click the account name from the accounts overview.
  2. Select Statements. The list shows every issued statement for that account, newest first.
  3. Pick the statement period you want and click the download arrow next to it.
  4. Save the PDF. NetBank names it after the account, so rename it with the period if you are collecting a run of months.
  5. In the CommBank app: Accounts, tap the account, then Manage and View statements. Open the statement, tap the share icon and Save to Files.

Then drop the file above; several months of CommBank statements at once come back as one workbook.

Is the CommBank PDF password-protected?

CommBank statement PDFs are not password-protected. They open straight away and can be uploaded as downloaded.

What CommBank statements look like

Date, Transaction, Debit, Credit, Balance with "$" suffix and CR/DR markers on the balance.

A CommBank transaction account statement lists Date, Transaction, Debit, Credit and Balance, with an Opening balance line at the top of the first page and a Closing balance at the end. Dates in the body show day and month only, with the year taken from the statement period in the header, so a statement that crosses 31 December needs the year inferred correctly. The Balance column carries a CR or DR suffix rather than a minus sign; an overdrawn everyday account reads as, say, 250.00 DR. Everyday accounts are statemented monthly or quarterly depending on the product, and a busy month runs three to five pages. Card statements use a different layout with a Transaction Date and a Posting Date.

Why not use CommBank's own export?

NetBank exports a transaction list as CSV, OFX or QIF from the Export link above the transactions, and the CSV does include a running balance, which is more than some banks manage. The catch is scope: the export is capped at around 600 transactions and two years, it only works on desktop (the app has no export), and the CSV arrives without a header row. For anything older, or when the figures need to match the issued statement rather than a filtered feed, the PDF is the document to convert. Statements are kept in NetBank for up to seven years.

Where CommBank statements trip up converters

  • DR/CR balance markers are read so an overdrawn balance is negative, and the check still ties out.

Which software CommBank customers import into

CommBank customers most often import into Xero, MYOB, QuickBooks Online.

CommBank questions

Why do the dates on my CommBank statement have no year?

CommBank prints only day and month against each transaction and states the period once in the header. The converter reads the period dates and assigns the year to each row, rolling over when the month sequence goes from December to January. Check the first and last rows after converting a statement that spans a year end.

My balance went overdrawn mid-statement. Does DR come through correctly?

Yes. A DR suffix on the Balance column is treated as a negative balance and a CR suffix as positive, so the running check still ties from the opening figure to the closing one. In the Excel output the balance is a plain signed number with no suffix.

Is the NetBank CSV good enough instead of converting the PDF?

For the last few months, usually yes. It has a balance column and imports cleanly into Xero or MYOB once you add headings. Past two years, or beyond 600 rows, it stops, and it will not match the issued statement line for line, which is what an accountant or lender asks for.

How do I convert a CommBank statement PDF to Excel?

Download it from CommBank using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many CommBank statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in Australia

All banks and formats · See a sample result