A yearly family review needs only four numbers from your twelve-month sheet: total spend, the top five categories, the biggest single bills, and how many months went over budget. Pull those out, sit down with the family for an hour, and finish by writing down three decisions. Here is the whole routine, worked on a made-up household of four.
What should I pull out of the sheet first?
Assume an April to March sheet with a log of Date in column A, Amount in column C and Category in column D, plus a category summary. Take these four figures.
- Total spend: =SUM($C$2:$C$3000).
- Spend per category: =SUMIFS($C$2:$C$3000, $D$2:$D$3000, $F2), copied down for each category name in column F.
- Biggest single bills: =LARGE($C$2:$C$3000, 1), then 2, 3, 4 and 5, and look up the Description in the matching row.
- Months over budget: build a column of twelve monthly totals with =SUMIFS($C$2:$C$3000, $A$2:$A$3000, ">="&H2, $A$2:$A$3000, "<"&EDATE(H2,1)), where H2 holds the first of that month, then count them with =COUNTIF(I2:I13, ">"&MonthlyBudget).
If formulas feel fiddly, a pivot table gives the same category and month totals in a few clicks: Insert, PivotTable, with Category in rows, the month in columns and Amount in values. Either route works; just compare the grand total with your plain SUM so you know nothing was dropped.
What does a worked example look like?
Say the Sharma household earned ₹9,60,000 over the year, which is ₹80,000 a month, and logged ₹7,50,000 of spending. Their top five categories were these.
| Category | Yearly spend (₹) | Share of total |
|---|---|---|
| Rent | 2,16,000 | 28.8% |
| Groceries | 1,44,000 | 19.2% |
| School fees and tuition | 96,000 | 12.8% |
| Transport and fuel | 54,000 | 7.2% |
| Electricity, gas and internet | 48,000 | 6.4% |
Those five add up to ₹5,58,000, about 74 percent of the ₹7,50,000 total. Everything else, such as eating out, festivals, domestic help and medical, was ₹1,92,000. The family kept about ₹2,10,000 of income, which is roughly 22 percent. The formula is =(Income-TotalSpend)/Income.
Which single bills deserve a second look?
Totals hide lumps. In this household the biggest single bills were a ₹40,000 admission fee in April, ₹35,000 for a family trip in May, ₹28,000 of Diwali shopping and ₹22,000 for an AC repair. Ask of each one: was it planned, was it paid from the right pot, and will it come back next year? A bill that returns every year is not a surprise any more; it belongs in the monthly budget as a small amount set aside.
Were we really over budget in four months?
With a budget of ₹60,000 a month, the months above it were April (school fees), May (trip), October and November (festivals). Counting four tells you the pattern is seasonal, not a daily leak. If the overspend were spread over eight or nine months, the monthly budget itself is probably set too low.
What three decisions can come out of this?
- Raise or lower one monthly budget line so it matches reality, for instance setting aside ₹3,750 a month for the festive season (₹45,000 divided by 12).
- Move one recurring lump, such as the school admission fee, into a separate savings pot filled monthly.
- Pick one habit to watch, say eating out, with a monthly limit you all agree on.
These are examples of the form a decision takes, not recommendations for your household. Write yours in a cell on a Review tab with a date to check again.
Closing checklist
Before the meeting, confirm the twelve months add up to your bank statements, that every row has a category, and that the family knows what counts as spending versus saving. If you keep your records in SpendixAI, the overview and reports can give you the category and month views to bring to this same conversation, and a CSV download opens straight in your sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


