How to Convert Australian Bank Statements to CSV and Excel (2026 Guide)

Why Convert Australian Bank Statements to CSV?

Australian banks — Commonwealth Bank, ANZ, Westpac, NAB, Bendigo Bank, and others — provide account statements as PDF files. These PDFs are perfect for reading but impossible to work with in accounting software like Xero, MYOB, or QuickBooks.

Converting to CSV (or Excel) solves several problems at once:

• Import into Xero, MYOB, or QuickBooks for bank reconciliation without manual data entry
• Categorise transactions for BAS lodgement and GST reporting
• Prepare EOFY tax returns with structured, sortable data
• Analyse spending with pivot tables, filters, and formulas in Excel or Google Sheets
• Bridge the gap when your bank doesn't support direct bank feeds to your accounting software

Understanding Australian Bank Statement Formats

Australian bank statements share some common features, but each bank has its own PDF layout:

Date Formats

Most Australian banks use DD/MM/YYYY or DD MMM YYYY date formats (e.g., "21/04/2024" or "21 Apr 2024"). Some use abbreviated formats like "21 Apr 24". This differs from the US MM/DD/YYYY format, which is why generic conversion tools often get Australian dates wrong.

StatementKit recognises all Australian date formats and converts them to the standardised YYYY-MM-DD format that accounting software expects.

Currency and Amount Formatting

Australian statements use the dollar sign ($) for AUD amounts, with commas as thousands separators and a period for decimals (e.g., $1,234.56). Most banks use separate columns for withdrawals (debits) and deposits (credits).

Transaction Types

Australian bank statements include several country-specific transaction types:

• OSKO / PayID — Australia's real-time payment system, replacing slower bank transfers
• BPAY — The national bill payment system, with biller codes and reference numbers
• Direct Entry — Salary deposits, Centrelink payments, ATO refunds
• EFTPOS — Point-of-sale debit card transactions
• Periodical Payments — Scheduled recurring transfers

Bank-by-Bank Format Guide

Commonwealth Bank (CommBank)

Australia's largest bank uses a clean tabular format with Date, Transaction, Debit, Credit, and Balance columns. Dates use DD MMM YYYY format. NetBank and the CommBank app allow PDF statement downloads by statement period.

ANZ

ANZ statements include Date, Transaction Details, Debit, Credit, and Balance columns. They use DD/MM/YYYY dates. ANZ Internet Banking provides statement downloads under the "Statements" section.

Westpac

Westpac uses Date, Narrative, Debit, Credit, and Balance columns. Dates are in DD MMM format (without year on each line — the year is in the statement header). Online Banking provides PDF downloads under "eStatements".

NAB

NAB statements show Date, Transaction Details, Debit, Credit, and Balance. They use DD MMM YY dates. NAB Internet Banking offers statement downloads from the account details page.

Bendigo and Adelaide Bank

Bendigo Bank uses Date, Transaction, Withdrawals, Deposits, and Balance columns with DD MMM YY dates (e.g., "21 Apr 20"). Statements can be lengthy for active accounts. See our Bendigo Bank conversion guide for specific details.

Step-by-Step: Convert Any Australian Bank Statement

1. Download your PDF statement from your bank's online banking portal. Most banks keep 7 years of statements available for download.
2. Upload to StatementKit — sign up for free and upload the PDF file.
3. Review the extracted transactions — verify dates, amounts, and descriptions are correct. StatementKit shows a preview of all extracted data.
4. Download as CSV or Excel — choose the format that suits your needs. CSV for accounting software imports, Excel for analysis and reporting.
5. Import into your accounting software — upload the CSV directly to Xero, MYOB, QuickBooks, or Reckon.

Importing Into Australian Accounting Software

Importing into Xero

Xero is the most popular cloud accounting software in Australia. To import your converted bank statement:

1. Go to Accounting > Bank Accounts
2. Select your bank account
3. Click Import a Statement
4. Upload the CSV file from StatementKit
5. Map the columns (Date, Description, Amount) — Xero usually auto-detects these
6. Confirm the import and begin reconciling

Importing into MYOB

MYOB is widely used by Australian accountants and bookkeepers:

1. Go to Banking > Bank Transactions
2. Click Import Statement
3. Select the CSV file
4. Map the date, description, and amount columns
5. Import and categorise your transactions

Importing into QuickBooks Online

1. Go to Banking > Banking
2. Select your bank account and click Link account > Upload from file
3. Upload the CSV and map columns
4. Review and accept the imported transactions

BAS Lodgement and Tax Reporting

One of the biggest benefits of converting bank statements to CSV is simplifying BAS (Business Activity Statement) lodgement and end-of-financial-year tax preparation.

GST Tracking

StatementKit's AI automatically categorises transactions into categories like Income, Shopping, Bills & Utilities, Food & Dining, and Transport. This makes it easy to identify GST-inclusive purchases and calculate your GST credits for BAS reporting.

EOFY Preparation

For end-of-financial-year (30 June) tax returns, having 12 months of bank transactions in structured format lets you:

• Sort and filter by category to identify deductible expenses
• Calculate total income and expenses by category
• Export summaries for your accountant or tax agent
• Cross-reference against invoices and receipts

Tips for Australian Users

• Download all 12 months at once if your bank allows it — saves time compared to converting monthly statements individually.
• Check the date format after conversion — Australian DD/MM dates should be converted to YYYY-MM-DD. If "03/04/2024" appears as April 3 (not March 4), the conversion is correct for Australian format.
• Use Excel for BAS prep — download as Excel to use filters and SUMIF formulas to total expenses by category for your BAS.
• Credit unions count too — StatementKit works with all Australian credit unions (People's Choice, Teachers Mutual, Heritage Bank, etc.), not just the big four.

Related Resources

• Australian Bank Statement Converter — our dedicated tool page for Australian banks
• Bendigo Bank Statement Converter — specific guide for Bendigo and Adelaide Bank
• How to Reconcile Bank Statements in Xero
• Bank Statement to CSV — general conversion guide