WESTPAC · BSB, BPAY AND OSKO
westpac bank statement example
A Westpac statement is an Australian-dollar record identified by BSB and account number, and its activity list mixes BPAY, direct debits, card purchases and PayID transfers. Each describes itself differently and needs reading on its own terms. The westpac bank statement example below is an invented Choice everyday account month in Australian dollars, with a BSB that starts with a zero, a BPAY payment and an Osko transfer to a mobile-number PayID.
Download an authentic Westpac statement
In Online Banking, open Overview, then Statements; choose an account and period, then Download PDF.
BSB and account number identify the account
Australian accounts are identified by a six-digit BSB, which encodes the institution and branch, plus the account number. The BSB has a leading-zero problem built in: many begin with zero, and any spreadsheet that treats the field as numeric will silently drop it, producing a five-digit value that identifies nothing.
Store the BSB as text, with the account number, in the header of your extraction. Both belong with the data, not just in the PDF you downloaded it from.
BPAY payments carry a biller code and reference
A BPAY payment to a utility, insurer or government body carries a biller code identifying the organisation and a customer reference identifying your account with them. Both are numeric and both matter: the biller code tells you who was paid, the reference tells you which of your accounts with them it was applied to.
Keep them as text. A BPAY reference converted to a number is no longer usable for matching against a bill.
PayID and Osko transfers settle fast
Transfers through the New Payments Platform settle quickly and may identify the counterparty by a PayID such as a phone number or email address rather than by BSB and account number. The description therefore looks different from a traditional transfer and may carry a short message from the sender.
Capture the full description including any message; it is often the only record of what the payment was for.
Direct debits and card activity
Direct debits recur under arrangements you granted, with amounts that can vary. Card purchases post after authorisation, so late-period purchases can fall into the next statement. Both are ordinary, and both produce apparent discrepancies for someone reconciling from memory rather than from printed dates.
Build the list of recurring direct debits once and check it against each later statement; a missing one indicates a cancelled arrangement.
Closing the period in Australian dollars
In Australian dollars, the activity must carry the opening figure onto the closing one. Rebuild the balance column from the top and halt the moment yours parts company with the printed one; that line, and no other, is where the fault sits.
Australian statements commonly print the balance after each transaction, which makes this check both available and fast.
Getting the document
Choose the account and period inside your own Westpac banking. Keep the BSB, account number and period with the file.
The issued PDF is the record; any spreadsheet built from it is a working copy for your own analysis.
Identifiers underpinning this westpac bank statement example
The BSB heads this list because it is the field most frequently destroyed between the PDF and the spreadsheet.
| Field | Why it matters here |
|---|---|
| BSB | Six digits, often with a leading zero; text only |
| Account number | Stored with the BSB as text |
| Statement period | 17 Aug to 16 Sep on the specimen |
| Opening balance | Carried forward from the previous document |
| BPAY biller code and reference | Who was paid and against which of your accounts |
| PayID and Osko transfers | Fast settlement; the counterparty may be a mobile number |
| Closing balance | The endpoint the arithmetic has to reach |
After turning CR into a sign, the Westpac file is ready if:
- The BSB kept its leading zero through import
- BPAY biller codes and references were stored as text
- The balance column you rebuild follows the printed one exactly
BSB-based identification against other systems
Markets that identify accounts differently avoid the leading-zero trap entirely. Australian payment industry material is published by AusPayNet, the Australian payments industry body.
Pass the issued statement to the Excel converter or the CSV converter; the extraction guide sets out the verification.
Westpac bank statement example: CR balances and BSBs
Why did my Westpac BSB lose a digit in Excel?
Westpac BSBs begin with 03 or 73, and a spreadsheet drops the leading zero when it reads the column as a number. Import the BSB column as text, or retype it as 032-xxx afterwards.
What is a BPAY biller code?
A numeric code identifying the organisation you paid. The accompanying reference identifies your account with them.
What is PayID?
An identifier such as a phone number or email used to address a fast payment, instead of BSB and account number.
Why is a card purchase on the following statement?
Settlement fell outside this window, so the movement belongs to the following document.
What does CR after the balance mean?
The account is in credit — you hold the money. DR would mean the account is overdrawn. Strip the suffix into a sign when you import, rather than leaving it in the number.