Three sheets turn a spreadsheet into a money manager app: one list of transactions, one list of categories with monthly limits, and one summary that adds things up by month and category. Everything else is decoration. You can build it in an evening, and the formulas below work in Excel 2010 onwards and in Google Sheets.
Sheet 1: the Transactions list
Name the first sheet Transactions and give it five columns in row 1: Date, Category, Amount, Account, Note. Put a plain rupee amount in Amount, with expenses as positive numbers. Keep one row per payment, never one row per day, because totals by day hide the small leaks.
Turn the Category column into a dropdown so spellings never drift. Select the Category cells, open Data, then Data Validation, choose List, and point it at the category names you will keep on the second sheet. A typo like Grocery versus Groceries is the most common reason a home-made template gives wrong totals.
Sheet 2: Categories and limits
Name the second sheet Plan. In column A list your categories, and in column B write the monthly limit you are aiming for. Add a third column for what you have actually spent this month. Put the month you are reviewing, as the first day of that month, in a cell such as E1, for example 01-11-2026.
The spent column uses SUMIFS, which adds amounts that meet several conditions at once. With the first category in A2, this formula works for November:
- =SUMIFS(Transactions!$C$2:$C$500, Transactions!$B$2:$B$500, $A2, Transactions!$A$2:$A$500, ">="&$E$1, Transactions!$A$2:$A$500, "<="&EOMONTH($E$1,0))
- Argument order matters: first the range to add up (Amount), then each range followed by its condition (Category equals A2, Date on or after the first, Date on or before the month end).
- Fill the formula down for every category, then put =B2-C2 in column D to see what is left in each one.
Using $A$2:$A$500 instead of whole columns keeps the sheet quick. When you pass row 500, extend the range or turn the list into a table so it grows with you.
A worked example with made-up numbers
Say your November plan has Groceries ₹9,000, Transport ₹3,500 and Eating out ₹4,000, a total of ₹16,500. By the 20th, SUMIFS shows Groceries ₹7,350, Transport ₹2,100 and Eating out ₹4,650. The left-over column then reads ₹1,650, ₹1,400 and minus ₹650. That one red cell is the whole point of the exercise: you learn on the 20th, not on the 30th, that eating out has outrun its limit by ₹650.
| Category | Limit (₹) | Spent by the 20th (₹) | Left (₹) |
|---|---|---|---|
| Groceries | 9,000 | 7,350 | 1,650 |
| Transport | 3,500 | 2,100 | 1,400 |
| Eating out | 4,000 | 4,650 | -650 |
| Total | 16,500 | 14,100 | 2,400 |
How do I see a month-by-month summary?
Add a third sheet called Monthly. Put the first day of each month down column A (01-04-2026, 01-05-2026 and so on for an April to March year). In B2 use =SUMIFS(Transactions!$C$2:$C$500, Transactions!$A$2:$A$500, ">="&$A2, Transactions!$A$2:$A$500, "<="&EOMONTH($A2,0)) and fill down. A simple line chart on that column shows whether spending is drifting up before the year ends.
If you want the split by category as well, make a small grid with months across the top and categories down the side, and use the same SUMIFS with both the category and the date range. Check the grid total against column B; if they differ, a transaction has a category not in your list.
Where does a spreadsheet template stop being enough?
Honestly, a template is fine for months. It starts to hurt when you have to retype forty or fifty rows from every bank and card statement, when a merchant shows up under three different names, or when someone needs a report in a particular format. At that point an app that takes statement files helps more than a cleverer formula.
SpendixAI takes bank and card statements as PDF, CSV or Excel, lets you review the rows before they are saved, and keeps cash expenses as hand entries. You can still download your data as CSV, so nothing you built in Excel is wasted.
Setup checklist
- Create Transactions, Plan and Monthly sheets.
- Add the Category dropdown through Data Validation.
- List 8 to 12 categories only; you can split them later.
- Enter the monthly limits once, then adjust after two months of real data.
- Every Sunday, paste or type the week's payments and glance at the Left column.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

