KPI dashboard template (Excel): a sample with eight KPIs, targets and status rules

A KPI dashboard is one page that says, for each key measure, where it stands against target and whether anyone should worry. This template gives you a finished sample for a sales-led business and the workbook behind it. You type the month once; every actual, target, variance and status follows from the data. It is built for business teams, not personal budgets.

What a KPI dashboard is, and the sample

The sample month is June. Each of the eight KPIs shows its actual, its target, May's figure, the variance (actual − target), that variance as a percentage of target, and a status:

The count under the table reads 4 On track, 1 Watch and 3 Off track. That is the whole point of the page: in two minutes, the meeting knows which three rows to spend its time on.

What is in the template

The workbook has no charts. Every figure is a formula over the Data sheet, so it works in Excel 2016 as well as Microsoft 365 and nothing has to be redrawn when the month changes.

• Definitions. One row per KPI: the KPI name, its formula in words, owner, unit, direction of good (up, down or band), the Watch tolerance (5% in the sample), the band for band KPIs (2% for headcount) and the source system. The SEC's 2020 guidance on key performance indicators expects "a clear definition of the metric and how it is calculated" for any KPI a public company reports; the same discipline inside a company stops the monthly argument about what a number means.
• Data. One row per KPI per month: Month as text (2026-06), KPI, Actual and Target. The month column is formatted as text so Excel does not turn 2026-06 into a date.
• Dashboard. Type the month in B2. The prior month in E2 is found from the month list on the Trend sheet. Each row pulls its figures with SUMIFS:

Actual:  =SUMIFS(Data!$C$2:$C$2000,Data!$A$2:$A$2000,$B$2,Data!$B$2:$B$2000,$A5)
Target:  =SUMIFS(Data!$D$2:$D$2000,Data!$A$2:$A$2000,$B$2,Data!$B$2:$B$2000,$A5)
Variance % of target:  =IFERROR((C5-D5)/ABS(D5),"")

• Trend. Each KPI's actual for every month of the year in one block, and its status for every month in a second block, one column per month. Blank months stay blank rather than showing zero. If you want a picture of the trend, select a row and add a line sparkline yourself; the template ships without one.
• Checks. For the selected month, each KPI must have exactly one Data row, a non-zero target and a prior month. A row that fails says which problem it has.

The status rule, written down

The status comes from three things on the Definitions sheet: the direction of good, the tolerance and, for band KPIs, the band. First the template works out how far the KPI is on the wrong side of its target, as a share of target:

• up: (target − actual) / target
• down: (actual − target) / target
• band: |actual − target| / target − band

Then: zero or less is On track, up to the tolerance is Watch, beyond it is Off track. A missing target reads No target. In the workbook, with the direction, tolerance and band looked up by INDEX and MATCH, the shape is:

=IF(D5=0,"No target",IF(unfavorable<=0,"On track",IF(unfavorable<=tolerance,"Watch","Off track")))

The status cells are colored green, amber and red with conditional formatting rules of the "Equal To" kind, so the color always follows the text and never a hand-picked fill.

The worked sample

Revenue beat target by 150, or 2.4%, so it is On track. Gross margin was 1.6 points below its 40.0 target. That is 4.0% of the target, inside the 5% tolerance, so it is Watch, not Off track. New customers were 4 short of 50, an 8.0% miss: Off track.

The two rows that matter most are the ones where up is bad. DSO rose from 49 to 52 days against a target of 45: 7 days, 15.6% over, Off track. Monthly churn of 1.8% against 1.5% is 20.0% worse than target, also Off track. A dashboard that assumed "higher is better" would have shown both green.

Operating expenses came in 30 under a 1,750 target, which is good for a cost, so On track. Headcount is 3 below plan; 3 / 215 is 1.4%, inside the 2% band, so On track. A headcount well above plan would be flagged as quickly as one well below.

The reading: revenue looks fine, but more customers are leaving, fewer are arriving and they are paying more slowly. Those three reds are the agenda.

How to adapt it

1. Rewrite Definitions with your own KPIs. Give each one a formula, an owner and a source; a measure without an owner is a metric, not a KPI, as KPI vs metric vs measure explains.
2. Set the direction of good for every row, and a tolerance that matches how noisy the measure is. Setting thresholds from a measure's own history shows how.
3. Paste your monthly actuals and targets into Data, spelling each KPI exactly as on Definitions.
4. Keep eight or fewer on the Dashboard. If you need another row, insert it above the last KPI row on Dashboard, Trend and Checks and fill the formulas down, so the status counts take it in.
5. Store percentages as numbers (38.4, not 38.4%) or as fractions throughout, but not a mix, and set the row's number format to match.

KPI dashboard examples by team

• Finance: revenue, gross margin, EBITDA margin, operating cash flow, DSO, operating expenses against budget. The full monthly version is the financial dashboard template.
• Sales: bookings against quota, pipeline coverage, win rate, average deal size, sales cycle days, new customers.
• Customer success: net revenue retention, logo churn, renewal rate, time to first value, support backlog.
• Procurement: spend under contract, on-time in-full delivery, purchase price variance, supplier lead time, days payable outstanding.

For sixty more, with formulas, see KPI examples; for lists by sector, KPIs by industry.

Where it goes wrong

• No direction of good. A rising DSO colored green because "up" was assumed to be good.
• Status thresholds nobody wrote down, so the colors are argued about every month. Put the tolerance in Definitions, where everyone can see it.
• Points and percent mixed up. Gross margin 1.6 points below target is a 4.0% shortfall. This template tests the tolerance on the percentage of target; say so when you present it.
• Too many KPIs. Past eight or ten, the page becomes a report and the reds get lost.
• Missing targets. A month with no target compares against zero. The Checks sheet flags it, and the status reads No target instead of a color.

When the dashboard needs to answer why

A template shows the status; it does not say why DSO went red. Covirage's tools compute each KPI from your own files, apply the threshold, and open each red to the customers behind it; the external AI model explains, and it never does the arithmetic. See board reporting to put the KPIs in front of the board with a citation on every figure, drafted from the files you already export. For the KPI formulas, see financial KPIs; for other layouts, Excel dashboard examples; for the status colors, conditional formatting in Excel.