I once watched a CEO spend 45 minutes in a financial review meeting trying to find one number: current runway. The CFO presented 23 slides covering P&L trends, balance sheet movements, departmental budgets, and capital efficiency metrics. The deck was comprehensive, polished, and utterly useless for making decisions.
The CEO just wanted to know: How much cash do we have? How fast are we burning it? How long until we need to raise capital or hit profitability?
Simple questions. But buried under layers of slides, charts, and tables.
This scenario plays out in boardrooms everywhere. Finance teams confuse comprehensiveness with clarity. They present everything when leadership needs something: the vital few metrics that drive decisions.
After managing finance operations from combat zones in Iraq ($33 billion in funds) to nuclear missions at Malmstrom Air Force Base ($125 million budget), I learned this lesson repeatedly: the best financial reporting isn't the most detailed. It's the most focused.
Here's the one-page financial dashboard framework I use with every client. It delivers clarity in five minutes, not 45.
The Problem with Most Financial Dashboards
Most dashboards fail for three reasons:
1. Too Much Information
More data doesn't create more insight. It creates cognitive overload. When you present 40 metrics, the audience retains maybe five—and you have no control over which five they remember.
2. Wrong Time Horizon
Most financial reports are backward-looking. They tell you what happened last month, last quarter, last year. That's important for learning, but not sufficient for steering. CEOs need forward-looking indicators that help them navigate what's coming.
3. No Hierarchy of Information
Not all metrics matter equally. Revenue matters more than office supply spending. Runway matters more than accounts receivable days. But most dashboards present everything with equal weight, forcing the viewer to do the mental work of prioritization.
The One-Page Dashboard Framework
The one-page dashboard solves these problems through ruthless focus. It's organized into five sections, each answering a critical question:
Section 1: How Much Cash Do We Have? (Top of Page)
This goes first because it's existential. Every other metric is academic if you run out of cash.
Metrics to include:
- Current cash balance — As of yesterday
- Monthly burn rate — Average of last 3 months
- Runway in months — Cash divided by burn, clearly labeled
- Trend indicator — Is burn accelerating, stable, or declining?
Visualization: Simple table or large numbers with color coding. Green if runway >12 months, yellow if 6-12 months, red if <6 months.
Why it works: The CEO can glance at this and know immediately whether cash is a current crisis, an upcoming concern, or not an issue. No calculation required.
Section 2: Are We Growing? (Left Column)
Revenue growth is the primary health indicator for most businesses. This section shows if you're gaining or losing momentum.
Metrics to include:
- Current month revenue
- Prior month revenue
- Month-over-month growth %
- Year-to-date revenue vs. target
- 3-month trend line — Simple sparkline or mini-chart
For subscription businesses, also include:
- Monthly Recurring Revenue (MRR)
- Net Revenue Retention
- Churn rate
Visualization: Use actual numbers plus a simple trend arrow (↑ ↓ →) or sparkline showing 3-6 months of history.
Why it works: Growth trajectory becomes immediately obvious. Is revenue accelerating, plateauing, or declining? You know in seconds.
Section 3: Are We Profitable? (Middle Column)
Profitability tells you whether your business model works at current scale.
Metrics to include:
- Gross profit and gross margin %
- Operating expenses
- EBITDA or Operating Income
- Net income
- Break-even revenue — How much revenue do you need to hit zero net income?
Visualization: Waterfall chart showing revenue → COGS → gross profit → opex → net income. Or simple table with margin percentages.
Why it works: You can see exactly where money is being made or lost. Is the problem gross margin or operating expenses? The structure makes it obvious.
Section 4: What's Our Unit Economics? (Right Column)
This section shows whether each customer, product, or transaction is profitable on its own.
For B2B/SaaS companies:
- Customer Acquisition Cost (CAC)
- Lifetime Value (LTV)
- LTV:CAC ratio — Should be >3:1
- Months to recover CAC — Should be <12
For e-commerce/transactional businesses:
- Average order value
- Contribution margin per transaction
- Repeat purchase rate
For service businesses:
- Revenue per employee
- Utilization rate
- Gross margin per project
Why it works: Unit economics reveal whether your business model is fundamentally sound. You can be growing fast and still failing if each customer loses money.
Section 5: What Should We Watch? (Bottom Section)
This section highlights leading indicators and risks that aren't reflected in current financials but will impact future performance.
Include 3-5 forward-looking metrics such as:
- Sales pipeline value — What's coming?
- Win rate trends — Are we closing more or fewer deals?
- Churn signals — Customer health scores, support ticket trends, usage metrics
- Key hiring progress — Critical roles being filled
- Upcoming large expenses — Major contracts, equipment purchases, etc.
Why it works: This is where you highlight what's not yet in the numbers but will be. It turns the dashboard from a rearview mirror into a windshield.
Design Principles
Layout and design matter as much as content. Here's how to make it scannable:
Principle 1: Visual Hierarchy
The most important information should be the most prominent:
- Larger fonts for critical metrics (cash, runway, revenue)
- Smaller fonts for supporting details
- Bold for current period, regular for comparisons
Principle 2: Color Sparingly
Color should convey meaning, not decoration:
- Green: Positive performance or low risk
- Red: Negative performance or high risk
- Yellow/Orange: Caution or moderate risk
- Black/Gray: Neutral information
Don't use color for every number. Use it to highlight what needs attention.
Principle 3: Minimize Chart Junk
Every element should serve a purpose:
- No 3D effects
- No unnecessary gridlines
- No decorative graphics
- Remove chart borders unless needed for clarity
White space is your friend. It makes the important stuff stand out.
Principle 4: Consistency
Use the same format every period:
- Same layout
- Same metrics in same positions
- Same color scheme
This allows pattern recognition. The CEO can spot anomalies instantly because they know what "normal" looks like on this page.
Sample Dashboard: A Real Example
Here's what this looks like for a $15M ARR SaaS company:
TOP SECTION - CASH POSITION
Cash: $4.2M | Burn: $350K/mo | Runway: 12 months 🟢
Trend: Burn stable vs. last quarter
LEFT COLUMN - GROWTH
MRR: $1.25M (+8% MoM)
ARR: $15.0M
Net Revenue Retention: 112%
Churn: 3.2% (↓ from 4.1%)
MIDDLE COLUMN - PROFITABILITY
Revenue: $1.3M
Gross Profit: $1.0M (77%)
Operating Expenses: $1.15M
Net Income: -$150K
Break-even Revenue: $1.5M
RIGHT COLUMN - UNIT ECONOMICS
CAC: $8,500
LTV: $32,000
LTV:CAC: 3.8:1 🟢
Months to recover CAC: 11
BOTTOM - LEADING INDICATORS
Pipeline: $2.8M (up from $2.3M last month)
Win rate: 28% (target: 25%)
Customer health: 87% "healthy" (stable)
Key hire: VP Sales starting Dec 15
That's it. Everything a CEO needs to know about the financial health of the business. On one page. Readable in five minutes.
Building Your Dashboard
Here's how to create this for your business:
Step 1: Choose Your Tool
Options in order of sophistication:
- Excel/Google Sheets: Fast to build, easy to customize, everyone can read it
- Tableau/Looker/Power BI: More powerful, can pull from multiple data sources, looks professional
- Specialized tools: Mosaic, Causal, Runway — purpose-built for finance dashboards
Start simple. Excel is fine. You can always upgrade later.
Step 2: Identify Your Top 5 Metrics
What are the five numbers your CEO actually needs to make decisions? Not the five you think are interesting—the five that drive action.
Ask your CEO: "If you could only see five financial metrics, which would they be?" Build around that.
Step 3: Build the First Draft
Don't aim for perfection. Get something on paper (or screen) that includes:
- The five critical metrics
- One chart or visualization
- One forward-looking indicator
Show it to someone. Get feedback. Iterate.
Step 4: Automate Data Refresh
Manual dashboards die. The finance person gets busy, the update gets skipped, and suddenly your one-page dashboard is three weeks stale.
Invest in automation:
- Direct connections from your accounting system to your dashboard
- Scheduled queries that pull fresh data
- Scripts that update calculations automatically
If updating the dashboard takes more than 15 minutes, automate more.
Step 5: Establish Update Cadence
How often should it refresh?
- Weekly: For high-growth or cash-constrained businesses
- Monthly: For stable, profitable businesses
- Real-time: If your systems support it and your business moves fast enough to warrant it
Whatever cadence you choose, stick to it religiously. Consistent updates build trust in the data.
Common Mistakes to Avoid
Mistake #1: Making It Two Pages
The constraint is the point. One page forces prioritization. Two pages becomes three, then five, then you're back to 23-slide decks.
If it doesn't fit on one page, you're including too much. Cut something.
Mistake #2: Showing Only Actuals
Numbers without context are meaningless. Is $1.2M in revenue good or bad? You can't tell unless you show:
- Prior period comparison
- Budget/target
- Trend direction
Always include context.
Mistake #3: No Narrative
The dashboard should answer most questions, but not all. Include a 2-3 sentence commentary box that highlights:
- The one thing that's going better than expected
- The one thing that needs attention
- The one decision that's needed
This frames the conversation before it starts.
Mistake #4: Static Forever
Your business evolves. Your dashboard should too. Quarterly, ask: "Are these still the right metrics?" Adjust as needed.
Beyond the CEO: Dashboard Variations
The CEO dashboard is the master view. But different stakeholders need different cuts:
Board Dashboard
- More emphasis on strategic metrics (growth rate, market share, competitive position)
- Longer time horizons (quarterly and annual trends, not just monthly)
- Capital efficiency metrics (burn multiple, capital raised vs. deployed)
Department Head Dashboard
- Departmental budget vs. actual
- Headcount and per-employee productivity
- Department-specific KPIs tied to company goals
Investor Dashboard
- Growth trajectory
- Milestone achievement
- Capital deployment and remaining runway
- Key risks and mitigations
Same principles—one page, ruthless focus, clear hierarchy—but tailored to the audience.
Final Thoughts
The one-page dashboard isn't just a reporting tool. It's a forcing function for strategic clarity.
When you have to pick the five most important metrics, you're forced to articulate what actually drives your business. When you have to fit it on one page, you're forced to eliminate noise. When you commit to updating it weekly or monthly, you're forced to build systems that make data accessible.
All of this makes you a better finance leader and makes your organization more data-driven.
Start building yours this week. Pick your five metrics. Put them on one page. Share it with your CEO. Get feedback. Iterate.
Within a month, you'll wonder how you ever ran the business without it.
Gabriel Denny Financial Services, LLC