Accounting Samurai
Back to Blog

How to Download CommBank (CBA) Transactions as a CSV File

6 min readBlog

Need to download transactions from your Commonwealth Bank account as a CSV file? CommBank allows you to export your account transactions for a selected date range, giving you structured banking data that can be used for bookkeeping, tax preparation, spreadsheets and financial reporting.

In this guide, we'll show you how to download CommBank transactions as a CSV file in just a few simple steps.

Watch the video tutorial below or follow the step-by-step instructions.

How to Download CommBank Transactions as CSV

Step 1: Log In to CommBank NetBank

Start by logging in to CommBank NetBank.Once you're logged in, select the Commonwealth Bank account containing the transactions you want to export. If you have multiple CBA accounts, make sure you select the correct account before continuing.

Step 2: Choose Your Transaction Date Range

Select the date range for the transactions you want to download.For example, if you need transactions for the last quarter of the calendar year, you could select:

From: 1 April
To: 30 June

You can choose a period that matches your bookkeeping or reporting requirements, such as a month, quarter or other available date range.

Step 3: Select Exports

Once you've selected the transactions and period you need, click Exports. This gives you access to the available options for exporting your Commonwealth Bank transaction data.

Step 4: Select CSV as the File Type

Choose CSV as your preferred file type. CSV stands for Comma-Separated Values. It's a widely supported file format for storing structured data and is particularly useful for bank transactions because individual transactions can be processed as separate rows.

Step 5: Export Your CommBank Transactions

Once CSV has been selected, click Export. Your Commonwealth Bank transactions will then be exported as a CSV file. That's it! You now have your CommBank transaction data in CSV format for the selected period.

Why Download CommBank Transactions as a CSV File?

A CSV export is useful when you need to actually work with your bank transaction data, rather than simply read a statement.

Because CSV files contain structured transaction data, they can be opened in spreadsheet applications and used with compatible bookkeeping, accounting and financial tools.

You may want to export your CBA transactions as CSV for:

  • Bookkeeping

  • Tax preparation

  • BAS preparation

  • Business expense tracking

  • Income tracking

  • Transaction categorisation

  • Spreadsheet analysis

  • Creating Profit & Loss statements

  • Importing transactions into compatible accounting software

  • Sharing transaction data with your accountant

For sole traders, freelancers, contractors, gig workers and small business owners, downloading transactions regularly can make it much easier to keep financial records organised.

CommBank CSV vs PDF Bank Statement: Which Should You Download?

Whether you need CSV transactions or a PDF bank statement depends on what you're trying to accomplish.

PDF Bank Statements

A PDF bank statement is generally the better option when you need a readable financial document showing your account activity for an official statement period.

PDF bank statements can be useful for:

  • Proof of income

  • Loan applications

  • Mortgage applications

  • Rental applications

  • Financial record keeping

  • Providing financial documents to third parties

CSV Transaction Files

A CSV export is usually better when you need to process the individual transactions.

For example, CSV files make it easier to:

  • Sort transactions

  • Filter transactions

  • Search transaction descriptions

  • Identify business income

  • Categorise expenses

  • Calculate totals

  • Analyse spending

  • Import banking data into compatible software

  • Prepare financial reports

If you're downloading Commonwealth Bank transactions specifically for bookkeeping or preparing a Profit & Loss statement, CSV will often be more convenient than manually copying transactions from PDF statements.

Using Commonwealth Bank CSV Transactions for Bookkeeping

If you use your CommBank account for business purposes, your CSV export can provide much of the raw financial data required for your bookkeeping.

Your account may contain income such as:

  • Customer payments

  • Client payments

  • Uber or rideshare payouts

  • Delivery platform payments

  • Marketplace income

  • Other business revenue

Your business expenses could include:

  • Fuel

  • Vehicle expenses

  • Tolls and parking

  • Phone and internet

  • Software subscriptions

  • Advertising

  • Insurance

  • Equipment

  • Professional services

  • Bank fees

  • Other operating expenses

Downloading the transactions gives you the raw data, but those transactions still need to be reviewed and organised into meaningful income and expense categories.

Turn Your CommBank Transactions Into a Profit & Loss Statement

If your ultimate goal is to prepare business financial records, downloading your Commonwealth Bank transactions is only the first step.

A Profit & Loss statement, also known as a P&L or income statement, summarises your business income and expenses for a particular period and calculates your resulting profit or loss.

Creating one manually from your CBA transactions can involve:

  1. Exporting your bank transactions.

  2. Reviewing each transaction.

  3. Separating personal and business transactions.

  4. Identifying business income.

  5. Identifying deductible business expenses.

  6. Assigning expenses to the correct categories.

  7. Calculating category totals.

  8. Calculating total income and expenses.

  9. Determining your net profit.

  10. Preparing the final Profit & Loss statement.

For an account containing hundreds or thousands of transactions, this can quickly become time-consuming.

Accounting Samurai can help simplify this process.

Instead of manually working through every bank transaction in a spreadsheet, Accounting Samurai helps turn your banking data into an organised Profit & Loss statement.

This can be particularly useful for:

  • Uber and rideshare drivers

  • Uber Eats drivers

  • DoorDash drivers

  • Amazon Flex drivers

  • Gig workers

  • Freelancers

  • Contractors

  • Sole traders

  • Small business owners

Generate a P&L From Your CommBank Transactions

Already exported your Commonwealth Bank transactions?

Upload your banking data to Accounting Samurai and turn your income and expenses into an organised Profit & Loss statement without manually building one from scratch.

👉 Generate Your Free Profit & Loss Statement Now

Frequently Asked Questions

Can I download CommBank transactions as a CSV file?

Yes. You can export transaction data from your Commonwealth Bank account through CommBank NetBank and select CSV as the file type.

How do I export transactions from Commonwealth Bank?

Log in to CommBank NetBank, select the relevant account, choose the transaction period you need, select Exports, choose CSV as the file type and export the transactions.

Can I select a date range when exporting CommBank transactions?

Yes. You can select the transaction period you need before exporting the data. This makes it useful when you need transactions covering a particular month, quarter or other reporting period.

What is a CSV bank transaction file?

CSV stands for Comma-Separated Values. It is a structured data format commonly used for exporting banking transactions.

Unlike a PDF statement designed primarily for reading, CSV files make it easier to sort, filter, categorise and process individual transactions.

Can I open a CommBank CSV file in Excel?

CSV is a widely supported format and can generally be opened using spreadsheet applications such as Microsoft Excel and other compatible spreadsheet software.

Why would I export Commonwealth Bank transactions as CSV?

CSV files can be useful for bookkeeping, tax preparation, expense categorisation, BAS preparation, spreadsheet analysis and creating financial reports such as Profit & Loss statements.

Should I download CommBank transactions as CSV or PDF?

Use PDF when you need a readable bank statement or supporting financial document. Use CSV when you need to analyse, categorise, import or otherwise process individual bank transactions.

Can I create a Profit & Loss statement from CommBank transactions?

Yes. You can manually separate and categorise your business income and expenses from the exported transactions and use those figures to prepare a Profit & Loss statement. Alternatively, Accounting Samurai can help automate much of this process and reduce the need to manually process every transaction.