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
| KPI | Owner | Target | Actual | Variance | % of target | Last month | Status (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
- Choose your KPIs. Pick five to ten metrics tied to your goals. Edit the examples or add your own.
- Assign an owner to each KPI, the person responsible for tracking and improving it.
- Set monthly targets.
- Enter actual results at the end of each month. The template calculates the variance and percentage of target.
- Rate each KPI green, amber or red.
- 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
Best Free Excel Templates
Our most useful free Excel templates for home and work, all with formulas built in and laid out to print neatly on Letter paper.
TemplateSimple CRM Spreadsheet Template
A lightweight CRM for freelancers and small businesses. Track every lead and customer, deal stage, value and next follow-up, without paying for software.
TemplateSocial Media Report Template
A monthly social media report that shows growth, reach and engagement by platform, your top posts and what you will do next month.
TemplateMarketing Plan Template
A practical marketing plan for small businesses. Define your goals and audience, pick your channels, set a budget and track what works.