Bank Statements for Your BAS and End of Financial Year (Australia)
Your BAS and your end-of-financial-year (30 June) figures both start from the same place: every transaction in your business bank and card accounts. Download each period, convert it into your bookkeeping software or a spreadsheet, and categorise it, so the GST and income figures add up.
Not tax advice. This guide is about getting your bank transactions into a usable shape for Australian filing. What you can claim depends on your situation: check the official guidance linked here or ask a tax professional. See our disclaimer.
When your BAS is due
According to the ATO (ATO: Due dates for your BAS, checked October 2026):
- You must lodge monthly if your GST turnover is $20 million or more, or if the ATO has told you to. Below that you can choose monthly; otherwise you lodge quarterly.
- A monthly BAS is due on the 21st day after the month ends.
- Quarterly BAS is due on 28 October, 28 February, 28 April and 28 July. Lodging online may give you an extra two weeks, except for the December quarter, which already has a longer due date.
The financial year runs from 1 July to 30 June, so the April to June quarter is also your end-of-year cut-off.
Step 1: Download each period from your bank
- Download each business transaction account and card for the BAS period (or the whole year at EOFY). Choose OFX or CSV where offered.
- If a bank feed is connected, download only the dates the feed is missing, so nothing is imported twice.
- Older periods may only be available as PDF statements: that’s fine, they can be converted too.
Step 2: Get the data into your software
| Where it goes | File it needs | Converter |
|---|---|---|
| Xero | Xero statement CSV or OFX | Bank CSV to Xero (Westpac, CommBank and NZ layouts included) |
| MYOB Business | OFX or QIF (not CSV) | Bank CSV to MYOB |
| QuickBooks Online | QBO or 3/4-column CSV | CSV to QBO |
| A spreadsheet | Excel | PDF bank statement to Excel |
Australian exports use day-first dates. In the converter’s preview, check a date after the 12th and the totals before you download.
Step 3: Categorise with GST in mind
For each transaction, record whether it’s business, which income or expense account it belongs to, and whether GST applies. Bookkeeping software does this with tax rates on each line; in a spreadsheet, add a GST column next to the category.
Keep the receipts and tax invoices behind each GST credit you claim. The bank statement shows that you paid, not what you bought.
Step 4: Reconcile before you lodge
- Reconcile each account to the statement balance at the end of the period: see reconciling in Xero or reconciliation in Excel.
- Look for duplicates where an imported file overlaps a feed: fixing duplicate transactions.
- At EOFY, check that the four quarters add up to the year, and that the 30 June balance matches the bank.
Frequently asked questions
When is my quarterly BAS due?
The ATO lists 28 October, 28 February, 28 April and 28 July. Lodging online may give you two extra weeks, except for the December quarter.
Can MYOB import a CSV bank statement?
No. MYOB imports bank statements as OFX, QFX, QIF or OFC. Convert the CSV to OFX first, then import it.
Do I need receipts as well as bank statements for GST?
Yes. A statement shows that you paid, but the tax invoice shows the GST. Keep both.