Financial Documents

Convert Commonwealth Bank Statement to Excel or CSV

Learn when CommBank's native CSV export is enough and when you need PDF conversion. Covers CommBank PDF quirks and preparing data for Xero, MYOB, or BAS.

Published
Updated
Reading time
9 min
Topics:Financial DocumentsAustraliaBank StatementsExcelPDF conversionCommBankaccounting reconciliation

If your CommBank transactions are recent, export a CSV from NetBank or CommBiz and open it in Excel. If you only have an older monthly PDF, convert the statement instead, because the PDF layout needs dates, balances, page headers, and split transaction rows parsed before it is reliable for reconciliation or import.

CommBank's 2025 AGM address says the CommBank app has more than 9 million active users and more than 12.7 million daily logins. That scale translates to a high volume of Commonwealth Bank statement PDFs flowing through practices every month for BAS preparation, client reconciliation, and import into tools like Xero and MYOB.

The right method depends on what you're starting with: recent transactions you can export as CSV from NetBank or CommBiz, or older archived PDF statements that require conversion to get usable rows and columns.

CommBank's Native Export Options and Their Limits

Before reaching for any conversion tool, it's worth understanding exactly what CommBank gives you out of the box. The bank offers two distinct ways to get transaction data out — and each has a different format, time range, and use case.

NetBank CSV export is the most direct route to structured data. From the transaction activity screen in NetBank (for personal and small business accounts), you can export your transaction history as a CSV file. This gives you raw, column-separated transaction data that opens directly in Excel or any spreadsheet application. CSV is now the only format the new NetBank exports, since CommBank has retired the OFX and QIF exports. The catch: each search or export covers up to 600 transactions, and NetBank holds up to two years of transactions, for open accounts and for accounts closed within the last two years. Beyond that window, the data simply isn't available through this method. That is still a generous lookback by local standards: St.George, Bank of Melbourne and BankSA show only about three months online, so St.George group statement conversion usually has to start from the PDF.

To export from NetBank in a browser, CommBank's steps are:

  1. Log on to NetBank.
  2. Choose the account you want to export from and select Export.
  3. To set a period, use Advanced search above the transactions list to choose the dates, then select Export again.
  4. Choose CSV as the format and select Export transactions.

Labels can differ slightly in the new NetBank. If the period you need holds more than 600 transactions, export it in consecutive date ranges and combine the files in one sheet.

This is a transaction-level export, not a replica of your monthly statement. CommBank lists four fields in it: the date of the transaction, the amount in a single column with debits shown as negative numbers, the transaction details, and the account balance at the time of the transaction. Dates come through in DD/MM/YYYY format. What the export does not reproduce is the statement itself: the opening and closing balances, the statement period and the account headers printed on the official statement PDF.

CommBiz serves a different audience. If your client or organisation uses commercial or business accounts through CommBiz, it provides its own transaction export functionality. Which platform you use depends entirely on the account structure: NetBank for personal and small business, CommBiz for commercial and institutional accounts. CommBiz exports reach back up to 25 months. For one account, go to Accounts > Transaction History, choose the account, set the date range under Transaction Search and select Search, then pick CSV or PDF under Export Format and select Export Transactions. The file takes a few minutes to generate, after which Refresh and View Report open it. To export several accounts at once, File Transfer > Export > Request Transaction History File produces BAI2, QIF or PDF. Each PDF export is limited to 5,000 lines, and transactions older than 25 months come from the account statements.

Monthly statement PDFs fill a different gap. Through NetBank and the CommBank app, you can download formatted monthly statements as PDFs going back up to seven years for most open accounts, and for up to two years after an account is closed. In NetBank, open the account, select View all statements, pick the financial year and use Select all to download that year's statements as PDFs in one go. These statements contain everything: transaction details plus opening balances, closing balances, running balances, and account headers. They're the complete financial record. But they arrive as formatted documents, not as structured spreadsheet data.

Here's the practical decision point:

  • The CSV export covers your date range? Use it. It's the fastest path to Excel-ready data with zero reformatting required.
  • You need transactions older than two years, or the statement layout with opening and closing balances? The statement PDF is the only place CommBank provides them, and a PDF is not a spreadsheet.

Use PDF conversion when you need prior-year BAS support, multi-year audit records, data from a closed account (its statements stay in NetBank for up to two years after closing), or a statement-level record rather than a transaction dump. In those cases, the structured export usually runs out before the compliance or reconciliation work does.

Before converting a CommBank PDF, check four format details that affect accuracy:

  • Dates without years: Statement rows may show "14/03" rather than "14/03/2024", so the converter must infer the year from the statement period.
  • Negative balance formatting: Parentheses, CR markers, and DR markers need to become usable numeric signs.
  • Repeated page headers: Multi-page statements repeat account headers and running-balance summaries that should not become transaction rows.
  • Native versus scanned PDFs: NetBank downloads usually contain selectable text, while scanned statements need OCR before the data can be parsed.

How to Convert CommBank PDF Statements to Excel or CSV

For PDF statements, the practical choice is usually between manual copy-paste for one small, clean statement and automated extraction for multi-page, scanned, or backlog work.

Manual Copy-Paste

Open the CommBank PDF in any PDF viewer, select the transaction rows, and paste into Excel. For a single-page statement with a dozen transactions, this can work. Beyond that, expect problems.

Pasted data frequently lands with broken row alignment — a single transaction splits across two or three Excel rows, or multiple transactions merge into one cell. Column separation is unreliable: amounts may land in the description column, and dates often lose their alignment entirely. You will also need to manually fix the two CommBank-specific issues covered earlier: adding the year to every date (since CommBank PDFs omit the year from dates) and normalising the debit/credit sign convention so negative balances render correctly in your spreadsheet formulas.

For a multi-page statement or a backlog of several months, manual copy-paste becomes untenable. The error rate climbs with every page, and the reformatting work quickly exceeds the time it would take to re-key the data from scratch.

Automated Data Extraction

Purpose-built extraction tools analyse the document structure, identify transaction tables, and return structured data with correctly typed values: numbers as numbers, dates as dates.

For CommBank statements specifically, this means the tool handles year inference (resolving "14/03" to "14/03/2025" based on the statement period printed on the first page), interprets negative balance formatting including amounts in parentheses, strips repeated page headers and footers that appear on every page of multi-page statements, and differentiates between native and scanned PDFs automatically.

With Invoice Data Extraction, the workflow is straightforward. Upload your CommBank PDFs, then prompt the AI with instructions specific to your needs — for example, "Format dates as YYYY-MM-DD" or "Treat amounts in parentheses as negative." The AI extracts transaction data following those instructions and outputs a structured Excel (.xlsx), CSV (.csv), or JSON (.json) file. Every row in the output references the source file and page number, so you can verify any transaction against the original statement.

The tool supports both native digital PDFs and scanned documents (including mobile phone photos of printed statements), so you do not need a separate OCR step regardless of how the CommBank statement was generated. You can convert CommBank statements to Excel automatically without manually correcting any of the formatting issues that plague copy-paste methods.

For backlogs, batch upload keeps the same workflow from becoming twelve separate jobs. Invoice Data Extraction handles batches of up to 6,000 mixed-format files, and the output keeps each row tied to its source file and page.

If you also work with statements from other Australian or international banks, the same extraction approach applies. NAB customers, for instance, face a similar split between NAB Internet Banking's recent-transaction CSV export and older PDF statements — our walkthrough on extracting NAB statement data into Excel or CSV covers the NAB-specific quirks. The same is true for Westpac Live and Corporate Online exports, where our guide to converting Westpac statements to Excel or CSV covers the Westpac-specific paths. See our guide on converting bank statements from any bank to Excel for a broader overview of the process across different institutions.


Preparing CommBank Data for Xero, MYOB, and BAS

Before importing converted CommBank data, turn the extraction output into a clean accounting CSV:

  • For Xero: Use Date, Amount, Description, and optional Payee or Reference columns. NetBank's CSV already has one signed amount column. For PDF-extracted output with separate Debit and Credit columns, consolidate them into one Amount column, with debits negative and credits positive. See importing bank transactions into Xero for the full column-mapping process.
  • For MYOB: Confirm the CSV structure expected by MYOB Business or AccountRight, then map CommBank withdrawals and deposits to the required amount-sign convention. See importing bank statement data into MYOB for version-specific import details.
  • For BAS preparation: Keep DD/MM/YYYY dates consistent, filter transactions by BAS period, and tag GST-free, GST-inclusive, and input-tax-credit items before matching deposits and withdrawals against invoices.

The important checks are the same in all three workflows: no repeated page headers, no subtotal rows, no missing year values, and no split transaction descriptions.

Extract invoice data to Excel with AI

Upload your invoices, say what you need in plain words, and download the spreadsheet.

  • A panel of AI agents has to agree on every value
  • What the panel cannot agree on is flagged as Review Needed
  • 50 free pages every month, no subscription
  • Any layout, any language, scans and phone photos
  • Numbers come through as numbers and dates as dates
  • Files encrypted and deleted within 48 hours