Kpiloom

Excel Finance Dashboard Templates

A finance dashboard gives a clear profit and loss view, cash position and the margins behind them. Pick your industry below to see a live preview of the Excel version.

Choose your industry

KPIs in every finance dashboard

KPIWhat it tells youFormula
RevenueTotal income from sales in the period.SUM of revenue ledger
Gross marginWhat is left from each sale after direct costs.(Revenue − Cost of goods sold) ÷ Revenue
Net profitProfit after all expenses, interest and tax.Revenue − All expenses
Operating expensesRunning costs such as salaries, rent and software.SUM of operating expense accounts
Cash balanceCash available in bank and in hand.Opening cash + Inflows − Outflows
Cash runwayHow many months the cash lasts at the current burn.Cash balance ÷ Average monthly net burn
Days sales outstandingHow quickly customers pay their invoices.(Accounts receivable ÷ Revenue) × Days in period
EBITDA marginOperating profit before interest, tax, depreciation and amortisation, as a share of revenue.EBITDA ÷ Revenue