How to Track Monthly Expenses in Excel (Step by Step)
Tracking your spending is the single most useful thing you can do with Excel. You don’t need an app, a subscription, or a finance degree — just one spreadsheet with a place to log what you spend and a few formulas that add it all up by category. This guide walks you through building exactly that, and if you’d rather not build it yourself, our Personal Budget & Spending Tracker does all of it the moment you open it.
The three pieces of an expense tracker
Every good expense tracker has the same three layers, and they map cleanly onto three worksheet tabs:
- A transactions log — one row per purchase: date, description, category, amount.
- A category summary — how much you spent in each category this month.
- A dashboard — the totals and a chart, so you can see where the money went at a glance.
Build them in that order. The log feeds the summary, and the summary feeds the dashboard.
Step 1 — Set up the transactions log
On a tab called Transactions, create four column headers in row 1: Date, Description, Category, and Amount. Then turn the range into a proper Excel Table (select your headers and press Ctrl+T). A structured table is worth the two seconds it takes — formulas that reference it expand automatically as you add rows, so you never have to rewrite a range.
To keep your categories consistent, add a drop-down list to the Category column using Data Validation. Pick Data → Data Validation → List and point it at a small list of categories (Groceries, Rent, Transport, Dining, Utilities, and so on). Now every row uses the exact same spelling — which matters enormously in the next step, because Excel treats “Dining” and “dining ” (with a stray space) as different categories.
Step 2 — Total each category with SUMIF
This is the formula that does the heavy lifting. On a Summary tab, list your categories down column A. Next to each one, use SUMIF to add up every transaction that matches:
=SUMIF(Transactions[Category], A2, Transactions[Amount])SUMIF reads “look through the Category column, find every row that equals the category in A2, and add up the matching Amounts.” Drag it down your category list and you have a live monthly total for each one — no manual adding, and it updates the instant you log a new expense.
Want a grand total? A plain SUM across your category totals does it:
=SUM(B2:B12)Step 3 — Compare against your budget
A tracker becomes a budget the moment you add a target. Put a Budget column next to your category totals, type in what you planned to spend, and add a Difference column that subtracts one from the other:
=B2-C2A positive number means you’re under budget; a negative one means you overspent. To make overspending jump off the page, select the Difference column and apply conditional formatting — a rule that turns the cell red when the value is less than zero. Now you don’t have to read numbers; the colors tell the story.
Step 4 — Build the dashboard
The dashboard is where it all comes together. Two visuals do 90% of the work:
- A pie chart of your category totals shows the proportion of spending at a glance — the slice for “Dining” being half the pie is a wake-up call no number delivers as fast.
- A small table of your three biggest categories, pulled with formulas, tells you where to cut first.
Freeze the top rows so your headers stay visible as the transaction list grows, and you’ve got a tracker you’ll actually keep using.
A faster route: pivot tables
If you’d rather not write a SUMIF for every category, a pivot table summarizes your transaction log in about four clicks: drop Category into Rows and Amount into Values, and Excel builds the category totals for you. The trade-off is that a pivot table needs a manual refresh when you add rows, whereas SUMIF updates live. Many people use both — SUMIF on the dashboard, a pivot table for ad-hoc “what did I spend on X?” questions.
Skip the build — open it and go
Everything above is built into our Personal Budget & Spending Tracker for $12. You get a Transactions log with category drop-downs already wired, a Budget vs Actual sheet with conditional formatting, and a Dashboard with a live spending pie chart and savings-rate gauge — all tested for zero formula errors. Log a few expenses and the whole thing fills in. If you want the budget tracker plus four more workbooks (loans, projects, freelancing, savings), the 5-template bundle saves you 40%.
Get the Personal Budget & Spending Tracker → $12
FAQ
What’s the best way to categorize expenses in Excel?
Use a fixed list of 8–12 categories and enforce it with a Data Validation drop-down. Consistent category names are what make SUMIF and pivot tables accurate — free-typing leads to “Food,” “food,” and “Groceries” being counted separately.
How do I total expenses by category automatically?
Use =SUMIF(category_range, "Groceries", amount_range). It adds every amount whose category matches, and it recalculates the moment you add a new row. See our full SUMIF guide for variations.
Can I track expenses in Excel on my phone?
Yes. The free Excel mobile app and Google Sheets both open .xlsx files, so a tracker you build on a laptop syncs to your phone. Formulas like SUMIF and SUM work the same on mobile.
How is this different from a budget?
A tracker records what you did spend; a budget adds what you planned to spend and flags the gap. Add a Budget column and a Difference formula (=Budget-Actual) and your tracker becomes a budget. Here’s a broader guide to budgeting in Excel.
