How to Categorize Expenses in Excel

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:

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:

Then use a lookup when the vendor name is predictable:

In this example, B2 is the vendor field. The formula looks for that vendor in the rules table and returns the matching category.

Summarize spending by category

Once the category column is clean, category totals become simple.

If column D is Category and column F is Amount:

That returns total software spend.

For a business tracker, it is often better to limit the ranges:

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.

Make categories consistent

Create a controlled category list and use data validation instead of free-typing every label. Decide how refunds, transfers, taxes, subscriptions, and mixed-purpose purchases should be classified before importing transactions. Keep the original merchant description and add a category column so the source remains traceable. Review uncategorized rows and unusually large amounts each month, and write down exceptions in a notes field. A smaller, consistently applied category system is usually more useful than a long list nobody maintains.

Sources

• Internal Revenue Service: Recordkeeping
• Microsoft Support: Using structured references with Excel tables