You can build a working money manager in Google Sheets with two tabs: one for entries and one for a monthly summary driven by SUMIFS. Below is the exact layout and the formulas, so you can type them rather than hunt for a download. It is enough for one person tracking a few hundred entries a month.
How should the Entries tab be laid out?
Use row 1 for headings and enter data from row 2.
| Column | Heading | What goes in it |
|---|---|---|
| A | Date | A real date, for example 05/11/2026 |
| B | Category | Chosen from a dropdown |
| C | Amount | Positive number in rupees |
| D | Account | Bank, card, cash or wallet |
| E | Note | Free text |
Select B2:B500, choose Data, then Data validation, and set a dropdown from a list such as Food, Rent, Transport, Bills, Health, Fun, Other. A dropdown stops spelling variants like Food and food from splitting your totals.
How do I total spending by category for a month?
On a Summary tab, put the first day of the month in cell B1, for instance 01/11/2026, and list your categories in A3 downward. In B3 enter this formula and fill it down:
- =SUMIFS(Entries!$C$2:$C$500, Entries!$B$2:$B$500, $A3, Entries!$A$2:$A$500, ">="&$B$1, Entries!$A$2:$A$500, "<="&EOMONTH($B$1,0))
- Argument order is sum range first, then each criteria range followed by its criterion
- EOMONTH($B$1,0) returns the last day of the month in B1
- Total spending for the month: =SUM(B3:B9)
How do I compare with a budget?
Put your budget for each category in column C, and in D3 enter =C3-B3 for the amount left. For the percentage used, enter =IF(C3=0,0,B3/C3) and format the cell as a percentage. For an overall flag, =IF(SUM(B3:B9)>SUM(C3:C9),"Over budget","Within budget") works in both Google Sheets and Excel.
A worked example with made-up numbers
Say November's food budget is ₹8,000 and the SUMIFS shows ₹6,350. Left: 8,000 - 6,350 = ₹1,650. Percentage used: 6,350 divided by 8,000 is 0.79375, shown as about 79%. With 10 days left, you can spend about 1,650 divided by 10, which is ₹165 a day.
When does a sheet stop being enough?
A sheet works well until entering every line by hand becomes the chore. When it does, SpendixAI lets you upload bank and card statements as PDF, CSV or Excel, review rows, and use its Report builder and CSV download. Until then, the sheet above is a fine place to start.
How do I see spending by month at a glance?
Add a helper column F on the Entries tab with =TEXT(A2,"yyyy-mm") and fill it down, so each row carries its month. Then in a monthly table, list months such as 2026-11 in H3 downward and use =SUMIFS($C$2:$C$500,$F$2:$F$500,$H3) in I3. Both functions behave the same in Excel, where the pattern "yyyy-mm" also works. Add a column chart over the monthly table and you will see a bad month before it becomes a habit.
One refinement for later: add an Account column filter with a second SUMIFS criterion, for example Entries!$D$2:$D$500,"Credit card", so you can see what one card carried in a month. Each extra criterion is just another pair of range and condition at the end of the formula.
Make the template last
- Add a new Entries tab each financial year rather than overwriting
- Protect the formula cells so you do not type over them
- Make a copy of the sheet monthly
- Keep statements as the final check on your totals
Useful ideas start with a clearer picture of your own spending.
Explore your reports
