Why an audit on top of reviews
Monthly reviews look at what you spent. A quarterly audit looks at whether your records can be believed. These are different questions. A sequence of excellent monthly reviews can still sit on top of records that have quietly drifted: an account that stopped importing, a category used inconsistently, a recurring entry that no longer applies.
An audit every three months catches such drift before it becomes a year-long problem.
Set a boundary for the exercise
Allow about forty-five minutes, no more. Put the date in your calendar when you finish the previous one, because audits that depend on remembering tend to be forgotten. Choose a quiet time and have your bank apps or statements to hand. Treat it as a health check, not a rebuild. The aim is to find problems, fix the cheap ones and write down the rest.
Check one: do the balances agree?
Compare the tracker balance for each account with the real balance as of the quarter end. Do this for every account, including cash, wallets and cards. Record the differences in a short list.
Any account with a difference larger than your tolerance needs investigation. A frequent finding is an account that stopped receiving imports weeks ago and is missing recent entries.
Check two: are the categories consistent?
Pick three or four merchants you use often and look at how their transactions were categorised across the quarter. Are they always in the same place? If a supermarket appears under food, household and shopping, your rules need attention.
Also scan the largest transactions of the quarter. Do they sit in sensible categories? A large item miscategorised can distort an entire report.
Check three: look for gaps
Scan each month for days without any entries. A few are natural. A run of five empty days in the middle of a normal month suggests missing data. Likewise, look for categories that were active in one month and silent in the next, with no obvious reason.
Gaps are easier to see on a calendar view or a daily chart than in a list. If your tracker has such a view, use it.
When you find a gap, work out whether it is a gap in life or a gap in records. A week when you were travelling with little spending is real. A week with nothing at all, in a household that eats three meals a day, is a sign that something stopped arriving and needs to be reconnected or entered by hand.
Check four: recurring items
List your recurring payments and verify each still applies. Has a subscription ended? Has a standing instruction changed amount? Are there any that should exist but do not? Recurring entries that no longer match reality produce phantom forecasts and false budgets.
Be alert, too, to amounts that have quietly changed. A utility bill that drifted up, an instalment that was restructured or a membership that rose at renewal will all make last quarter’s expectations wrong. Update the recurring entry to the current figure, and add a note with the date of the change so the history stays understandable.
A short audit sheet
Many people find a tiny checklist convenient.
- Balances: all accounts compared, differences noted.
- Categories: top merchants consistent, top transactions sensible.
- Gaps: no unexplained empty stretches.
- Recurring items: all current.
- Duplicates: sorted by amount and scanned.
Tick each, write the date and note anything unresolved. Next quarter, begin by checking those leftovers.
The reward
After a few audits, you will find fewer problems each time, which is the point. The audit becomes a calm confirmation that the machine is running well. That confidence is worth much more than the hour or so a year it costs, because it allows you to treat your reports as facts rather than as approximations to be doubted.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

