A Google Sheets expense tracker needs three tabs: a Log where every expense is a row, a Categories list that feeds dropdowns, and a Summary that adds things up with QUERY. Build it in about twenty minutes, then enter expenses once a day. The sheet stays useful as long as the Log has one rule: one expense per row, with the same columns every time.
What goes on the Log tab?
Create a tab called Log with these headings in row 1:
- A: Date
- B: Description (what or who you paid)
- C: Category
- D: Account (for example HDFC card, cash, wallet; use your own names)
- E: Amount (₹, positive numbers)
- F: Month, filled by one formula
In F1 write =ARRAYFORMULA(IF(A2:A="","",TEXT(A2:A,"yyyy-mm"))) and leave F2 downward empty. Every dated row now gets a month label such as 2025-11. Freeze the header row with View, then Freeze, then 1 row.
How do I add dropdown categories?
Make a tab called Categories and list your categories in A2:A30: Rent, Groceries, Fuel, Eating out, Bills, Medical, Travel, Shopping, Other. Back on Log, select C2:C1000, open Data, then Data validation, add a rule, choose Dropdown (from a range) and point it to Categories!A2:A30. Turn on the option to reject invalid input, so a typo such as Grocries cannot slip in. For dates, select A2:A1000, add a rule of type Date, and set the number format to dd-mmm-yyyy so every entry is a real date and not text.
How do I build the monthly summary?
On a tab called Summary, type a month in B1 as text, say 2025-11. In A3 use:
=QUERY(Log!A1:F, "select C, sum(E) where F = '"&B1&"' and C is not null group by C order by sum(E) desc label sum(E) 'Total'", 0)
QUERY works like a small database command: select the category and the sum of the amount, filter to the chosen month, group by category and put the largest first. The final 1 says the first row of the range is a header row. Change B1 to 2025-12 and the table follows. Below it, =SUM(Log!E2:E) gives the all-time total, and =SUMIFS(Log!E2:E,Log!F2:F,B1) gives the month's total; the two should match the QUERY lines when added up.
Adding a monthly limit per category
Put limits in column B of the Categories tab, say Eating out ₹3,000 and Groceries ₹8,000. Next to each QUERY result, a Left column can read =VLOOKUP(A4,Categories!A:B,2,FALSE)-B4. With a ₹8,000 grocery limit and ₹5,650 spent, it shows ₹2,350 left; conditional formatting can turn negatives red.
Can I share it with family and use it on my phone?
Use the Share button and give each person an access level: Viewer to look, Commenter to suggest, Editor to add rows. Give Editor only to people who will really enter data. Protect the Summary and the formula column F through Data, then Protect sheets and ranges, so nobody types over a formula by accident.
Where does a sheet like this start to strain?
- Cash and card entries rely on you remembering them.
- Matching the sheet to a bank statement is manual, row by row.
- Pasted descriptions need tidying before they categorise well.
- Receipts live elsewhere, in a photo gallery or a folder.
That is where SpendixAI can help alongside or instead of the sheet. You upload a bank or card statement as PDF, CSV or Excel, review the rows before they are saved, and add cash expenses by hand, singly or several at once. It has no bank connection and never asks for net-banking logins, and the same workspace opens on web and mobile.
A first-week checklist
- Fill in ten real expenses and confirm the summary adds up.
- Check the Month column is not blank for any dated row.
- Pick one time of day for entry and stick to it.
- At month end, compare the Log total with what left your accounts, and list anything missing.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


