Business financial dashboard: what to include, with an example

Monday, 9 a.m. The owner of a distribution company opens the banking app, sees a balance of R$ 180,000 and relaxes. Twelve days later, there is not enough cash to run payroll. Nobody stole anything and sales did not drop. Monday’s balance was already spoken for: suppliers, taxes and a loan installment, all due in the same two weeks.

That is the problem a business financial dashboard solves. It is not about pretty charts. It is about replacing “how much do I have today?” with “how much will I have, am I making money, and where is my cash stuck?”

A business financial dashboard is a single screen that brings together the indicators showing the health of a company’s cash and profit. The essentials: current and projected cash, contribution margin, operating profit, receivable and payable terms, overdue receivables, and a comparison against target or break-even.

What a financial dashboard is (and what it is not)

A financial dashboard is not the income statement turned into charts, and it is not a colorful bank statement. The income statement tells you what happened last month; the bank statement shows what already came in and went out. The dashboard exists to tell you, in under a minute, whether the business needs to act now.

So the working rule is simple: every indicator on the screen needs a decision attached to it. If the number goes up or down and nobody does anything differently, it does not belong on the main dashboard. It can live in a monthly report, which serves a different purpose.

Separate the two accounting views from day one, too. Cash basis shows when money actually moves. Accrual basis shows when revenue and expenses are earned or incurred. A dashboard that blends the two without saying so produces exactly the payroll scene above.

Which indicators should a financial dashboard include?

Instead of starting from a list of 30 KPIs, start from four questions. Every indicator that makes it onto the dashboard answers one of them.

The table below turns the questions into indicators, with formula and review frequency. It is the core that works for most small and midsize companies.

Question	Indicator	Formula	Review
Do I have cash?	Projected balance	Current balance + expected receipts − expected payments	Weekly
Do I have cash?	Cash runway	Balance ÷ average weekly outflow	Weekly
Making money?	Contribution margin	(Revenue − variable costs) ÷ revenue	Monthly
Making money?	Operating profit	Contribution margin − fixed expenses	Monthly
Cash stuck?	Cash conversion cycle	Days inventory + days receivable − days payable	Monthly
Cash stuck?	Overdue rate	Amount over 30 days past due ÷ total receivables	Weekly
Hit the target?	Margin of safety	(Revenue − break-even revenue) ÷ revenue	Monthly

If any of these numbers is unclear, review the financial indicators for small businesses and how to calculate contribution margin before you build the dashboard.

A worked example: a distributor’s dashboard

Back to the distributor from the opening, with simulated numbers. In October it billed R$ 420,000 (about US$ 78,000). Variable costs (goods, freight, commissions and sales taxes) came to 58% of revenue. Fixed expenses were R$ 150,000.

• Contribution margin: 42% of R$ 420,000 = R$ 176,400.
• Operating profit: R$ 176,400 − R$ 150,000 = R$ 26,400.
• Break-even revenue: R$ 150,000 ÷ 0.42 = R$ 357,100.
• Margin of safety: (R$ 420,000 − R$ 357,100) ÷ R$ 420,000 = 15%.

Read that way, it was a good month. The company made a profit and sits 15% above its break-even point. Now look at the terms: inventory turns in 30 days, customers pay in 38 and suppliers are paid in 25. The cash conversion cycle is 30 + 38 − 25 = 43 days. Every real sold takes more than six weeks to come back as cash.

This is where the dashboard pays for itself. A 13-week forecast shows the balance falling below the owner’s minimum, even though the business is profitable.

With that on screen, the decision shows up five weeks early: renegotiate terms with a large supplier, factor part of the receivables or hold back an inventory purchase. Without the dashboard, the same decision becomes an emergency the day before payroll.

How to structure a financial dashboard by company size

The most common mistake is copying a larger company’s dashboard. A ten-person business does not need EBITDA by business unit; it needs to know whether the month closes. The structure grows with the operation.

Stage	Indicators on the dashboard	Data source	Who reviews
Small, owner decides everything	Projected balance, runway, overdue receivables, contribution margin	Bank statement and a payables/receivables sheet	Owner, every Monday
Growing, with a finance person	The above + cash conversion cycle, operating profit, actual vs. budget	ERP or management system + bank	Owner and finance, weekly; partners, monthly
Midsize, with a controller	The above by unit or channel, EBITDA, debt, profitability by customer	ERP, CRM, accounting and ad platforms integrated	Leadership, monthly; managers, weekly

At every stage, the main dashboard fits on one screen. Details live in tabs or supporting reports, opened only when a first-screen number needs explaining.

The prerequisite almost nobody meets: separate the accounts

No dashboard works if the company account pays for the owner’s groceries. According to Sebrae’s Financial Habits of Small Businesses survey, 61% of Brazilian entrepreneurs pay business expenses from their personal account (2025 data, published in January 2026).

The same survey shows how control is done: 30% use a spreadsheet, 25% write things down in a notebook, 20% use an app or system, 13% leave it to their accountant and 10% have no control at all. In practice, more than half of small businesses start from data that does not connect to anything.

So the right order is: a separate business account, a fixed owner’s salary, and payables and receivables recorded in a single place. Only then does the dashboard stop being a nice picture of wrong data.

Common financial dashboard mistakes

Showing revenue without margin

Growing revenue with shrinking margin is the classic pattern of companies that sell their way into trouble. If the dashboard puts revenue at the top and buries contribution margin in a tab, it nudges people toward the wrong decision.

Numbers without a reference

“R$ 26,000 operating profit” says nothing on its own. Every indicator needs a comparison: target, previous month, same month last year or break-even. Without it, nobody knows whether to celebrate or worry.

Manual updates once a month

A dashboard that depends on someone pasting data on the 10th is just a late report. For cash, acceptable lag is days, not weeks. And manual updates tend to slip precisely in the tightest months.

Too many charts

Expense pie charts, target speedometers, sales heat maps. Every extra chart competes for attention with what matters. If you have to scroll to see cash, the dashboard has failed.

Excel, Power BI or a ready-made tool?

Excel works well at the first stage, as long as someone updates it with discipline. The limit shows up when data comes from three or four systems and reconciliation starts eating hours every week.

Power BI and Looker Studio offer more flexibility but need someone to model the data and maintain connections; we compare the trade-offs in Is Power BI worth it?. Tools that already connect bank, ERP and CRM save that work at the cost of less customization. The choice depends less on the tool and more on who will keep the dashboard alive.

Frequently asked questions

What should a financial dashboard include?

At minimum: current and projected balance, cash runway, overdue receivables, contribution margin, operating profit and a comparison against target or break-even. Larger companies add the cash conversion cycle, debt levels and results by unit or channel.

How do I build a financial dashboard in Excel?

Create one tab for transactions (date, amount, category, forecast or actual) and another for the dashboard, using formulas such as SUMIFS to consolidate by week and category. Start with five indicators and a cash forecast chart. Add sophistication only after you have kept it updated for three months straight.

What is the difference between a financial dashboard and an income statement?

The income statement is an accounting report that measures a period’s result on an accrual basis. The dashboard is a management tool that combines cash and profit views to support quick decisions. One does not replace the other.

How often should a financial dashboard be updated?

Cash and overdue indicators, at least weekly. Margin, profit and budget comparisons can be monthly. Ideally, updates are automatic, so frequency does not depend on anyone’s calendar.

A good dashboard makes someone act on Monday

The test of a financial dashboard is not how it looks. It is whether, after a minute in front of the screen, the owner knows what to do this week: who to chase, what to postpone, who to renegotiate with. If the dashboard only confirms what everyone already felt, it is measuring the past. When data is scattered across bank, ERP, CRM and spreadsheets, Sherlok shortens the path: you ask in plain language what cash will look like in the coming weeks and get the analysis ready, built from your connected sources.