How to Categorize Expenses in Excel
Categorize expenses in Excel with clear rules, dropdowns, lookup tables, and review fields so spending reports stay consistent.
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 categories are what turn a transaction list into something useful.
Without categories, an expense tracker is just a long receipt log. With consistent categories, you can review spend by travel, meals, software, supplies, payroll, or client costs without rebuilding the analysis every month.
Start with a short category list
Do not create 40 categories on day one.
Start with the categories you actually review:
| Category | Common examples |
|---|---|
| Travel | flights, hotels, taxis, mileage |
| Meals | client meals, team meals, coffee |
| Software | SaaS tools, subscriptions, licenses |
| Office | supplies, equipment, postage |
| Marketing | ads, contractors, events, creative |
| Professional services | legal, accounting, consulting |
| Other | real expenses that need later review |
The goal is not perfect taxonomy. The goal is consistent review.
Use dropdowns for manual categorization
If people are entering expenses by hand, use a dropdown list for the Category column.
That prevents variations like software, Software, SaaS, and Tools from splitting the same kind of spend into separate buckets.
Dropdowns are especially useful in a freelancer expense tracker where the same person is entering expenses quickly between client work.
Use lookup rules for repeated vendors
For recurring vendors, create a small rules table on another sheet:
| Vendor contains | Category |
|---|---|
| Uber | Travel |
| Adobe | Software |
| Google Workspace | Software |
| Delta | Travel |
Then use a lookup when the vendor name is predictable:
=XLOOKUP(B2, Rules!A:A, Rules!B:B, "Needs review")In this example, B2 is the vendor field. The formula looks for that vendor in the rules table and returns the matching category.
⚠ WATCH OUT
Vendor-based rules are useful, but they are not perfect. A marketplace, card processor, or general retailer may need manual review because the vendor name does not explain the business purpose.
Summarize spending by category
Once the category column is clean, category totals become simple.
If column D is Category and column F is Amount:
=SUMIF(D:D, "Software", F:F)That returns total software spend.
For a business tracker, it is often better to limit the ranges:
=SUMIF(D2:D500, "Software", F2:F500)That keeps the formula clearer and avoids unnecessary full-column calculations in larger workbooks.
Add a review category
Every expense system needs a temporary category for uncertainty.
Use Needs review when the vendor or purpose is unclear. That is better than guessing. During month-end review, filter those rows and assign final categories before sending the data to a bookkeeper, manager, or expense report.
The Griddy way
Categorizing expenses manually gets tedious because the same vendor rules, dropdowns, and review exceptions keep coming back.
"Categorize these expenses using Travel, Meals, Software, Office, Marketing, and Needs review, then summarize totals by category"
Griddy can structure the category list, apply the repeatable rules, flag uncertain rows, and build the summary table from the cleaned data.
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.
Use this on real templates
Make spending categories consistent enough to review
Clean expense categories turn raw transactions into budget insight, tax prep, reimbursement checks, and management review that can be trusted.
Expense Tracker
Log every expense, track receipts, and generate category summaries. Free template for personal or business use.
Expense Tracker for Small Business
Track small business expenses by vendor, category, payment method, receipt status, and month in one free spreadsheet for Excel and Google Sheets.
Expense Tracker for Freelancers
Track freelance business expenses, receipts, software, client costs, mileage, and tax categories in one free spreadsheet template.
Small Business Budget
Plan revenue, direct costs, overhead, and EBITDA in one compact operating budget. Keep H1 totals, margin, and owner notes visible without building a giant finance model.