How to Track Expenses: Five Methods, and the One That Actually Sticks

Almost everyone who decides to track their spending succeeds for about eleven days. The notebook fills up, the spreadsheet gets a good first week, and then a busy Tuesday happens and the whole thing quietly stops. The problem is almost never discipline. It is that the method chosen costs more effort per purchase than the information is worth in the moment.

So the useful question is not “which method is best?” but “which method survives a bad week?” Here are the five real options, with the honest cost of each.

1. The notebook

A pocket notebook and a pen. Write the amount and what it was for. It sounds primitive and it has one real advantage: friction at the point of spending. Writing “18 — lunch out, again” by hand makes you notice the pattern in a way a tap never does.

The cost is that a notebook cannot add up, cannot categorise and cannot tell you what is left. At the end of the month you have a diary, not a report, and turning it into one is an evening of typing. Good for a two-week awareness exercise. Bad as a system.

2. The spreadsheet

The default for anyone comfortable with a computer. Columns for date, category, amount and account, a couple of SUMIF formulas, and you have a real ledger that you control completely.

Spreadsheets fail for a specific reason: they live where you are not. Spending happens at a till, in a taxi, at a restaurant table. Entry happens at a desk, hours later, from memory or a pocketful of receipts. That gap is where the method dies. If you use a spreadsheet, the only version that survives is one you can open on your phone in ten seconds.

• Keep it to six columns: date, type, category, description, amount, account
• Write expenses as negative numbers so the column total is your net
• One sheet per month, not one giant sheet per year
• Enter on the day, not on the weekend

3. Your bank’s app

Every bank now shows spending by category, and it takes zero effort because the bank already has the data. For people whose money moves entirely through one card, this is genuinely enough.

It breaks the moment your life is more complicated than that. Cash is invisible. A second bank is invisible. Money you lent a friend is invisible. And bank categories are guesses made from merchant names, so a supermarket that also sells petrol will file your fuel as groceries and never tell you.

4. Envelope budgeting

Divide the month’s money into envelopes — groceries, transport, fun — and spend only what is in each. Physically with cash, or in an app that mimics it. It is the strongest method for people who overspend, because the limit is visible before the purchase rather than after it.

The cost is rigidity. Real months contain a car repair and a wedding gift, and a system that treats every overspend as a failure gets abandoned after the first genuinely unusual month. If you try this, decide in advance how you will move money between envelopes without calling it cheating.

5. An expense tracker app

The category most people end up in, and the one with the widest quality range. A good one removes the typing; a bad one is a spreadsheet with worse ergonomics.

The single feature that decides whether you will still be using it in three months is how long one entry takes. If logging a coffee is four taps and a keypad, you will stop. If it is a photograph of the receipt, or saying “four fifty, coffee” out loud, you will not.

The honest comparison

Ranked by the only metric that predicts survival — effort per transaction — the order is: bank app (zero, but incomplete), tracker with scanning or voice (a few seconds, complete), envelope app (moderate, and disciplined), spreadsheet (high), notebook (high, and no maths).

Notice that the two extremes lose for opposite reasons. The bank app is effortless but blind to half your money. The notebook sees everything but does nothing with it. What you want is completeness without the typing.

How to actually start

1. Pick one month and commit to it. Not forever — one month.
2. Log every account you actually use: bank, cash, and each card.
3. Enter on the day. The single biggest predictor of failure is a backlog.
4. Do not create thirty categories. Eight is plenty, and “other” is allowed.
5. At the end of the month, look once. One number will surprise you. That number is the whole point.

The surprise is usually eating out, subscriptions, or small daily purchases that never felt like decisions. It is almost never rent.

What to do with what you find

Do not cut everything. Cutting across the board fails for the same reason crash diets fail. Take the one category that surprised you and put a limit on it for next month, leaving the rest alone. One change, applied consistently, beats five changes abandoned in a fortnight.

Then repeat. The second month is easier than the first because the accounts are already set up and you know what your normal looks like. By the third month you are not tracking expenses any more; you are just noticing them, which was always the actual goal.