Convert Westpac statements to Excel or CSV

'Exports and reports' in Westpac Online Banking already offers CSV, QBO, QIF and OFX files, so why convert a statement? Usually because the account is closed, someone sent you statements rather than login access, or you need the opening and closing balances to reconcile against. This page covers those cases and how the PDFs come out as Excel or CSV.

Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $9 up to 25 pages, priced by page count above that. No subscription.

Several statements? Drop up to 100 at once: one payment for all of them, priced by their total pages.

See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Westpac statement into Excel

  1. Download the PDF statement from Westpac online banking

    • Sign in to Westpac Online Banking or the Westpac App.
    • In Online Banking, go to 'Overview' and then 'Statements' and select an account under 'Active accounts'; in the app, search 'Statements' in the Smart Search bar and tap 'Statements (incl. closed accounts)'.
    • Enter a date range or pick a pre-set range, select 'Search', and select 'Download PDF' (in the app, tap the statement period and the share icon).
    • Save the statement for the period you need as a PDF.
    Go to Westpac Online Banking
  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Westpac statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · AUD
Sample bank statement rows with made-up data, amounts in AUD
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Westpac statements

Closed accounts stay visible

Online Banking shows up to seven years of statement history, closed accounts included. That helps when you're winding up an estate or reviewing an old business account. Those statements are PDFs, so converting them is how you get the transactions into a spreadsheet without retyping.

QBO and OFX need one account

If you do use the bank's own export, QBO and OFX files need a single account selected. For one-off periods, or for accounts you can't log in to, the converted statement gives you a Xero-ready or QuickBooks-ready CSV instead.

Statements by date range

The statement search returns whatever date range you ask for. Run two searches with overlapping ranges and you can easily save the same statement twice. When duplicate or overlapping periods turn up in an upload, they are flagged before you export.

Descriptions on two lines

Card purchase details on Westpac statements often wrap onto a second line. The conversion joins them into one description and gives each transaction a single signed amount, with money out shown as a negative figure.

Output and review

From Westpac PDF to your books

Accounting tip

Westpac's export already offers QBO for QuickBooks, and OFX or QIF for MYOB, which imports those formats but not CSV. For closed accounts or statements you were sent, use the Xero-ready CSV in Xero, or the three-column QuickBooks-ready CSV in QuickBooks Online.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

    Files for QuickBooks Online

    Files for Xero

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Westpac statement questions

Can I get statements for a closed Westpac account?
Yes. Up to seven years of statement history, closed accounts included, is available in Online Banking and the app. Download the PDFs for the periods you need and upload them here. Any gaps between the statements you've collected are flagged, which is useful when an estate needs a complete record.
Should I use Westpac's export or convert the statement?
If you have access and need recent transactions, the bank's export is quick. Statements win when the account is closed, when someone else downloaded the period for you, or when you want the opening and closing balances, which let the converter confirm every transaction was captured.
Can I import converted Westpac rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Westpac statement to Excel

Page 1 free, no sign-up to see it; just an email to download.

pdf2text is independent and not affiliated with or endorsed by Westpac.