The Small Business KPI Dashboard: 8 Numbers Worth Reviewing Every Month

Oct 6

A small business KPI dashboard kets you get a quick view of your company’s financial and operating health and, more importantly, identify areas that may require attention. Key performance indicators, or KPIs, are a small set of measurable indicators that leaders use to evaluate how a business is performing against its most important objectives.

Small business owners have access to more data than ever before. Between financial reports from accounting software, lead generation and sales reports from customer relationship management (CRM) systems, and marketing reports of impressions and conversions, there’s no lack of data that leaders can use to guide their business. The challenge business owners face is figuring out which numbers matter and what decisions they can help drive.

What Are KPIs?

A key performance indicator (KPI) is a measurable value used to assess performance against an important business objective. KPIs are chosen by business owners or department managers in order to track the metrics that are the most important to their respective area of a business.

Businesses generate countless metrics including website visits, invoices sent, average order value, employee hours, sales calls, email open rates and hundreds of others. While each metric can tell you something about a business, that doesn’t make it a KPI.

A metric becomes useful as a KPI when it helps you evaluate something important to the performance of your business.

For example, if your objective is to increase profitability, revenue alone may not be sufficient. Instead, gross margin may be more useful as a KPI because it can show whether additional sales are actually producing more gross profit.

On the other hand, if cash flow is a concern, accounts receivable and the age of unpaid invoices may deserve greater attention. If you’re trying to grow sales, the size and quality of your sales pipeline may help you assess whether you are generating enough future opportunities.

One of the best things about creating a small business KPI dashboard is that KPIs aren’t standard — you can choose the numbers that are the most important for you. In fact, trying to track too many metrics can actually make it harder to see what’s happening in your business. The right KPIs depend on the business and what leadership is trying to accomplish.

Why Are KPIs Important for Small Businesses?

KPIs are important for small businesses because as businesses grow, it becomes increasingly difficult for owners to stay aware of all the different aspects of their business. Having more customers, employees, products, and transactions mean there’s more activity to keep track of. As a result, owners increasingly have to manage their business through information rather than observation.

When businesses are very small, owners tend to be involved in everything and therefore have a reasonably good view of what is happening throughout their business. They know which customers haven’t paid, whether sales have been slow, whether employees have too much work or not enough, and they probably know about how much cash they have in the bank.

That’s where KPIs become important. Used properly, KPIs can help you:

Identify problems earlier. Declining margins, aging receivables or a shrinking sales pipeline may become visible before they turn into larger problems.
Understand trends. Looking at the same measures consistently makes it easier to distinguish a temporary fluctuation from a meaningful change in the business.
Allocate resources. KPIs can help determine whether the business needs more sales, additional capacity, tighter cost controls or investment somewhere else.
Improve planning. Comparing actual performance with forecasts can expose assumptions that need to be revised.
Focus management attention. Perhaps most importantly, KPIs help owners decide what deserves a closer look.

In most cases, KPIs don’t tell you everything you need to know. Instead, they tell you what questions to ask next.

For example, if gross margin falls from 50% to 30%, the KPI doesn’t tell you whether it was because of higher supplier costs, product mix, or something else. It just tells you that something changed and gives you a place to start investigating.

What Is a Small Business KPI Dashboard?

A small business KPI dashboard is a tool that brings together the most important measures of business performance in one place so business owners or managers can quickly understand how a company or department is performing. The specific KPIs included in a dashboard will vary from based on what metrics are most important to particular leaders, but the purpose is the same:

To quickly identify what’s going well, what isn’t and where you may need to make a decision.

Businesses can — and often do — track hundreds of metrics simply because the data is available, but a dashboard isn’t supposed to be a repository for everything you know about your company.

For most small businesses, a relatively short list of KPIs can provide a surprisingly comprehensive picture.

Metrics To Include in a Small Business KPI Dashboard

Here are eight typical metrics worth considering for a small business KPI dashboard:

1. Cash on Hand

Revenue gets most of the attention in business, but cash is what pays employees, vendors, lenders, and landlords. So it makes sense for most dashboards to start with a clear picture of how much cash the business has available.

Depending on the company, simply tracking the current cash balance may be enough. Businesses with less predictable cash flows may also want to calculate their cash runway, or approximately how long the company can continue operating at its current rate of spending without additional cash coming in.

The question leaders need to ask isn’t just “How much cash do we have?” — it’s whether the company has enough cash to meet its obligations while still funding the investments necessary to operate and grow.

After all, a profitable company can still run into trouble if customers pay slowly, inventory absorbs too much capital or expenses come due before revenue is collected.

2. Revenue

Revenue is one of the most obvious small business KPIs, but the headline number only tells part of the story — it becomes much more helpful with additional context. Typical best practice is to start with total revenue for the month or quarter and compare it with:

The previous month/quarter
The same period last year
Your budget or forecast

Once you have these comparisons, you can look at what actually drove any meaningful change.

For example, did revenue increase because you added customers? Did existing customers spend more? Did one unusually large sale account for most of the growth? Did a particular product, service or market outperform?

A business that grew revenue by 10% because dozens of customers spent slightly more may be in a very different position from one that grew by the same amount because a single large customer doubled its purchases.

3. Gross Margin

Unfortunately, this is where many small businesses fall short. They obsess over revenue, which tells them how much they’re selling, but pay no attention to gross margin, which tells them how valuable those sales are.

Gross margin is represented as a percentage of revenue. The formula is fairly simple:

Gross margin = (Revenue – Cost of goods sold) ÷ Revenue

For example, if your business generated $100,000 in revenue and incurred $60,000 in direct costs to generate those sales, your gross profit would be $40,000 and gross margin would be 40%.

Where gross margin becomes important is in tracking it over time. This may help reveal problems that revenue alone may hide.

For example, revenue may grow while margins decline because of discounting, rising input costs, changes in product mix or an increase in lower-margin customers. In those cases, looking at revenue growth alone could give you the wrong impression about the health of the business.

Depending on your business model, you may also want to monitor contribution margin, operating margin or margins by product, service or customer segment.

4. Accounts Receivable

For businesses that invoice customers, a sale isn’t the same as cash in your pocket. Accounts receivable tells you how much customers owe your company, but the total balance alone isn't necessarily enough. You also need to know how long those receivables have been outstanding.

Some metrics to track to monitor the health of accounts receivable include:

Total accounts receivable
Receivables more than 30 days old
Receivables more than 60 or 90 days old
Average collection time

A growing receivables balance can be totally normal when sales are increasing, but receivables growing substantially faster than revenue can indicate that customers are taking longer to pay. That can create a cash problem even when the income statement looks healthy.

Tracking receivables also gives you an opportunity to intervene earlier by following up on overdue invoices, changing payment terms or reconsidering how much credit you extend to particular customers.

5. Sales Pipeline

KPIs like revenue and gross margin are mostly backward-looking — they tell you what has already happened. But in this case, KPIs can actually stop being backward-looking and start being forward-looking.

Sales pipeline is a great example of what may happen next. It can help answer questions such as:

Are we creating enough opportunities to support future revenue goals?
Is the pipeline growing or shrinking?
Are opportunities moving through the sales process?
Is too much of our expected revenue dependent on one or two deals?

For businesses with a defined sales process, track the value of qualified opportunities currently in the pipeline. You may also want to monitor the number of opportunities, expected close dates and historical conversion rates.

Over time, comparing pipeline forecasts with actual sales can also make revenue planning considerably more useful.

6. Customer Concentration

One of the easiest risks to overlook in a growing business is customer concentration. A company may be generating record revenue while becoming increasingly dependent on a small number of customers. That’s why owners should know approximately how much of their revenue comes from their largest customers.

One simple approach for a KPI dashboard is to track the percentage of revenue generated by your largest customer and your top five or 10 customers.

There isn't a universal concentration level that’s appropriate for every business. A company built around a few large enterprise accounts will be very different from an ecommerce business with thousands of customers.

But, within any business, what’s often more useful is the trend. For example, if your largest customer accounted for 10% of revenue two years ago, 20% last year and 30% today, your business has changed. Losing that customer would now have a much larger impact.

That doesn’t necessarily mean the customer is a problem. But it does mean that concentration is something you should understand when making decisions about sales, hiring, investment, and growth.

7. Capacity

Every growing business eventually runs into a practical constraint: How much work can they handle? One way to know the answer is to track capacity.

How to do this varies considerably by industry. For example, a professional services firm might track billable utilization, whereas a manufacturer may monitor production capacity. A contractor might track scheduled jobs against available crews, and a healthcare practice may look at available appointments.

Whatever metric you track, the question is similar:

How much additional business can we handle with our current resources?

Low utilization can indicate excess capacity and a need for more demand (i.e., a need to ramp up sales).

Extremely high utilization, on the other hand, can signal a very different problem.

If your team is already operating near its practical limit, adding more customers may result in longer turnaround times, lower service quality, employee burnout, or the need for additional hiring and investment.

Capacity belongs on a KPI dashboard because sales decisions and operating decisions shouldn't happen independently.

8. Forecast Variance

The final number on a good small business KPI dashboard should tell you something about the quality of your expectations. Forecast variance measures the difference between what you expected to happen and what actually happened.

Forecast variance = Actual result – Forecast result

You can apply this to revenue, expenses, cash flow, hiring, or other important business measures.

Suppose you forecast $200,000 in monthly revenue and generate $170,000. The $30,000 shortfall matters, but so does understanding why your forecast was wrong. Maybe a large sale was delayed. Maybe your key closer was on vacation. Maybe forecasts were simply too optimistic.

Forecasting isn’t about predicting the future perfectly — it’s about developing a reasonable view of what is likely to happen and updating that view as new information becomes available.

How To Build a Small Business KPI Dashboard

To build a small business KPI dashboard, create a simple table with each of your primary KPIs. For every metric, include the current value, the previous period, your target or forecast, and, where useful, the same period from the previous year.

The dashboard might look something like this:


KPI	Current	Prior Period	Target	Trend
Cash	---	---	---	↑ / ↓
Revenue	---	---	---	↑ / ↓
Gross Margin	---	---	---	↑ / ↓
Accounts Receivable	---	---	---	↑ / ↓
Qualified Pipeline	---	---	---	↑ / ↓
Customer Concentration	---	---	---	↑ / ↓
Capacity Utilization	---	---	---	↑ / ↓
Forecast Variance	---	---	---	↑ / ↓

Building a small business KPI dashboard doesn’t need to be complicated. You don’t necessarily need specialized business intelligence software to build a useful dashboard. For many small businesses, a spreadsheet is more than adequate.

Likewise, don’t worry about making the dashboard visually impressive — focus on making it useful. Start with the decisions. Then determine which numbers help you make them. Once the basic dashboard works, you can automate data collection, add charts, or connect it to business intelligence software.

How Often Should You Review Your Business KPIs?

In general, you should review your business KPIs monthly. That said, this schedule can vary by business, and not every KPI needs to be reviewed on the same schedule. For example, cash may deserve attention every week or even every day during periods of uncertainty. Sales teams may review pipeline weekly. Margin and forecast variance may make more sense as part of a monthly business review. How often you review the numbers is less important than the fact that you do review the numbers and do it consistently.

More importantly, reviewing your dashboard should lead to questions that you explore further, such as:

Why did our margin fall?
Why is the pipeline down?
Why is the average age of our receivables increasing?
Why are we consistently beating our revenue forecast but missing our cash forecast?

Your KPI Dashboard Should Make the Next Decision Easier

The goal of a small business KPI dashboard isn’t to track everything happening in your company. The goal is to give you enough information to know where to look.

For example, if cash is healthy, revenue is growing, margins are stable, customers are paying on time, pipeline is strong, concentration is manageable, the company has sufficient capacity, and results are reasonably close to forecast, you probably don’t need to spend hours digging through reports looking for a problem.

However, if one of those things changes, you know where to start asking questions — and that’s what makes a dashboard valuable.

Good reporting doesn’t give you more numbers — it helps you decide what deserves your attention.

Want a simple structure for turning these numbers into a regular management habit? Download The Friday Business Review, a practical framework for reviewing performance, identifying issues, and deciding what needs attention next.

Dock Treece