How to Track Expenses in Excel
Track expenses in Excel with a clean transaction log, categories, receipt status, and summary formulas that make monthly review easier.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
Expense tracking in Excel works best when every transaction gets one row. Do not start with charts or a giant dashboard. Start with a clean log that you can trust.
Once the log is consistent, summaries and reports become much easier.
Start with the right columns
Use a simple table with these fields:
| Column | Why it matters |
|---|---|
| Date | Lets you summarize by month or week |
| Vendor | Helps you spot repeat spending |
| Category | Powers budget and tax summaries |
| Amount | The number you will total |
| Payment method | Useful when cards, bank accounts, or cash are mixed |
| Receipt status | Shows what still needs documentation |
| Notes | Captures business purpose, client, project, or reimbursement context |
That structure is enough for personal spending, freelance expenses, small-business bookkeeping, and reimbursement prep.
Step 1. Turn the log into a table
Select the expense range and use Excel's table feature. A table makes filters easier, keeps formulas easier to read, and expands automatically when you add new rows.
Use consistent category names. Software, SaaS, and Apps may mean the same thing to you, but Excel will treat them as three categories unless you standardize them.
Step 2. Add category totals
If column C contains category and column D contains amount, total software spend with:
=SUMIF(C:C, "Software", D:D)That gives you a quick category rollup without building a pivot table.
For a month-specific total, use SUMIFS. If column A contains dates, G1 has the start date, H1 has the end date, and H2 has the category:
=SUMIFS(D:D, A:A, ">="&G1, A:A, "<="&H1, C:C, H2)That pattern is useful for monthly reviews because you can change the date window and category without rewriting the formula.
Step 3. Track receipts while the expense is fresh
Receipt tracking is easier when it happens at entry time. Use labels like Attached, Missing, Requested, or Not required.
Then filter the table to Missing before month-end. That is much better than searching email and card statements after the report is due.
✦ TIP
Step 4. Review the expense log monthly
A good monthly review answers four questions:
- which categories changed the most?
- which vendors repeated more often than expected?
- which receipts are still missing?
- which expenses should be reclassified before tax or reimbursement work?
If the sheet answers those questions, it is doing its job. You can add charts later, but the log and category totals matter more.
Use a template if you want the structure already built
If you do not want to build the columns and formulas from scratch, start with Griddy's expense tracker template. Freelancers can use the freelancer expense tracker, and small businesses can use the small business expense tracker.
The Griddy way
Expense tracking gets easier when the sheet can help with cleanup, not just storage.
"Categorize these expenses, flag missing receipts, and summarize March spending by category"
Griddy can update the tracker, clean up category labels, and build the summary from the transaction rows you already have.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.