Twenty minutes is enough to set up a Google Sheets spending tracker: one sheet for the log, one for monthly totals using SUMIFS, and a dropdown so categories stay consistent. The steps below give exact formulas. Copy them cell by cell and change the ranges to suit your data.
Step 1: the Log sheet
Name the first sheet Log. Put these headings in row 1.
- A: Date
- B: Amount (₹)
- C: Category
- D: Account
- E: Note
Format column A as Date and column B as Number. Enter rows from row 2 downward, one expense per row. Use the same date format every time.
Step 2: a dropdown for categories
- On a sheet named Lists, type your categories in A2 to A10: Groceries, Eating out, Home, Utilities, Transport, Health, Shopping, Fun, Other.
- Back on Log, select C2:C500.
- Choose Data, then Data validation, then Add rule. Under Criteria pick Dropdown (from a range) and enter Lists!A2:A10.
- Save. Now each cell in column C offers your list and rejects stray names.
Step 3: monthly totals by category with SUMIFS
Name another sheet Summary. Put the first day of the month you want to see in B1, for example 01/11/2026. List categories in A3 downward. In B3 enter this formula and fill it down:
=SUMIFS(Log!$B$2:$B$500, Log!$C$2:$C$500, $A3, Log!$A$2:$A$500, ">="&$B$1, Log!$A$2:$A$500, "<"&EDATE($B$1,1))
SUMIFS takes the range to add first, then pairs of criteria range and criterion. This one adds amounts where the category matches A3 and the date falls from the first of the month up to, but not including, the first of the next month. Change B1 and every row updates.
Step 4: a grand total and a budget check
- Total spent in the month: =SUM(B3:B11)
- Budget for a category in C3, then left: =C3-B3
- Rows in the month: =COUNTIFS(Log!$A$2:$A$500, ">="&$B$1, Log!$A$2:$A$500, "<"&EDATE($B$1,1))
- Percent of budget used: =IF(C3=0,"",B3/C3)
A worked check
Say November's log has Groceries rows of ₹1,850, ₹2,240 and ₹960, and a Transport row of ₹640. Summary should show Groceries = 1,850 + 2,240 + 960 = ₹5,050 and Transport = ₹640. If a total looks wrong, check for a date typed as text (left-aligned cells), a category spelled differently or a row outside row 500.
When does the sheet stop being enough?
The sheet is a fine start. It gets heavy when you want rows from bank statements, automatic categorising and receipts with each entry. At that point you could try SpendixAI, which imports PDF, CSV or Excel statements, lets you review rows before saving and groups spending by category. Keep your sheet as a backup.
Two small upgrades
Once the basics work, add two things. First, freeze row 1 on the Log sheet (View, then Freeze, then 1 row) so headings stay visible. Second, add a Check cell on Summary that compares the grand total with a direct sum of the month: =SUM(B3:B11)-SUMIFS(Log!$B$2:$B$500, Log!$A$2:$A$500, ">="&$B$1, Log!$A$2:$A$500, "<"&EDATE($B$1,1)). If it returns anything other than zero, a row has a category that is not on your list.
Keeping the sheet healthy
Make a copy of the file at the end of each financial year, April to March, and start the new year with an empty Log. Keep the Lists sheet and the formulas unchanged so last year's copy stays comparable. If several people will type into the sheet, protect the Summary tab (Data, then Protect sheets and ranges) so nobody overwrites a formula by accident, and agree that new categories are added to Lists first.
Next steps
- Add one row today.
- Fill the Summary for the current month.
- Review it every Sunday for five minutes.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

