On target
6
Amber
5
Red
1
KPI Scorecard
Business KPIs against target with achievement, red-amber-green status, change since last period and a perspective summary.
6 free performance kpi dashboard templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 6 spreadsheets from KPIs & Performance, Store Operations and Financial Statements & Reporting. Start with KPI Scorecard, Retail Store KPI Scorecard and Monthly Financial Dashboard: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
On target
6
Amber
5
Red
1
Business KPIs against target with achievement, red-amber-green status, change since last period and a perspective summary.
Sales
$308,840
Conversion rate
14%
Average transaction value
$33
Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.
Revenue this month
$655,000
Revenue, last 12 months
$7,013,000
EBITDA margin this month
16%
One page that answers how the business did this month: revenue, margins, EBITDA, cash, DSO and customers against target, with 12-month trends.
Average score
3.9
Preferred suppliers
1
Needing review
3
Quarterly weighted supplier scores on quality, delivery, price, responsiveness and compliance, with ratings, quarter-on-quarter trend and review flags.
On track
4
At risk
2
Off track
2
Objectives, measures, targets and actuals across financial, customer, process and learning perspectives.
Team revenue
$547,000
Team attainment
88%
Team win rate
33%
Compare reps on activity, pipeline, win rate and quota attainment on one page.