Financial Dashboard Seed — Minimal Weekly KPIs

Purpose and audience

This dashboard is for solopreneurs, freelancers, and microbusiness owners who need a small set of numbers that reliably signal whether the business is healthy and what to do next. It focuses on weekly cadence so you can spot trends and act before small problems become big ones.

Core KPIs (what to track and how)

• Weekly revenue — Cash received or invoiced for work delivered during the week. (Spreadsheet: sum of payments or invoices dated in week.) Why: shows near-term sales performance and market demand.
• Booked work — Value of confirmed work scheduled to be delivered in the next 30 days (contracts, signed proposals, scheduled projects). Why: a forward-looking buffer for revenue.
• Cash balance — Available cash in operating accounts (exclude long-term reserves). Why: immediate ability to pay expenses and respond to opportunities.
• 3‑month runway — Cash balance divided by average monthly net cash burn (use trailing 90 days to estimate monthly burn). Express as months. Formula (simple): runwayMonths = cashBalance / (averageMonthlyBurn). Why: clear signal of how long you can operate without new income.
• Gross margin % — (Revenue − direct costs) / Revenue × 100. Use the same definition of direct costs consistently (subcontractors, materials, platform fees). Why: shows whether the business is scalable and which offers are profitable.
• Client concentration % — Revenue from top client over the tracking period / total revenue × 100. Why: high concentration is risk; it triggers actions to diversify.
• Experiment ROI — Simple ratio for each marketing/sales experiment: (Net revenue attributed − experiment cost) / experiment cost. If you cannot attribute revenue directly, use leading indicators (leads or conversion lift) as a proxy. Why: keeps you experimenting without wasting money.

Suggested thresholds and signals (quick defaults)

• Runway < 3 months — urgent: prioritize cash, cut discretionary spend, accelerate sales/collections.
• Gross margin < 30% (service businesses) — investigate pricing, scopes, or costs.
• Client concentration > 30–40% — plan diversification actions (new leads, alternative offers).
• Booked work declining 3 consecutive weeks — trigger sales sprint or promotional experiment.
• Experiment ROI < 0 — pause or iterate; keep experiments small and time-boxed.

Spreadsheet / Airtable layout (simple template)

Columns (one row per week): WeekStart | WeeklyRevenue | BookedWork30d | CashBalance | AvgMonthlyBurn | 3MoRunway | GrossMarginPct | TopClientPct | ExperimentROI | Notes | Action

Example formulas (spreadsheet-friendly):

• 3MoRunway = CashBalance / AvgMonthlyBurn
• GrossMarginPct = (WeeklyRevenue - DirectCosts) / WeeklyRevenue
• TopClientPct = TopClientRevenue / WeeklyRevenue

Visuals that help

• Sparklines for Weekly Revenue and Booked Work (8–12 week window) to see trends at a glance.
• A small gauge or highlighted number for 3‑month runway (red/amber/green thresholds).
• Bar comparing weekly revenue to a simple target or rolling average.
• Single-line indicator for client concentration with a callout when it exceeds your threshold.

Weekly huddle — a short maintenance guide (15–25 minutes)

1. Quick readout (3 minutes): who updates the dashboard and any data-quality notes.
2. Numbers review (5 minutes): look at the three fastest-moving signals — Weekly Revenue, Booked Work, Cash Balance / Runway.
3. Signal check (5 minutes): call out any thresholds hit (runway under 3 months, margin drop, rising concentration).
4. Decide one action (5–10 minutes): choose one concrete step you will take this week (call a prospective client, tighten scope on a project, run a low-cost promotion, pause an experiment). Record owner and due date in the Action column.
5. Capture learning (2 minutes): note one insight about what’s working or not for next week.

Data sources and responsibilities

Typical sources: bank statements (cash balance), invoicing/bookkeeping (revenue), CRM or calendar (booked work), expense records (direct costs), and experiment tracking sheets (experiment cost/results). Assign one person (often the business owner) to update the dashboard weekly and mark the date of last update in the sheet.

Small-business tips

• Make the dashboard a living tool: if a metric doesn’t trigger actions, remove it.
• Favor forward-looking metrics (booked work, runway) over vanity numbers.
• Keep experiments cheap and measurable; stop what doesn’t produce a reasonable ROI quickly.
• Automate simple pulls where possible (bank balances, bookkeeping exports) but validate numbers weekly.

How to adapt this dashboard

Customize metrics for your model: subscription businesses may prefer MRR and churn instead of weekly revenue; product sellers should track inventory turnover and gross margin per SKU. Adjust thresholds to your runway tolerance and seasonality.

Next steps and suggested templates

To make this practical quickly: create a Google Sheets or Airtable copy with the columns above, add simple formulas for runway and margin, and build an 8–12 week sparkline view. If you want saved weekly history and trend analysis, consider an interactive weekly submission form that appends each week’s numbers to a dataset.

Image search phrase: financial dashboard small business