How to Read Your Sales Dashboard Without Getting Lost

The common reaction to a new dashboard is to stare at it, feel mildly informed, and close the tab. A day later you cannot remember a single number. That is not a failure of attention. It is a failure of method: nobody told you what to look for.

Here is the method we use ourselves and suggest to shop owners. Three passes, in a fixed order, and permission to ignore everything else.

Pass one: the tiles at the top

The top of a dashboard usually carries the plain totals. In Billy these are today's sales, receivables, payables, and cash and bank balance. Read them left to right as a short story.

• Today's sales: are we open and trading as expected?
• Receivables: how much is still owed to us?
• Payables: how much do we owe?
• Cash and bank: can we cover the payables?

That is the whole financial health check in four numbers. If the last number is smaller than the third and bills fall due soon, that is the first thing to act on, whatever the charts say.

Pass two: the daily chart

A sales-by-day chart is for spotting shape, not exact values. Look for the rhythm of your trade. A clothes shop sees weekend peaks. A wholesaler may see a spike on market days. A clinic's pharmacy counter may be quiet on Sundays.

Once you know the normal rhythm, deviations stand out. A flat Saturday in a shop that always peaks on Saturdays deserves a question. A single low Tuesday does not. One bad day is noise, and we would not touch a price or promotion because of it.

Pass three: the monthly chart

Monthly bars show the slower story: growth, seasonality, and the festival peaks that every Indian retailer plans around. Compare a month with the same month last year if you have it, not with the previous month. October against September tells you little. October against last October tells you something.

If the date range is adjustable, use it. Billy lets you view today, this week, this month, the financial year or a custom range. A custom range is handy for comparing a sale fortnight with the fortnight before, or the week of a shop renovation with a normal week.

Questions a dashboard can answer, and ones it cannot

A sales dashboard answers 'how much, and when'. It does not answer 'why' by itself. If sales dip, the numbers will not tell you whether a competitor opened, your best salesperson was on leave, or a bad review went up. You still have to go and ask.

It also cannot tell you about profit. Sales is what you billed, not what you kept. Read profit vs cash before treating a rising sales line as good news on its own.

A five-minute routine

1. 1Open the dashboard at the same time each day.
2. 2Read the four tiles. Note anything odd.
3. 3Glance at the daily chart. Does it match what you saw in the shop?
4. 4Once a week, set the range to this week and compare with last week.
5. 5Once a month, check the monthly chart and write one sentence about what changed.

That single sentence is surprisingly valuable. After six months you have a small diary of what actually moved your numbers, which is better than any report.

Making the dashboard part of the shop

Some owners keep the dashboard open on the counter computer; others check it on a phone browser in the evening. Either way, tie it to a moment that already exists. Looking at it with the first cup of tea, or while closing the register, is far likelier to stick than a reminder you will ignore. Share one number a week with the staff too, such as how this week compares with last. People tend to care about a figure they are shown.

• Chasing every dip. Charts wiggle.
• Reading sales and ignoring receivables. Revenue not collected is a loan to your customer.
• Comparing unlike periods, such as a Diwali week against a normal week.
• Leaving the dashboard to the accountant. The owner is the one who can act on it.

For what to do when the receivables number looks too big, overdue payments and ageing reports is the natural next read. If you would like a dashboard tile built around a number specific to your trade, we do that kind of work, and you can reach us through our contact page.