There's a reason spreadsheets refuse to die: they are infinitely flexible, cost nothing, and keep your data offline. If you like being in control of your tools, building an expense tracker in Excel (or Google Sheets) is still a great move in 2026. This guide walks through the exact template we use, the 5 formulas that power it, and how to build the whole thing in under 30 minutes.
Prefer Google Sheets? We have a Google Sheets expense tracker template that uses the same structure. Prefer an app? Start with our best apps comparison.
Why Excel still works in 2026
- Zero data sharing. Your file never leaves your device unless you send it.
- Full customization. Columns, categories, formulas — your call.
- Powerful analysis. Pivot tables, charts, and filters on tap.
- No vendor lock-in. .xlsx opens in Numbers, Google Sheets, LibreOffice.
The trade-offs are real, too:
- You are the data entry clerk. Every row is your typing.
- No receipt OCR, no email parsing, no AI categorization.
- No mobile-friendly capture — you log when you're at the computer.
This is why many people start with a spreadsheet and graduate to an app like Smart Expense once they want the AI automation. We cover the comparison in our complete guide to expense tracking.
The template structure
A clean expense tracker template needs just three sheets:
Sheet 1: Transactions
| Date | Merchant | Category | Amount | Notes |
|---|---|---|---|---|
| 2026-04-22 | Whole Foods | Groceries | 84.12 | Weekly shop |
| 2026-04-22 | Shell | Transport | 45.00 | Fill up |
| 2026-04-23 | Netflix | Subscriptions | 17.99 | Monthly |
Sheet 2: Categories
A simple list of your categories (one per row). Used as a data-validation list for the Category column on Sheet 1 so you can't typo a category.
Sheet 3: Summary
A pivot table (or a set of SUMIFS formulas) showing monthly totals by category and a trend chart.
Build it from scratch in 30 minutes
- Open Excel. Save a new file as
expense-tracker-2026.xlsx. - Rename Sheet1 →
Transactions. Add headers: Date, Merchant, Category, Amount, Notes. - Select the data range, press Ctrl+T to convert it into a formatted table. Name the table
tbl_tx. - Create Sheet2 named
Categories. Type your 10 category names (see our expense categories list). - Back on Transactions, select the Category column. Data → Data Validation → List → source =
Categories!$A$1:$A$20. Now the column has a dropdown. - Format the Amount column as Currency.
- Create Sheet3 named
Summary. Add category totals via SUMIFS (formula below). - Select the summary range, Insert → Column Chart.
The 5 formulas you actually need
Total by category
=SUMIFS(tbl_tx[Amount], tbl_tx[Category], "Groceries")
Returns the total spent on Groceries across all transactions.
Total by category for a specific month
=SUMIFS(tbl_tx[Amount], tbl_tx[Category], "Groceries", tbl_tx[Date], ">=2026-04-01", tbl_tx[Date], "<2026-05-01")
Month total (all categories)
=SUMIFS(tbl_tx[Amount], tbl_tx[Date], ">=2026-04-01", tbl_tx[Date], "<2026-05-01")
Transaction count by category
=COUNTIFS(tbl_tx[Category], "Dining")
Largest transaction in a month
=MAXIFS(tbl_tx[Amount], tbl_tx[Date], ">=2026-04-01", tbl_tx[Date], "<2026-05-01")
Adding a simple dashboard
On the Summary sheet, lay out a small block at the top with:
- Current month total (big number)
- Last month total (for comparison)
- Top 5 categories this month
- Subscriptions total
- One column chart of monthly totals over time
That's a dashboard. Looks professional. Updates automatically as you add transactions to Sheet1.
When to graduate to an app
Spreadsheets stop being fun when one of these happens:
- You're missing days of entry because you can't be at your computer.
- Your paper receipt pile is growing (you can't photograph receipts into Excel).
- You want your phone to remind you about a subscription that just auto-renewed.
- You want AI to categorize for you.
When that moment arrives, Smart Expense accepts CSV import — so your spreadsheet history transfers cleanly. Your data stays yours, the tooling just levels up.
FAQ
Is Excel better than Google Sheets for this?
They're functionally equivalent. Sheets is better if you want easy phone editing. Excel is better for advanced formulas and larger datasets. Our Google Sheets template is the same template.
Can I import my spreadsheet into Smart Expense?
Yes — export as CSV, then import inside Smart Expense. Your history carries over and the AI categorizer picks up where you left off.
How many rows can Excel handle?
Modern Excel handles millions of rows without issue. A personal tracker will have a few thousand rows per year — no problem.
Spreadsheets are a wonderful starting point and a great long-term option for people who love control. For more on the broader tracking practice — weekly reviews, monthly closes, category hygiene — see our complete guide to expense tracking.