Convert Commonwealth Bank statements to Excel and CSV

CommBank's new NetBank exports transactions as CSV only; the OFX and QIF options are gone. If your routine relied on those, or you've been sent statements rather than NetBank access, the PDF is what you have to work with. If you work from Commonwealth Bank statement PDFs, whether a single month or a whole financial year, this converter turns them into Excel or CSV rows you can reconcile.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your CommBank statement into Excel

  1. Download the PDF statement from CommBank online banking

    • Log on to NetBank or the CommBank app.
    • In NetBank, select the account on the Home page; in the app, tap 'Accounts', tap the account, tap 'Manage', and scroll down to 'View statements'.
    • In NetBank, select 'Download latest statement', or 'View all statements', choose the financial year, tick the statements (or 'Select all'), and select 'Download (PDF)'. In the app, tap the statement and the 'Download' button.
    • Save the statement for the period you need as a PDF.
    Go to CommBank Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your CommBank statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · AUD
Sample bank statement rows with made-up data, amounts in AUD
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about CommBank statements

Statements are filed by financial year

NetBank groups statements by financial year and lets you tick several, or all of them, and download in one go. That is handy at tax time, but a batch can easily include one statement twice or skip a month. When you upload the batch, duplicate, overlapping and missing periods are flagged before you export.

CSV is the only NetBank export now

CommBank says you can still export transactions from NetBank in CSV, while OFX and QIF are no longer available in the new NetBank. If your old routine relied on a QIF file, a converted statement gives you a CSV laid out for Xero or QuickBooks instead, or plain columns you can map yourself.

Seven years, then two after closing

CommBank keeps online statements for up to seven years, and for two years after an account is closed. If a client is about to close an account, save the statements first. Once that two-year window has passed, NetBank no longer shows them.

Debits, credits and the balance

Each statement page lists debits and credits in separate columns with the balance alongside. The converter turns these into one signed amount per line, negative for money out, and tests the printed balance column against the statement's totals.

Output and review

From CommBank PDF to your books

Accounting tip

Xero's statement import accepts CSV, so the Xero-ready file goes straight in, and Xero remembers your column mapping after the first import. MYOB is the awkward one: its statement import takes QIF or OFX rather than CSV, and those formats are no longer offered in the new NetBank.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

CommBank statement questions

Can I still get a QIF or OFX file from NetBank?
Not from the new NetBank. CommBank says OFX and QIF exports are no longer available there and CSV remains. If your software needs a particular CSV layout, convert the statement PDF here and choose the Xero-ready or QuickBooks-ready CSV, or a plain CSV you can map on import.
How do I convert a whole financial year of CommBank statements?
Download the year's statements from NetBank, where you can select them all at once, and upload them together. Each statement becomes rows with YYYY-MM-DD dates, and any gap or overlap between periods is flagged, which matters when you are closing off a 1 July to 30 June year.
Can I import converted CommBank rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your CommBank statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by CommBank.