Have you ever reached the end of the month and wondered, "Where did all my money go?"
I've asked myself that question more times than I would like to admit. As someone who builds websites, apps, browser extensions, and digital tools, I spend a lot of time thinking about income, growth, and opportunities. But over the years, I realized that focusing only on earnings tells only half the story.
In a previous blog post, I shared how tracking income and creating monthly summaries can help make smarter financial decisions. While income tracking is important, expense tracking is just as valuable. After all, it doesn't matter how much money comes in if you don't know how much is going out.
That realization led me to create a simple expense-tracking spreadsheet that helps me monitor spending without paying monthly subscription fees or handing my financial data over to third-party apps.
Why Expense Tracking Matters More Than Most People Think
Many people track their bank balance. Fewer people track individual expenses.
At first, those two things may sound similar, but they're not.
Knowing that your account balance dropped by $500 tells you what happened. Knowing exactly where that $500 went tells you why it happened.
When you record your expenses consistently, patterns begin to appear.
Maybe you're spending more on fuel than you realized.
Maybe you're buying office supplies every week.
Maybe restaurant spending is quietly increasing every month.
Maybe a business expense you thought was minor is actually becoming one of your highest recurring costs.
Without tracking, these patterns remain hidden.
With tracking, they become opportunities to improve.
A Lesson I Learned While Building Online Projects
Over the years, I've worked on many digital projects, from websites and calculators to browser extensions and spreadsheets.
One thing I've learned is that data helps remove guesswork.
When I look at website analytics, I can see which pages get traffic.
When I look at business reports, I can see which projects generate income.
The same principle applies to money.
If I don't collect the data, I'm forced to make decisions based on memory.
And memory is often inaccurate.
I've had situations where I thought I was spending very little on a particular category, only to discover after tracking that the amount was much higher than expected.
The numbers told a different story.
That's one reason I prefer keeping an expense log. It allows me to make decisions based on facts rather than assumptions.
Why I Didn't Want Another Subscription
Today, there seems to be an app for everything.
Many budgeting apps are helpful, but they often come with monthly fees, annual subscriptions, feature limitations, or requirements to connect your bank accounts.
Some people are comfortable doing that.
Others are not.
Personally, I wanted a solution that gave me complete control over my data.
I wanted something simple.
I wanted something I could understand.
Most importantly, I wanted something I owned.
That's why I created a spreadsheet-based expense tracker.
No monthly fees.
No linked accounts.
No complicated setup.
Just a straightforward system that allows me to record expenses and review spending patterns.
The DIY Expense Spreadsheet
The spreadsheet is designed for individuals, freelancers, side hustlers, and small business owners who want a practical way to track expenses.
You can find it here:
👉 https://erickouassi.gumroad.com/l/vbsad
The spreadsheet contains two main tabs.
Sheet 1: Expense Entry
This is where all expense data is entered.
Every row represents a single expense.
The fields include:
- Date: When the expense occurred.
- Time: Optional but useful for detailed records.
- Purpose: Select a category such as gas, travel, meals, office supplies, or other expense types.
- Amount Spent: Record the dollar amount.
- Notes: Add any details you want to remember.
- Month: Automatically generated from the date entered.
One thing I intentionally designed into the spreadsheet is flexibility.
Life gets busy.
You may forget to record an expense today and remember it three days later.
That's okay.
Simply enter the expense when you remember, and the spreadsheet will still organize it correctly based on the date.
The goal isn't perfection.
The goal is awareness.
Sheet 2: Insights and Analysis
This is where the spreadsheet becomes especially useful.
Unlike the first sheet, you don't have to manually enter anything here.
The information is automatically pulled from your expense records.
This allows you to look for trends and patterns that might otherwise go unnoticed.
For example:
- Did you spend more on transportation this month than last month?
- How often are you paying for vehicle maintenance?
- Are business-related purchases increasing?
- Which expense categories consume the largest share of your budget?
Instead of guessing, you can see the answers directly in your data.
A Real-World Example
Imagine you own a small business and use your car frequently.
Every month, you're paying for:
- Fuel
- Car washes
- Maintenance
- Parking
- Accessories
None of these expenses seem large individually.
But after several months of tracking, you might discover that transportation-related expenses represent a significant portion of your budget.
With that information, you can start asking better questions.
Could some trips be combined?
Could expenses be reduced?
Are costs increasing faster than revenue?
These are the kinds of insights that become visible when expenses are organized and categorized consistently.
What I Like Most About Spreadsheet Tracking
People often assume spreadsheets are outdated.
I disagree.
A well-designed spreadsheet can be remarkably powerful.
Here are a few reasons I still use them:
Simplicity
There's almost no learning curve.
If you can type into a cell, you can use the spreadsheet.
Clarity
Everything is visible.
You're not clicking through multiple screens trying to find information.
Control
Your data remains yours.
You decide where it's stored and how it's used.
Cost Savings
Many software subscriptions seem inexpensive at first.
But multiple subscriptions can add up quickly over the course of a year.
A spreadsheet can often accomplish exactly what many people need without ongoing costs.
Who Should Use This Spreadsheet?
This spreadsheet is ideal for:
- Freelancers
- Side hustlers
- Small business owners
- Independent contractors
- Gig workers
- Families managing household expenses
- Anyone trying to build better financial habits
That said, every situation is different.
If you're managing a large or complex business with extensive accounting requirements, professional accounting software and expert advice may still be necessary.
For many everyday users, however, this solution provides a simple and affordable starting point.
Lessons I've Learned About Financial Organization
Building tools for myself has taught me an important lesson.
Most financial problems don't start with bad intentions.
They start with lack of visibility.
When we don't know where money is going, making improvements becomes difficult.
When we can clearly see the numbers, better decisions become easier.
That's true whether you're managing personal finances, operating a side business, running a blog, or building software products.
Small habits repeated consistently often produce the biggest results.
Recording expenses may seem like a tiny task.
But after months of tracking, those entries become a valuable source of insight.
Practical Takeaways
If you're trying to improve your finances, here are a few simple steps:
- Start tracking expenses today, even if you're not perfect.
- Categorize spending consistently.
- Review your records monthly.
- Look for recurring expenses that can be reduced.
- Use data to guide decisions instead of relying on memory.
- Keep a system that's simple enough to maintain long term.
The best tracking system isn't necessarily the most advanced one.
It's the one you'll actually use.
Final Thoughts
As a builder, I've learned that successful projects start with understanding the data behind them.
The same principle applies to money.
Income tracking helped me understand what was coming in.
Expense tracking helped me understand what was going out.
Together, they provide a clearer picture of financial reality.
That's exactly why I created this expense spreadsheet. Not because it's complicated, but because it's simple enough to use consistently and powerful enough to provide useful insights over time.
If a basic tool can help you better understand your spending, make smarter decisions, and save money along the way, then it's doing its job.
So let me leave you with this question:
If you reviewed every expense you made over the last three months, what spending pattern do you think would surprise you the most?