The Only Financial Dashboard Your Agency Needs: Five Numbers, Updated Monthly
- Ellis Bennett

- Jun 30
- 4 min read
The agencies that make consistently better decisions about hiring, pricing and growth are not doing so because they have better instincts.
They have five numbers updated on the first Monday of every month.
That's it. That's the entire system.
"Five numbers. First Monday. Every month. That's the whole habit."
No finance director. No expensive software. No 40-tab spreadsheet nobody opens. Just five numbers, tracked consistently, reviewed monthly — and a habit that compounds into significantly better decision-making over time.
Why Five Numbers Is Enough
Most agency owners either track nothing beyond what their accountant sends at year end, or they try to build an elaborate financial model and abandon it after month two because it's too time-consuming to maintain.
The dashboard below sits in the middle. It takes 20 minutes to build and 10 minutes a month to update. It won't tell you everything about your business — but it will tell you the five things that matter most, and it will tell you in time to act on them.
The real value isn't in any single number. It's in the trend. One month tells you very little. Three months tells you whether you're improving, flat, or heading somewhere you don't want to be.
The Five Numbers to Track
1. Revenue This Month vs Last Month -
Direction of travel matters more than the absolute figure. Is revenue growing, flat or declining?
Where to find it: Xero → Reports → P&L → current month.
2. Gross Margin % This Month vs Last Month -
Gross profit ÷ revenue × 100. Target 55% or higher.
If gross margin is declining while revenue grows, you are scaling a problem rather than scaling a business. Growth that erodes margin isn't progress — it's a pricing or delivery efficiency issue getting bigger every month.
Where to find it: same P&L report.
3. Net Margin % This Month -
What's left after every cost is accounted for. Target 20% or higher.
This is the wealth creation metric. Revenue and gross margin tell you whether the business model works. Net margin tells you whether the business is actually making money you can keep.
Where to find it: bottom line of the same P&L report.
4. Cash in Bank Today -
Not projected. Not expected. The actual balance, right now.
Alongside this, ask: do you have three months of operating costs accessible? This is your buffer position, and it's the single biggest factor in whether a difficult month becomes a crisis or a non-event.
Where to find it: Xero → Banking → Bank Accounts.
5. Corporation Tax Set Aside to Date -
What percentage of net profit year-to-date is sitting in a dedicated tax account? It should be 20–25%.
If it's less than that, move some across today. This number is the difference between a calm January and a panicked one — it tells you in real time whether you're on track or building a problem for year end.
Where to find it: check your tax savings account directly.
How to Build the Dashboard
You don't need anything sophisticated for this. A simple Google Sheet works:
Five rows, one for each number above
Monthly columns running left to right across the top
A benchmarks column on the right showing the target for each metric: 55%+ gross margin, 20%+ net margin, three months of cash, 20–25% CT set aside
Fill in the current month and the previous two if you can. Three data points give you a trend line — and the trend is far more useful for decision-making than any single snapshot.
Your Checklist
Build the dashboard today — a Google Sheet, five rows, monthly columns across the top
Add a benchmarks column on the right — 55%+ gross margin, 20%+ net margin, three months cash, 20–25% CT set aside
Fill it in for this month and the last two — the trend is more useful than any single data point
Set a recurring reminder — first Monday of every month, 20 minutes, update the dashboard
Share it with your accountant — they should be reviewing this with you monthly
Three Things to Do This Week
1. Build the dashboard today. Five rows in a Google Sheet. Twenty minutes to build once, ten minutes to update every month after that. Set it up before anything else this week.
2. Fill in the last three months — not just this one. A single month tells you very little. Three months gives you the trend, and the trend is what actually drives good decisions.
3. Look at what the trend is telling you. Gross margin declining while revenue grows is a pricing conversation. Net margin consistently below 15% is a cost structure conversation.
Corporation tax set aside sitting at zero is a January problem already in motion.
This isn't a complicated system. It's a simple one that most agency owners never build because it feels too basic to matter.
It matters. Five numbers, reviewed every month, is the difference between making decisions on instinct and making them on evidence.
Want to talk through your numbers? Book a discovery call — no obligation, just a straight conversation about your agency's finances.
Want more insights like this delivered straight to your inbox? Subscribe to The Margin — financial clarity for growing agencies, every week.

%20copy_edited.png)



Comments