Dashboard template

The whole business on one page, read in five minutes.

Eight numbers, three charts and a scorecard: the page a CEO or owner opens on Monday morning and the board receives as a PDF the week before the meeting — drawn from finance, sales, operations and people systems at once.

Revenue$8.1MMargin41%Cash$2.3MNPS52

Executive overview

The whole business on one page, for Monday.

An executive dashboard fails in one of two ways: it is either a wall of every metric the company has, or a copy of the finance pack. This template is neither. It holds the eight figures that decide whether the month is on track, one trend chart for each of revenue, margin and cash, and a department scorecard that turns green or red against targets that leadership agreed once.

Every figure comes from the system that owns it — the ledger for revenue and cash, the CRM for pipeline, the help desk for satisfaction, the HR sheet for headcount — so there is no re-typing and no argument about whose number is right. Each tile drills down to the departmental dashboard behind it.

Most boards receive it as a scheduled PDF five days before the meeting, with a short commentary added by the CEO. Our guide to automating board reports walks through the setup, and period-over-period explains the comparisons every tile carries.

  • CEOs and owners who want one page on Monday instead of six departmental reports.
  • Boards and investors who receive the same page as a scheduled PDF before each meeting.
  • Finance and chiefs of staff who currently assemble the board pack by hand.
The metrics

What a executive overview dashboard should show.

Each figure below is on the template from the first minute — rename, redefine or remove any of them.

Revenue vs plan

Month to date and year to date against budget, from the ledger, with the gap in currency.

Gross margin

Rolling 3-month margin against the same period last year, so mix and pricing changes show up as a trend rather than noise.

Cash

Bank balance today and the 13-week forecast low point — the number a board asks about first when it is falling.

Customers gained and lost

New customers minus lost customers this quarter, from the CRM or billing. Growth net of churn, not gross.

Pipeline coverage

Open weighted pipeline ÷ remaining target for the quarter. The earliest warning that next quarter’s revenue is not there.

Headcount and people cost

Current headcount against plan, and payroll as a share of revenue.

On-time delivery

Orders, projects or cases delivered on the promised date ÷ all delivered, from the operations system. The customer’s experience in one number.

Net promoter score

The latest quarterly score with response count and the trend arrow, from your survey tool or help desk.

The panels

The charts on the page, and the decision each one supports.

Headline tiles

The eight figures above, each with its comparison and a green, amber or red state against target. The five-minute read.

Revenue and margin, 13 months

Bars for revenue, a line for gross margin percent, plan overlaid. Shows whether growth is coming with margin or at its expense.

Cash and forecast

Actual balance to today and the 13-week forecast with its low point marked. Decides the timing of hires, purchases and dividends.

Department scorecard

One row per department — sales, marketing, operations, support, people — with 2–3 agreed KPIs each against target. Each head sees their own row; the CEO sees all.

Exceptions and risks

A short list of items outside tolerance this week: a late project, an overdue major invoice, a site under plan. Generated from the data, not typed in.

Region or business unit comparison

Revenue, margin and growth by region or unit, ranked. The chart that starts the resource-allocation conversation.

Where the numbers come from

Connect the systems you already run.

The template expects data like this. Connect it live or import it, relate the tables once, and every panel fills in.

See all 50+ connectors
XeXeroQuQuickBooksNeNetSuiteSaSalesforceHuHubSpotMiMicrosoft SQL ServerGoGoogle SheetsMiMicrosoft Excel
FAQ

Executive overview template questions.

Something else on your mind? Ask us directly — a person answers.

What should an executive dashboard include?

Revenue and margin against plan, cash and a short forecast, customers gained and lost, pipeline coverage, headcount, an operational delivery measure and a customer satisfaction score — then a scorecard by department. Eight to ten figures is the right size; more becomes a filing cabinet.

Can the board get it as a PDF automatically?

Yes. Schedule the dashboard as a PDF to the board’s email list on a chosen day each month; each recipient receives only the pages and rows they are permitted to see.

How often does the executive dashboard update?

Each tile updates as its source does — ledger figures on the accounting system’s refresh, pipeline hourly, live-connected databases continuously. Each tile shows when its data was last updated.

Can we start from this template and change it?

Yes. Replace tiles with the figures your board actually asks about, add a business unit split or an ESG panel, and it becomes your own page. Nothing in it is fixed.

Your executive overview dashboard, this week.

Bring your data and we'll set this template up on it live — then shape it around the questions you actually ask.

Talk to sales

Prefer to see plans first? See pricing

Contact usWhatsApp