Financial Dashboard Playbook — Minimal KPI Set

Why a Minimal Financial Dashboard?

If you run a one-person business or small operation, you need a handful of numbers that reliably tell you whether the business is healthy and what action to take next. Too many metrics create noise; none leaves you making decisions blind. This playbook gives a compact weekly dashboard you can build in a spreadsheet or light BI, plus update steps and decision triggers.

Core Hunger

Monitor a small set of metrics that tell you what to do next—protect runway, keep customers healthy, and avoid surprises.

Minimal KPI Set (what to track and why)

1. Net Cash (current bank balance)

   Why: Your most immediate resource. Shows how long you can operate without new inflows.

   How to get it: Bank balance or combined cash accounts at close of last business day.

2. Burn (monthly net cash outflow)

   Why: How much cash you spend per month on average.

   How to calculate: Sum of cash expense outflows minus cash receipts (non-recurring inflows excluded) over the last 30 days, or average of last 3 months for smoothing.

3. Runway (months)

   Why: How many months you can operate at current burn before cash hits zero.

   Formula: Runway = Net Cash / Monthly Burn. If Burn is negative (net inflow), show as “Growing” instead of numeric.

4. MRR / Retainer Revenue (recurring monthly revenue)

   Why: Predictable income you can count on every month.

   How to calculate: Sum of recurring subscriptions, retainers, or contract-based monthly billings recognized this month.

5. Client Concentration (% revenue from top client)

   Why: High concentration is risk. Knowing the share from your biggest client helps prioritize diversification or contingency planning.

   How to calculate: (Revenue from top client in last 3 months / Total revenue last 3 months) × 100.

6. Profit Margin (simple operating margin)

   Why: Shows whether revenue is actually producing surplus after direct costs (useful if you sell services or products).

   How to calculate: (Revenue − Cost of goods / direct delivery cost) / Revenue. Use trailing 30 days or month-to-date.

Simple Weekly Dashboard Layout (spreadsheet-friendly)

Structure a single-sheet dashboard with a few compact sections:

1. Top summary row — KPIs as large numbers with small trend sparkline: Net Cash, Runway (months), Monthly Burn, MRR, Client Concentration, Profit Margin.
2. Trends — small charts (last 12 weeks): cash balance, MRR, burn. Visual trends help spot momentum faster than numbers alone.
3. Risk indicators — simple colored badges (green/amber/red) driven by thresholds (examples below).
4. Actions & Notes — a short text field you update weekly for prioritized next action (e.g., “Follow up on overdue invoice X; pause ad spend; confirm retainer renewal”).

Weekly Update Checklist

• Update Net Cash with bank balance.
• Record any invoices sent & payments received since last update.
• Update or confirm recurring revenue (MRR/retainers).
• Update burn using recent outflows and expected invoices.
• Recalculate runway and client concentration.
• Write one short action describing what you will do this week if any indicator is amber/red.

Thresholds and Simple Interpretation Rules

Adjust thresholds to your business; these are starting points for small businesses:

• Runway < 3 months: RED — immediate action (reduce burn, accelerate collections, secure short-term cash).
• Runway 3–6 months: AMBER — plan to add revenue or reduce fixed costs; identify top 3 levers to extend runway.
• Runway > 6 months: GREEN — monitor, but don’t get complacent.
• Client concentration > 30%: AMBER — prepare contingency plan; aim to reduce to <20% over time.
• MRR growth flat or declining for 2+ months: AMBER — investigate churn, pricing, or sales pipeline.

Action Examples

• If cash drops unexpectedly: pause discretionary spending, contact largest receivable, consider short-term financing options.
• If client concentration is high: prioritize marketing to similar but independent customers, or develop digital product offering.
• If MRR is stable but profit margin is shrinking: review direct costs and pricing.

Minimal Tools & Low-Cost Automation

• Spreadsheet (Google Sheets / Excel) is enough. Use one sheet for Transactions, one for Customers, one for Dashboard calculations.
• Bank/Accounting feeds: where available, link bank or accounting tool (QuickBooks, Wave) to import transactions to reduce manual updates.
• Light BI: Google Data Studio, Microsoft Power BI Desktop, or Chart blocks in Google Sheets if you want charts without heavy cost.
• Set simple alerts: an email reminder to update the dashboard weekly; conditional formatting highlights thresholds.

Common Malhungers (what to avoid)

• Tracking dozens of KPIs that never change or don’t drive action.
• Relying solely on revenue without watching cash and runway.
• Using accrual accounting revenue for immediate cash decisions—use cash flows for runway decisions.

Next Steps — Starter Implementation (30–60 minutes)

1. Create a new spreadsheet and add these sheets: Transactions, Customers, Dashboard.
2. Populate Net Cash from your bank, add last 30 days of expenses and receipts into Transactions.
3. Compute Burn (last 30 days), MRR (current recurring invoices), Runway, Client Concentration.
4. Set conditional formatting for thresholds and add a small notes cell for the weekly action.

When to Consider More Automation

If updates become time-consuming or you want historical dashboards across products/clients, consider automating with accounting integrations and a light BI tool. That’s a natural next stage, but the spreadsheet playbook will serve most solo and microbusiness needs.

Quick Reference: KPI Formulas

• Runway (months) = Net Cash / Monthly Burn
• Client concentration (%) = (Revenue from top client, last 3 months / Total revenue, last 3 months) × 100
• Profit margin = (Revenue − Direct costs) / Revenue