Kpiloom

Google Sheets Executive Dashboard Templates

A executive dashboard puts the handful of numbers a founder or board checks every week on one page. Pick your industry below to see a live preview of the Google Sheets version.

Choose your industry

KPIs in every executive dashboard

KPIWhat it tells youFormula
RevenueTotal revenue for the period.SUM of revenue
Net profitProfit after all costs.Revenue − All expenses
Revenue growthChange in revenue versus the previous period.(This period − Last period) ÷ Last period
CustomersActive paying customers.COUNT DISTINCT of paying customers
Cash balanceCash in bank and in hand.Opening cash + Inflows − Outflows
HeadcountNumber of employees.COUNT of active employees
NPSHow likely customers are to recommend you.% Promoters − % Detractors
Gross marginShare of revenue left after direct costs.(Revenue − COGS) ÷ Revenue