Small business KPI dashboard: the 8 essential KPIs

A small business owner does not need fifty numbers. You need to know, every week, whether the company is selling, whether it is making money, whether it can pay its bills and whether the work will keep coming. Eight KPIs are enough to answer that:

1. Monthly revenue, compared with the target.
2. Gross margin rate.
3. Cash on hand and a three-month forecast.
4. Days sales outstanding (DSO): how long customers take to pay.
5. Working capital, in days of revenue.
6. Order backlog, in months of work.
7. Margin per customer.
8. Break-even point: the revenue that covers your fixed costs.

These eight form the core. They are not enough to run a wholesaler the same way as a consulting firm, so the generator above adapts the list to your sector and your current priority. This article covers each KPI: its formula, how often to check it, where the data comes from and how to set an alert threshold.

Four questions, eight KPIs

A good dashboard answers questions. It does not try to measure everything. Here are the eight KPIs, grouped by question.

Are we selling enough?

• Monthly revenue always sits next to a benchmark: this month’s target, or the same month last year. A number on its own says nothing.
• Order backlog tells you how many months of work are already signed. It is the first KPI to check when you want to know if activity will hold. In services, add open proposals, weighted by their chance of closing.

Are we making money?

• Gross margin rate shows what is left after purchases and direct costs. Rising revenue with a falling margin is bad news in disguise.
• Margin per customer often holds a surprise: your biggest customers are not always your most profitable ones. Discounts, small orders, rush deliveries and reminders add up.

Can we pay?

• Cash on hand is the balance of your bank accounts. On its own, it is falsely reassuring. A three-month forecast, with expected receipts and planned payments, shows the low point ahead.
• Days sales outstanding measures the time between invoice and payment. According to the Banque de France, late payments in France averaged 13.4 days at the end of 2025. Without these delays, French SMEs and micro-businesses would have had €13 billion more in cash. The same report notes that fewer than one large company in two meets the 60-day limit.

Will it last?

• Working capital is the money tied up in your cycle: inventory and unpaid customer invoices, minus what you owe suppliers. When it grows faster than revenue, growth is eating your cash. Our working capital calculator does the maths for you.
• Break-even point is the revenue that exactly covers your fixed costs. Tracking it during the month tells you from which day you start making money.

Formulas, frequency and sources: the reference table

Every KPI needs a written definition. That is what stops arguments about “the right number” in meetings.

The right frequency follows how fast you can act. Bpifrance Création, the French public bank’s guide for business founders, considers a monthly update often necessary, and weekly tracking of some indicators when activity is highly seasonal or cash is tight. Checking daily a number you can only act on once a month is pointless.

What changes by sector

The core stays the same. What changes are two or three KPIs specific to your trade. Those are the ones the generator adds.

In e-commerce, DSO matters little: customers pay when they order. Days of inventory takes its place in the core.

Fictional example: a supplies wholesaler tracks revenue and margin. All looks fine. Adding days of inventory by product family, the owner finds that one family takes a large share of the warehouse for a small share of sales. The problem was not in sales. It was in the stock.

Where the data lives, and why you need to cross it

In a small business, the numbers are spread across several tools. Each one holds part of the truth.

• Accounting is the reference. But it arrives after the month is closed, sometimes much later.
• Invoicing gives revenue and unpaid invoices, day by day.
• The CRM, or a simple sales spreadsheet, holds quotes and open deals.
• The bank gives your real cash position, to the day.
• Inventory software or the ERP gives quantities, values and movements.

Useful KPIs come from crossing these sources. Real DSO needs invoicing and the bank. Margin per customer needs invoicing, purchases and time spent. A customer who pays later and later while ordering less and less sends a clear signal, but no single tool sees it.

Fictional example: a services firm sees a stable DSO in its invoicing software. Matching invoices with bank receipts, it finds that two customers pay later and later. Other customers, who pay fast, offset them in the average. The average was hiding the problem.

That is what our three example dashboards show on the Demos page: “Client profitability”, “Cash and working capital” and “Customer signals”. They are built on fictional data.

Setting thresholds and alerts

A KPI without a threshold is just a number. With a threshold, it becomes a decision. There is no universal threshold: a normal DSO in construction makes no sense for an online shop paid at checkout. Here is how to set yours.

1. Start from your contracts. For DSO, the first benchmark is your own payment terms. In France, the law frames them. Without an agreement, payment is due 30 days after receipt of the goods or completion of the service. Between businesses, agreed terms cannot exceed 60 days from the invoice date, or 45 days end of month, with sector-specific exceptions. A DSO above your own terms means late payments.
2. Start from your costs. For cash, add up one month of fixed outgoings: salaries, payroll taxes, rent, loan repayments. Decide how many months you want to be able to cover. Multiply the two: that is your minimum cash level.
3. Start from your history. For margin or backlog, look at least twelve months back, to cover a full season. The warning threshold is your usual low for that month, not an annual average.
4. Start from your budget. For revenue, the threshold is the target. Read the gap in euros and in percent.

Two levels are enough: “watch” and “act”. Each alert has an owner and an action decided in advance. Fictional example of a rule: “if a customer goes X days past their payment terms, the bookkeeper calls them; beyond Y days, the owner calls”. Choose X and Y based on your customers and your cash.

Review your thresholds every quarter. An alert that fires every week ends up ignored: that means the threshold is in the wrong place.

One page: how to lay it out

An owner’s dashboard fits on one screen. A layout that works:

1. At the top, four numbers: revenue, margin, cash, DSO. Each with its comparison (target or last year), its twelve-month trend and its status written in words.
2. In the middle, two charts: forecast cash over the coming weeks, then revenue and margin over twelve months.
3. At the bottom, an action list: late payers, quotes to follow up, stock that no longer moves. This is the part you work through in meetings.

Four simple rules:

• the same period everywhere, with the update date clearly visible;
• a written status, “watch” or “act”, not just a colour;
• each KPI’s definition one click away;
• two or three lines at most per chart.

The most common mistakes

Too many KPIs

Bpifrance Création puts it plainly: a dashboard that is too complex, with too many indicators, is unlikely to be used regularly. L-Expert-Comptable.com, a French online accounting firm, advises a maximum of 10 indicators per dashboard. Our rule: if a KPI never triggers a decision, remove it.

Vanity metrics

Website visits, followers or quotes sent feel good to watch. They say nothing about the health of the business. A quote only counts once it is signed, a visit only if it buys. Prefer conversion rate and margin.

Numbers nobody trusts

Sales reports one revenue figure, accounting another. Both are right: one counts orders, the other invoices. The fix takes three steps: one written definition per KPI, one reference source, and the update date on display. A dashboard whose numbers are disputed stops being read.

Manual updates

A dashboard that takes hours of copy and paste every month falls behind, then gets dropped. As soon as you cross more than two sources, automate the collection.

No benchmark, no action

A number without a comparison says nothing. A gap without an owner changes nothing. Each line should say where you are, where you meant to be and who acts.

Which tool?

A spreadsheet is enough to start, with a few KPIs filled in each month. When sources multiply, a tool connected to your software removes data entry and errors. We compare Power BI, Looker Studio and Metabase in a separate article, and we break down what a dashboard costs a small business.

FAQ

How many KPIs should a small business owner track?

Six to eight for the owner. Beyond that, attention scatters. Each manager can have a more detailed dashboard, but the owner’s stays short.

How often should the dashboard be updated?

Cash and late payments, weekly. Revenue, weekly as month to date. Margin, working capital and margin per customer, monthly. Break-even, quarterly. When cash is tight, move to a weekly rhythm.

What is the difference between a metric and a KPI?

A KPI, or key performance indicator, is a metric tied to a goal and given a threshold. The number of invoices issued is a metric. DSO compared with your payment terms is a KPI.

Are my accountant’s figures enough?

They are reliable, but they arrive late and look backwards. A management dashboard adds fresher data: invoicing, bank, orders. Share your definitions with your accountant: they can help you align them with the books.

What next?

Pick your list in the generator above. Write down the definition and threshold of each KPI. Start with what you have, even in a spreadsheet.

To see these KPIs in context, open our example dashboards. If you want your software to feed yours with no manual entry, KAVDAL builds dashboards for SMEs: a data diagnostic at €290, guaranteed and deducted if a project follows; a first dashboard from €1,500; full management reporting from €4,500. Prices are net; VAT not applicable, art. 293 B of the French tax code (CGI). Details are on the Pricing page. A free 20-minute call is enough to know where to start.