The short answer. A small business dashboard should show 5 to 8 numbers that change what you do this week: usually revenue against target, margin, cash, money owed to you, enquiries by source, conversion rate, cost per customer and one operations number such as stock cover or overdue jobs. Pick from the 12 below, write down how each one is calculated, and leave everything else off the first page.
Most owners we speak to already have the data. It sits in Excel files, Tally or another accounting tool, Shopify and the Meta Ads account. What they don’t have is one page that answers “how are we doing, and what needs attention?” in under a minute. These are the 12 numbers we start from when we build that page.
The 12 numbers
Money 01–04
- Revenue against target. Sales this month so far compared with the plan for the same point in the month, not with the full-month target. Source: accounting or sales system.
- Gross margin %. (Revenue − direct costs) ÷ revenue. Revenue can rise while margin falls, and only one of them pays the bills. Source: accounting system.
- Cash in the bank, in weeks. Cash available divided by average weekly outgoings. “Six weeks of cash” is easier to act on than a balance. Source: bank export.
- Money owed to you, overdue. Unpaid invoices past their due date, oldest first. A strong sales month means little if it hasn’t been collected. Source: invoicing or Tally.
Sales and customers 05–08
- Enquiries by source. New enquiries this week, split by where they came from: Google, Instagram, referrals, ads. Source: website form with source tracking, CRM or a simple sheet.
- Conversion rate. Paying customers ÷ enquiries over the same period. If enquiries rise and sales don’t, the problem is after the enquiry. Source: CRM or sales sheet.
- Average order or job value. Revenue ÷ number of orders or jobs. It tells you whether growth comes from more customers or bigger ones. Source: sales system.
- Repeat customers. Share of this month’s customers who bought before. For product and food brands it’s often the cheapest growth there is. Source: Shopify or sales history.
Marketing 09–10
- Cost per customer by channel. Spend on a channel ÷ customers it brought in. Cost per click and reach don’t belong on an owner’s first page. Source: ad accounts plus sales data.
- Ad return checked against real sales. What the ad platform reports compared with the sales you actually recorded. Platforms count with their own attribution, so the two rarely match exactly. Source: ad accounts plus Shopify or accounting.
Operations 11–12
- Stock cover. Stock on hand ÷ average daily sales, shown in days. It flags stockouts and cash tied up in slow stock. For service businesses, use team capacity booked instead. Source: inventory sheet or Shopify.
- Overdue jobs or orders. Work past its promised date. Customers notice this before any other number moves. Source: job cards, order system or project sheet.
How to pick your 5 to 8
Twelve numbers is too many for one page. Use three questions to cut the list:
- Does it change a decision this week? If nobody would act differently when it moves, it belongs in a monthly report, not the dashboard.
- Can it be calculated from data you already have? Start with what exists. A number that needs a new process to collect can come in version two.
- Does someone own it? Every number needs one person who explains it when it moves.
For a restaurant or local service business, that usually leaves revenue against target, margin, enquiries or bookings by source, and overdue jobs. An online store might add stock cover, repeat customers and ad return against real sales. A B2B company tends to swap repeat customers for pipeline numbers, such as qualified leads and opportunities by channel.
What one page should look like
- Top row: the 3 or 4 headline numbers, each with last period alongside and a clear up or down.
- Middle: one trend chart for revenue or enquiries over the last 12 weeks.
- Bottom: one “needs attention” list, such as overdue invoices, low-stock items or late jobs.
Detail lives on a second and third page for whoever needs it. The owner’s page should be readable on a phone.
Three mistakes that make owners stop trusting the dashboard
1. Two reports, two answers
If sales counts an order when it’s placed and accounts counts it when it’s invoiced, the same month shows two different totals. The fix is a written definition for every number: its formula, its source and its owner. We write one for every dashboard we build, and it’s often the most useful page in the handover.
2. Mixing dates
On a marketing and pipeline dashboard we built in Power BI, reports had been mixing the date a lead was created with the date a deal closed. Period comparisons looked unreliable until each number was tied to the right date. It’s a common, quiet error, and it’s why “this month vs last month” sometimes makes no sense.
3. Trusting the ad platform’s numbers alone
On an e-commerce account we manage, Meta Ads Manager reported a 5.18× purchase return on ₹88,501 of spend over 13 days in July 2026. That’s a useful signal, but it’s Meta’s own attribution, not audited sales. A dashboard should put ad spend next to the sales you actually recorded, so the return can be checked.
Excel or Power BI?
Both work. Excel suits a small team that already lives in spreadsheets and needs one owner’s view. Power BI suits more data sources, more people viewing, or scheduled refresh. In both, use Power Query to connect the source files, so updating the dashboard means pressing refresh, not copying and pasting.
Questions owners ask
How many KPIs should a small business track?
Five to eight on the main page. You can track more underneath, but if the first page needs scrolling, it won’t get read.
How often should the dashboard update?
Weekly is right for most small businesses. Daily makes sense for sales and stock in a busy store. Real-time is rarely worth the cost.
My data is messy. Can I still have a dashboard?
Usually yes. Messy is normal: duplicates, different date formats, names spelled three ways. Cleaning it is part of the build. The real blocker is data that doesn’t exist at all.
Do I need a data warehouse?
Not to start. With three or fewer sources, Excel or Power BI connected straight to your files is enough.
Want this built from your own files? Your Business Dashboard in 10 Days takes up to three sources and turns them into one page with every number defined and checked.