Ten minutes a week is all it takes.
Most founders I talk to can’t tell me their real cash position off the top of their head. They have a rough sense, revenue “around” a number, expenses “somewhere around” another, but not the actual margin, not the real free cash flow, and definitely not the growth rate versus last month. You don’t need a CFO to fix this. You need a simple tracker and ten minutes a week.
Why “I’ll look at my numbers when I have time” doesn’t work
Every founder I’ve ever worked with plans to sit down and go through their finances “properly” at some point. Quarterly review. Annual planning. Whenever the bookkeeper sends the report.
It never happens on schedule. By the time you open the P&L, you’re looking at numbers from three months ago, which means whatever decision you needed to make, hire, cut a software, push harder on sales, raise rates, you were making blind for an entire quarter.
The fix isn’t a better accounting system. It’s a ten-minute weekly habit that keeps your finger on the actual number in real time. You don’t need to replace your bookkeeper. You just need a live view that’s accurate enough to make decisions from.
That’s what a simple cash flow tracker does. Here’s what it should actually contain.
The five things a cash flow tracker has to cover
Skip the bloated templates with 40 tabs. The tracker only needs to do five things well:
- Monthly revenue, separated by current clients vs. new clients. This is the single most important split. It tells you how much of your month depends on closing new business vs. retaining existing.
- Monthly expenses, payroll, contractors, software, and “other.” Four categories is plenty. More granularity just makes it less likely you’ll update the thing.
- Free cash flow and margin %. The difference, and the percentage. This is the number you actually manage the business by.
- A yearly overview that annualizes your run rate. Take your month-to-date and project forward. It’s not a forecast, it’s a sanity check.
- An LTV tracker per client. How much each client has paid you cumulatively, and your average LTV across all of them.
That’s the whole system. You can run a legitimate $1–5M service business on this much financial visibility. We do.
The split that changes how you think, current clients vs. new
If there’s one part of the tracker most founders haven’t built, it’s splitting revenue between current clients and new clients each month.
Most trackers just lump it all together. “Revenue in March: $87K.” Fine. But if 65% of that came from existing relationships and 35% from new business, that’s a very different company than one where the split is flipped.
The reason this matters, businesses with high existing-client revenue are stable but slow-growing. Businesses with high new-client dependence are growing but brittle. If your new client share is 60%+ of monthly revenue, a bad sales month puts the whole business in trouble. If it’s 10%, you’re not growing, you’re coasting.
Watching that ratio over time tells you which lever to pull. Too dependent on new deals? Work on retention. Too dependent on existing clients and revenue is flat? Push harder on acquisition.
You can’t see any of that in a lumped-together revenue line. Split it.
Color-code payment status while you’re in there
This is a small thing that saves a lot of grief. Next to each client’s monthly revenue, add a tiny status indicator, paid, partially paid, late, or bounced. Green, yellow, orange, red.
Now when you look at the sheet on Monday morning, you’re not just seeing what revenue you generated. You’re seeing what revenue you’ve actually collected, and what’s still outstanding. Those are different numbers, and if you only look at generated revenue you’ll end up in a cash crunch you could have seen coming.
The conditional formatting takes thirty seconds to set up and saves you from finding out at the end of the quarter that three clients are 60 days late and nobody followed up.
“Most founders don’t run into a cash problem. They run into a visibility problem that turns into a cash problem.”
Related reading
The operations formula that doubles an agency →The yearly overview is where the real thinking happens
The monthly view is for data entry. The yearly overview is where you make decisions.
Once you’ve been filling in the monthly sheets for a while, the yearly view auto-aggregates and gives you twelve months side by side, revenue, expenses, free cash flow, margin, growth rate. Plus an annualized projection from your year-to-date, so you can see what trajectory you’re on right now without waiting until December.
Three simple charts on top of that, total revenue over time, total expenses over time, free cash flow over time, and suddenly the direction of the business is impossible to miss. Margins compressing for three months straight? You’ll see it. Expenses outpacing revenue? You’ll see it. Revenue growing nicely but cash flow flat? You’ll see that too, and figure out where the leak is.
This is the view I open when I’m thinking about hiring, about cutting a software subscription, about raising prices. Not the P&L. The tracker.
Track LTV per client, it changes how you sell
The last tab is the LTV tracker. Clients down the rows, months across the top, total paid per client on the right. Average LTV across all clients at the bottom, plus average revenue per client per month.
Two numbers you want to watch here. First, average LTV, it should be trending up over time. If it’s flat for six months, either your retention is slipping or you’re signing clients smaller than your existing book. Second, average revenue per client, if this is flat while your client count grows, the new clients are pulling the average down. Useful to know before you hire to serve them.
Most founders quote price off feel. Once you can see LTV trending, you start quoting against what you know a good client is actually worth to the business over time, not off what you hope you can charge.
This is not a replacement for a bookkeeper
Important caveat. If you can afford an accountant or bookkeeper, get one. Their reports will be more rigorous, more complete, and will include things this tracker can’t touch, accruals, depreciation, tax positioning, the whole proper picture.
What this tracker does is fill the gap between “official reports that arrive a month late” and “I have no idea what’s happening right now.” The weekly habit catches drift before the quarterly report does. And if you don’t have a bookkeeper yet, it’s a perfectly fine bridge until you do.
Ten minutes a week. That’s all the discipline this takes. If you can’t get yourself to that, the tracker isn’t your problem, you’ve got a deeper issue with actually running the business. Start with ten minutes a week, and the rest gets easier.
- • Most founders have a rough sense of their numbers, not an actual one. Ten minutes a week in a simple tracker fixes that.
- • Five things the tracker needs: monthly revenue split into current vs. new clients, four expense categories, free cash flow and margin, a yearly overview with annualized projection, LTV per client.
- • Splitting revenue by current vs. new clients tells you whether to push retention or acquisition. Most trackers skip this.
- • Color-code payment status. The difference between generated revenue and collected revenue is where cash crunches hide.
- • The yearly overview is where you make real decisions, hires, cuts, price changes. Not the P&L.
- • Not a replacement for a bookkeeper, but a bridge, and a real-time visibility layer even when you have one.
Grab the free cash flow tracker.
The exact Google Sheet template, monthly revenue (split by current vs. new), expenses, free cash flow, margin, yearly overview with annualized run rate, and LTV tracker. Ten minutes a week, zero setup. Free download.