Getting started

Build your own expense tracker Excel template with working formulas

Build an expense tracker Excel template with four sheets, correct SUMIFS and data-validation steps, and a monthly summary that updates itself.

Editorial illustration for Build your own expense tracker Excel template with working formulas

Around thirty minutes and three sheets give a working Excel expense tracker template: Transactions for raw entries, Lists for categories, and Summary, which totals each category per month with SUMIFS. The formulas below work in Excel and in Google Sheets.

What should the Transactions sheet contain?

One row per expense, with the same columns in the same order every time.

ColumnHeaderExample
ADate05-04-2026
BDescriptionBig Basket order
CAmount1840
DCategoryGroceries
EAccountHDFC card
FMonth=TEXT(A2,"yyyy-mm")

Enter dates as real dates, not text. Column F turns each date into a label like 2026-04, which the Summary sheet will match.

How do you make the category column error-proof?

  1. On the Lists sheet, type your categories in A2 downward: Groceries, Rent, Transport, Eating out, Bills, Other.
  2. Back on Transactions, select D2:D500.
  3. Go to Data, then Data Validation, and choose List.
  4. For the source, select Lists!$A$2:$A$30.
  5. Now the dropdown stops typos such as Grocery and Groceries from splitting your totals.

How does the Summary sheet add things up?

Put categories down column A, and month labels such as 2026-04 across row 1 starting at B1. Then, in B2, write the formula below and copy it across and down.

  • =SUMIFS(Transactions!$C$2:$C$500, Transactions!$D$2:$D$500, $A2, Transactions!$F$2:$F$500, B$1)
  • Total per month: =SUM(B2:B7), placed beneath each column.
  • Share of month: =B2/B$8, formatted as a percentage.

The argument order in SUMIFS is the sum range first, then each criteria range followed by its criterion. Mixing that up is the most common error.

What does a quick check look like?

Say April holds Groceries ₹9,600, Rent ₹18,000 and Bills ₹3,400 in your three test rows. The April column should show ₹9,600 + ₹18,000 + ₹3,400 = ₹31,000. If it shows something else, the usual cause is a category spelled differently, or a date that is text, so F2 shows an error or an empty label.

Where does a template stop being enough?

  • Typing a month of UPI and card lines by hand is slow.
  • You need to track several accounts and currencies.
  • Receipts live somewhere else.
  • You want reports without rebuilding formulas.

When that happens, SpendixAI is an option: you upload statements as PDF, CSV or Excel, review the rows before saving, and download CSV reports to keep a copy. Your Excel template remains useful as a backup of the final numbers.

How do you add a simple monthly budget column?

Next to each category in the Summary sheet, add a Budget column with your planned figure, and a Difference column. If Groceries has a budget of ₹10,000 in cell N2 and the April actual is in B2, the formula in O2 is =N2-B2. A positive number means you are under budget, a negative one over. Apply conditional formatting to O2:O7 so negatives turn red. Keep budgets as numbers you typed, not formulas, so you can change them without breaking anything. Review them after three months rather than every week.

If you share the file with a partner, protect the Summary sheet so formulas cannot be overwritten by accident, and leave only the Transactions sheet open for typing. In Excel, use the Review tab and Protect Sheet. In Google Sheets, use Data, then Protect sheets and ranges. Add a note in A1 of the Transactions sheet saying which columns to fill and in what format, so nobody types a date as text.

Keep the template healthy

  • Back it up monthly under a dated name.
  • Never type over formulas.
  • Extend the 500-row range before you reach it.
  • Review categories at year end.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports