A monthly spending scorecard is a small table of six numbers you fill in each month: income, total spend, savings rate, fixed-cost ratio, biggest category and the number of surprises. Add a column for last month and one for the change. Once you have the habit, a review takes minutes, because you are comparing, not starting from scratch.
What are the six numbers?
- Income: money that came in for the month, such as salary and regular side income.
- Total spend: everything that went out for living, excluding transfers into your own savings.
- Savings rate: income minus spend, divided by income.
- Fixed-cost ratio: rent, EMIs, school fees, insurance and other must-pay items, divided by income.
- Biggest category: the category with the largest spend, and its amount.
- Number of surprises: how many payments you did not expect and that were above a threshold you set.
How do you define a surprise?
Pick a threshold that fits your household, for example ₹2,000, and count any unplanned payment above it. A repair, a medical bill or a forgotten subscription renewal all qualify. The number is useful because it grows when life is messy and shrinks when it is calm, and it tells you whether your plan for fixed and planned spending is realistic.
A filled-in scorecard with hypothetical numbers
Say income is ₹85,000 both months. This month you spent ₹62,000 and last month ₹66,500. Fixed costs are ₹38,000 in both.
| Measure | This month | Last month | Change |
|---|---|---|---|
| Income | ₹85,000 | ₹85,000 | No change |
| Total spend | ₹62,000 | ₹66,500 | ₹4,500 lower |
| Savings rate | 27% | 22% | Up 5 points |
| Fixed-cost ratio | 45% | 45% | No change |
| Biggest category | Food, ₹14,500 | Travel, ₹18,000 | Changed |
| Surprises | 2 | 3 | One fewer |
The working: savings this month is 85,000 − 62,000 = ₹23,000, and 23,000 ÷ 85,000 is about 27%. Last month 85,000 − 66,500 = ₹18,500, which is about 22%. The fixed-cost ratio is 38,000 ÷ 85,000, about 45%, in both months. One glance tells you the improvement came from variable spending, not fixed costs.
Which spreadsheet formulas fill it in?
If your sheet has income in B2, total spend in B3 and fixed costs in B4, these work in Excel and Google Sheets.
- Savings: =B2-B3
- Savings rate: =(B2-B3)/B2, then format the cell as a percentage.
- Fixed-cost ratio: =B4/B2, formatted as a percentage.
- Change in spend against last month's figure in C3: =B3-C3
For the biggest category, put your category totals in a range such as E2:E15 with names in D2:D15. Then =MAX($E$2:$E$15) gives the amount, and =INDEX($D$2:$D$15, MATCH(MAX($E$2:$E$15), $E$2:$E$15, 0)) gives the name. Both work in Excel and Google Sheets.
What do you do with the result?
- If the savings rate fell, look first at the biggest category and the surprises.
- If the fixed-cost ratio is rising, the cause is usually a new EMI, a rent rise or an extra subscription.
- If surprises are frequent, consider a small buffer line in next month's plan.
- If everything is steady, leave it alone and note one thing that went well.
When maintaining the table by hand starts to feel like a chore, tools can fill the numbers for you. SpendixAI has an overview and ready-made reports that give your totals by category, so you only need to copy six figures into the scorecard.
Setting it up
- Make the table once, with the six rows and three columns.
- Fix your definitions and your surprise threshold.
- Fill it on your review day.
- Copy this month into the last-month column at the start of the next.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

