Skip to content

Create a One-Page Dashboard for Your Small Business

Why a one-page dashboard matters

You’re busy. A one-page dashboard gives you the few numbers that tell whether the business is healthy or needs attention. It saves time, stops guesswork, and focuses actions on what moves the needle.

Decide the purpose and audience

Pick one primary purpose and who will use the dashboard. Examples:

  • Owner daily check: cash, sales, urgent issues.
  • Weekly operations: productivity, backlog, inventory.
  • Monthly growth: revenue, margins, customer trends.

Rule: If you can’t explain the purpose in one sentence, simplify it.

Choose 6–8 key metrics (KPIs)

Limit to the small set that answers the purpose. Use this filter: Is it measurable, timely, and actionable?

Common KPI sets by business type:

  • Retail: Today’s sales, 7-day avg sales, cash on hand, inventory turnover, top-selling SKUs, returns %.
  • Service (e.g., plumbing): Booked jobs (7-day), Revenue this month, Technicians’ utilization, Average job value, On-time rate, Open leads.
  • E-commerce: Daily revenue, Conversion rate, Average order value, Traffic (sessions), Cart abandonment %, Fulfillment delay days.

Design the layout (one page, clear zones)

Divide the page into clear zones that match decision flow:

  1. Top line: Overall headline metrics (1–2 numbers). Example: Today’s revenue; Cash available.
  2. Left column: Leading indicators (traffic, leads, appointments).
  3. Right column: Lagging indicators (revenue, gross profit, returns).
  4. Bottom: Operational exceptions and actions (issues to fix this period).

Visual rules: use big numbers for headlines, small charts for trends (sparkline), one color for “ok”, red for alerts.

Set simple thresholds and decision rules

Turn numbers into actions. Attach a short rule to each metric:

  • Sales vs target: If daily sales < 80% of target → run promotion or call top 10 customers.
  • Cash on hand: If < 14 days of runway → delay nonessential spending and invoice follow-up.
  • Inventory turnover: If < 1/month for key SKU → run clearance or bundle offers.
  • Open leads: If > 20 uncontacted leads → assign owner and call within 24 hours.

Pick tools that match your comfort level

Simple tools get you 80% of the value. Choices:

  • Spreadsheet (Google Sheets or Excel): Best for control, low cost. Use simple formulas and one sheet as the dashboard.
  • Dashboard apps (Google Data Studio / Looker Studio, Power BI, Tableau): Good for automated data pulls if you have multiple systems.
  • All-in-one POS/accounting dashboards: Many POS or accounting systems offer built-in dashboards—use them if they show your chosen KPIs.

Rule of thumb: Start in a spreadsheet. Move to a dashboard app only when you have stable KPI definitions and want automation.

Data sources and update frequency

Decide where each metric comes from and how often it refreshes. Common sources: POS, accounting, booking system, website analytics.

Practical update schedule:

  • Daily: Sales, cash, appointments, urgent operational issues.
  • Weekly: Inventory levels, leads, staff utilization.
  • Monthly: Gross margin, churn, customer acquisition cost.

Build it step-by-step (spreadsheet method)

  1. Open a new sheet named Dashboard.
  2. Top row: put dashboard title and date last updated.
  3. Create a section for each KPI with: label, current value, short trend (last 7 days), and action rule.
  4. Use simple formulas: SUM, AVERAGE, COUNTIF, VLOOKUP (or XLOOKUP).
  5. Add conditional formatting: green/yellow/red based on thresholds.
  6. Create small charts (sparklines) to show direction over time.
  7. Lock the layout and share view-only with your team; keep a separate editable data sheet.

Example dashboard snapshot (service business)

Top line: Today’s revenue: $1,200 (target $1,800) — ALERT (call 5 past customers).

Left: Booked jobs (7-day): 28; Open leads: 14 (follow-up owner)

Right: Month-to-date revenue: $22,000; Avg job value: $785; Tech utilization: 68% (target 75%)

Bottom: Exceptions: 3 late invoices >30 days (collections: assign to admin)

Checklist before you start using it

  • Purpose and audience clear in one sentence.
  • 6–8 KPIs chosen and defined (how calculated).
  • Data sources mapped to each KPI.
  • Update frequency set and owner assigned.
  • Thresholds and action rules written next to each metric.
  • Dashboard tested for 2 weeks and adjusted.

Keep it alive

Review the dashboard on a fixed cadence: daily quick check, weekly review meeting, monthly strategy review. If a metric causes repeated manual fixes, either automate its data or replace the metric.

Quick tips

  • Use plain labels—no jargon.
  • Show trend direction, not just the number.
  • Limit colors: green, yellow, red.
  • Keep actions short—one sentence each.

Starter template (fields to copy)

Dashboard title | Date updated

Headline 1: Metric name — Value — Target — Action

Headline 2: Metric name — Value — Trend — Action

Left column: Leading indicators (list)

Right column: Lagging indicators (list)

Bottom: Exceptions — Owner — Due date