Microsoft Excel is one of the most powerful tools ever created for tracking personal finances — and you almost certainly already have access to it. Whether you use the desktop version through Microsoft 365 or the free Excel Online version in your browser, you can build a complete expense tracker in about 30 minutes.
This guide walks you through the entire process from a blank spreadsheet to a fully functional monthly expense tracker, with no prior Excel experience required.
What You'll Build
By the end of this guide, you'll have an Excel expense tracker with a transaction log where you record every expense, automatic category totals using SUMIF formulas, a budget vs. actual comparison, color-coded alerts when you overspend in a category, and a monthly tab structure you can duplicate for each new month.
Step 1: Open Excel and Create Your Workbook
Open Microsoft Excel (desktop or online) and create a new blank workbook. Save it immediately as "Expense Tracker 2026.xlsx." You'll be working with two tabs: one called "Transactions" and one called "Summary."
Right-click on the default "Sheet1" tab at the bottom and rename it "Transactions." Click the "+" button to add a second tab and name it "Summary."
Step 2: Set Up Your Transactions Tab
On the Transactions tab, create these column headers in row 1:
| Column | Header | Purpose |
|---|---|---|
| A | Date | When the purchase was made |
| B | Merchant | Where you spent the money |
| C | Category | Type of expense |
| D | Amount | How much you spent |
| E | Notes | Optional details |
Select row 1 and make it bold. Then format column A as a Date column and column D as a Currency column by right-clicking each column, choosing "Format Cells," and selecting the appropriate format.
Step 3: Create a Dropdown List for Categories
The most important step for making your tracker actually useful is creating a consistent category list. If you type "Groceries" sometimes and "grocery" other times, your SUMIF formulas won't work correctly.
First, decide on your categories. A practical list:
- Housing, Groceries, Dining Out, Transportation, Utilities, Subscriptions, Health, Personal Care, Entertainment, Clothing, Savings, Miscellaneous
To create a dropdown in column C, select the entire column C (except the header). Go to Data → Data Validation. Under "Allow," select "List." In the "Source" field, type your categories separated by commas. Click OK.
Now when you click any cell in column C, a dropdown arrow appears and you select the category — no typing required, no inconsistencies.
Step 4: Enter Your Transactions
Each row is one transaction. Here's what a few days of entries might look like:
| Date | Merchant | Category | Amount | Notes |
|---|---|---|---|---|
| 07/01/2026 | Kroger | Groceries | $124.87 | Weekly shop |
| 07/01/2026 | Shell | Transportation | $52.00 | Gas fill-up |
| 07/02/2026 | Chipotle | Dining Out | $14.50 | Lunch |
| 07/03/2026 | Netflix | Subscriptions | $15.49 | Monthly |
| 07/03/2026 | CVS | Health | $28.00 | Prescriptions |
Step 5: Build Your Summary Tab with SUMIF Formulas
Switch to your Summary tab. Create a table with four columns: Category, Budget, Actual, and Difference.
In the Category column, list all your expense categories. In the Budget column, enter how much you plan to spend in each category this month. In the Actual column, use SUMIF formulas to pull the totals automatically from your Transactions tab:
=SUMIF(Transactions!C:C,"Groceries",Transactions!D:D)
This tells Excel: look in column C of the Transactions tab, find every row where the value is "Groceries," and sum the corresponding values in column D. Copy this formula for each category, changing the category name in quotes.
In the Difference column, use a simple subtraction: =Budget - Actual. A positive number means you're under budget. A negative number means you overspent.
Step 6: Add Conditional Formatting for Visual Alerts
Select your Difference column. Go to Home → Conditional Formatting → New Rule. Create two rules:
- Rule 1: Format cells where value is less than 0 → fill with light red (overspent)
- Rule 2: Format cells where value is greater than 0 → fill with light green (under budget)
Now your Summary tab gives you an instant visual snapshot of your budget health every time you open it.
Step 7: Add a Total Row
At the bottom of your Summary table, add a Total row using SUM formulas for Budget, Actual, and Difference. This gives you your overall budget performance for the month at a glance.
Step 8: Duplicate the Tab Structure for Each Month
When a new month starts, right-click on your Transactions tab and select "Move or Copy." Check the "Create a copy" box. Rename the new tab with the month name (e.g., "Aug 2026"). Clear out the transaction rows but keep your column headers and formatting. Do the same for your Summary tab.
The Manual Entry Problem — and How to Solve It
The system above is solid, but it has one weakness: you have to manually enter every transaction. For people who pay with cards and collect paper receipts, this quickly becomes the reason the tracker gets abandoned.
ReceiptSync eliminates this friction. You scan your receipts with your phone — paper receipts, email receipts, or digital receipts — and ReceiptSync automatically extracts the merchant name, date, and amount. You can export that data directly to Excel, so your Transactions tab stays current without the tedious manual entry. It's the difference between a tracker you maintain for two weeks and one you actually use all year. Start tracking your spending free with ReceiptSync →
Tips for Sticking With Your Excel Expense Tracker
The most important habit is consistency, not perfection. You don't need to log every transaction the moment it happens. Many people find it easier to batch their entries once a week — set aside 15 minutes on Sunday to log the week's receipts. Keep your receipts (or scan them with ReceiptSync as you go) so you have the data when you sit down to enter it.
Related posts: