​

How to Convert a CommBank Statement to CSV

If you've ever tried to get your Commonwealth Bank transaction history into a spreadsheet, you've probably hit the same wall: CommBank statements download as PDFs, not CSVs — and PDFs don't play nicely with Excel, Xero, or your bookkeeping tool of choice.

The good news is there are several ways to get a clean CSV from your CommBank statement, ranging from a built-in export inside NetBank to automated PDF conversion tools. This guide walks through each option, when to use it, and how to avoid the formatting headaches that come with copy-pasting bank data by hand.

Why CommBank Statements Are Hard to Work With

Commonwealth Bank statements are formatted for reading, not for data processing. Dates, descriptions, debits, and credits are laid out in columns designed to look right on a printed page — not to map cleanly into rows and columns in a spreadsheet. That's fine if you just need to glance at a balance, but it becomes a real problem when you're:

• Reconciling accounts in Xero, MYOB, or QuickBooks
• Building a personal budget in Excel or Google Sheets
• Preparing records for a bookkeeper or accountant
• Feeding transaction data into a treasury or ERP system

In all of these cases, you need structured data — a CSV, not a PDF.

Method 1: Export Transactions Directly from NetBank

Commonwealth Bank's online banking platform, NetBank, has a built-in export feature for recent transactions. This is the fastest option if you only need a short date range.

Steps:

1. Log in to NetBank (or the CommBank app on desktop).
2. Select the account you want to export.
3. Go to the transaction history or statements section.
4. Choose your date range.
5. Look for an export or download option and select CSV (rather than PDF or OFX).
6. Save the file to your computer.

Limitations: NetBank's export usually only covers a limited transaction history window (commonly the last 1–2 years, depending on account type), and it won't help if all you have is an old statement already saved as a PDF — for example, one an accountant sent you, or one you downloaded before realizing you'd need CSV format.

Method 2: Manually Copy Data from a PDF Statement

If you only have the PDF and can't re-export from NetBank, some people try copying and pasting transaction rows straight into Excel.

Why this usually goes wrong:

• Columns don't align — debit and credit amounts often land in the same cell
• Multi-line transaction descriptions break across rows
• Dates paste as text instead of recognized date values
• Running balance columns get mixed in with transaction amounts

For a single-page statement this might be tolerable. For a full month (or a year of statements for tax time), manual copy-paste quickly becomes a multi-hour job with a high error rate — which is a real problem when the output feeds into a reconciliation or a tax return.

Method 3: Use a PDF-to-CSV Conversion Tool

The most reliable option — especially for older statements, bulk conversions, or anyone who needs the output to be reconciliation-ready — is a dedicated bank statement converter. These tools read the PDF layout, correctly separate debits from credits, and output a clean CSV (or MT940/CAMT.053 for treasury systems) with proper date formatting and one transaction per row.

What to look for in a converter:

• Accuracy on Australian bank formats — CommBank's column layout differs from other banks, so a generic PDF-to-text tool often misreads debit/credit columns
• Batch processing — the ability to upload several statements at once, rather than one PDF at a time
• No manual cleanup required — output should open directly in Excel or import straight into accounting software without reformatting
• Data privacy — since a bank statement contains sensitive financial information, check that the tool doesn't retain your files or use your data for anything beyond the conversion itself

Data River is built for exactly this use case: upload a CommBank PDF statement and get back a structured CSV (or MT940/CAMT.053 file) in seconds, with debits, credits, dates, and descriptions correctly separated — no formulas, macros, or manual cleanup needed. Files are processed and deleted immediately, so nothing is stored or used to train any model.

Which Method Should You Use?

Frequently Asked Questions

Can I convert a CommBank PDF statement to CSV for free?NetBank's built-in export is free but limited to recent transaction history. For older PDF statements, most dedicated converters offer a free tier or trial for a small number of pages.

Does CommBank offer CSV downloads directly?Yes, through NetBank's transaction export feature — but only for accounts and date ranges you can still access online, not for a PDF someone has already sent you.

Is it safe to upload a bank statement to a conversion tool?Check the provider's privacy policy before uploading. Look for tools that explicitly state they delete files after conversion and don't use uploaded data for AI training or any other purpose.

What file formats can a CommBank statement be converted to besides CSV?Most conversion tools can also output MT940 or CAMT.053 formats, which are commonly required by treasury management systems and ERP software.

---

Need to convert a CommBank statement right now? Try Data River — upload your PDF and download a clean CSV file in seconds.