ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. KPI dashboard
Excel template · KPI

KPI dashboard template

Enter six numbers at the end of each month: the template calculates margin, profit, growth, receivable days and average sale, and updates the charts.

Updated:
Valtera_KPI_dashboard_EN.xlsx · 15 KB · Sheets: Guide, KPI
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_KPI_dashboard_EN.xlsx — KPI · Preview with sample data
IndicatorJanFebMarAprMayJunJul
INPUTS (MONTH END)
Revenue64,00061,00070,00074,00079,00073,00068,000
Cost of sales37,80036,00040,90043,00045,70042,30039,400
Operating expenses19,50019,20019,80020,10020,40020,00021,100
Cash balance41,00036,50039,00044,20047,80045,10040,300
Accounts receivable88,00091,00096,000101,000104,00099,00097,000
Number of customers41394446484543
INDICATORS
Gross margin40.9%41.0%41.6%41.9%42.2%42.1%42.1%
Operating profit6,7005,8009,30010,90012,90010,7007,500
Profit margin10.5%9.5%13.3%14.7%16.3%14.7%11.0%
Revenue growth (month on month)-4.7%14.8%5.7%6.8%-7.6%-6.8%
DSO, days41454141394143
Average sale per customer1,5611,5641,5911,6091,6461,6221,581
Cash balance in months of costs1111111

Which indicators

IndicatorWhat it shows
Gross marginWhat is left of each manat sold after cost of goods
Operating profitRevenue − cost of goods − operating expenses
Profit marginOperating profit as a share of revenue
Revenue growthChange on the previous month
DSOHow many days, on average, customers take to pay
Average saleRevenue per customer
Cash balance in months of expensesHow many months of expenses the cash in the account covers

Rules for a good dashboard

  • No more than 5–8 indicators: the owner should see the situation at a glance.
  • Set a target for each indicator and compare every month.
  • Have the figures ready by the 5th of the month: a late report delays decisions.

For plan vs actual analysis: budget template. To reduce receivable days: DSO calculator.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.