How to Convert Westpac Statements to CSV or Excel

Why Convert Westpac Statements?

Westpac is one of Australia's 'Big Four' banks and the country's oldest bank, founded in 1817. Serving over 13 million customers in Australia and New Zealand, Westpac provides transaction accounts, savings, home loans, and credit cards. Westpac PDF statements are regularly needed by customers for tax returns, loan applications, and bookkeeping. Westpac's statement format places transactions in a clean table, but the density of data — especially for business accounts — makes manual spreadsheet entry impractical. BankRead's AI extracts every transaction from Westpac PDFs and produces structured, categorized output.

Understanding the Westpac Statement Format

Westpac transaction account statements use a portrait PDF with transactions in a table showing Date, Narrative (description), Debit, Credit, and Balance. The header includes the BSB, account number, and statement period. Westpac credit card statements display an account summary followed by transaction details with Date, Description, and Amount. Westpac uses 'Narrative' as the column header for transaction descriptions, which is unique among Australian banks. All amounts are in AUD ($).

How to Convert with BankRead

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

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your Westpac 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 Westpac Statement PDF

1. Log in to Westpac Online Banking at westpac.com.au or use the Westpac Mobile Banking app.
2. Select the account from your accounts summary.
3. Click 'Statements' in the account options.
4. Select the statement period — Westpac stores eStatements for up to 7 years.
5. Click the download link to save the PDF to your device.

What Data Gets Extracted

BankRead extracts the following fields from your Westpac statement:

• Transaction date (DD/MM/YYYY, Australian format)
• Narrative / description (e.g., 'EFTPOS DEBIT BUNNINGS WAREHOUSE' or 'DIRECT CREDIT ATO REFUND')
• Debit amount (purchases, fees, direct debits)
• Credit amount (salary, refunds, transfers in)
• Running balance (AUD)
• AI-assigned category (e.g., Home Improvement, Salary, Utilities, Groceries)

Export Options

Once your Westpac 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 Westpac Statements

• Westpac uses 'Narrative' as the description column header rather than 'Description' — BankRead maps this correctly.
• EFTPOS and card purchase descriptions include the merchant name — BankRead preserves the full narrative for accurate categorization.
• Westpac credit card statements (Altitude, Low Rate, Mastercard) are supported alongside transaction accounts.
• Multi-page statements from active accounts are processed in a single upload.
• Westpac Business transaction account statements follow the same format as personal accounts.

Common Issues and Solutions

• Westpac's 'Narrative' field sometimes contains transaction codes and reference numbers alongside the merchant name. BankRead extracts the full narrative text and uses AI to identify the merchant for categorization.
• Westpac's 'Interest Paid/Charged Summary' at the end of statements is aggregate data and not duplicated as individual transactions.
• Westpac Choice, Life, and 55+ account statements all use the same format and are handled identically.

Frequently Asked Questions