AU
Come tax time in Australia, your bank statements are the evidence behind your return — the income that came in and the deductions you're claiming both moved through the account. Whether you lodge through myTax yourself or hand it to a tax agent, converting a year of statements to a clean spreadsheet is what turns a shoebox of PDFs into totals you can actually put on the return and defend if the ATO asks. This covers doing that for your income tax return.
What your return draws from the statement
The Australian financial year runs 1 July to 30 June, and your individual or sole-trader return pulls a few things from your banking:
- Assessable income. Salary, sole-trader receipts, interest earned and other income that lands in the account.
- Deductions. Work-related expenses, or business expenses if you're a sole trader — each needs to be a real transaction you can point to.
- Interest and any franking. Interest is income; the bank reports it, so your figure should match.
The ATO increasingly pre-fills income it already knows about, so your job is to make sure your records agree and that you've captured every deduction you're entitled to.
From PDF to a return-ready spreadsheet
- Download the year's statements as PDFs — CommBank's NetBank, Westpac, NAB, ANZ and the rest keep them in online banking.
- Convert each to Excel or CSV. Every transaction returns as a row — date, description, debit, credit and balance — with the closing figure checked.
- Combine the months into one sheet for the full financial year.
- Total income and sort deductions. Sum the income lines, then add a category column for your deduction types and total each — those figures go onto the return.
Substantiating your deductions
The part of a return most likely to be questioned is deductions. The ATO expects you to be able to show a work-related or business expense was actually incurred, and while you still need the receipt for the detail, the bank statement is the record that you paid it and when. With expenses as sortable rows, you can group them by type — tools, subscriptions, motor vehicle, home office — total each, and cross-check against your receipts, so every claim on the return has a transaction behind it. That's far quicker than reading down a PDF, and it's exactly what a tax agent would rather receive than a stack of statements.
What the converter handles that a copy-paste won't
Australian statements often wrap a long payee or a BPAY reference onto a second line, and a plain copy-paste turns that into a phantom row that throws the columns out — so a total you rely on for the return is wrong. The converter joins each wrapped line back to its transaction and checks the running balance across the year, so your income and deduction totals are built on complete, reconciled data.
Matching what the ATO already knows
The ATO pre-fills a growing amount of your return — salary from your employer, interest from your bank, dividends — usually a few weeks into the new financial year once third parties have reported. That's convenient, but it isn't the same as being complete: the pre-fill won't include sole-trader receipts, cash income, or a deduction you're entitled to. Converting your statements gives you an independent record to check the pre-fill against, so you can confirm the interest figure matches, catch any income the ATO doesn't yet have, and make sure every deduction is captured. It's the difference between accepting the pre-fill on trust and lodging a return you know is right — which matters most if you're a sole trader, where a lot of the return isn't pre-filled at all and comes straight from your banking.
Frequently asked questions
Can I convert my bank statements for my tax return for free?keyboard_arrow_down
Yes. Upload each monthly PDF and get a clean Excel or CSV back free to start, with the running balance checked so the year is complete.
Which Australian banks does it work with?keyboard_arrow_down
All the major ones — CommBank, Westpac, NAB, ANZ, Macquarie, Bendigo, Suncorp, ING and more.
Does the ATO want my bank statements?keyboard_arrow_down
Not with the return itself, but you need them to prepare it and to substantiate income and deductions if you're reviewed. A clean spreadsheet is the fastest way to have that evidence in order.
Can my tax agent use the converted file?keyboard_arrow_down
Yes. A reconciled spreadsheet of income and categorized deductions is what an agent would rather work from than a folder of PDFs, and it keeps their time — and your fee — down.
Try it on your own statement
Clean Excel/CSV, with every transaction checked to balance.