Gathering twelve months of statements for an accountant takes about an hour when you work from a short list rather than from memory. Identify each account, collect the statements, mark the transfers between your own accounts, and file everything under one naming style so nothing has to be explained twice.
Where do I start?
Open a blank note and write one line per account: the nickname, the bank's name only if you need it to remember, and the months you need. Include the accounts that feel small, like a savings pot for a car service or an account set up just for one project. Those are the usual forgotten ones.
A worked example with a transfer
Say you move A$500.00 from your everyday account to savings on 3 June. The everyday statement shows A$500.00 out and the savings statement shows A$500.00 in. If both are added to a list of spending and income, your records show A$500.00 of income that never arrived and A$500.00 of spending that never happened.
| Date | Account | Money in | Money out | Note |
|---|---|---|---|---|
| 3 Jun | Everyday | - | 500.00 | Transfer to savings |
| 3 Jun | Savings | 500.00 | - | Transfer from everyday |
| 5 Jun | Everyday | 2,100.00 | - | Pay |
| 6 Jun | Everyday | - | 78.20 | Groceries |
Once the first two lines are marked as Own transfer, the real picture is A$2,100.00 in and A$78.20 out. 2,100.00 - 78.20 = A$2,021.80 added to your total money position, which matches what you would feel in the bank.
What does a one-hour plan look like?
- 15 minutes: list accounts and the months required
- 25 minutes: download statements and save with names like 2025-06 Everyday
- 10 minutes: find the transfers and mark them
- 5 minutes: compare closing and opening balances across months
- 5 minutes: write the cover note
How do I find transfers fast?
Sort the money-out column by amount and look for round figures; transfers are often round. Then look for the same amount and the same date on a different account's money-in column. In a spreadsheet, a formula like =COUNTIFS($F$2:$F$500,D2,$B$2:$B$500,B2) in a helper column counts how many rows share both a date and an amount. A result of 2 or more is a candidate, so check it by eye rather than trusting it blindly.
What if I use my account for work and home?
Do not split the lines before sending. Put a note at the top of your cover page saying the account is mixed, and list the items you know belong to work. Your accountant can then decide how to treat the rest. Questions about what counts for tax purposes belong with them, because rules and limits change.
What if my statements do not have a running balance?
Then make your own check. Add all money in and all money out for the month and compare with the difference between the opening and closing figures. If the opening is A$1,240.00, in is A$3,000.00 and out is A$2,780.50, the closing should be 1,240.00 + 3,000.00 - 2,780.50 = A$1,459.50.
SpendixAI is built around India and INR, not Australian dollars, but it follows the same principle: each transaction stays attached to its account so a transfer can be seen from both sides.
A last tip on naming. If you open an account part way through the twelve months, put the opening month in your account list, so a statement that starts in October is not mistaken for a missing set from January to September. One line of explanation, such as Opened 14 October, answers the question before it is asked.
Before the email goes
- Count accounts times months and confirm the file count matches.
- Check each transfer is marked in your own list.
- Attach the cover note first, files after.
- Keep a copy of exactly what you sent.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


