Business Performance Dashboard
The biggest customer the business has ever had signs in July, and everyone goes home happy. A few weeks later the owner runs payroll with the first new hire on it, pays the paper and vinyl supplier for the first big order, and looks at the bank balance. The customer pays in 60 days, and that clause didn't come up at the signing.
That squeeze is what an established small business runs into. The SBA Office of Advocacy's February 2026 FAQ counts 6,395,635 US small businesses with paid employees. On average from 1994 to 2022, only 49.2% of new employer establishments lasted five years, but 69.5% of those that did went on to reach ten. Getting through the start is the first problem. Growing without breaking what already works is the next one.
Growth gets paid for with cash. In the Federal Reserve Banks' 2025 Small Business Credit Survey, published March 2026, 60% of employer firms applied for financing in the prior 12 months. The most common reasons were to meet operating expenses (56%) and to pursue an expansion or new opportunity (46%). Reaching customers and growing sales was the most common operational challenge. When winning customers is the hard part, a big yes is easy to accept before anyone has priced it.
This example follows an invented company: a 26-person commercial print and signage business in the Midwest that wins a regional grocery chain. Every number here is modeled, not pulled from a real customer. Two of the ten targets below have a published benchmark behind them. The rest are starting points.
What is a Business KPI Dashboard?
Overview
A business KPI dashboard is the owner's monthly check that sales are turning into profit, the profit is turning into cash, and the customers who paid for last year are still buying.
It starts with demand. Sales booked is the value of work customers have agreed to buy this month, invoiced or not. Revenue is what was actually invoiced. When booked runs ahead of revenue, the workshop is about to get busy.
Then the margins. Gross margin shows what's left after materials, production labor and subcontractors. Net profit margin shows what's left after rent, salaries, insurance and everything else. Revenue per employee shows whether the people you hired are earning their keep.
Then the cash. Accounts receivable days is how long customers take to pay. Cash on hand, counted in weeks of normal spending, is how long the business could keep going if nothing came in.
Last, the customers. On-time delivery is the promise you can measure from your own job records. Customer retention shows whether the regulars came back. Largest customer share of revenue shows how much of the business depends on one buyer's goodwill.
Who benefits from this dashboard?
- Owner: Ten numbers, one screen, once a month. It's the difference between knowing the business grew and knowing whether it got better.
- Bookkeeper or outside CPA: Margins and receivables days come straight from the month-end close, and a strange number gets questioned while the transactions are still fresh.
- Operations or production manager: On-time delivery and revenue per employee show when the shop floor is overloaded, before customers start calling to chase.
- Sales lead: Sales booked tells them whether next month will be busy. Retention tells them which accounts need a visit.
- The bank, at renewal time: A lender reviewing a line of credit will ask about cash, receivables and customer concentration. Having two years of history on one screen makes that meeting short.
Count your largest customer at parent-company level. Thirty-eight grocery stores billed on separate accounts look like 38 small customers in the books. They're one customer, and they can all leave in the same email.
Dashboard Example Overview
The company prints signage, vehicle graphics, banners and marketing material for about 600 local business customers: restaurants, property managers, realtors, schools and contractors. It has 26 staff on one site and sells mostly on 30-day terms. It reports monthly against ten KPIs:
- Revenue: Invoiced revenue for the month, on an accrual basis. The headline figure, and the one most likely to flatter.
- Sales Booked: The value of orders and signed work accepted in the month, whether or not it has shipped. It leads revenue by a few weeks, and a large contract shows up here first.
- Gross Margin: Revenue less materials, production labor and subcontracted work, divided by revenue. A new customer's pricing shows up here.
- Net Profit Margin: Net profit after all operating costs, before owner distributions, divided by revenue. The check that growth paid for itself.
- Cash on Hand: The month-end bank balance divided by average weekly spending over the last three months. Weeks beat dollars here: the same bank balance covers fewer weeks once payroll grows, which is exactly what happens in this example.
- Accounts Receivable Days: Month-end receivables divided by average daily revenue over the last three months. On 30-day terms, low 40s is normal.
- On-Time Delivery: Jobs delivered or installed by the date promised, divided by jobs delivered. Promised, not requested, so the date on the job ticket matters.
- Customer Retention Rate: Customers who bought in the 12 months before last who also bought in the last 12, divided by those earlier customers. It moves slowly and late.
- Revenue per Employee: Monthly revenue times 12, divided by full-time-equivalent staff. It shows whether hiring kept pace with the work, or ran ahead of it.
- Largest Customer Share of Revenue: Revenue from the biggest single customer, divided by total revenue. Lower is safer. The ceiling here is 20%.
For most of the first year, the board is dull in the way an owner wants. From October 2024 to August 2025, revenue runs between $306,500 (January) and $380,000 (May), gross margin stays between 45.3% and 46.4%, and on-time delivery never drops below 95%. Cash on hand sits between 7.1 and 8.8 weeks. The largest customer, a property management firm, is never more than 10.1% of revenue.
In July 2025 the company wins the grocery chain: weekly promotional signage for 38 stores, plus a store graphics refresh. Sales booked jumps to $525,300 that month. The catch is in the contract. The chain pays on 60-day terms, its price is well below the shop's usual rates, and it wants every store's signs on the same day each week.
The work arrives in September. Revenue reaches $441,900, then $493,100 in October, and the company hires six people between August and December. In October, with the new staff still learning, revenue per employee peaks at $197,200. That looks like a productivity record. In practice it means overtime.
Then the rest of the board catches up. Accounts receivable days go from 44 in August to 57 in October and November, because the chain's accounts payable team rejects invoices without a store purchase order number on them. Cash on hand falls from 8.0 weeks in August to 2.1 weeks in November, about 15 days of spending, well under the 27 cash buffer days the JPMorgan Chase Institute found at the median small business in 2016. Gross margin falls from 46.0% in August to 36.9% in December, on the chain's pricing, overtime and reprints. On-time delivery slides to 86.4% in December, because the grocery run gets the wide-format printer first every week and the regulars wait. By December the chain is 29.7% of revenue, and net profit margin is down to 3.3%.
In January 2026, with net margin at 2.1%, the owner picks three things to give up. Same-day and rush work stops from March: it carried the best margins in the shop, but it was the work that pushed scheduled jobs past their dates. The chain is offered a 2% discount for paying within 15 days, which costs margin and brings cash in a month and a half sooner. And the owner skips the next two quarterly distributions. On top of that, chain jobs move to a night shift from February, and every invoice now carries the store's purchase order number.
The cash comes back first. Receivables days fall to 45 in March and 41 in April, once the chain starts taking the discount, and cash on hand is back at the six-week target in April. On-time delivery is back to 94.1% in March and 96.3% by September 2026. Revenue per employee settles at $187,200, well above where it started, with no overtime behind it.
Some numbers stay where the contract put them. Gross margin is 41.6% in September 2026, against a 45% target the business no longer hits, because more than a quarter of its work is now priced by a grocery chain. Customer retention fell from 78.0% in August 2025 to 71.2% in May 2026, as regulars who waited in the autumn rush quietly went elsewhere, and it has only recovered to 72.6%. The chain is still 27.7% of revenue.
The year-on-year view sums it up. Revenue for the twelve months to September 2026 is $5.62 million, up 32% on the year before. Net profit is about $359,000, against about $347,000. About a third more revenue produced about $12,000 more profit, and a business that depends on one customer for more than a quarter of its sales. The owner decided that was worth it. The dashboard is how they know what they paid for it.
Creating a Business Dashboard in SimpleKPI
-
Step 1 Close the month before you read the margins
Margins are only as good as the books under them. On cash-basis books, gross margin swings with when the supplier got paid, not with when the job was done. Ask your bookkeeper for an accrual-basis profit and loss each month, closed within ten working days, and enter the margins from that, not from a mid-month bank download.
If you're still settling which numbers make the list, the guide to choosing KPIs walks through the reasoning.
-
Step 2 Count cash in weeks, and agree what a week costs
Add up three months of real outgoings: payroll and payroll taxes, rent, suppliers, insurance, loan repayments and what the owner takes as salary. Divide by 13 for an average week. Leave out one-off purchases like a new printer, or the number jumps around for reasons that tell you nothing.
-
Step 3 Give every number one person who answers for it
In a 26-person business that's usually four people. The bookkeeper owns the margins and receivables days. The production manager owns on-time delivery. Whoever runs sales owns sales booked and retention. The owner keeps cash, revenue per employee and the largest customer share, because those are the numbers that decide whether to hire, borrow or say no.
-
Step 4 Price a big contract against four numbers before you sign
Before saying yes to a customer that would change the business, work out what it does to four numbers: gross margin at their price, receivables days at their terms, weeks of cash after you hire for them, and their share of your revenue. If any one of those lands outside its target, you know what to negotiate before the contract is signed, not after.
List of Business KPIs
Cash on hand and accounts receivable days have published figures to compare against. The other eight are this example's starting points, so set your own from a year of history.
| KPI Name | Typical Target | Description | Calculation |
|---|---|---|---|
| Revenue | $380,000 a month (starting point) | Invoiced revenue for the month. Reset the target when a major contract lands. | Sum of invoices dated in the month, accrual basis |
| Sales Booked | ≥ revenue target (starting point) | Work customers agreed to buy this month. Leads revenue by weeks. | Value of orders and signed work accepted in the month |
| Gross Margin | ≥ 45% (starting point) | What's left after the direct cost of doing the work. | (Revenue - materials, production labor and subcontractors) / revenue |
| Net Profit Margin | ≥ 8% (starting point) | What's left after every operating cost, before owner distributions. | Net profit / revenue |
| Cash on Hand | ≥ 6 weeks (JPMorgan Chase Institute median 27 days) | How long the business could pay its bills with nothing coming in. | Month-end cash / (last three months' spending / 13) |
| Accounts Receivable Days | ≤ 42 days (APQC median 38.0) | How long customers take to pay. Lower is better. | Month-end receivables / (last three months' revenue / days in those months) |
| On-Time Delivery | ≥ 95% (starting point) | Jobs finished by the date promised to the customer. | Jobs delivered by the promised date / jobs delivered |
| Customer Retention Rate | ≥ 75% (starting point) | Last year's customers who bought again this year. | Customers in the prior 12 months who also bought in the last 12 / customers in the prior 12 months |
| Revenue per Employee | ≥ $165,000 a year (starting point) | Whether staffing kept pace with the work. | Monthly revenue x 12 / full-time-equivalent staff |
| Largest Customer Share of Revenue | ≤ 20% (starting point) | How much of the business one customer could take with them. Lower is better. | Largest customer's revenue, at parent-company level / total revenue |
Ten is a lot if you've never tracked anything. The 5 essential KPIs challenge is a good way in: start with revenue, gross margin, cash on hand, receivables days and on-time delivery, keep them up for a quarter, then add the rest. For a list shaped around your own trade, try the KPI generator.
Why Business Dashboards Matter
An owner of a 20 or 30-person business usually knows revenue to the nearest thousand without looking. It's the other nine numbers that drift, and they drift because revenue is going up. In the example, every warning on the board in late 2025 came from the same good news.
Revenue and gross margin pull against each other whenever a big customer negotiates. Revenue and cash pull against each other whenever terms get longer, because receivables grow a month or two before the money does. Revenue per employee looks best just before on-time delivery breaks, because a stretched team is a productive team until it isn't. And every large contract that lifts revenue also lifts the largest customer's share.
None of that means turning the big customer down. It means deciding what you're prepared to give up, and how far, before the numbers decide for you. This owner gave up rush work, two percent on the chain's invoices and two quarters of distributions, and got a bigger, steadier business that's more exposed to one customer. Those are fair trades if you make them on purpose.
If you only read one pair each month, make it revenue against weeks of cash. In this example, October 2025 brought the highest monthly revenue in two years and 3.0 weeks of cash in the bank.
For the finance team's version of these numbers, see the financial dashboard example. For a venture-funded company measuring burn and runway rather than profit, see the startup dashboard example.
Building it in SimpleKPI
Build this dashboard yourself with SimpleKPI's KPI dashboards, or start from the Financial KPIs template. The mechanics are the same whatever you track:
- KPIs: each one gets a target, an entry frequency and tags, so you can report by team, site, product or whatever you split the numbers by.
- Data: type numbers in, import a spreadsheet, or use an integration or the API. The dashboard updates as each number lands, so daily and monthly KPIs sit side by side.
- Reports: scheduled KPI reports email the numbers to people who never log in.
- AI: Kip, the built-in AI, suggests targets and flags indicative benchmarks (AI estimates, not peer data) once some history builds up.
- Price: $79 a month for unlimited users and KPIs, as one flat price, with a 14-day free trial and no card needed.