# Australian Bank Statement to Excel: Dates and BSB Lines

- Author: FastBankConvert (https://www.fastbankconvert.com)
- Published: 2026-01-22
- Updated: 2026-01-22
- Category: Bank statements to Excel and CSV
- Canonical: https://www.fastbankconvert.com/blog/australian-bank-statement-to-excel

> Convert an Australian bank statement to Excel: day-first dates, BSB and account lines, Osko and BPAY descriptions, and credit or debit columns.
To convert an Australian bank statement to Excel, turn the PDF into rows, read every date as day, month, year, and combine the Credit and Debit columns into one signed amount. Keep the BSB and account number from the header as columns, not rows, then tag Osko, PayID and BPAY lines so payments are easy to group and check.

## Day-first dates on an Australian bank statement

Australian statements write dates day first, so 04/05/2026 is 4 May. Excel set to a US region reads the same text as 5 April, and anything above 12 in the first position stays as text. The fix is to tell Excel the order at import, or rebuild each date from its day, month and year.

### Text to Columns with a date order

If the converted dates sit in one column as text, select the column, choose Data, Text to Columns, pick Delimited, click through to the last step, choose Date and set the order to DMY. Excel then reads each value as day, month, year regardless of the computer's region. This works on a whole column in one pass and needs no helper formula.

### Short dates without a year

Many statements print `04 May` with the year only in the statement period. Add the year from the header, and take extra care on a statement that runs across 1 January, where early-January rows belong to the following year. Sorting the finished column is the quickest check: a statement for one period should not spread across two years unless its period does.

### Choosing a display format

Show the finished dates as yyyy-mm-dd or as `d mmm yyyy`. Both are unambiguous to anyone who opens the file, whether they work in Sydney or Seattle.

## Credit and debit columns on Australian statements

Australian statements commonly print a Debit column for money out and a Credit column for money in, with a running balance beside them. Some print a single amount with a minus sign or a CR or DR marker instead. Either layout becomes one signed column in Excel: credits positive, debits negative.

### Two columns into one

With Debit in C and Credit in D, a formula of `=N(D2)-N(C2)` in a new column gives a signed amount for each row. N treats an empty cell as zero, so rows with one figure need no special handling.

### Balances marked CR or DR

The balance column may read `2,410.55 CR` for money in the account and `85.10 DR` for an overdrawn or owing balance, depending on the bank. Convert those to plain numbers: CR stays positive, DR becomes negative. Once the balances are numbers, the opening balance plus the signed amounts should reproduce each printed balance in turn.

### Transaction totals at the foot of the statement

Many statements close with totals for credits and debits over the period. After merging the columns, use SUMIF on the signed column, once for values above zero and once for values below, and compare both figures with those totals. A mismatch on one side tells you whether a missing row was money in or money out.

## BSB and account number lines in an Australian statement

A BSB, short for Bank-State-Branch, identifies the financial institution and branch that hold an account. The [BSB system is administered by AusPayNet](https://auspaynet.com.au/node/717) for Australian financial institutions. On a statement, the BSB and account number sit in the header, and sometimes again in transfer descriptions.

### Header lines are not transactions

The header BSB and account number describe the whole statement, so they belong in columns repeated on every row, not as rows of their own. Add a BSB column and an Account column, fill them from the header, and the rows from several accounts can share one workbook without confusion.

### BSBs inside descriptions

A transfer description may include the other party's BSB and account number, for example `TRANSFER TO 062-000 12345678` as an invented example. Keep those digits as text, not numbers. Excel would otherwise drop leading zeros or read the hyphenated BSB as a subtraction or a date. Format the column as Text before pasting, or prefix the value with an apostrophe.

### More than one account in a single file

If you hold an everyday account and a savings account at the same bank, the PDF may cover both, each with its own BSB and account line followed by its own transactions. Fill the Account column from whichever header line sits above each block, so every row carries the account it belongs to. Then filter by Account before running any balance check, because the two accounts have separate opening and closing figures and will never tie as one list.

### Privacy when sharing the file

A sheet full of BSBs and account numbers is sensitive. If you send the workbook to someone, consider masking all but the last few digits of your own account number in the header columns.

## What do Osko, PayID and BPAY mean in Australian statement descriptions?

Osko, PayID and BPAY are payment services whose names often appear in Australian statement descriptions. Osko and PayID run on the New Payments Platform, used for fast transfers between accounts. BPAY is a bill payment service that uses a biller code and a customer reference number from the bill.

### The fast payment names

The [NPP Australia page on Australian Payments Plus](https://www.auspayplus.com.au/brands/nppa) describes Osko as the service enabling real-time payments between bank accounts, and PayID as a way to send and receive money using a mobile number, email address, ABN or organisation identifier instead of a BSB and account number. So a line mentioning PayID may show a phone number or email where you would expect account details.

### BPAY bills

The [BPAY page on Australian Payments Plus](https://www.auspayplus.com.au/solutions/bpay) says you use the Biller Code and your Customer Reference Number from your bill to pay in online banking. On a statement, a BPAY line therefore often carries those two numbers, which makes it easy to match a payment to a specific bill.

### Other common words

Descriptions may also include EFTPOS or Visa Debit for card purchases, Direct Credit for incoming payments such as wages, and Direct Debit for collections. The [guide to bank statement transaction codes](/blog/bank-statement-transaction-codes) covers abbreviations used more widely.

## Can you pull the BPAY biller and reference out of an Australian description?

Yes, as long as your bank prints them in a consistent pattern. A short set of formulas, or Flash Fill, can lift the payment type, the payee or biller and the reference into separate columns. Then a filter on Type shows every BPAY bill, and a SUMIFS totals each biller across the year.

### A worked example

These five rows are examples with invented names, numbers and amounts, shown after cleaning.

| Date | Raw description | Type | Payee or biller | Reference | Amount |
| --- | --- | --- | --- | --- | --- |
| 2026-05-01 | DIRECT CREDIT EXAMPLE PTY LTD PAYROLL | Direct Credit | EXAMPLE PTY LTD | PAYROLL | 2,840.00 |
| 2026-05-03 | EFTPOS CORNER BAKERY | EFTPOS | CORNER BAKERY | | -12.50 |
| 2026-05-06 | BPAY EXAMPLE WATER 12345 REF 99887766 | BPAY | EXAMPLE WATER | 99887766 | -148.20 |
| 2026-05-10 | OSKO PAYMENT TO A NGUYEN DINNER | Osko | A NGUYEN | DINNER | -45.00 |
| 2026-05-21 | TRANSFER TO 062-000 12345678 SAVINGS | Transfer | SAVINGS | 062-000 12345678 | -500.00 |

### The formulas

With the raw description in B2, a Type can be found by testing for each keyword:

```
=IFS(ISNUMBER(SEARCH("BPAY",B2)),"BPAY", ISNUMBER(SEARCH("OSKO",B2)),"Osko", ISNUMBER(SEARCH("EFTPOS",B2)),"EFTPOS", ISNUMBER(SEARCH("TRANSFER",B2)),"Transfer", TRUE,"Other")
```

For the BPAY reference, the text after `REF ` can be taken with `=TRIM(MID(B2, SEARCH("REF ",B2)+4, 30))`. Where a bank's pattern is less regular, type two or three examples by hand in the Payee column and press Ctrl+E for Flash Fill, then check the guesses against the raw text.

### Checking the split

Sort by Type and scan the Other rows. Each one is either a payment type you have not added to the formula or a description the pattern missed. The amounts are untouched by any of this, so the balance check still holds.

## Australian statements that need special handling

Some Australian statements break the simple pattern: scanned paper copies, years of history in one file, and credit union statements that hold several accounts. Each changes how you prepare the file, not how the rows are cleaned.

### Scanned statements

If you only have paper, scan it flat and in good light. A phone scanning mode beats a plain photo, as the guide to [using your phone as a document scanner](/blog/use-phone-as-document-scanner) explains. Expect more character errors in BSBs and references, and check the balance column closely.

### Long histories

A year or more of statements in one PDF can run to hundreds of pages. The guide to [converting a large PDF to Excel](/blog/convert-large-pdf-to-excel) explains when to split the file first and how to stitch months together without duplicates.

### Credit unions and linked accounts

Customer-owned banks and credit unions sometimes put several accounts, such as savings and a loan, in one statement. The [credit union statement guide](/blog/credit-union-statement-to-excel) covers splitting those so each account's balance can be checked on its own.

### Converting the statement

FastBankConvert is getting ready to open. It reads a statement's layout instead of relying on a fixed list of banks, and warns you before download if the balances do not add up. [Get started](/get-started) to hear when trials begin.