Convert Commonwealth Bank Statement to Excel or CSV

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. The catch: NetBank's export covers a maximum of around 600 transactions and only reaches back approximately two years. Beyond that window, the data simply isn't available through this method.

This is a transaction-level export, not a replica of your monthly statement. You get dates, descriptions, and amounts — but not the formatted layout with opening balances, closing balances, and running totals that appear on the official statement PDF. The exported file typically includes columns for Date, Transaction Description, Debit, Credit, and Balance, with dates in DD/MM/YYYY format.

CommBiz serves a different audience. If your client or organisation uses commercial or business accounts through CommBiz, it provides its own transaction export functionality with a similar recent-history window. Which platform you use depends entirely on the account structure — NetBank for personal and small business, CommBiz for commercial and institutional accounts. The export capabilities follow the same general pattern: recent transactions in a structured format, with a finite lookback period.

Monthly statement PDFs fill a different gap. Through NetBank and the CommBank app, you can download formatted monthly statements as PDFs covering a significantly longer historical period than the CSV export allows. 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 data older than two years, a period exceeding 600 transactions, or the full statement layout with balances? The PDF is the only export CommBank provides — 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, 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. Consolidate separate Debit and Credit columns 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.