Skip to content

Balance sheet dashboard builder

Assets, liabilities and equity at a glance, with liquidity and leverage ratios. Enter your balances or upload a CSV, then download an editable slide or workbook.

New here? — takes 2 minutes.

Balance sheet dashboard

Statement of financial position — As at 30 September

Total assets

$41.2m
+$1.3m QoQ

Total equity

$24.4m
+$0.9m QoQ

Current ratio

1.9x
+0.1x

Debt to equity

0.42
−0.03

Assets vs liabilities and equity, $m

Current assetsNon-current assetsCurrent liabilitiesNon-current liabilitiesEquity
0
12
24
36
48
Current assets: 16.4Non-current assets: 24.8Current liabilities: 0Non-current liabilities: 0Equity: 0
Current assets: 0Non-current assets: 0Current liabilities: 8.6Non-current liabilities: 8.2Equity: 24.4
AssetsLiabilities a…

Current assets, $m

16.4$16.4m
Cash6.2 38%
Receivables7.1 43%
Inventory2.3 14%
Prepayments0.8 5%

Balance sheet trend, $m

Total assetsTotal liabilitiesEquity
0
12
24
36
48
41.224.416.8
Q4 FY25Q1 FY26Q2 FY26Q3 FY26

Condensed balance sheet, $m

LineSep 30Jun 30Change
Current assets16.415.6+0.8
Non-current assets24.824.3+0.5
Current liabilities8.68.4+0.2
Non-current liabilities8.28.0+0.2
Equity24.423.5+0.9

3 Balance Sheet Dashboard templates

Every template opens as a finished dashboard. Pick the closest one, then change anything.

Metrics and how to calculate them

The KPIs these templates are built on, with the formula behind each one.

Current ratio
Current assets ÷ current liabilities.
Quick ratio
(Current assets − inventory − prepayments) ÷ current liabilities.
Debt to equity
Total borrowings ÷ total shareholders' equity.
Working capital
Current assets − current liabilities.
Equity ratio
Total equity ÷ total assets × 100.
Return on assets
Net income for the last 12 months ÷ average total assets × 100.
Reconciliation completion
Balance sheet accounts reconciled and reviewed ÷ accounts in scope × 100.

How to make your Balance Sheet Dashboard

Pick a template, put your numbers in, download — about two minutes. Nothing to install; the PDF and every other format come with a SlideTeam plan.

  1. 1

    Pick your dashboard

    Click Pick Your Dashboard. This dashboard has 3 ready-made layouts, such as Balance sheet overview and Three-statement summary. Each opens finished, with example figures.

  2. 2

    Change the numbers

    Point at any widget (tap it on a phone) and choose Edit to type or paste its numbers and labels — a column copied from Excel pastes straight in. Click the dashboard's title to rename it.

  3. 3

    Use your own data

    Upload CSV or Excel takes a CSV, .xlsx or .xls file and shows exactly what it read: pick the sheet, the label column and how repeated rows are combined (sum, average, count), then Build a new dashboard or Fill this template with your columns. Not sure of the layout? Download the sample CSV and replace the numbers.

  4. 4

    Download PDF, PowerPoint, Excel and more

    Download (right end of the toolbar) lists every format: a PDF (free), PowerPoint with native charts you can still edit (right-click › Edit data), a report pack (summary slide plus one slide per chart) as PowerPoint or PDF, Excel (opens on a Dashboard sheet with live charts) and a CSV for Power BI, Tableau or Google Sheets.

  5. 5

    More options: add widgets, brand it, share

    More options (top right) shows the rest: Add widget puts in a chart, KPI tile, table, funnel or a Text / commentary box; the arrows on a widget move it and ✕ removes it; click the subtitle to edit it. Customise sets the currency, template language, slide size, brand colour and logo. Sheets / Slides shows how to open your file in Google Sheets or Slides; Share copies a link to this exact dashboard.

Common questions

What is a balance sheet dashboard?

A visual summary of what a company owns and owes at a date: assets, liabilities and equity, how they moved since the last quarter, and ratios such as current ratio and debt to equity.

Can I make a balance sheet dashboard in Excel?

Build it here and download Excel: you get a workbook with the balances and live charts. Or upload your trial balance as a CSV and download an editable PowerPoint slide.

How is a financial statement dashboard different?

It combines the income statement, balance sheet and cash flow on one page. Use the Three-statement summary template for board and lender reporting.

What should balance sheet reporting cover at quarter end?

Reconciliation status for every account, review of high-risk accounts and a flux analysis that explains large movements. The Balance sheet reporting and recs template tracks all three.

Goes well with this — from our other free tools

The figures in the example dashboards are illustrative and exist so each page shows a finished dashboard rather than an empty grid. Replace them with yours before sharing anything.