Tracking a month without a spreadsheet habit

To see where the money really goes, track one full pay cycle — payday to payday — not a calendar month. That's the stretch the money has to last, so it's the honest unit to measure.

Take the numbers from the card history, not from memory. Memory keeps the big, rare payments (rent, a jacket) and quietly drops the small daily ones (coffee, a taxi, a delivery), so a guess almost always lands too low. Sam guessed about 50,000 UAH; the history totalled 62,858 across 86 payments.

The first number worth having is the simplest: add up the whole amount column, before sorting anything into categories. One total already tells you whether the cycle fit inside what came in.

Eighty-six lines are too many to read one by one. Group them: the bank already tags each payment, so a handful of categories turns a wall of transactions into a short list of totals. Eighteen categories is plenty; by hand, 8–10 would do. You want to know where the money went, not which café.

Once grouped, read the totals from the top. After rent (16,000 UAH), the biggest category is groceries at 12,425 — thirteen supermarket trips of 665 to 1,145 UAH each. No single trip felt like the second-biggest cost of the month, yet together they are. That's the point of totalling by category: it surfaces costs that hide in many small, ordinary payments, not in one memorable purchase.

When you decide what to change, the useful question isn't "what was the biggest payment?" but "what adds up to the most?" A big one-off purchase is a single decision you notice; a habit is dozens of small payments you don't.

Sam remembered his child's jacket — 2,300 UAH in one go, the biggest single flexible purchase. But ranked by category total, food delivery (4,205) cost almost twice as much across ten quiet orders, while coffee (1,395) and taxi (2,195) slipped by unnoticed. Rank the categories by their totals: groceries 12,425 > food delivery 4,205 > clothes 2,300 > coffee 1,395 > public transport 365. The order by total is not the order by how big each purchase felt.

A payment can be the biggest single purchase and still be far from the biggest leak. The two measure different things: one payment versus a whole category's total across the cycle.

The jacket was 2,300 UAH in one go — the largest single flexible purchase, and a seasonal one that won't repeat. But by category total, eating out (4,345) and food delivery (4,205) each cost almost twice as much, and delivery plus taxi came to 6,400. Those repeat every cycle; the jacket doesn't. So the jacket is memorable, not the biggest leak. When you look for leaks, compare category totals and ask which ones repeat — a repeating habit shapes the cycle far more than one seasonal purchase.

Tracking only helps if it's both useful and light enough to keep up. Four rules do that:

• Payday to payday, not the calendar month — it matches the stretch the money has to last.
• From the card history, not memory — the history keeps the small payments memory drops.
• Note each cash withdrawal — cash is the one blind spot the history can't fill (Sam's 2,000 UAH vanished from the picture).
• Total once a cycle, on payday — twenty minutes a month is a habit you can keep.

Two tempting rules quietly break it. Splitting into forty categories turns tracking into a chore nobody keeps up, and you learn nothing extra by knowing which café. Tracking only payments over 1,000 UAH hides exactly the habits that matter: delivery, taxi and coffee were 7,795 UAH of Sam's cycle, every one of them under 1,000.