Convert Commonwealth Bank Statements to Excel

Upload your Commonwealth Bank PDF statement to the converter, and it extracts transaction dates, descriptions, debits, credits, and running balances into an Excel workbook. Download the .xlsx file and open it in Microsoft Excel, Google Sheets, or LibreOffice Calc for analysis, reconciliation, and reporting.

The converter handles both digitally generated and scanned Commonwealth Bank statements. It recognises transaction tables, separates debit and credit columns, and preserves the chronological order of entries. You get a clean spreadsheet ready for pivot tables, formulas, and accounting workflows without manual retyping.

How Do I Convert a Commonwealth Bank Statement to Excel?

1. Download your statement PDF from CommBank NetBank or the CommBank app under Statements & documents.
2. Go to BankStmtConverter.com and upload the PDF file.
3. The converter extracts transaction date, description, debit, credit, and balance columns.
4. Download the Excel workbook (.xlsx format).
5. Open the file in Excel, Google Sheets, or another spreadsheet application.

The process takes under 30 seconds for most statements. Multi-page PDFs are concatenated into a single worksheet with all transactions in date order.

What Data Gets Extracted from Commonwealth Bank Statements?

The converter captures the transaction table columns printed on Commonwealth Bank statements:

• Transaction date — the date the transaction was processed, formatted as DD/MM/YYYY.
• Description — payee name, reference text, or transaction narrative as shown on the statement.
• Debit — amounts withdrawn or paid out, shown as positive numbers in a dedicated column.
• Credit — deposits and incoming transfers, shown as positive numbers in a separate column.
• Balance — the account balance after each transaction, carrying forward line by line.

The Excel output preserves these columns with headers in row 1. The balance column matches the printed closing balance on your statement, which the converter cross-checks during extraction to confirm accuracy.

Working with Commonwealth Bank Statements in Excel

Once you have the workbook open, Excel becomes a reconciliation and reporting workspace. The transaction table sits in a single worksheet, with each row representing one transaction and columns locked to consistent data types—dates as dates, amounts as numbers.

Filter the description column to isolate specific payees or transaction types. Click the dropdown arrow in the header, type a keyword like "Woolworths" or "salary", and Excel shows only matching rows. Sort by the debit column to list your largest expenses at the top, or by transaction date to review activity in a custom date range.

Create a monthly spending summary with a pivot table. Select your data range, go to Insert > PivotTable, drag Transaction Date to Rows (grouped by month), and Debit to Values (sum). You see total outgoings per month in seconds. Add Description to Rows under the date grouping to break down spending by payee within each month.

Reconcile against receipts or invoices using =SUMIF() formulas. If you track expected payments in a separate column, write =SUMIF(B:B,"*supplier name*",C:C) to total all debits matching that supplier in the description column. Compare the result to your invoice register to catch missing or duplicate payments.

Use conditional formatting to highlight transactions above a threshold. Select the debit column, go to Home > Conditional Formatting > Highlight Cells Rules > Greater Than, and enter an amount like 500. Large debits turn red, making it easier to review significant expenses during month-end close.

Export subsets as new files. Filter the data to a specific date range or payee list, copy the visible rows, paste into a new workbook, and save. Send the filtered extract to a client or auditor without exposing your full transaction history.

Does the Converter Work with Scanned Commonwealth Bank Statements?

Yes. If you scan a paper statement or photograph it with your phone and save as PDF, the converter applies OCR to recognise printed text in the image. It extracts transaction rows, separates columns, and converts amounts into numbers.

The system cross-checks the extracted opening and closing balances against the statement header and footer. If the sum of credits minus debits plus the opening balance matches the printed closing balance, you know the OCR read every transaction. Discrepancies trigger a warning so you can review the output before relying on it.

Image quality matters: use at least 300 DPI for scans and ensure good lighting for photos. The converter handles slight skew and common imperfections, but blurry or low-contrast images reduce accuracy.

Example: Commonwealth Bank Transactions in Excel

A converted statement might look like this in the spreadsheet:

Each amount is a number, so you can sum debits with =SUM(C2:C6) or calculate the average credit with =AVERAGE(D2:D6). The balance column updates row by row, matching the statement's printed figures.

Manual Retyping vs PDF Export vs Converter

Commonwealth Bank NetBank does not offer a native Excel export for transaction history at the statement level, so manual transcription or a converter are the main routes to spreadsheet format.

Data Privacy and File Deletion

Your uploaded PDF is processed on secure servers and deleted immediately after conversion. Files are not stored, shared with third parties, or used to train machine-learning models. The service extracts transaction data in memory, generates the Excel file, and purges the original PDF once you download the output.

No registration or email address is required for conversion. You upload anonymously, and the system does not log account numbers or personally identifiable details beyond what appears in the statement description text (which you control when you download).

Internal Links to Other Formats

If you need Commonwealth Bank transactions in a different format, try the Commonwealth Bank statement to CSV converter for plain-text import into custom scripts, or the Commonwealth Bank statement to Xero converter for direct reconciliation in Xero's bank statement import screen. For QuickBooks Desktop users, the Commonwealth Bank statement to QuickBooks converter produces .qbo files compatible with Web Connect import. The Commonwealth Bank statement to OFX converter generates OFX files for apps like MYOB and MoneyWorks. Browse all supported Australian banks on the Australia banks page.