Expense Tracker

Four columns and a total

Date, what it was, which category it belongs to, how much. Twenty rows by default. A total box at the foot.

The header takes a period label — a month, a week, a trip — and the currency switches: sterling, dollars, euros.

Write it down at the time

This is the whole discipline and there is no way around it.

Reconstructing a week's spending from memory on a Sunday produces a number that is wrong by a comfortable margin, always in the same direction. The small things vanish: the coffee, the parking, the thing you picked up on the way home. Those are exactly the expenses that add up to the gap between what people think they spend and what leaves the account.

Carry the sheet, or photograph it and write the entries up each evening. Either works; remembering on Sunday does not.

The category column is where the answers live

A list of amounts tells you the total. A list of categorised amounts tells you what to change.

Keep the set small. Six or eight, not twenty, and stable month to month, because a category list that keeps changing makes every comparison between one month and the next meaningless. Groceries, eating out, transport, household, personal, fun. If a purchase genuinely straddles two, pick one and stay consistent about which.

What a month of this actually does

Most people who track for a month find one category is roughly double what they assumed, and it is rarely the one they were worried about.

That is the point. You cannot budget your way out of a problem you have mis-identified, and the tracking is the diagnosis rather than the treatment. Track first for a month without changing anything — changing behaviour while measuring it gives you a picture of neither.

Paper against an app

Apps that read your bank feed are excellent at completeness and poor at attention. Everything is captured and nothing is noticed.

Writing an amount by hand takes four seconds and those four seconds are the mechanism — several studies of manual expense recording point the same way, and anyone who has kept one for a month recognises the effect. It also works for cash, which a bank feed does not see at all.

Related

For envelope-style budgeting rather than after-the-fact recording, the cash envelope budget. For the irregular annual bills, the sinking funds tracker.