Upload · Convert · Download
Convert Commonwealth Bank Statements to CSV
Turn Commonwealth Bank PDF statements into clean CSV files with transaction date, description, debit, credit, and balance in columns ready for import.
Upload Bank Statement
Drag & Drop your files for Demo or Browse
Converts 1 page in PDF or Single Image · This is Demo - limits 2/day
Upload your Commonwealth Bank PDF statement to BankStmtConverter, and the tool extracts each transaction's date, description, debit, credit, and balance into a structured CSV file. You download a spreadsheet-compatible file with columns mapped and ready for import into accounting software, spreadsheet analysis, or custom reconciliation workflows. The converter handles both digital and scanned Commonwealth Bank statements.
How do I convert a Commonwealth Bank statement to CSV?
- Download your Commonwealth Bank statement as PDF from NetBank or the CommBank app.
- Upload the PDF to BankStmtConverter at https://bankstmtconverter.com.
- The converter parses transaction rows and extracts date, description, debit, credit, and balance fields.
- Download the CSV file with columns separated by commas, ready for import.
The entire process takes under a minute for statements up to 50 pages. The CSV output uses standard column headers and preserves all decimal precision from the original statement.
What data gets extracted from Commonwealth Bank statements?
Commonwealth Bank statements list transactions with a posting date, description (merchant name or transfer reference), debit amount (money out), credit amount (money in), and running balance after each transaction. The converter captures all five fields into separate CSV columns. For transactions like EFTPOS purchases or BPAY payments, the full description line is preserved including reference numbers. Opening and closing balances are verified against the statement header to catch extraction errors.
Value dates are not separately printed on Commonwealth Bank statements, so the posting date serves as the transaction date in the CSV. Multi-line descriptions that span two rows in the PDF are concatenated into a single cell.
Using CSV files with accounting and analysis software
CSV is the most widely supported import format across accounting packages, bookkeeping tools, and spreadsheet applications. Unlike proprietary formats, CSV gives you direct control over column mapping and data transformation before import. Most Australian accounting software—MYOB, Xero, Reckon, QuickBooks Online—accepts CSV bank feeds through a manual import screen where you match CSV columns to the software's transaction fields (date, payee, amount out, amount in).
When importing Commonwealth Bank CSV into MYOB AccountRight, navigate to Banking > Spend Money or Receive Money > Import Data, then map the CSV columns: date to Date, description to Payee, debit to Amount (for Spend Money), credit to Amount (for Receive Money). MYOB expects separate import files for debits and credits, so filter your CSV in Excel first or import twice with different mappings. Xero's bank statement import (covered in detail on our Commonwealth Bank to Xero page) accepts combined debit-credit CSVs and auto-matches columns if headers are standard.
For Excel or Google Sheets analysis, open the CSV directly and use pivot tables to summarise spending by description keywords. A formula like =SUMIF(B:B,"*WOOLWORTHS*",C:C) totals all debits (column C) where the description (column B) contains
Common questions
Frequently Asked Questions
Does the converter work with scanned or photographed Commonwealth Bank statements?+
Yes. The converter uses OCR to read image-based PDFs and photos of paper statements. It checks extracted totals against the opening and closing balances printed on the statement to verify accuracy. Scanned statements with clear text produce reliable CSVs.
How is my Commonwealth Bank statement kept private?+
Your uploaded PDF and the generated CSV are deleted from the server immediately after you download the file. Files are not stored, shared, or used to train models. Processing happens in memory and is purged within minutes.
How accurate is the CSV output for reconciliation?+
The converter cross-checks the sum of all extracted debits and credits against the statement's printed opening and closing balances. If totals match, accuracy is typically 100 percent. For scanned statements, review a few transactions manually the first time you use the tool.
Can I import the CSV into MYOB or Reckon?+
Yes. MYOB and Reckon both accept CSV imports through their banking screens. You will need to map columns during import: date to transaction date, description to payee or memo, debit to amount out, credit to amount in. Some versions require separate files for debits and credits.
What if my Commonwealth Bank statement has multiple accounts on one PDF?+
The converter extracts all transaction tables it finds. If your PDF contains multiple accounts, the CSV will list all transactions sequentially. You can filter by balance column patterns or split the file in Excel based on account number references in descriptions before importing into accounting software.
Why use CSV instead of Excel or OFX for Commonwealth Bank statements?+
CSV is plain text, so it opens in any software without compatibility issues and works with custom scripts or database imports. Use CSV when you need maximum control over column mapping or when your accounting software does not support OFX or Excel imports. For QuickBooks or dedicated bank feeds, OFX is faster; for quick analysis, Excel is more convenient.