How to Export a CommBank Statement to CSV

If you need your Commonwealth Bank transactions in a spreadsheet — to import into accounting software, build a budget, or reconcile the books — a CSV file is what you want. CommBank handles this in two different ways depending on how recent the data is, and it helps to know which path applies before you start. (Menu labels in NetBank and the CommBank app change from time to time; the steps below are general.)

Two ways to get CommBank data out

CommBank generally splits things into two buckets:

• Recent transactions may be exportable directly from NetBank in a spreadsheet format (CSV or similar) where that option is available. This tends to be the easy path when you only need the last few weeks or months of activity, though availability varies.
• Older periods are usually delivered as a formal PDF statement rather than a raw data export. PDFs are designed for reading and record-keeping, not for spreadsheets, so getting them into CSV takes one extra step.

Knowing which bucket your data falls into tells you which of the two methods below to use.

Method 1: Export recent transactions from NetBank

Where NetBank lets you export recent transactions, exporting to a spreadsheet format is the cleanest route. The exact wording, menu placement, and availability vary, so treat the following as a general guide rather than exact instructions:

1. Sign in to NetBank on a desktop browser.
2. Open the account you want the data from.
3. Look for an Export or download option on the transactions view — it may sit under a menu or settings icon on the page.
4. Choose the date range you need, if a range can be set.
5. If a spreadsheet format such as CSV is offered, select it and download the file.

The CommBank app may offer a similar export on a per-account basis where available, though the desktop site often gives more control over date ranges and file formats. Once downloaded, open the file in Excel, Google Sheets, or Numbers and check the columns — date, description, amount, and balance — before you do anything else with it.

What if CSV is not offered?

Export availability can depend on the account type and how far back you are asking for. If you do not see a CSV (or any export) option for the period you need, that data is likely only available as a PDF statement — which brings us to the second method.

Method 2: Convert a PDF statement to CSV

For older periods, you will typically download a PDF statement first. If you are not sure how to find one, see how to download a Commonwealth Bank statement.

A PDF is fine for reading or for keeping as a source document, but you cannot sort, filter, or import it. To get usable data you need to convert it. There are a few approaches:

• Copy and paste the transaction table into a spreadsheet. This sometimes works if the PDF has a real text layer, but columns frequently collapse together and multi-line descriptions break the rows, so expect to clean up the result by hand.
• Retype it manually, which is reliable for a single short statement but slow and easy to get wrong on anything longer.
• Use an automated converter, which reads the statement, detects the transaction table, and exports clean rows for you.

The automated route is the most consistent, especially across several months. Drop the file into the free bank statement converter to turn a CommBank PDF into structured rows and export them to CSV. For a fuller walkthrough of the conversion options and their trade-offs, see how to convert a bank statement to Excel, and for CSV specifically, bank statement to CSV.

Getting the CSV into accounting software

CSV is the format most accounting tools expect for bank data, so once you have a clean file you can import it into packages such as Xero or MYOB to bring transactions into your books. Before importing, make sure the columns line up with what the software asks for — date format, description, and a single amount column (or separate debit and credit columns) are the usual sticking points. A quick tidy-up in a spreadsheet first will save time at the import step.

Tips for clean CommBank exports

• Match the date range to your need. For BAS or tax work you will often want full, consecutive periods rather than an arbitrary range.
• Check the amount column. Confirm whether debits and credits sit in one signed column or two separate columns, because import tools treat these differently.
• Keep the original file. Whether it is the raw export or the PDF statement, hold on to the source in case you need to re-export or reconcile later.
• Spot-check after converting. Compare the first and last few rows of your CSV against the statement to confirm nothing was dropped or misread.

For details on record-keeping requirements for businesses and sole traders, the Australian Taxation Office publishes guidance at ato.gov.au.

Whichever path applies — a direct CSV export for recent activity or a PDF conversion for older periods — the goal is the same: clean, structured transaction data you can actually work with.