Skip to content
BankConv
Get started

Convert Commonwealth Bank (CommBank) statements to Excel or CSV

CommBank balances end in CR or DR, so the balance column needs turning into signed numbers before any maths. NetBank's CSV export covers recent transactions only and usually has no header row. For older periods, download the PDF statements from NetBank or the CommBank app and convert them to Excel, CSV or Google Sheets in BankConv.

Updated

Download your CommBank statement

  1. 1.Log on to NetBank (commbank.com.au) or the CommBank app.
  2. 2.Look for Statements (in NetBank, usually under View accounts).
  3. 3.Choose the account and the statement period, then download the PDF.
  4. 4.Repeat for each period.

Do you need to convert at all?

NetBank lets you export the transaction list as CSV, and in formats for money and accounting software such as OFX, QIF and QBO.

Recent transactions only, from NetBank on a computer. The CSV usually has no header row. Older periods are PDF statements.

Commonwealth Bank (CommBank) export formats: CSV, OFX, QIF, QBO

What to know about Commonwealth Bank (CommBank) PDFs

Balances end in CR or DR
The balance column usually shows a suffix, such as $1,250.40 CR for money in the account. DR means overdrawn. Convert these to positive and negative numbers before you do any maths.
Dates without a year
Transaction dates usually print as day and short month (for example 03 Mar). The year comes from the statement period, which often runs for several months or across a financial year.
Opening and closing balance rows
The table usually begins with an OPENING BALANCE row and ends with a CLOSING BALANCE row. Exclude them when you total debits and credits.

Converting CommBank statements

CommBank statements from NetBank are usually text-based PDFs, so the transactions read straight off the page. Statement periods are often longer than a month, so a single PDF can run to several pages.

  1. Download the statement PDFs from NetBank.
  2. Upload them to BankConv.
  3. Check the rows, then export Excel, CSV or Google Sheets.
A CommBank statement converted, with the CR suffix still on the balance.

Turning CR and DR into numbers

Spreadsheets and accounting software need a plain signed number. Fix the balance column once and the rest of the checks are easy.

  • In Excel, use =IF(RIGHT(E2,2)=“DR”,-1,1)*VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E2,” CR”,“”),” DR”,“”),“$”,“”)).
  • Check that the last balance matches the closing balance.
  • Total debits and credits and compare them with the statement summary.

Australian dates are day first (DD/MM/YYYY), so set your spreadsheet or software to that format before importing, or 03/04 may become 4 March. For Xero or MYOB, import the CSV directly; see how to import a bank statement into Xero. For QuickBooks, see QuickBooks import.

How to convert a CommBank statement to ExcelVideo coming soon · 1:15

Sources: CommBank: How can I export transaction information to another software application? · CommBank: How far back can I track transactions in NetBank?

Product screenshotBankConv results page after converting a Commonwealth Bank (CommBank) statement (anonymised): rows table, format switch and export button.
A CommBank statement converted in BankConv

Columns you get

DateTransactionDebitCreditBalance
03 SepWoolworths 1234 Sydney NS AUS Card xx123454.30$1,945.70 CR
04 SepFast Transfer From J Smith Rent share600.00$2,545.70 CR
05 SepBPAY Origin Energy210.45$2,335.25 CR
08 SepSalary ACME PTY LTD3,100.00$5,435.25 CR

Sample rows in Commonwealth Bank (CommBank)'s layout, fictional data. First 5 pages free to check.

  • Deleted after 24 hours

    Your PDF and its converted files are deleted automatically. Account owners can choose 48 or 72 hours instead.

  • Read only to extract transactions

    Your statement is read (with OCR for scans) to pull out the transaction rows you download.

  • Encrypted in transit

    Uploads and downloads use HTTPS (TLS).

  • Passwords never stored

    The password of a protected PDF is used once to open the file.

  • No bank login

    BankConv works from the PDF you download, never from a connection to your bank.

How we handle your data

Commonwealth Bank (CommBank) statement questions

Can I export CommBank transactions to CSV?

Yes, for recent transactions, from NetBank. The file usually has no header row, with date, amount, description and balance. For older periods, convert the PDF statements in BankConv.

What does CR mean on a CommBank statement?

CR after the balance means the account is in credit, so you have money in it. DR means the account is overdrawn.

Can I convert a full financial year at once?

Yes. Upload up to 10 statement PDFs in one batch, then combine the rows in one spreadsheet. Your first 5 pages convert free.

Other Australia banks

  • ANZ
  • Westpac
  • NAB
  • ING Australia
  • Macquarie Bank
  • Bendigo Bank
  • St.George Bank
  • Bankwest
All Australia banks