Building a Simple Business Dashboard

What a Dashboard Is For

A dashboard is a single page that shows the handful of numbers you need to understand how the business is doing right now. It is not a report for outsiders or a full set of accounts. Its job is to answer one question quickly: is anything drifting off course?

For a small business, the dashboard can be a sheet of paper, a whiteboard, a page in a notebook or a simple spreadsheet. The format matters far less than the habit of looking at it at the same time each week.

Choose Few Numbers

The most common mistake is including too much. If you cannot take it in within a couple of minutes, it is too crowded. A reasonable target is somewhere between five and ten figures.

To decide what belongs, ask of each candidate:

• Would a change in this number make me do something different?
• Can I get it reliably, without spending an hour assembling it?
• Does it reflect something I can influence?

If the answer to the first question is no, leave it off. Numbers that are interesting but never lead to action tend to clutter the page.

Categories to Cover

Most small businesses benefit from a few figures in each of these areas. Which specific numbers you choose depends on your type of business.

Sales. Revenue for the week, and perhaps the number of orders, jobs or appointments. Service businesses might also track new inquiries or quotes sent, since these often come before revenue.

Cash. The balance in your business account and any money owed to you that is overdue. Cash flow problems usually show up here before they show up anywhere else, and late payments are easy to overlook until they pile up.

Costs and margin. Major expenses for the week and, if you can calculate it, your profit margin on the work you sold. Even a rough figure helps you notice if costs are creeping up.

Customers. A count of complaints, refunds or returns, or a simple satisfaction note. Repeat customers or cancellations can be worth a line if your business depends on ongoing relationships.

Operations. Something that reflects delivery quality or capacity, such as orders shipped late, backlog of unfinished jobs, or hours booked against hours available.

You will not need all of these. A one-person consulting practice and a small shop have quite different lists.

Define Each Number Clearly

Vague definitions make numbers useless. “Sales” could mean orders placed, invoices sent or payments received, and those are not the same thing. Decide on one meaning and write it beside the figure.

For each item, record:

• The name
• Exactly how it is calculated
• Where the data comes from
• How often it is updated

This takes a few minutes now and saves confusion later, particularly if someone else ever helps you maintain the page. It also prevents the quiet drift in which the definition changes and last month’s number can no longer be compared with this month’s.

Show Comparisons, Not Just Totals

A single figure is hard to interpret. Is $4,200 in weekly sales good? It depends on what is normal. Place beside each number at least one reference point:

• The previous week
• The same week last year, if you have it
• Your target or budget figure

A simple layout is a table with the metric name on the left, then columns for this week, last week and target. You can add a plain marker, such as an up or down arrow, or a note like “check” when something moves beyond a range you chose in advance.

If you have a business budget, comparing actuals with it is often the most informative reference. If you do not, last week and the past four-week average are a fine start.

A Hypothetical Example

Imagine a small home-cleaning business. Its owner might track these weekly:

(All figures are made up for illustration.) Reading across, the owner sees that jobs, revenue and inquiries all dipped, while overdue invoices rose. Revenue of $2,700 from 18 jobs works out to $150 per job, the same as last week’s $3,000 from 20 jobs. So the price per job held steady and the drop is about volume. That points the owner toward the front of the pipeline, meaning inquiries, and toward chasing the overdue amount, rather than toward changing prices.

Notice that the dashboard did not give the answer. It showed where to look.

Keep It Easy to Update

A dashboard that takes two hours to fill in will be abandoned within a few weeks. Design it so the weekly update takes about fifteen to thirty minutes.

• Pull from records you already keep, such as your bookkeeping records and invoice list.
• Update on a fixed day and time.
• Avoid figures that require manual counting if an easier proxy exists.
• Start with fewer items and add one only when you truly miss it.

If a number is hard to get, consider whether you need it. Sometimes a rougher figure that you can produce in a minute is more valuable than a precise one you never compile.

Review and Adjust

Use the dashboard as the starting point of a short weekly check. Look at what moved, ask why, and decide on at most one or two actions. Write the actions down and look at them next time to see what happened.

Every few months, review the dashboard itself. Remove items that never prompted a decision. Add one if you keep wishing you had it. Businesses change, and the page should change with them.

Limits to Keep in Mind

A dashboard simplifies. It cannot capture a customer’s tone on the phone, a supplier’s warning, or your own sense that something is off. Treat it as one input alongside conversation and judgment.

Small numbers also fluctuate by chance. A single slow week is rarely a trend, so wait for a few periods before reacting strongly. And keep in mind that tracking numbers does not by itself improve results. The benefit comes from noticing earlier and responding sensibly.