Business Expense Tracker

Template Overview

Keeping track of where money goes is the simplest habit that separates businesses that stay profitable from those that quietly bleed cash. This free business expense tracker for Excel makes it painless: enter each expense once on the Expenses sheet (date, category, description, payment method, amount) and the linked Summary sheet recalculates instantly using SUMIF formulas. The Month column fills in automatically from the date, and the Category column has a built-in dropdown so your data stays consistent.

Who this expense tracker is for

• Freelancers and consultants logging billable and reimbursable expenses
• Small businesses and startups tracking spend before they can afford accounting software
• Shopkeepers, service providers, agencies managing monthly outflows in India, US, UK, Australia, and worldwide
• Anyone who wants a clear monthly picture without learning QuickBooks, Zoho, or Tally

Which expense categories should a small business use?

Consistent categories are what make an expense tracker useful. Start with these and adjust for your business:

• Rent & utilities — office rent, electricity, water, internet
• Salaries & wages — employee pay, contractor fees, professional charges
• Marketing & advertising — ads, SEO, content, promotional material
• Software & subscriptions — SaaS tools, hosting, domains, cloud storage
• Office supplies — stationery, printing, small equipment
• Travel — flights, taxis, fuel, hotel stays for business
• Meals & entertainment — client lunches, team meals
• Professional fees — accountant, lawyer, consultant
• Bank charges & interest — fees, loan interest, transaction charges
• Taxes & compliance — GST paid, professional tax, filing fees
• Repairs & maintenance — office repairs, equipment servicing
• Miscellaneous — anything that does not fit above (keep this small)

Rule of thumb: 8-12 categories is the sweet spot. Fewer and you cannot see trends; more and every expense feels like a decision.

Expense tracker vs cash book vs profit and loss statement

These three often get confused, but they answer different questions:

• Expense tracker — where is my money going? Only outflows, grouped by category.
• Cash book — how much cash do I have right now? Both inflows and outflows with a running balance.
• Profit and Loss statement — did I make a profit this period? Revenue minus COGS minus expenses = net profit.

Most small businesses need all three. The expense tracker feeds the P&L (your expenses section) and the cash book (as outflow entries).

How to claim business expenses at tax time

An expense tracker is your first line of defence at tax filing. To make an expense deductible:

1. Record the date, vendor, category, and amount — this tracker captures all four automatically.
2. Keep the receipt or invoice — save PDFs in a folder named after the month.
3. Only claim genuine business expenses — personal purchases from the business account are not deductible.
4. Match to your P&L — the total in each category should tie to the corresponding expense line in your Profit and Loss statement.

In India, business expenses reduce your taxable income under the Income Tax Act (Section 37 for revenue expenses). Similar rules apply in most countries. If your accountant asks for an "expense schedule," this tracker with a printed Summary sheet is exactly what they need.

Common mistakes to avoid

• Waiting until the end of the month to enter expenses — receipts get lost. Enter them the same day or every few days.
• Mixing personal and business expenses — always keep them in separate files.
• Creating a new category for every unique expense — stick to your defined list; use description for detail.
• Ignoring small recurring costs — a ₹500 monthly SaaS subscription is ₹6,000 a year.
• Never reviewing the Summary sheet — the tracker's whole point is the monthly review.

Why an Excel expense tracker beats an app

Apps look modern but come with tradeoffs: monthly fees, vendor lock-in, sync issues, and privacy concerns. A spreadsheet you own has real advantages:

• Free forever — no subscription, no ads, no upsells
• Your data stays with you — no cloud account required
• Fully customisable — add columns, categories, or formulas any time
• Works everywhere — Excel, Google Sheets, LibreOffice Calc, Numbers, WPS
• Prints cleanly — for physical filing, audits, or accountant handoff

If your business ever outgrows a spreadsheet, you can export from any accounting tool that imports Excel. Starting simple with a tracker is the right call for anyone doing under a few hundred transactions per month.

Features

• Two linked sheets: expense log + auto summary
• Spend-by-category totals update automatically (SUMIF)
• Built-in category dropdown keeps data clean
• Month auto-fills from each date
• Works in Excel, Google Sheets and LibreOffice

Instructions

1. Download the file and open it in Excel, Google Sheets, or LibreOffice.
2. Go to the Expenses sheet and enter each expense on its own row.
3. Pick a category from the dropdown so the summary groups it correctly.
4. Type the amount — the running total at the bottom updates automatically.
5. Open the Summary sheet to see spending by category and your grand total.
6. Add or rename categories to fit your business if needed.

FAQ