My accountant sends me a monthly report that’s 14 pages long. It’s thorough, precise, and completely useless for daily decision-making. By the time I’ve waded through balance sheets, profit-and-loss breakdowns, and variance analyses, I’ve forgotten what question I was trying to answer.
So I built a one-page dashboard. Three numbers, updated weekly, visible the moment I open my spreadsheet. These three numbers tell me more about the health of my business than any 14-page report ever could. They tell me whether I can afford to hire, whether I need to increase sales activity, and whether I’m trending toward or away from my annual targets.
Most founders either drown in financial data or ignore it entirely. Both are dangerous. Drowning leads to analysis paralysis — you have all the information but can’t make decisions. Ignoring leads to blind spots — you make decisions without the information you need.
The solution is a dashboard that shows you exactly what you need to know, nothing more. Here’s how to build one in about an hour, even if you hate spreadsheets.
The Three Numbers That Matter Most
After years of tracking various financial metrics, I’ve narrowed my dashboard to three numbers that drive every financial decision:
Number 1: Cash runway (in months). Current bank balance divided by average monthly expenses. If the number is above 6, you’re safe. Between 3 and 6, you’re fine but should be aware. Below 3, you need to act. This single number answers “Am I okay?” and “How much time do I have?” — the two most important questions for any founder.
Number 2: Monthly recurring revenue (MRR) plus pipeline value. Your guaranteed income next month plus a weighted probability of your sales pipeline. I weight pipeline at 50% for proposals sent and 20% for discovery calls completed. This number answers “What’s coming in?” and helps predict revenue 30-60 days ahead.
Number 3: Revenue per hour worked. Total revenue divided by total hours worked (including non-billable hours). This is your true earning rate. If it’s declining, you’re getting less efficient — probably spending too much time on low-value activities. If it’s increasing, your systems and pricing strategy are working.
These three numbers take about 15 minutes to update each week and give me a complete picture of financial health, incoming revenue, and operational efficiency. Everything else is detail that I review monthly or quarterly, not weekly.
Building Your Dashboard (The Practical Setup)
You don’t need fancy software. A Google Sheet works perfectly. Here’s the setup:
Tab 1: Dashboard (the one-page view). Three numbers prominently displayed at the top. Below them, a simple trend chart showing each number’s movement over the past 12 weeks. Green/yellow/red color coding for each number based on the thresholds I described above.
Tab 2: Cash tracker. Bank balances updated weekly. Monthly expenses listed with averages calculated automatically. Cash runway computed automatically.
Tab 3: Revenue tracker. Invoices sent, payments received, recurring revenue, and pipeline with weighted values. MRR plus pipeline computed automatically.
Tab 4: Time tracker. Hours worked per week (I use a simple Toggl-like tool). Revenue per hour computed automatically by dividing monthly revenue by monthly hours.
Total setup time: about an hour. Total weekly update time: 15 minutes every Monday morning as part of my weekly CEO review.
If you want something more polished, tools like Fathom, Xero dashboards, or even QuickBooks’ built-in reports can generate similar views. But don’t let tool selection delay implementation. A Google Sheet you actually use beats a sophisticated tool you never set up.
The Monthly Closer Look (Beyond the Three Numbers)
Weekly, I look at three numbers. Monthly, I look at twelve:
Revenue breakdown by source. How much came from recurring clients, project clients, products, and other sources? Is the mix shifting toward or away from my recurring revenue targets?
Client profitability. Revenue minus direct costs for each client. Some clients generate great revenue but consume so much time that the effective hourly rate is terrible. This analysis has led me to fire two clients and renegotiate terms with three others.
Expense analysis. What are my top ten expenses? Has anything changed? Are there expenses I can eliminate or reduce without affecting quality?
Accounts receivable aging. Who owes me money and for how long? Anything over 30 days gets a follow-up. Anything over 60 days gets escalated.
Year-to-date versus plan. Am I on track to hit my annual revenue and profit targets? If I’m behind, what needs to change? If I’m ahead, can I invest in growth?
Cash flow projection (next 90 days). Based on known income and known expenses, what does my cash position look like three months from now? This prevents surprises.
This monthly review takes about an hour and happens alongside the broader financial section of my weekly review system. The data feeds directly into my quarterly business reviews where I make bigger strategic decisions.
Decision Frameworks Based on Dashboard Data
The dashboard isn’t just for observation — it’s for action. Here’s how I translate numbers into decisions:
When cash runway drops below 4 months:
- Pause all non-essential spending
- Accelerate pipeline activity (more outreach, more follow-ups)
- Invoice faster (send invoices on completion, not at month-end)
- Follow up aggressively on overdue receivables
When revenue per hour drops below my target:
- Audit time allocation: am I spending too much time on low-value work?
- Review pricing: should I raise rates on new engagements?
- Evaluate client mix: are low-profit clients consuming too much capacity?
- Consider automating or delegating time-consuming tasks
When MRR plus pipeline suggests a shortfall:
- Reach out to past clients for new projects
- Activate referral requests from current clients
- Increase content output to fill the pipeline
- Consider a short-term promotional offering to close pipeline quickly
When all three numbers are green:
- Invest in growth (new offerings, marketing, team)
- Build reserves (increase the profit allocation)
- Take strategic risks (test new markets, launch new products)
- Take time off (seriously — this is when to vacation)
The dashboard gives me the confidence to make these decisions quickly because I trust the data. Without it, decisions are delayed by uncertainty or made impulsively without evidence.
What Not to Track (Keeping It Simple)
The temptation is to track everything. Resist it. Too many metrics create noise that obscures signal. Here’s what I deliberately exclude from my regular dashboard:
Social media metrics. Followers, likes, and impressions are interesting but don’t drive financial decisions. I review these separately as part of my content strategy evaluation.
Website traffic. Important for marketing decisions but not financial decisions. Reviewed monthly, not weekly.
Industry benchmarks. Knowing that “average consulting margins are 30-40%” is useful once. Tracking it weekly adds nothing. Check annually.
Detailed expense breakdowns. Monthly, yes. Weekly, no. Individual expenses don’t change fast enough to warrant weekly review.
Employee productivity metrics. If you have a team, their productivity should be reviewed in management contexts, not financial dashboards. Mixing the two creates a surveillance culture.
The principle: your financial dashboard answers one question: “Is the business financially healthy, and what do I need to do about it?” Anything that doesn’t directly answer that question is noise.
Takeaways
-
Track three numbers weekly. Cash runway, MRR plus weighted pipeline, and revenue per hour worked. These tell you whether you’re safe, what’s coming, and how efficient you are.
-
Build your dashboard in a Google Sheet. Four tabs: dashboard view, cash tracker, revenue tracker, time tracker. One hour to set up, 15 minutes per week to maintain.
-
Do a monthly detailed review of twelve metrics. Revenue breakdown, client profitability, expense analysis, receivables aging, YTD versus plan, and 90-day cash projection.
-
Use the data for specific decisions. Each number has clear thresholds that trigger specific actions. This removes emotion from financial decision-making.
-
Don’t track more than you need. Social metrics, detailed expense breakdowns, and industry benchmarks are noise in a financial dashboard. Keep it focused on the question: “Is the business financially healthy?”
