For most small business owners, expense tracking is one of those things that starts out simple and slowly becomes a mess. Receipts pile up. Credit card statements go unreviewed. Come tax time, you're scrambling to piece together where thousands of dollars actually went over the past year.
A well-built expense tracker in Excel fixes all of that. It doesn't have to be complicated — in fact, the simpler it is, the more consistently you'll use it. Here's how to build one that actually works, from scratch, in under an hour.
Open a new Excel workbook and create two sheets — one called "Expenses" for your raw data, and one called "Summary" for your totals and charts. Start with the Expenses sheet.
Here are the columns every good expense tracker needs:
| Column | What to Enter |
|---|---|
| Date | The date the expense was incurred |
| Vendor | Who you paid (Amazon, AT&T, Office Depot, etc.) |
| Category | Type of expense — see categories below |
| Description | Brief note about what the expense was for |
| Amount | The dollar amount — always enter as a positive number |
| Payment Method | Business card, personal card, cash, check, etc. |
| Reimbursable | Yes or No — for expenses to be reimbursed by a client |
Consistent categories are the most important part of a useful expense tracker. If you enter "Lunch" sometimes and "Meals" other times, your totals by category will never be right. Pick your categories once and stick to them.
Here are the most common categories for small businesses:
This is where Excel does the work for you. On your Summary sheet, set up your key totals using SUMIF formulas that pull directly from your Expenses table.
Total expenses all time:
Total by category (repeat for each category):
Total for a specific month:
Total reimbursable expenses:
Tracking what you spent is useful. Comparing it to what you planned to spend is where expense tracking gets genuinely powerful. Add a simple budget column next to your category totals and use a formula to calculate the variance automatically.
Set up three columns on your Summary sheet:
The Variance column tells you instantly whether you're over or under budget in each category. Add conditional formatting to make it red when you're over budget and green when you're under — no more hunting through numbers to find the problems.
The best expense tracker in the world is useless if you only update it once a quarter. Here's how to make consistent tracking a realistic habit:
Set a weekly 10-minute block. Pick the same time every week — Friday afternoon, Monday morning — and enter everything from the past week. Ten minutes is all it takes when you're doing it weekly instead of scrambling to catch up monthly.
Keep your receipts in one place. Use a folder in your email, a phone photo album, or a simple paper folder on your desk. The system doesn't matter — consistency does.
Reconcile against your bank statement monthly. Once a month, compare your tracker total to your bank or credit card statement. If the numbers match, you know your tracker is complete and accurate.
When your expense tracking is set up correctly and kept up to date, a few things happen. You stop being surprised by how much you're spending in certain categories. You have real numbers to work with when setting a budget for next year. Tax preparation becomes a matter of exporting a table rather than reconstructing months of spending from memory.
More than anything, you get visibility. And visibility leads to better decisions — which is the whole point of tracking anything in the first place.
If you'd like help setting up a custom expense tracker built specifically for your business — with your categories, your budget targets, and your reporting needs — that's exactly what we do at HelpMyData.
Tell us how your business works and what you need to track. We'll build a clean, easy-to-use Excel tracker tailored to your specific needs — starting at just $75.
📧 Get Started Today