How to read a monthly category report
Four questions to ask your own numbers, and three traps that make a report tell you the wrong story.
4 min read
A monthly report is not a scoreboard. It's a document with four questions in it, and if you only look at the biggest bar you'll miss three of them. Here's a real-looking month, read properly.
March, by category
₹61,340.00 total
- Rent31% of the month
- ₹19,200.00
- Groceries15%
- ₹9,340.00
- Health15%
- ₹8,900.00
- Eating out12%
- ₹7,100.00
- Shopping10%
- ₹6,200.00
- Bills7%
- ₹4,180.00
- Transport5%
- ₹3,250.00
- Other5%
- ₹3,170.00
Total
₹61,340.00
Question 1: how much of this was already decided?
Add the lines you had no say in this month. Rent and bills come to ₹23,380, and 38% of the month was settled before it started. That number is more useful than any individual category, because it tells you how much of your spending is even available to change.
If the fixed share is high, the leverage isn't in skipping coffees. It's in the annual conversation about rent, insurance and subscriptions.
Question 2: is the surprising line a habit or an event?
Health at ₹8,900 is the eye-catching one. But ₹6,500 of it was a single dental appointment. Strip it out and health is ₹2,400, which is the normal month, and the total becomes ₹54,840.
The question to ask of any spike: will this line look like this again next month? An event needs no response beyond noticing it. A habit needs a decision.
Question 3: what moved since last month?
Levels are less informative than changes. Groceries at ₹9,340 means nothing on its own; groceries at ₹9,340 after two months around ₹8,500 means something started: a flatmate left, prices moved, or you've been buying dinner ingredients you don't cook.
Flip back through two or three months in the report. It takes ten seconds and it's where nearly all the useful information lives.
Question 4: what isn't in here?
Every report has holes. The usual ones:
- Cash. Untracked cash spending is invisible by definition. If your ledger shows ₹200 of cash a month, it's not measuring reality.
- Money someone else fronted. Your third of the flat's ₹21,750 of shared costs is real spending, even if it left your account as one settlement to a flatmate. Read the personal report and the group balances in the same sitting.
- Cards you didn't connect, accounts you forgot. The partner's card, the company card you use personally, the wallet balance.
Three traps
- The one-off that rewrites the story. Covered above, and the most common misreading there is. One flight, one repair, one gift can make a normal month look like a crisis.
- Categories too broad to act on. "Shopping ₹6,200" and "Other ₹3,170" are 15% of the month explaining nothing. If a line doesn't suggest a decision, it's the wrong line. Split shopping into clothes, home and gifts and the answer usually appears immediately.
- Comparing yourself to a benchmark. The right comparison is your own last three months. Somebody else's grocery bill is a different city, a different household and a different diet.
Then turn it into next month's budget
A report you only look at is a report that changes nothing. Take themedian of the last three months for each category, add about 10% to the variable ones, cut exactly one line on purpose, and you have next month's budget, built from evidence rather than intention.