The feeling of an unfinished month
Few things drain motivation like a reconciliation that almost works. Twelve of thirteen accounts agree, one is out by 340, and the difference sits in the back of the mind. People respond by avoiding the task, skipping the next month and gradually losing the whole habit. The cause is not the difference itself but the guilt around not knowing what it is.
A written list defuses this. It converts an unknown into a set of known loose ends.
What goes on the list
Each unresolved item gets one line with five fields: date, amount, account, suspected cause and next step.
| Date | Amount | Account | Suspected cause | Next step |
|---|---|---|---|---|
| 12 May | 340 | Card | Fee not entered | Check next statement |
| 20 May | 1,200 | Savings | Transfer pending | Confirm clearing by 25 May |
| 28 May | 85 | Cash | Unrecorded purchase | Ask household |
Seeing the problem in three lines makes it feel manageable, which it usually is.
Setting a tolerance
Decide in advance how much difference you are willing to carry. For a household, perhaps a few units can be written off as rounding or small cash slips. For a business, the tolerance should be tighter and the write-off documented.
Write the rule down. Without it, every difference is a decision, and decisions are tiring.
Writing off honestly
When a small difference cannot be explained after reasonable effort, record an adjustment entry with a clear note: unexplained difference, amount, date, account. Use a dedicated category such as reconciliation adjustments so that these entries are easy to find and total.
Do not hide the adjustment inside a general category. The total of such adjustments across a year is a quality measure of your tracking. A small, stable number is reassuring; a growing one is a warning.
Giving items an age
Unresolved items become more difficult to resolve as time passes, because memory fades and statements get archived. Add a column for the date first noticed and review the list monthly. Anything older than two months deserves a decision: resolve it, write it off or escalate to the bank or supplier.
Decisions made with evidence at hand are far easier than those made a year later.
Sharing the load
In a household, some items can only be resolved by another person. A cash difference may involve a family member’s purchase. Share the list, or the relevant lines, and ask for answers by a date. Frame it as a question about the records, not about anyone’s behaviour.
In a small business, an employee or partner may hold the answer. A short weekly check-in on the open list often resolves items in minutes.
What a good list looks like over time
A healthy open items list is short, current and shrinking. New items appear and are resolved within a month or two. If the list keeps growing, the root cause is likely an upstream habit, such as cash purchases not being logged or fees not being checked.
Treat the list as a diagnostic. Its entries point to the part of the process that is leaking.
A closing thought
Perfection in reconciliation is not the goal; knowledge is. A month with two documented open items is in better shape than a month where everything appears to match because differences were quietly forced.
Agreeing a rhythm with others
If more than one person adds entries, agree who handles the list and when. A short weekly message, listing the open items with a request for answers, keeps everyone informed without a meeting. People respond better to a short list with a date than to a general request to check the records.
Once an item is resolved, mark it with the date and the answer, so that the history of how it was settled remains visible.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


