Westpac Statement to CSV: Export, Convert, Reconcile

Someone has asked you for Westpac transactions in a spreadsheet, and "roughly right" will not do. It might be a mortgage broker wanting six months of a transaction account, an accountant assembling a BAS, a tax return that needs the year reconstructed, or a closed account you can no longer log in to.

Westpac is more generous than most banks here: Online Banking will hand you a machine-readable file directly. But that route has edges, and the moment you fall off one of them you are holding a PDF eStatement instead. This post covers both paths, the Westpac layout details that break naive converters, and how to prove your CSV matches the statement to the cent.

Quick answer

There are two ways to get Westpac transactions into CSV.

1. Westpac's own export. Online Banking on desktop offers four file types — CSV, QBO, QIF and OFX — over a date range you choose. This is the cleanest option when you have login access to a live account and the period you need is still on screen.
2. Convert the eStatement PDF. For older periods, closed accounts, statements a client or an ex-partner sent you, or anything you only have as an emailed or downloaded document, the data lives in a PDF. Upload it to a converter like BankStatementKit, which extracts the transactions and balance-checks the result against the statement's own printed totals.

Rule of thumb: if you can log in and the period is still exportable, take Westpac's file. Everything else goes through the PDF.

Convert a Westpac eStatement to verified CSV

Option 1: Westpac's built-in transaction export

If you have Online Banking access, start here — the data comes straight from the bank.

1. Log in to Westpac Online Banking on a desktop browser.
2. From Overview, select Exports and reports.
3. In the Transactions section, choose the option to export a CSV, QBO, QIF or OFX file.
4. Set a date range, select the account or accounts, and pick a file format and a date format.
5. Select Export and open the file in Excel or Google Sheets.

Two things to note. QBO and OFX are only offered when you export a single account, so a multi-account pull has to be CSV or QIF. And on the mobile app the equivalent is narrower: search Recent transactions, tap the download option, choose an account and a transaction period.

Where the built-in download stops

The export is genuinely good, and it still runs out in predictable ways:

• It needs a live login. A closed account, a business you no longer have access to, or a statement someone emailed you leaves no session to export from.
• Statements go back further than the export. Westpac keeps around seven years of statement history online, including for eligible closed accounts. Transaction exports are bounded by what Online Banking will still show you as transactions.
• The export is not the statement. A CSV you generated is a report you made; a stamped eStatement PDF is the document a lender or auditor asked for. When they want the statement, the statement is what you must convert.
• Format mismatch. QIF and OFX suit accounting packages, not analysis. If your destination is a spreadsheet or a data tool, only the CSV is useful, and it may still need column mapping.
• Third-party PDFs. Broker files, share-house reimbursements, discovery bundles — none of those arrive as CSV.

Each of those ends in the same place: a PDF.

Option 2: Convert the Westpac PDF statement to CSV

1. Download the eStatement PDF from Online Banking, or use the one you were sent.
2. Upload it. The file is processed in memory and never stored; if it happens to be password-protected, supply the password at upload and it is unlocked in memory too.
3. The transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance.
4. Check the verification label, then download the CSV.

Uploads are capped at 20MB or 50 pages, which comfortably covers a year of a busy transaction account. Scanned or photographed statements fall back to OCR automatically.

Turn a Westpac PDF into a spreadsheet

Why Westpac PDFs trip up generic converters

The description column wraps. Westpac's narrative text carries merchant name, location, card reference and payment method, and on a statement-width page one transaction routinely spills onto two or three printed lines. A converter that reads line by line emits phantom rows with a description and no amount, and your row count silently inflates. Rows have to be assembled around the date and amount columns, with continuation lines folded back into the transaction above.

Debit and credit are separate columns, not one signed number. The statement prints the amount in one of two columns depending on direction. Collapse them carelessly — or map them the way you would map an export that uses a single signed amount — and every debit in the file flips sign. Nothing errors; the file simply reconciles to the wrong number.

Header and footer furniture looks like data. The BSB and account number block, the statement period, the running page totals and the product disclosure text at the foot of the page all sit in the same coordinate space as the table. Anything that treats "text with numbers in it" as a transaction will pull those in.

Prove the CSV matches the statement

This is the step people skip, and it is the one that matters. A Westpac statement gives you two independent checks.

1. The running balance chain. Each row prints a balance. For every row, the previous balance minus the debit plus the credit must equal the printed balance. One dropped, duplicated or sign-flipped row breaks the chain at precisely the row where it went wrong, which makes the error findable rather than mysterious.
2. The opening and closing balances. The statement brackets the period with an opening balance and a closing balance, with total credits and total debits alongside. Opening + total credits − total debits must equal closing, and your CSV's summed columns must match those totals.

By hand that is ten or fifteen minutes per statement, and it is tedious enough that most people do it once and then stop. BankStatementKit runs both checks on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy pointing at the row where the numbers stop reconciling. More on the layout specifics on the Westpac statement converter page.

FAQ

The bottom line

Westpac gives you a real export, so use it when you can — CSV, QIF, QBO or OFX straight out of Online Banking beats any conversion. The moment the period is too old, the account is closed, or someone hands you the statement rather than the data, you are converting a PDF, and that is exactly where wrapped narratives and split debit/credit columns hide silent errors. Convert it, then check it against the statement's own totals.