KPI Scorecard Template
Financial Statements & Reporting
Quick Answer
List your KPIs with actual values, targets, and prior period comparatives. Paste into Claude or ChatGPT. Receive professional scorecard commentary with traffic light status and recommended actions for each metric.
What You Get
Professional commentary for each KPI with traffic light status, trend assessment, business implication, and specific recommended actions for off-track metrics, plus an overall performance summary.
Who Is This For
Business owners and managers maintaining monthly KPI scorecards, finance teams producing performance dashboards, and startup operators reporting metrics to investors and boards.
About This Template
A KPI scorecard is only as useful as the commentary that explains what the numbers mean and what to do about them. Raw numbers without context leave management guessing. This template takes your key performance indicators with actual versus target values and uses AI to produce concise scorecard commentary for each metric, a traffic light assessment, and specific recommended actions for any metrics that are off track. The output transforms a table of numbers into a decision-making tool.
Fill In Your Details
Your company name
e.g. June 2026
e.g. Monthly Revenue: $850K actual vs $810K target vs $720K prior year
e.g. Gross Margin: 60% actual vs 58% target vs 59% prior year
e.g. Monthly Churn: 2.1% actual vs 2.0% target vs 1.8% prior year
e.g. CAC: $1200 actual vs $900 target vs $950 prior year
e.g. NPS: 62 actual vs 55 target vs 58 prior year
Add any additional KPIs in the same format
Gather these details then use them to fill in the prompt below.
AI Prompts
Generate KPI scorecard commentary
Paste this prompt into Claude or ChatGPT with your metrics filled in.
You are a CFO preparing KPI scorecard commentary for management and board review. Using the metrics below, write professional commentary for each KPI and an overall performance summary. Company: [company_name] Period: [period] KPI 1: [kpi_1] KPI 2: [kpi_2] KPI 3: [kpi_3] KPI 4: [kpi_4] KPI 5: [kpi_5] KPI 6: [kpi_6] For each KPI provide: - Traffic light status: GREEN (on or above target), AMBER (within 10 percent of target), RED (more than 10 percent off target) - Performance vs target: the variance in absolute and percentage terms - Trend vs prior period: improving, stable, or declining - Business implication: one sentence on what this metric means for the business - Recommended action: specific action if AMBER or RED, confirmation if GREEN Then write a 3-4 sentence Overall Performance Summary covering the scorecard as a whole. Keep commentary concise — one paragraph maximum per metric.
Sample Output
This is an example of what AI produces when you use this template.
Monthly Revenue — GREEN
GREEN. $850K actual versus $810K target — 4.9 percent above plan. Trend: improving, up 18.1 percent versus prior year. Business implication: The enterprise segment is outperforming, contributing the majority of the $40K beat. Recommended action: Maintain current enterprise focus. Monitor whether SMB conversion rate is compensating or if the mix shift toward enterprise is structural.
Customer Acquisition Cost — RED
RED. $1,200 actual versus $900 target — 33.3 percent above target. Trend: declining (was $950 prior year, now $1,200). Business implication: CAC is increasing as the team moves upmarket to enterprise where sales cycles are longer and require more sales resources per deal. At current LTV of $18,000 the LTV/CAC ratio of 15x remains healthy, but the trend requires attention. Recommended action: Analyze CAC by channel and segment separately — enterprise CAC may be acceptable given higher LTV, while SMB CAC may be the issue. Implement channel-level CAC tracking within 30 days.