Right now, most business owners stare at a profit-and-loss report and still can’t answer one basic question: “Are we actually okay?” In today’s episode, you’ll step into three very different meetings—and hear how one simple dashboard changes every decision in the room.
In each of those meetings, the same problem kept showing up: everyone had data, but no one had the *right* numbers in front of them at the *right* time. That’s what a financial dashboard is supposed to fix—but only if you’re ruthless about what gets a spot on the screen.
In this episode, we’ll move from “lots of numbers” to a short, sharp list of metrics that actually drive decisions. We’ll talk about tracking cash burn so you know exactly how many months of runway you have left—whether that’s 24 months or just 6. We’ll look at how a gross margin swing from 32% to 38% can matter more than a small bump in revenue. And we’ll see why a simple accounts-receivable aging view—like $120k current, $80k at 30 days, $40k at 60+—can change your next move.
So once you’ve picked those core numbers, the next step is turning them into something people actually use every day. That means wiring real data into a real-time view, not emailing around a static spreadsheet once a month. For example, instead of waiting for month-end, you might pull yesterday’s bank balance, open invoices, and card spend into a single view that refreshes every 15 minutes. A sales leader can see that CAC has crept from $240 to $275 this week. A COO can spot that average days to get paid just jumped from 32 to 41—before it becomes a cash problem.
If you want a dashboard people actually use, start by deciding **who** it serves and what decisions they need to make in under 60 seconds.
For a founder or CFO, that might be: - “Can we safely hire 3 more people?” - “Do we need to slow spending this month?” - “Are we on track to hit the next funding milestone?”
For a sales leader, it’s more like: - “Is our acquisition machine profitable this quarter?” - “Which channels should get more budget this week?”
Translate those decisions into **4–7 KPIs per view**. More than that and attention fragments. The finance view and the sales view can share some metrics (like CAC), but they should not be identical.
A practical starter layout for a SaaS company might look like this:
**Row 1 – Health at a glance (top strip)** 1) **Cash balance trend (last 90 days)** - Simple line chart with today at the right edge - Target band shaded (e.g., minimum comfort level at $800k)
2) **Monthly Net Cash Flow (last 6 months)** - Column chart: positive = green bars, negative = neutral or amber - Hover shows exact values, e.g., -$120k, -$95k, +$15k
**Row 2 – Profit drivers** 3) **Revenue vs. Operating Expense** - Dual-line chart, rolling 12 months - Clear moment where OpEx crossed below revenue is visible
4) **Gross Margin % by product line** - Bar chart: Product A 41%, B 36%, C 22% - Sort descending so weak lines are obvious at the right
**Row 3 – Cash engine** 5) **Accounts Receivable: Days to Collect** - Single big number, e.g., **37 days**, with arrow vs last month - Small sparkline under it showing the last 6 months
6) **Customer Acquisition Cost vs. Lifetime Value** - Ratio tile, e.g., **LTV:CAC = 3.4 : 1** - If it falls below 3.0, tile turns amber; below 2.0, red
Make the **time grain** match the decision cycle: - Daily or hourly for payment alerts and card spend spikes - Weekly for sales and marketing efficiency - Monthly for board-level profitability
Technically, use your BI tool’s **row-level security** so that: - Sales sees their pipeline, revenue, CAC, and LTV—but not salaries - Department heads see their own spend vs budget - Leadership sees everything, including cash, debt, and full P&L detail
Design rules that sound cosmetic are actually adoption levers: - Use a color-blind–safe palette: one accent color (e.g., blue) plus neutrals - Reserve red for true exceptions: missed covenant, negative margin, breach of cash threshold - Keep load time <3 seconds; if a page takes 8 seconds, split it into two focused tabs
And one last constraint: **no chart without an owner**. Next to each tile, note who acts on it (name or role) and how often. A metric nobody owns quickly becomes wallpaper.
McKinsey found that teams who share financial KPIs widely are about **1.5× more likely** to beat peers on ROIC. That’s not because they stare at prettier charts; it’s because everyone sees the same constraints.
Take a 40-person agency: before, only the founder watched numbers. After rolling out a simple “traffic-light” view to all managers—green if client work is >75% of total hours, amber at 65–75%, red below 65%—utilization rose from **61% to 73%** in two quarters, lifting quarterly profit by **$84k** without adding a single new client.
Or a DTC brand that added one tile: “Cash tied in inventory: **$472k**.” Beneath it, a bar split between fast- vs slow-moving SKUs. When slow movers crossed **$150k**, the tile turned red. That prompt led them to cut three SKUs and free up **$190k** for marketing—fueling a **12%** revenue jump the next quarter.
The pattern: specific, visible thresholds nudge behavior faster than any memo.
In the next wave, the advantage goes to teams that move from “displaying” metrics to **testing with them**. Treat each KPI tile as a live hypothesis: “If we cut discounting by 2%, does gross margin rise 1–1.5 points within 60 days?” Embed small A/B flags directly in charts and track lift—e.g., a **7% CAC drop** after pausing one channel, or **18 days faster** collection when offering a 1% early‑pay incentive. Build review rituals so every change has a before/after story in the data.
Your challenge this week: pick **one** decision you make repeatedly—like approving hires over $80k or discounting deals above 15%. Then, design a “mini dashboard” for just that choice. Limit yourself to **3 tiles max** (e.g., margin %, payback months, AR impact). If a metric doesn’t change the decision at least **30%** of the time, cut it.
