NAB CLASSIC BANKING · RECURRING AUTHORITIES
nab bank statement example
A NAB statement is an Australian-dollar document where BPAY biller codes, direct debits and card activity sit in one list. Telling a recurring authority from a one-off payment is the distinction that most affects a budget built from the data. The nab bank statement example below is an invented Classic Banking month in which two direct debits recur from last month and one BPAY payment is a one-off, which matters for any budget built from it.
Recurring authorities versus one-off payments
A direct debit is an authority you granted an organisation to collect, and it will repeat until cancelled. A one-off BPAY payment is a single instruction you issued. Both can be to the same payee, and on the statement they can look similar. For budgeting the difference is the whole point: one is a standing commitment and the other is a discretionary act.
Build the list of recurring authorities once, then treat anything not on it as a one-off until proven otherwise. Reviewing three consecutive statements is usually enough to establish the list.
BPAY biller codes identify the organisation
A BPAY payment carries a numeric biller code for the organisation and a customer reference for your account with them. Where you pay several bills to the same provider — two energy accounts, two insurance policies — the reference is the only field that distinguishes them.
Both fields are numeric in appearance and both must be stored as text, or the reference will lose leading zeros and become unmatched to any bill.
BSB, account number and leading zeros
The BSB is six digits and frequently starts with a zero. Imported as a number it becomes five digits and identifies nothing. This is not an edge case; it is the default behaviour of most spreadsheets and the most common data loss in Australian statement conversion.
Set the column to text before the first row is read. Reformatting a column that has already been converted does not bring the zero back.
Card activity and posting dates
Card purchases post after authorisation, typically within a few business days. A purchase made just before the statement closed can therefore land in the next period. The posting date is the date the balance moved and is what the reconciliation uses.
If your expense reporting needs the purchase date, add it as a second column rather than replacing the bank's date.
Closing the NAB month
Everything in and out across the month must bridge the figure it opened with and the one it closed with. Track the printed balance against your own as you descend the page, and the first disagreement names the offending row for you.
Check the transaction count alongside the totals; two offsetting errors can leave a total looking correct while the detail is wrong.
Downloading the NAB statement
Save each period from your own NAB banking before any conversion starts. Keep the BSB, account number and period with the extracted data.
The issued PDF is the record a third party will accept; the spreadsheet is for your own analysis.
Recurring authorities in this nab bank statement example
The recurring-authority row is the one that most changes how a budget built from this data behaves.
| Field | Why it matters here |
|---|---|
| BSB field | Six digits that frequently open with a zero; text only |
| Account number | Recorded beside the BSB, also as text |
| Statement period | The month this document is answerable for |
| Opening balance | The figure the account carried into the month |
| Direct debits | Recurring authorities; list them once |
| BPAY biller code and reference | Organisation and your account with them |
| Closing balance | A$1,893.97 on the specimen |
A NAB dataset is dependable when:
- The BSB column was text before import, not corrected afterwards
- Recurring authorities were distinguished from one-off payments
- BPAY references kept their leading zeros
Bill payments in markets without BPAY
A statement without BPAY uses entirely different bill-payment conventions, which is instructive. Industry documentation for Australian payments comes from AusPayNet, the Australian payments industry body.
The real PDF belongs in the Excel converter or the CSV converter; the extraction guide covers what to confirm.
NAB bank statement example: recurring debits and BSBs
How do I tell a direct debit from a one-off payment?
A direct debit repeats under an authority you granted. Reviewing three consecutive statements establishes which payees recur.
Why does my NAB BSB show as 83001 in Excel?
NAB BSBs start with 08, and the leading zero was dropped when the column became a number. Import BSB and account number as text so 083-001 survives.
Why does the same biller appear twice?
You may hold two accounts with them. The customer reference is what distinguishes the payments.
Why is my purchase on the next statement?
It settled after this period closed, so the balance moved in the next one.
How do I spot a direct debit that should have been cancelled?
List last month's recurring debits, then look for the same payee this month. One you no longer recognise is worth querying with the payee first and then with NAB.