How to Convert CommBank Statements to CSV or Excel

Why Convert CommBank Statements?

Commonwealth Bank of Australia (CommBank) is Australia's largest bank by market capitalisation, serving over 16 million customers — nearly two-thirds of the Australian population. CommBank's PDF statements are among the most commonly processed bank documents in Australia, used by individuals for tax returns (via myTax or a tax agent), small businesses for BAS lodgement, and accountants for client bookkeeping. CommBank statement PDFs list transactions in a clear tabular format, but extracting data manually into Excel remains tedious. BankRead's AI reads CommBank's format and delivers structured, categorized transaction data instantly.

Understanding the CommBank Statement Format

CommBank transaction account statements use a portrait PDF with transactions listed chronologically in a table showing Date, Transaction Description, Debit, Credit, and Balance. The header includes the BSB, account number, account name, and statement period. CommBank credit card (Mastercard, Awards) statements display a summary section followed by detailed transactions with Date, Description, and Amount. Savings account (NetBank Saver, GoalSaver) statements show a simpler layout with fewer transactions. All amounts are in AUD ($).

How to Convert with BankRead

Follow these steps to convert your CommBank PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your CommBank online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your CommBank Statement PDF

1. Log in to CommBank NetBank at netbank.commbank.com.au or use the CommBank app.
2. Select the account from your accounts overview.
3. Go to 'Statements' in the account menu.
4. Choose the statement period — CommBank stores statements for up to 7 years in NetBank.
5. Click 'Download' or the PDF icon to save the statement to your device.

What Data Gets Extracted

BankRead extracts the following fields from your CommBank statement:

• Transaction date (DD/MM/YYYY, Australian format)
• Transaction description (e.g., 'EFTPOS WOOLWORTHS 1234 SYDNEY AU' or 'Direct Credit SALARY')
• Debit amount (card purchases, direct debits, fees)
• Credit amount (salary, transfers in, refunds)
• Running balance (AUD)
• AI-assigned category (e.g., Supermarkets, Fuel, Dining, Salary, Utilities)

Export Options

Once your CommBank statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for CommBank Statements

• CommBank statements use Australian date format (DD/MM/YYYY) — BankRead preserves this format in the export.
• EFTPOS and card transactions include the merchant name and location — BankRead extracts the full description for accurate categorization.
• CommBank credit card statements (Mastercard, Awards, Diamond) are supported alongside transaction accounts.
• Multi-page statements from high-activity accounts are processed in a single upload.
• CommBank Business transaction account statements follow the same format as personal accounts with higher transaction volumes.

Common Issues and Solutions

• CommBank statements sometimes truncate long merchant names. BankRead extracts whatever description text is available and uses it for AI categorization.
• The 'Interest Charged/Earned' summary at the end of CommBank statements is aggregate data and is not duplicated as individual transactions.
• CommBank home loan statements have a repayment-focused format rather than transaction detail and are not supported for line-item extraction.

Frequently Asked Questions