Template

KPI Dashboard Template

Track your most important business numbers each month against their targets. The Excel version calculates the variance and percentage of target for every KPI.

Updated November 19, 2026In SpreadsheetsFree download: Excel, PDF

Download this template free

No sign-up needed. Word and Excel files also open in Google Docs, Google Sheets and Apple Pages/Numbers. Letter size (8.5 × 11 in).

KPI Dashboard

Business / team
Month
Prepared by
KPIOwnerTargetActualVariance% of targetLast monthStatus (G / A / R)
Revenue ($)
New customers
Average order value ($)
Website visitors
Conversion rate (%)
Leads generated
Customer satisfaction (1–5)
Repeat customers (%)
Gross margin (%)
Cash on hand ($)

Wins this month

Concerns

Actions for next month

Preview of the template. Highlighted [brackets] show text to replace.

How to use the KPI dashboard

  1. Choose your KPIs. Pick five to ten metrics tied to your goals. Edit the examples or add your own.
  2. Assign an owner to each KPI, the person responsible for tracking and improving it.
  3. Set monthly targets.
  4. Enter actual results at the end of each month. The template calculates the variance and percentage of target.
  5. Rate each KPI green, amber or red.
  6. Review together and agree actions for next month.

Choosing good KPIs

Good KPIs are:

  • Linked to a goal: if a number does not influence a decision, do not track it.
  • Measurable and reliable: you can get the number easily and consistently.
  • Within your influence: the team can take action to improve it.
  • Balanced: include leading indicators such as leads and visitors, which predict future results, as well as lagging ones such as revenue.

Example KPIs by business type

Business type Useful KPIs
Online store Revenue, conversion rate, average order value, cart abandonment, return rate
Service business Billable hours, utilization, average project value, client retention
Restaurant Covers per day, average check, food cost %, labor cost %, online rating
SaaS Monthly recurring revenue, churn, customer acquisition cost, lifetime value
Nonprofit Donations, donor retention, program participants, volunteer hours

Make each KPI a SMART goal with our SMART goals template.

Frequently asked questions

What is a KPI?

A key performance indicator (KPI) is a measurable value that shows how well a business, team or person is achieving an important goal, for example monthly revenue, customer satisfaction or website conversion rate.

How many KPIs should a small business track?

Five to ten is plenty. Choose the metrics that most directly reflect your goals. Tracking too many makes it hard to see what matters.

How do I add a chart to the dashboard?

Select the KPI names and the Actual and Target columns, then choose Insert › Chart in Excel or Google Sheets. A clustered column chart works well for comparing actual vs. target.

Related templates and guides