How to Track Business Expenses in Excel (Step-by-Step + Free Template)

If you do not know where your money goes, you cannot control it. Tracking business expenses is the simplest habit that separates businesses that stay profitable from those that quietly bleed cash. You do not need expensive software — Excel does the job perfectly. Here is how to track your business expenses in Excel, step by step.

Why track your expenses

• Control spending — you spot waste and recurring costs you forgot about.
• Save on taxes — well-recorded expenses are deductions you can actually claim.
• Understand your business — your expenses feed straight into your profit and loss statement.
• Make better decisions — you see which areas cost the most and where to cut.

What to record for every expense

Keep it simple. For each expense, capture:

• Date of the expense
• Category (rent, utilities, salaries, marketing, travel, and so on)
• Description — a short note on what it was
• Payment method — cash, card, bank transfer, UPI
• Amount

Step-by-step: set up an expense tracker in Excel

1. Create the columns. Add headings: Date, Category, Description, Payment Method, and Amount.
2. Make a category list. Decide on a fixed set of categories and use a dropdown so every entry is consistent. Consistency is what makes your totals meaningful.
3. Enter expenses as they happen. The habit matters more than the format — add each expense the day it occurs so nothing is forgotten.
4. Add a summary. On a second sheet, use a SUMIF formula to total spending by category. This instantly shows where your money goes.
5. Review monthly. At month end, look at the category totals, compare with previous months, and act on anything that crept up.

Categories most small businesses use

Rent, utilities, salaries and wages, inventory or materials, marketing, travel, office supplies, software and subscriptions, taxes, and a "miscellaneous" catch-all. Keep the list short enough to be practical but detailed enough to be useful.

Tips to actually stay consistent

• Record daily, not monthly — catching up on a month of receipts is painful and error-prone.
• Keep your receipts — note the voucher or receipt number so you can find proof later.
• Separate business and personal — never mix the two; it makes tax time a nightmare.

Save time with a free template

Setting up the formulas yourself takes time. Instead, download our free business expense tracker — it already has the category dropdown and an automatic summary that totals your spending by category. Just start entering expenses.

To track cash specifically, our cash book template records cash in and out with a running balance, and your totals feed neatly into a profit and loss statement.

Summary

Tracking business expenses comes down to recording every expense consistently with a date, category, and amount, then summarising by category each month. Set it up in Excel with a dropdown and a SUMIF summary — or start from a ready-made template and just enter your numbers.