Skip to content

One-Page Financial Dashboard for Small Business Owners

Why a one-page dashboard matters

You run many things. You don’t have time to dig through reports. A one-page financial dashboard shows the few numbers that tell you if the business is healthy now and what action to take next.

What to include (the essentials)

Keep it to 6–8 items. Each item should be updated weekly or monthly depending on your cash flow speed.

  • Cash on hand — bank + undeposited receipts.
  • Net cash change (period) — cash at period end minus cash at period start.
  • Accounts receivable (A/R) aging — total A/R and % past 30/60/90 days.
  • Accounts payable (A/P) due — total due this month.
  • Sales (period) — revenue for this week/month vs same period last period and last year.
  • Gross margin % — (Revenue – Cost of Goods Sold) / Revenue.
  • Burn rate / Net monthly cash burn — average monthly negative cash flow.
  • Working capital runway — cash on hand / average monthly cash burn (months left).

Layout that fits one page

Use a single spreadsheet tab or one slide. Arrange top-to-bottom:

  1. Header row with company name and reporting date.
  2. Line with cash on hand and runway — large and visible.
  3. Two-column area: left = sales and margin, right = A/R and A/P.
  4. Bottom row: simple action items and notes.

Copy-and-paste dashboard template (spreadsheet cells)

Paste this into a blank sheet. Column A = label, Column B = value, Column C = trend/notes.

Reporting Date: , 2025-___ (enter date)
A1: Cash on hand | B1: = (enter amount) | C1: 
A2: Net cash change (period) | B2: = (enter amount) | C2: 
A3: Sales (period) | B3: = (enter amount) | C3: vs last period: (enter %)
A4: Gross margin % | B4: = (enter %) | C4: target: (enter %)
A5: A/R total | B5: = (enter amount) | C5: %>30d: (enter %)
A6: A/P due this month | B6: = (enter amount) | C6: priority: (high/low)
A7: Monthly burn (avg) | B7: = (enter amount) | C7: 
A8: Runway (months) | B8: =IF(B7>0, B1/B7, "N/A") | C8: 
A9: Key action items | B9: 1) 2) 3) | C9: owner: (initials)

Tip: Format currency and percentages. Use simple formulas where shown.

Simple decision rules (use these weekly)

  • If Cash on hand < 1 month runway → Pause discretionary spending and contact lender or customers for accelerated payments.
  • If A/R >30 days > 25% of A/R → Send collections notice and offer a 5% early-payment discount for settling in 7 days.
  • If Sales down >10% vs last period → Run a quick promotion and recheck ad spend ROI.
  • If Gross margin drops >5 percentage points → Review pricing and supplier costs immediately.

Weekly checklist (5–10 minutes)

  • Update reporting date and all values.
  • Check cash on hand and runway.
  • Flag any A/R over 30 days; assign owner to collect.
  • Confirm A/P due this month and prioritize payments by vendor importance.
  • Note one action to improve cash (collections, cut expense, push sales).

Monthly tasks (30–60 minutes)

  • Reconcile bank to cash on hand number.
  • Calculate average monthly burn for past 3 months.
  • Compare sales and margins to prior month and same month last year.
  • Update pricing or supplier conversations if margins worsen.

Examples — filled-in snapshot

Example: Small cafe, reporting 3/31/2025

Cash on hand: $18,000 | Net cash change (month): -$4,000 | Sales (month): $40,000 (down 8% vs last month)
Gross margin: 65% (target 68%) | A/R total: $2,000 (%>30d: 10%) | A/P due: $6,000 | Monthly burn: $4,000 | Runway: 4.5 months

Action items: 1) Offer staff overtime cut. 2) Send 7-day pay email to A/R. 3) Negotiate 15-day terms with top supplier.

How to present this to your bookkeeper or banker

Send the single sheet with these notes:

  • Reporting period and date.
  • One-line summary: cash, runway, and top risk (e.g., "Runway 4.5 mo; A/P due $6k next 30d").
  • Requested help: short-term loan, extended supplier terms, or collections support.

Quick setup checklist

  1. Create spreadsheet tab called "One-Page Dashboard".
  2. Copy the template cells above into the tab.
  3. Link data to your accounting software totals if possible.
  4. Schedule a weekly 10-minute review on your calendar.

Final tips

  • Keep it updated. A dashboard is useless if it’s old.
  • Use colors sparingly: green for OK, red for action required.
  • Limit commentary—one or two lines for decisions.