← Blog

What to Put on a Small Business KPI Dashboard

November 17, 2026 · 7 minute read

Quick answer

Keep it to about seven numbers: cash, revenue vs last year, gross margin, receivables over 30 days, new leads by source, pipeline value and work in progress. Pull them automatically from your accounting, pipeline and job tools.

A good KPI dashboard for small business has fewer numbers than you think. Most bloated dashboards grow to 30 metrics and get ignored. Pick about seven that you'd actually act on, and make sure they update themselves.

This guide covers which numbers matter, where they come from, how often to check them and the mistakes that turn a dashboard into wallpaper. It works whether you run a trade business, a shop, a practice or an agency.

The seven numbers a KPI dashboard for small business needs

  • Cash on hand. What's in the bank today, and what's due out this month.
  • Revenue this month vs last year. The simplest read on whether you're growing.
  • Gross margin. By job, product or client if you can, so you know what actually makes money.
  • Accounts receivable over 30 days. Money you've earned but haven't collected.
  • New leads and where they came from. The front of the pipeline.
  • Pipeline value. Quotes and proposals out, weighted by how likely they are to close.
  • Work in progress. Jobs or orders open, and how many are late.

What each number tells you to do

A number only earns a place if it changes what you do. Here is the decision behind each one:

  • Cash low. Chase receivables, delay non-urgent purchases or talk to your lender early.
  • Revenue behind last year. Check whether leads dropped, close rates fell or jobs slipped into next month.
  • Margin slipping. Look at pricing, materials, labor hours or discounts on recent work.
  • Receivables growing. Send reminders sooner, and consider deposits on larger jobs.
  • Leads down. Check which source fell off, then fix that channel first.
  • Pipeline thin. Follow up on open quotes and plan marketing for the next few months.
  • Late work rising. Rebalance crews or staff, and tell affected customers before they ask.

If you can't name the action for a number, drop it from the main view.

Comparing revenue to the same month last year matters because most businesses are seasonal. Comparing to last month can make a normal slow month look like a crisis.

The exact labels change by industry, but the questions behind them stay the same. Do we have cash and are we growing? Are we making money on the work, and is more coming in?

What the seven look like in different businesses

  • A contractor. Margin by job shows which job types are worth chasing. Work in progress shows open jobs and which are past their promised finish date.
  • A wholesale or product business. Margin by product line matters most. Work in progress becomes open orders, and late shipments are the number to watch.
  • A professional services firm. Margin by client shows who is profitable once time is counted. Receivables over 30 days often matter more than revenue.
  • A retail shop. Revenue vs last year by week is the core read. Leads may be replaced by foot traffic or online visits, and stock levels replace work in progress.

Keep the structure and swap the details. Seven numbers, each tied to a decision.

A cleaning or maintenance company might add one number for recurring contracts up for renewal. A clinic or salon might track open appointment slots for the next two weeks. One extra number is fine if it drives a real decision.

Why a finance-only small business dashboard falls short

Most dashboard tools only look at accounting data. That tells you what already happened. Pairing your finances with leads, pipeline and job status tells you what's coming, which is when you can still do something about it.

Say revenue looks fine this month. But new leads dropped by half three weeks ago. A finance-only view won't show that until revenue falls, which may be two months away.

The same goes for late jobs. A growing list of overdue work usually shows up as unhappy customers and slow payments later. Seeing it early gives you time to move people around.

Where the data comes from

Your accounting software has cash, revenue, margin and receivables. Your leads and pipeline live in a CRM, inbox or spreadsheet. Jobs live in your project tool.

A useful dashboard pulls from all of them automatically, so nobody builds it by hand.

Some systems connect directly. Others have no way to connect, but most can email a report on a schedule. That report can be read in automatically, so even older software can feed the dashboard.

For example, a contractor's job software might only export a daily summary. A distributor's warehouse system might only send a weekly stock report. Both can still feed the same dashboard without anyone retyping figures.

The goal is zero copy and paste. If someone has to update a number by hand, it will eventually be late or wrong.

Is a QuickBooks dashboard enough?

A QuickBooks dashboard covers the financial half well. Cash, revenue, receivables and profit by customer or class are all there if your books are set up for it.

What it can't show is the front of the business: leads, quotes, open jobs and who is responsible for what. For that you need to bring in data from where that work is tracked. Many owners end up with QuickBooks open in one tab and a spreadsheet in another, and the whole picture lives in their head.

How to know your numbers in business: a simple routine

Check cash and leads weekly, and margin, revenue and receivables monthly. Watch work in progress whenever it changes. A short weekly summary in your inbox covers most of it.

A routine matters more than the tool. Here is one that works for most owners:

  1. Pick the seven numbers and write one sentence for each explaining what you'd do if it moved.
  2. Find where each number lives today and who updates it.
  3. Connect each source so the number updates without anyone touching it.
  4. Set a short weekly review, the same day and time, and keep it under 20 minutes.
  5. Look at the trend as well as today's figure. Three weeks of decline means more than one bad week.
  6. Assign an owner to any number that's off, with a date to report back.
  7. Review the list each quarter and drop any number nobody has acted on.

Keep it to one screen

If it doesn't fit on one screen, it's too long. Every number should answer a question you'd act on. Drop the rest.

Put cash and the most urgent warning at the top. Leave detail one click away, so you can dig into a number when it moves without cluttering the main view.

Color helps when it's used sparingly. Mark a number red only when it crosses a line you've agreed on, so red always means act now.

Use plain labels. "Owed to us, over 30 days" is clearer to a team than an accounting term.

Common mistakes

  • Tracking everything. More numbers feel thorough but hide the ones that matter.
  • Building it by hand. A dashboard someone updates on Friday afternoon is stale by Monday.
  • Only looking backward. Revenue and profit are results. Leads, pipeline and late work are early warnings.
  • No comparison. A number on its own means little. Compare it to last year, to target or to the trend.
  • Messy books. If income and costs are miscategorized, margin will be wrong no matter how good the dashboard looks.
  • No owner. A number nobody is responsible for will stay red forever.

Questions owners ask

What KPIs should a small business track?

Start with cash on hand, revenue against last year, gross margin, overdue receivables, new leads, pipeline value and work in progress. Adjust the labels for your industry, but keep the list short.

How do I make a dashboard for my business?

List the numbers you'd act on, find where each one lives and connect those sources so they update on their own. A spreadsheet can work at first, but manual updates tend to slip within a few weeks.

Can QuickBooks show me a dashboard?

Yes, for financial numbers. It won't show leads, quotes or job status unless that work is also tracked there, so most owners combine it with another source.

How often should I review my business numbers?

Weekly for cash and leads, monthly for margin, revenue and receivables. A short, regular review beats a long one you keep putting off.

Where a Control Hub fits

A Control Hub is one way to get this view without building it by hand. It pulls from your accounting, leads and job systems, keeps the numbers current and sends a weekly summary. See finances and reporting, or read how owners use it to run the business without being there.

If you'd like help choosing your seven numbers, book a call and we'll work through them together.

Schedule a call

See what a Control Hub could do for your business

Tell us a little about how you work. We'll reach out to set up a short call. No obligation, and the questionnaire that follows takes about 15 minutes.

Biggest pain points (pick any)
We only use this to get in touch. Privacy policy.