A good monthly expense tracker in Excel has two tabs: a Log where every payment is one row, and a Summary that adds up each category for a chosen month with SUMIFS. Below is the layout, a ready Indian category list, and the exact formulas, so you can build it in about fifteen minutes and keep it for years.
What goes on the Log tab?
| Column | Heading | Notes |
|---|---|---|
| A | Date | Real dates such as 05-11-2026, not text |
| B | Description | Short, in your own words |
| C | Amount | Rupees as a number; refunds negative |
| D | Category | Dropdown from the Summary list |
| E | Paid by | UPI, Cash, Card, Bank transfer |
Press Ctrl+T to turn the range into an Excel Table so it grows with each new row. Then use Data, Data Validation, List on column D, with the source set to the category list on the Summary tab.
Which Indian categories should I pre-fill?
- Kirana and groceries; Milk; Vegetables and fruit
- Domestic help; School and tuition; Society maintenance
- Gas cylinder; Electricity; Mobile and UPI recharge; Internet and DTH
- Fuel and FASTag; Auto and cab; Medical
- Temple and charity; Eating out; Festivals and gifts
- EMI and loan; Insurance premium; Other
Rename anything that does not fit your home. A joint family may want Elders' medical separate; a student may want Mess and Stationery.
How does the Summary tab work?
Put the list in A2:A19. In E1 type the first day of the month you are viewing, for example 01-11-2026, formatted as mmm-yyyy. Then in B2 enter this formula and copy it down.
=SUMIFS(Log!$C$2:$C$2000, Log!$D$2:$D$2000, $A2, Log!$A$2:$A$2000, ">="&$E$1, Log!$A$2:$A$2000, "<"&EDATE($E$1,1))
The first criterion matches the category, the next two keep dates from the first of the month up to, but not including, the first of the next month. Change E1 to see any other month. With a Table you could use structured names instead, but plain ranges like these work in every version of Excel and in Google Sheets.
Make E1 easy to change by typing the date or adding a dropdown of month-start dates beside it. Freeze the top row of the Log (View, Freeze Panes) and switch on filters, so you can look at just the cash rows or just one category in a second. To see how you pay, copy the SUMIFS and use column E as the criterion: UPI, Cash and Card each get a total for the month, and you can see how much of your spending leaves as cash that no statement will record.
How do I know nothing slipped through?
Add two cells under the list. B21 is =SUM(B2:B19), the total of the categories. B22 is the total of everything logged that month: =SUMIFS(Log!$C$2:$C$2000, Log!$A$2:$A$2000, ">="&$E$1, Log!$A$2:$A$2000, "<"&EDATE($E$1,1)). In B23 put =B22-B21. It should be zero. A value that is not zero means some rows have a blank or misspelt category.
What can I add later?
- A Budget column next to the totals, and a Left cell: =C2-B2.
- Conditional formatting that turns a row red when spend passes budget.
- A Paid by summary using SUMIFS on column E, so you see how much goes through UPI and how much is cash.
- A yearly view for April to March with twelve month columns.
Keep one file per financial year, from April to March, named for example 2026-27. Copy the whole file at year end rather than clearing it, so the old year stays intact and the new year starts with the same formulas and category list.
When the sheet starts to feel heavy
Typing every transaction is the weak spot of any tracker. If your bank and card statements already list most payments, SpendixAI can import them and categorise them for you to review, and you can still download reports as CSV and open them in Excel. Keep the sheet for what you enjoy tracking by hand, and let imports handle the rest.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

