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.

FAQ

Which business expenses are tax deductible?

Ordinary and necessary business expenses are deductible — rent, utilities, office supplies, professional fees, marketing, business travel, staff salaries, and depreciation on business assets. Personal expenses are not, even if paid from the business account. Keep a receipt or invoice for every entry so you can defend the deduction if asked.

Should I track personal and business expenses in the same file?

No. Keep them completely separate. Mixing them makes tax filing painful, confuses your P&L, and can cause problems if your business is ever audited. Use one spreadsheet for the business and a separate one for personal finance.

What is the difference between an expense tracker and a cash book?

An expense tracker records only outgoing money by category — useful for spotting where you spend. A cash book records both inflows (income received) and outflows (expenses paid) with a running balance, giving you an accurate view of cash on hand. Many small businesses use both.

Can I use this Excel expense template in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open with Google Sheets. Formulas, categories, and the SUMIF summary continue to work. You will get real-time collaboration too, which is useful if more than one person logs expenses.