Google Sheets 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 Google Sheets version.
Choose your industry
Retail Finance DashboardGoogle Sheets · $29E-commerce Finance DashboardGoogle Sheets · $29SaaS Finance DashboardGoogle Sheets · $29Restaurant Finance DashboardGoogle Sheets · $29Café & Bakery Finance DashboardGoogle Sheets · $29Hotel Finance DashboardGoogle Sheets · $29Real Estate Finance DashboardGoogle Sheets · $29Construction Finance DashboardGoogle Sheets · $29Manufacturing Finance DashboardGoogle Sheets · $29Logistics Finance DashboardGoogle Sheets · $29Clinic Finance DashboardGoogle Sheets · $29Hospital Finance DashboardGoogle Sheets · $29Dental Practice Finance DashboardGoogle Sheets · $29Pharmacy Finance DashboardGoogle Sheets · $29Gym & Fitness Finance DashboardGoogle Sheets · $29Salon & Spa Finance DashboardGoogle Sheets · $29Coaching Institute Finance DashboardGoogle Sheets · $29School Finance DashboardGoogle Sheets · $29University Finance DashboardGoogle Sheets · $29Marketing Agency Finance DashboardGoogle Sheets · $29Consulting Finance DashboardGoogle Sheets · $29Law Firm Finance DashboardGoogle Sheets · $29Accounting Firm Finance DashboardGoogle Sheets · $29Insurance Finance DashboardGoogle Sheets · $29Banking Finance DashboardGoogle Sheets · $29Fintech Finance DashboardGoogle Sheets · $29Automotive Finance DashboardGoogle Sheets · $29Car Dealership Finance DashboardGoogle Sheets · $29Agriculture Finance DashboardGoogle Sheets · $29Food Processing Finance DashboardGoogle Sheets · $29FMCG Distribution Finance DashboardGoogle Sheets · $29Wholesale Finance DashboardGoogle Sheets · $29Kirana Store Finance DashboardGoogle Sheets · $29Fashion & Apparel Finance DashboardGoogle Sheets · $29Jewellery Finance DashboardGoogle Sheets · $29Electronics Store Finance DashboardGoogle Sheets · $29Furniture Finance DashboardGoogle Sheets · $29Pharma Finance DashboardGoogle Sheets · $29Telecom Finance DashboardGoogle Sheets · $29Solar & Energy Finance DashboardGoogle Sheets · $29Non-profit Finance DashboardGoogle Sheets · $29Events Finance DashboardGoogle Sheets · $29Travel Agency Finance DashboardGoogle Sheets · $29Media & Publishing Finance DashboardGoogle Sheets · $29Gaming Finance DashboardGoogle Sheets · $29Creator Business Finance DashboardGoogle Sheets · $29Freelancer Finance DashboardGoogle Sheets · $29Startup Finance DashboardGoogle Sheets · $29IT Services Finance DashboardGoogle Sheets · $29Security Services Finance DashboardGoogle Sheets · $29Cleaning Services Finance DashboardGoogle Sheets · $29Printing & Packaging Finance DashboardGoogle Sheets · $29Pet Care Finance DashboardGoogle Sheets · $29
KPIs in every finance dashboard
| KPI | What it tells you | Formula |
|---|---|---|
| Revenue | Total income from sales in the period. | SUM of revenue ledger |
| Gross margin | What is left from each sale after direct costs. | (Revenue − Cost of goods sold) ÷ Revenue |
| Net profit | Profit after all expenses, interest and tax. | Revenue − All expenses |
| Operating expenses | Running costs such as salaries, rent and software. | SUM of operating expense accounts |
| Cash balance | Cash available in bank and in hand. | Opening cash + Inflows − Outflows |
| Cash runway | How many months the cash lasts at the current burn. | Cash balance ÷ Average monthly net burn |
| Days sales outstanding | How quickly customers pay their invoices. | (Accounts receivable ÷ Revenue) × Days in period |
| EBITDA margin | Operating profit before interest, tax, depreciation and amortisation, as a share of revenue. | EBITDA ÷ Revenue |