AU
About Westpac statements
Westpac is one of Australia's big four banks and one of the oldest companies in the country. You grab the statement PDF from Westpac Online Banking or the app, under Statements — same as you would for any branch-based account.
A Westpac statement carries Osko and PayID receipt numbers in the description, across Date, Description, Debit, Credit and Balance columns. That's exactly the detail that gets scrambled when you paste a PDF into a spreadsheet, and exactly what the converter preserves, column by column.
Currency stays AUD (Australian dollars) and the DD/MM/YYYY dates carry straight through, exactly as they appear on the statement. Scanned or photographed PDFs work too: OCR reads them into the same columns, and the running balance is checked before anything downloads.
What lands in QuickBooks is a clean, checked file — so the only thing left is the reconciling you'd do anyway.
Why people convert Westpac to QuickBooks
When you're cleaning up QuickBooks or taking on a new client, there are usually Westpac months with no feed behind them. A converted file fills those in under Upload from file, instead of keying each transaction.
It also saves the back-and-forth at year end. Instead of asking a client for a CSV their Westpac login may not even offer, you take the PDF they already have and convert it, so the numbers in QuickBooks match the statement line for line.
Import a Westpac statement into QuickBooks
QuickBooks Online takes a CSV; QuickBooks Desktop takes a .qbo Web Connect file.
- Convert the PDF above. For QuickBooks Online download the QuickBooks CSV; for Desktop download the QBO.
- QuickBooks Online: Banking → Bank transactions → Link account → Upload from file.
- Pick the CSV, map Date / Description / Amount, choose the account, and import.
- QuickBooks Desktop: File → Utilities → Import → Web Connect Files, then select the .qbo.
infoOne honest caveat
The QBO file carries a placeholder bank id, so QuickBooks Desktop can reject it with an OL-301 error ("not a participating financial institution") until you set your own bank's id. For a reliable import, use the QuickBooks CSV in QuickBooks Online instead — we don't claim the QBO will import everywhere.
The totals are checked first
The totals are checked before you download. If a row is missing, the statement gets flagged right here — so a gap shows up before it reaches QuickBooks or your client, not after.
Frequently asked questions
Does this go straight into QuickBooks?expand_more
In QuickBooks Online the CSV imports cleanly under Banking → Upload from file. The Desktop QBO can hit an OL-301 error ("not a participating financial institution") until you set your own bank's id — so for Online, stick with the CSV.
What does a Westpac statement look like?expand_more
A Westpac statement carries Osko and PayID receipt numbers in the description, across Date, Description, Debit, Credit and Balance columns. The converter reads each of those into its own column, so the QuickBooks-ready file imports into QuickBooks cleanly.
Where do I download the Westpac statement?expand_more
From Westpac Online Banking or the app, under Statements. Save the PDF, then drop it into the converter above — multi-page and multi-month statements are read in one go.
Does it work on a scanned Westpac statement?expand_more
Yes. Scanned or photographed PDFs are read with OCR into the same columns, and the balance check still runs, so a scan converts the same as a digital download.
What does it cost to start?expand_more
Converting is free to start. Excel, CSV and JSON download with no login; the QuickBooks file needs a free sign-in.