FP&A KPIs: What a Finance Team Should Measure

FP&A KPIs are the small set of measures that tell a finance team and the leaders it serves whether the business is on plan, why it is or is not, and whether the planning process itself is working. The temptation is to track everything. The discipline is to choose a few measures in each of six groups, define each one precisely, show it against budget and trend, and attach an owner and an action. This list gives twenty KPIs with formulas, a single worked company that shows how each is calculated, and guidance on how many to report and how to avoid common traps. It supports the performance management section of budgeting and forecasting, and follows how to build an FP&A function. For KPI work in the wider business, see the pages on business analytics, KPIs and ROI.

The worked company

All KPIs below use one hypothetical company, with figures in thousands of dollars for the year.

Gross profit = 24,000 - 14,400 = 9,600. Operating profit = 9,600 - 6,600 - 600 = 2,400. EBITDA = 2,400 + 600 = 3,000.

Group 1: Growth

1. Revenue growth versus budget and prior year. (Actual - Budget) / Budget = (24,000 - 23,300) / 23,300 = +3.0%. Pair it with volume, price and mix to explain it. See price-volume-mix analysis.
2. Revenue by segment, product or channel (share and growth). Shows where growth is coming from and where it is concentrated.
3. Order backlog or pipeline coverage (where relevant). Pipeline / target. See pipeline-based sales forecasting.

Group 2: Profitability

1. Gross margin %. Gross profit / Revenue = 9,600 / 24,000 = 40.0%.
2. Operating margin %. Operating profit / Revenue = 2,400 / 24,000 = 10.0%.
3. EBITDA margin %. 3,000 / 24,000 = 12.5%.
4. Contribution margin by product or customer. Revenue less variable costs, the margin that supports fixed costs. See unit economics.
5. Operating expense ratio. Operating expenses (including depreciation) / Revenue = 7,200 / 24,000 = 30.0%.

Group 3: Cash and working capital

1. Days sales outstanding (DSO). Receivables / Revenue × days = 3,000 / 24,000 × 360 = 45 days.
2. Days inventory outstanding (DIO). Inventory / Cost of goods sold × days = 2,400 / 14,400 × 360 = 60 days.
3. Days payables outstanding (DPO). Payables / Cost of goods sold × days = 1,600 / 14,400 × 360 = 40 days.
4. Cash conversion cycle. DSO + DIO - DPO = 45 + 60 - 40 = 65 days. Each day of the cycle ties up revenue/360 = 24,000 / 360 = about 67 of cash, so a 5-day improvement releases about 333.
5. Cash conversion (operating cash flow to EBITDA). 2,700 / 3,000 = 90%. A persistent low figure signals profit that is not turning into cash. See cash flow management.
6. Minimum cash and liquidity headroom. Cash plus unused credit versus the minimum policy level, from the cash forecast.

Group 4: Efficiency and productivity

1. Revenue per employee. 24,000 / 120 = 200 per employee. Compare with history and use with care across different business models.
2. Inventory turns. Cost of goods sold / Inventory = 14,400 / 2,400 = 6.0 times. See demand planning and inventory optimization.
3. Customer acquisition cost and payback (where relevant). Sales and marketing spend per new customer and months to recover it.

Group 5: Forecast quality

1. Forecast accuracy (WAPE) and bias. Total absolute error / Total actuals, and mean error. A 7.2% WAPE with a bias near zero is a very different story from a 7.2% WAPE with a +6% bias. See how to measure financial forecast accuracy and forecast bias in financial planning.
2. Budget variance by line. (Actual - Budget) / Budget for major lines, reported with explanations.

Group 6: Process

1. Close and reporting speed. Working days from period end to management pack. Also the share of analysis time versus data preparation time.

A one-page KPI report

Show each KPI with the current value, the target or budget, the prior period and a trend marker. For the worked company:

Every KPI that is off target needs an owner and a next step. A KPI nobody can act on is a statistic.

Turning a KPI into a target

A target should come with arithmetic showing what it is worth. Using the worked company:

A table like this turns "improve DSO" into "release 200 of cash", and makes it easier to see which target matters most. Be careful that the targets do not collide: extending payment days with suppliers may cost early-payment discounts or affect supply, and shortening inventory days may raise stockouts. See the cash conversion cycle for trade-offs.

A KPI dictionary

Keep a one-page dictionary so everyone calculates a KPI the same way.

KPIs for product companies

Companies that make or buy products should add measures of the operating plan that sits behind the financials: forecast accuracy and bias at item level, fill rate or service level, weeks of supply, excess and obsolete stock as a share of inventory, and purchase order lead time reliability. They are the leading indicators for margin and cash. See demand planning and inventory optimization. For the software that can report them, see FP&A software; for a lean set of KPIs in a small company, see FP&A for small business.

How to choose the right few

Common traps

• Too many KPIs. Attention is limited; more measures dilute focus.
• Vague definitions. Two people computing "gross margin" differently will produce different numbers.
• Measuring what is easy rather than what matters.
• Targets that conflict. For example, a DSO target pushing collections against a sales target pushing generous terms.
• Averages that hide. A blended margin may hide a loss-making product.
• No owner.
• Gaming. Whatever is measured will be optimized; check for unintended behavior.
• Ignoring seasonality. Compare like with like.

FAQs

What KPIs should an FP&A team track?

A small set across growth, profitability, cash and working capital, efficiency, forecast quality and planning process, defined precisely and linked to decisions.

How many KPIs should I report to leadership?

Usually five to ten, with more detail available by department.

What is the cash conversion cycle?

Days sales outstanding plus days inventory outstanding minus days payables outstanding: the days between paying suppliers and collecting from customers.

What is a good gross margin?

It depends on the industry and business model. Compare with your own history, budget and peers in your category.

How often should KPIs be reviewed?

Monthly for most, weekly for cash and operational leading indicators.