Money tips

Unreconciled items: a short list beats long guilt

When a few entries refuse to match, the answer is not to abandon the whole reconciliation. Keep a short, dated list and give each item an owner and a next step.

Editorial illustration for Unreconciled items: a short list beats long guilt

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.

DateAmountAccountSuspected causeNext step
12 May340CardFee not enteredCheck next statement
20 May1,200SavingsTransfer pendingConfirm clearing by 25 May
28 May85CashUnrecorded purchaseAsk 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports