Plenty of business owners reach late June with a year of bank transactions still uncategorised. It feels like a wall. It isn't — reconciling a full year is repetitive, not hard, and the right approach turns a dreaded multi-day slog into a focused weekend.
This is the plain-English process a bookkeeper would follow, stripped down for a sole trader or small business owner doing it alone.
What "reconciling a year" actually involves
Reconciliation is checking that every transaction in your records matches your real bank statement, so your income and expense totals are complete and correct. You're doing three things, in order: getting every transaction in, putting each one in the right category, and confirming your closing balance matches the bank's. Do that for each account and you're reconciled.
Step 1 — Get every transaction in (don't type them)
Manual entry is where weekends disappear. Instead, download your statements for the whole financial year and import them:
- Export CSV or Excel from your online banking, or save the PDF statements
- Import the lot in one go rather than month by month
- Include every account — main account, savings, credit cards, and payment platforms
A year of transactions imports in minutes. Typing the same data takes hours and introduces errors. See how to import bank statements.
Step 2 — Categorise: let rules and AI do the repetitive work
Most of your transactions are the same handful of vendors over and over — the same telco, the same fuel stops, the same software subscriptions. You should categorise each of those once, not fifty times.
- Set a coding rule for each recurring vendor so it's categorised automatically every future time it appears
- Use software that ships with common Australian vendors already recognised, so coding works on the first import
- Let an AI layer suggest categories for the one-off transactions it hasn't seen before
This is the difference between a weekend and a week. For the detail, see how auto-coding works.
Step 3 — Match to the bank and find the difference
Once everything is categorised, compare your closing book balance to the bank's closing balance for the period. If they match, that period is done. If they don't, the difference is a clue:
- A figure that matches one transaction exactly = a missing or duplicated entry
- A small recurring gap = bank fees or interest not yet recorded
- A timing gap = a payment that cleared in a different period
Never "round it off." An unreconciled difference is always a real, findable transaction.
Step 4 — Lock the period and pull your BAS figures
When each quarter reconciles, lock it so it can't be changed by accident, then read off your GST collected and GST paid for the BAS. With the year reconciled, your June-quarter BAS and your tax return are working from final, trustworthy numbers.
A realistic weekend plan
| Session | Task | Rough time |
|---|---|---|
| Saturday morning | Import all accounts for the full year | 30–60 min |
| Saturday afternoon | Set rules for your top 20 recurring vendors | 1–2 hours |
| Sunday morning | Review and code the remaining one-off transactions | 1–2 hours |
| Sunday afternoon | Match balances quarter by quarter, fix differences | 1–2 hours |
Compare that to manual entry of a year's transactions, which routinely runs to 15–20 hours.
Doing it without a bookkeeper
ReconLink was built for this exact situation. Import CSV, Excel or PDF statements, and a 139-vendor default coding pack categorises common Australian transactions immediately — no blank chart of accounts to build first. Rules and an AI layer handle the rest, and a BAS worksheet falls out the other side. The Solo plan has a 30-day free trial with no card; there's an EOFY founding offer at the EOFY offer page, or start free.
Frequently asked questions
Can I really reconcile a whole year over a weekend?
For a typical sole trader or micro business — yes, if you import statements instead of typing them and use rules to categorise recurring vendors. The volume is repetitive, so automation does most of the work.
What if my balance won't reconcile?
The difference is always a real transaction: something missing, entered twice, or with the wrong amount. Search for the exact difference amount first — it usually finds the culprit immediately.
Do I need accounting experience to do this?
No. Reconciliation is matching and categorising. The rules are simple; the only requirement is that your records are complete.
This article is general information for Australian small business owners, not tax advice. Confirm current rates, thresholds and lodgement dates with the ATO or a registered tax or BAS agent for your situation.