Seven Numbers on One Page: A Monthly Dashboard for the Owner Who Has No Analyst

Principles of an Effective Dashboard

Large companies report dozens of metrics. A small business needs a handful, chosen for what they tell the owner to do. This guide gives a template. It is general information, adaptable to your business.

Principles: 1. One page. If you need more, you will not read it. 2. Same month last year. Seasonality makes month-on-month comparisons misleading. Where you have no history, compare with the previous four weeks. 3. Rate and volume. Track how many and how much, separately. 4. One owner per number. Someone is responsible for each. 5. One question per number. If a number goes the wrong way, what is the first thing you check?

Core Numbers for Every Business

• Sales, and sales compared with the same month last year. • Gross margin, the share of sales left after direct costs. • Cash at bank and the number of days of fixed costs it covers. • Receivables, the money owed to you, and how many days it takes customers to pay.

“The best dashboard is the one you will actually open.”

Sector-Specific Templates: Retail, Hospitality, Logistics, Services

For a shop or a chain: • Same-store sales growth. This compares sales in outlets open in both periods and strips out the effect of new openings. As our hospitality piece showed from a January 2026 report, a chain can grow revenue by opening stores while each store sells less. For one shop, the equivalent is your sales on the same days against last year. • Footfall or orders, and average basket. Invented example: A shop took Rs 20 lakh in the month, against Rs 19 lakh a year earlier, up 5.3%. Orders were 1,000 against 1,100, down 9.1%, and the average basket rose from Rs 1,727 to Rs 2,000. Prices and mix lifted sales while customer count fell. The owner's question: why are fewer people buying?

For a hotel, guesthouse or restaurant: • Occupancy (rooms sold divided by rooms available), average room rate, and RevPAR (revenue per available room, which is occupancy times average rate). For a restaurant: covers, average spend per cover and sales per seat. • Direct bookings share, since commissions cost money. Invented example: A 30-room guesthouse sells 600 room nights in a 30-day month at Rs 3,000, revenue Rs 18 lakh. Available room nights are 900, so occupancy is 66.7% and RevPAR is Rs 2,000.

For a transport or logistics firm: • Cost per kilometre or cost per delivery, vehicle utilisation (days on road, loaded share) and on-time delivery rate. • Fuel share of cost. The DPIIT-NCAER study reported fuel at 42.1% of road freight expenses on average. Compare your own. Invented example: A fleet of 10 trucks spends Rs 12 lakh on fuel in a month out of Rs 28 lakh total operating cost, 42.9%. Close to the study's average. If the share is much higher, ask about routes and driving practices.

For a service business: • Billable utilisation (billed hours divided by available hours), average realisation per hour, pipeline of confirmed work for the next three months, and client concentration (the share of sales from the largest client). Invented example: A consultancy's largest client is 45% of sales. If that client leaves, the firm's sales fall by almost half. The owner's question: what is the plan to widen the base?

Building, Reviewing, and Mistakes to Avoid

How to build it: Use a simple spreadsheet. One row per number, columns for this month, last month, the same month last year, the target and a note. Fill it in on the first working day of each month. Use colours sparingly; a number going the wrong way for two months running is worth a conversation.

How to use it: Review it for 30 minutes with whoever helps run the business. Pick one number to improve in the next month. Write down the action and who will do it. Revisit next month. After six months, drop numbers you never act on.

Mistakes to avoid: • Too many numbers. • Vanity numbers that rise but do not tell you what to do. • Averages that hide extremes. Look at the top and bottom of the range as well. • Changing definitions. If you change how you calculate a number, note it.

A Sample First Month

In month one, do not aim for accuracy to the rupee. Gather what you can from your bank statement, invoices and till or booking records, and fill in the page with rounded figures. Note which numbers were hard to find. In month two, improve the two or three that were least reliable. By month three, you will have a baseline and, more importantly, a habit. Many owners find that the act of writing the numbers down changes what they notice, before any analysis is done.