Expense Tracker Template: Free Excel & Google Sheets

Some links in this post are affiliate links — see our disclosure.

Budget spreadsheets fail for one reason: they’re designed like tax forms. Thirty columns, conditional formatting, a dashboard that takes an hour to feed. You abandon it by February.

This template is the opposite. Four data columns, one category list, three summary formulas. It takes five minutes to set up, it works identically in Excel and Google Sheets, and it’s the sheet this site’s SUMIF guide uses in every example.

What’s inside

The whole template is one tab. No input sheet, no summary sheet, no charts tab.

That’s it. Four columns, nothing hidden, nothing computed while you type.

The category list

Keep it to eight or fewer. Every extra category is a decision you make per entry, and decisions are where trackers die.

1. Housing
2. Groceries
3. Utilities
4. Transport
5. Dining out
6. Subscriptions
7. Health
8. Income

If a purchase doesn’t fit, put it under the closest one. “Miscellaneous” is a black hole — don’t add it.

The three formulas that do the work

Paste these into a small summary block below the data (say, rows 2–4 of column G). They use SUMIF/SUMIFS, which work identically in Excel and Google Sheets — if one of them throws an error, our VLOOKUP error guide covers the usual suspects like range mismatches.

Total spent this month:

=SUMIFS(D:D, A:A, ">="&DATE(2026,8,1), A:A, "<"&DATE(2026,9,1), D:D, "<0")

Total income this month:

=SUMIFS(D:D, A:A, ">="&DATE(2026,8,1), A:A, "<"&DATE(2026,9,1), D:D, ">0")

Spending by category (put “Groceries” in F2, formula in G2):

=SUMIFS(D:D, B:B, F2, D:D, "<0")

Three formulas, not thirty. To see a category breakdown, type category names in F2:F9 and drag the formula down.

How to set it up (5 minutes)

1. Create a new spreadsheet — in Excel or Google Sheets (if you’re deciding between the two, our Excel vs Google Sheets comparison covers which fits your situation).
2. Type the headers in A1:D1: Date, Category, Description, Amount.
3. Add a data validation dropdown on column B: select B2:B500, then Data → Data validation (Sheets) or Data → Data Validation (Excel), and set the list to your eight categories. Now you click a category instead of typing it — this is the single biggest habit-saver in the template.
4. Paste the three formulas into the summary block.
5. Enter this week’s spending as a test run. If the totals move, the template works.

How to use it

• Enter once a day — three minutes, usually while making coffee. Daily beats weekly; weekly you forget the small purchases that add up to the real numbers.
• Don’t reconcile to the penny. If the credit card statement says $412.83 and the sheet says $410, you’re fine. The point is trends, not audit-grade accuracy.
• Review the category totals once a month (the first weekend works). Decide one category to cut, not five. One cut sticks; five don’t.

Why this template works

• Capture takes five seconds. A dropdown, a date, a number. If entry takes longer than the purchase did, you’ll stop.
• It answers one question: “Where did the money go?” The summary block answers it in one glance.
• It shrinks instead of growing. When the sheet feels heavy, you delete a category — you never add a feature. That’s the same philosophy as our Notion task system guide, just for money.

The fine print

• The template is free and stays free. Copy the structure above into any spreadsheet you own — there’s nothing to download and no account to create.
• If you want spending to arrive in the sheet automatically instead of by hand, the Zapier + Notion workflows guide shows the same trigger-and-append pattern, and you can point it at any spreadsheet or database you prefer.
• The formulas are date-bound to August 2026 as written — when the month changes, update the two DATE() values in the month formulas. Took you two seconds, right? That’s the whole point of boring.