Convert Westpac statement PDFs to Excel, Xero and CSV.
Xero, MYOB, Excel files from the PDF.
Westpac eStatements are ordinary unprotected PDFs. Online Banking has a proper export under Overview, then Exports and reports: Export CSV, QBO, QIF, OFX file, where you choose a date range, the accounts, the file format and the date format.
Drop your Westpac statement here
PDF, scan or photo. Up to 12 files at a time.
Not ready to upload your own? See a sample result
5 pages free, no account. Amounts stay in AUD.
Last updated
How to download a Westpac statement as a PDF
- In Westpac Online Banking go to Overview, then Statements.
- Select the account under Active accounts (closed accounts are listed separately).
- Enter a date range or pick a preset range, then select Search.
- Select Download PDF against the statement you want and save it.
- In the Westpac App, type Statements into the Smart Search bar, tap Statements (incl. closed accounts), choose the account and period, then tap the share icon to save or send the PDF.
Then drop the file above; several months of Westpac statements at once come back as one workbook.
Is the Westpac PDF password-protected?
Westpac eStatements are ordinary unprotected PDFs. Nothing needs removing before upload.
What Westpac statements look like
Date, Description, Debit, Credit, Balance; card purchases show the merchant and a "Card xx1234" suffix.
Current Westpac statements read Date, Transaction Description, Debit, Credit, Balance; older ones in a shelf of paper say Withdrawals, Deposits and Balance instead, and both are handled. Dates are dd/mm/yy. Card purchases show the merchant and location followed by a Card xx1234 marker, and a foreign purchase adds a second line with the original currency amount, which is merged into the description. Personal accounts are statemented monthly or half-yearly depending on the product, and a six-month statement on an everyday account can run past twenty pages. Business One statements often list fee lines separately at the end of the month.
Why not use Westpac's own export?
Online Banking has a proper export under Overview, then Exports and reports: Export CSV, QBO, QIF, OFX file, where you choose a date range, the accounts, the file format and the date format. The CSV carries a Balance column and is one of the tidier bank exports around. Transaction history online goes back about three years, though the app route (Download recent transactions) is limited to 30, 90 or 120 days or a custom range of up to 12 months. eStatements are kept for seven years, so for older periods, or when you need the official document rather than a data feed, download the statement PDF and convert that.
Where Westpac statements trip up converters
- Statements are commonly newest-first in the app export; rows are put in date order before reconciling.
Which software Westpac customers import into
Westpac customers most often import into Xero, MYOB, Excel.
- Tally XML. TallyPrime XML export: Receipt and Payment vouchers for Alt+O import, alongside Excel, CSV, QuickBooks and Xero.
- Non-expiring pack. $19 buys 100 pages that never expire, and no statement is charged more than 15 pages.
- API and email-in. REST API and email-in on every plan, including the free one.
- Your file. Deletion of your file starts when processing ends; results are kept 7 days with an account, 1 day without.
- Balance check. There is no per-bank template: every row is added up against the opening and closing balances printed on the statement, and a misread is flagged, not hidden. How the balance check works
Westpac questions
The app shows transactions newest first. Will the Excel file come out backwards?
No. The statement PDF itself is oldest to newest and the converter sorts by date before checking the running balance, so the output is always in chronological order regardless of how the app displayed things. If you have a Download recent transactions PDF from the app rather than a true statement, it converts too, but it has no opening balance line to check against.
Which is better for Xero: the Westpac OFX or the converted statement?
For the current month, the OFX or QBO export is fine and imports directly. For a backlog, or where Xero needs the same figures the accountant sees on the statement, convert the PDF to CSV and import that. The converted file has the balance on every row, which makes it easy to spot where a Xero feed dropped a day.
Do older Westpac statements with Withdrawals and Deposits headings still work?
Yes. The parser recognises both the older Withdrawals/Deposits/Balance heading set and the current Debit/Credit/Balance one, and maps them to the same debit and credit columns in the output.
How do I convert a Westpac statement PDF to Excel?
Download it from Westpac using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.
How many Westpac statements can I convert at once?
Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.