A Google Sheets personal finance template needs only three tabs: one for every transaction, one for your category list, and one summary that adds things up by month. The summary is driven by a single formula, SUMIFS, so once it is set you only ever type new rows into the first tab.
Tab 1: Transactions
Name the first tab Transactions and set up these columns in row 1.
- A: Date (format as a date, for example 14/04/2026)
- B: Category
- C: Amount in rupees, entered as a plain number with no ₹ sign typed in
- D: Account or note, for example 'salary account card' or 'cash'. Use whatever your own accounts are called.
Keep one row per payment, and keep every row filled. Gaps in the date column make the summary quietly skip rows.
Tab 2: Categories, and a dropdown that stops typos
Put your categories in a tab called Lists, one per cell down column A: Rent, Groceries, Transport, Eating out, Bills, Health, Other. Then select B2:B500 on the Transactions tab, open Data, then Data validation, add a rule, choose Dropdown (from a range) and point it at Lists!A2:A20. Now 'Grocries' can never sneak in as a new category and break your totals.
Tab 3: Summary, the formula that does the work
On a tab called Summary, type the first day of the month you want in cell F1, for example 01/04/2026. List your categories down column A starting at A3, put the monthly budget for each in column B, and use this in C3 and fill it down:
- C3: =SUMIFS(Transactions!$C$2:$C$500, Transactions!$B$2:$B$500, $A3, Transactions!$A$2:$A$500, ">="&$F$1, Transactions!$A$2:$A$500, "<="&EOMONTH($F$1,0))
- D3: =B3-C3 shows what is left in that category
- C12: =SUM(C3:C11) gives the month's total
SUMIFS takes the range to add first, then pairs of range and condition. EOMONTH($F$1,0) returns the last day of the month in F1, so the two date conditions fence in exactly one month. Change F1 to 01/05/2026 and every number updates.
A worked month
Say your Food budget is ₹9,000 and these rows are entered for April: ₹1,850, ₹2,310, ₹640, ₹1,275 and ₹1,980. The total is 1,850 + 2,310 + 640 + 1,275 + 1,980 = ₹8,055. The sheet then shows ₹945 left, since 9,000 minus 8,055 is 945. These are made-up numbers; use your own budget.
How do I know nothing slipped through?
Add one check cell on the Summary tab. It adds every transaction in the month regardless of category, then subtracts the category totals:
- In F3 type =SUMIFS(Transactions!$C$2:$C$500, Transactions!$A$2:$A$500, ">="&$F$1, Transactions!$A$2:$A$500, "<="&EOMONTH($F$1,0))-C12
- If it shows 0, every row landed in a listed category.
- If it shows a number, a row has a blank or misspelt category. Filter column B for blanks and fix it.
Can I make the sheet do more?
Two small upgrades are worth it. First, =QUERY(Transactions!A1:D500, "select B, sum(C) where A >= date '2026-04-01' and A <= date '2026-04-30' group by B label sum(C) 'Total'", 1) gives a one-step summary, though it works in Google Sheets only and the date has to be written in that year-month-day style. Second, freeze row 1 and set a filter so you can sort by amount to spot anything unusual.
When a sheet stops being enough
Typing every row yourself is where sheets break down. If you find you have stopped updating it, SpendixAI takes a bank or card statement as PDF, CSV or Excel, lets you review the rows before saving, and suggests categories you can correct, so the sheet's job becomes the thinking rather than the typing. It also has budgets on Pro and a CSV download if you ever want your data back in a sheet.
Starter checklist
- Three tabs: Transactions, Lists, Summary.
- Dropdown on the category column.
- One SUMIFS per category, driven by the month in F1.
- The check cell showing 0.
- A fixed day each week to enter rows.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

