Convert Commonwealth Bank Statements to Xero

Upload your Commonwealth Bank PDF statement to BankStmtConverter, and the tool extracts every transaction with its date, description, debit, credit, and balance into a CSV file formatted for Xero's bank statement import. Download the file and upload it through Xero's Reconcile screen to see your transactions ready for matching.

Xero requires a specific CSV structure with headers and date formats it recognises. Commonwealth Bank statements use DD/MM/YYYY dates, which Xero accepts for Australian accounts, and the converter maps the statement's columns—transaction date, description, debit (money out), credit (money in), and running balance—into the exact layout Xero expects. You avoid manual retyping and column-alignment errors that break imports.

How do I convert a Commonwealth Bank statement to Xero format?

1. Download your Commonwealth Bank statement as a PDF from NetBank (Account Details > Statements, select date range and download).
2. Go to BankStmtConverter's Commonwealth Bank to Xero converter and upload the PDF.
3. The tool parses every transaction line, extracting date, description, debit, credit, and balance, and writes them into a Xero-compatible CSV.
4. Download the CSV file to your computer.
5. In Xero, open the Reconcile screen (Accounting > Bank Accounts > select your Commonwealth account > Import a Statement).
6. Upload the CSV file; Xero reads the headers, loads the transactions, and displays them in the reconciliation feed.
7. Match transactions to invoices, bills, or create new transactions as needed.

What data gets extracted from Commonwealth Bank statements?

Commonwealth Bank statements list each transaction with a date, description, debit amount (withdrawals and payments), credit amount (deposits and transfers in), and a running balance after each entry. The converter captures all five fields. Transaction descriptions include payee names, transfer references, card merchant names, and direct-debit narrations exactly as printed on the statement. Value dates and posting dates both appear on some statement formats; the converter uses the transaction date that determines the balance calculation. The running balance column lets the tool verify extraction accuracy: the final extracted balance must match the statement's closing balance.

Using the Xero CSV in your reconciliation workflow

Xero's bank statement import accepts CSV files with specific column headers: *Date*, *Amount*, *Payee*, *Description*, and *Reference* are common, though Xero is flexible with header names as long as it can infer date and amount columns. The converter outputs Date, Description, Debit, Credit, and Balance columns. When you upload the file, Xero's import wizard lets you confirm column mappings; map Date to the date field, and either combine Debit/Credit into a single signed Amount column or let Xero handle them separately (debits as negative, credits as positive).

Once imported, transactions appear in the Reconcile screen's bank statement lines section, sitting above your existing bank feed or manual entries. Xero attempts automatic matching: if an invoice for $1,200.00 exists and a credit line for $1,200.00 appears on the same date with a matching reference, Xero suggests the match. You click OK to reconcile, or Create if the transaction is new spending (Xero opens a spend-money form pre-filled with date, amount, and payee). The Description field from your Commonwealth statement helps you identify unclear transactions—card payments show merchant names, transfers show recipient account nicknames.

For multi-month reconciliations, import one statement CSV at a time in chronological order. Xero warns you if a statement period overlaps existing imported transactions, preventing duplicates. The Balance column in the CSV is ignored by Xero during import (Xero calculates its own running balance), but the converter uses it internally to validate extraction accuracy before you download.

Does it work with scanned or photographed Commonwealth Bank statements?

Yes. If you receive a paper Commonwealth Bank statement and scan it as a PDF, or photograph it and save the image as PDF, the converter's OCR engine reads the text from the image. It handles common scanning artefacts: slight skew, shadows along the page fold, and variable image quality. The tool extracts transaction rows and cross-checks the final balance against the printed closing balance on the statement. If totals match, the data is accurate enough for Xero import. Scanned statements take 10-15 seconds longer to process than digital PDFs, but output the same CSV structure.

Privacy and data deletion

Your Commonwealth Bank statement is processed on BankStmtConverter's server and deleted immediately after you download the CSV. Files are not stored, shared, or used to train models. The conversion happens in isolated processing: your PDF goes in, transaction data is extracted and formatted, the CSV is generated, and both the original PDF and any intermediate data are wiped within seconds. No login is required, so no file is associated with an account.

Comparison: manual entry vs bank export vs converter

NetBank offers CSV export for most account types, which you can import into Xero directly. The converter is useful when you only have the PDF (archived statements, accounts where CSV export is unavailable, or statements from a business banking portal that generates PDF-only reports), or when you need to handle scanned paper statements that you cannot export digitally.

Worked example: Commonwealth Bank statement to Xero CSV

A Commonwealth Bank business-account statement shows these transactions for three days in May:

• 02/05/2024 — EFTPOS Purchase Officeworks Sydney — Debit $347.50 — Balance $12,840.30
• 03/05/2024 — Direct Credit INV-1034 ACME PTY LTD — Credit $2,400.00 — Balance $15,240.30
• 03/05/2024 — Direct Debit Telstra Business — Debit $189.00 — Balance $15,051.30
• 05/05/2024 — Bank Fee Monthly Account Fee — Debit $10.00 — Balance $15,041.30

The converter produces a CSV with these rows:

You upload this CSV into Xero. The $2,400.00 credit matches an unpaid invoice for ACME Pty Ltd, and Xero suggests reconciling them. The Officeworks debit becomes a new spend-money transaction coded to Office Supplies. The Telstra debit matches a recurring bill, and the bank fee is coded to Bank Fees. Four transactions reconciled in under a minute.

When to use Xero format instead of other outputs

Choose Xero CSV when you reconcile Commonwealth Bank accounts in Xero and need to import historical statements or handle accounts without live bank feeds. For general-purpose analysis, the Commonwealth Bank to Excel converter gives you pivot tables and formulas for reporting. If you import into MYOB or another tool that prefers generic CSV, the Commonwealth Bank to CSV converter outputs plain transaction rows without Xero-specific headers. For QuickBooks users, the Commonwealth Bank to QuickBooks converter produces QBO files for Web Connect import. More Australian banks are supported on the Australia banks page.

Edge cases: multi-page statements and opening balances

Commonwealth Bank statements for active business accounts often run 10-20 pages. The converter processes every page in sequence, extracting transactions in chronological order and preserving the running balance across page breaks. If the statement includes an opening balance line and a closing balance summary, the tool checks that the first transaction's starting balance and the last transaction's ending balance match those printed figures. Discrepancies (rare, usually from partial-page scans) trigger a warning so you can review the CSV before importing into Xero.