The owner's morning dashboard: 6 numbers that actually matter

Most owner dashboards are noise. Here is the short list that finance heads in Indian SMBs actually open at 9am: sales, cash, ageing, GST, top branch, top SKU.

If you sit with twenty Indian SMB owners and watch how they use a “dashboard”, a pattern emerges fast: they don’t. They open it once, see fourteen charts, and never look again.

A dashboard that actually gets opened every morning has six numbers, sometimes fewer. Everything else is a drill-down, not a tile.

This is the short list we end up with on most AnalytAI deployments.

1. Sales today (and yesterday)

A single big number with a small comparison. The comparison is what carries the weight, not the absolute value.

Today: ₹14.2 L
Yesterday: ₹13.1 L
Same day last week: ₹12.6 L

That last line, same weekday last week, is the one most teams forget. Day-of-week swings are huge in Indian retail and B2B distribution. Monday vs Friday is not noise, it is structure.

2. Cash collected today

Sales is not money. Cash collected is. For most owners, the gap between sales booked and cash collected is the single most useful number on the dashboard.

A healthy distributor business will collect 90–95% of what they bill within a few days. If today’s collection ratio drops below 70% for three days in a row, something is breaking. It is either the field collection team, or a specific party.

3. Overdue greater than 60 days

Not total receivables. Overdue receivables. Ageing buckets matter more than absolute outstanding.

We default to 60+ days because:

30 days is normal credit period.
60 days is “needs a phone call this week”.
90 days is “may not collect without escalation”.
120+ days is “probably written off in your head, not in your books”.

One number, one colour. Red if it crossed a threshold, amber if it grew week-over-week, green if it shrank.

4. Top branch this month

For multi-location businesses (manufacturing with depots, retail with stores, distribution with godowns), one tile shows the top branch by MTD revenue. Click it, and you see all branches ranked.

This single tile catches the slow drift that excel reports miss. The branch that was second last quarter is suddenly fifth. You see it on day 6 of the month, not on day 35.

5. Top SKU or party

Either:

Top SKU by sales MTD (for product-heavy businesses)
Top party by sales MTD (for B2B businesses with concentration risk)

The point isn’t to celebrate the top. It is to spot when the top changes. If your #1 customer stops being #1, you want to know in week one, not in month three.

6. GST liability so far

A live running total of GST collected minus GST input credit available, for the current month.

For most Indian SMBs, the GST number is a surprise on the 19th of every month. A live tile fixes that. You see the liability accruing every day, and you plan your bank balance for the 20th.

For more on the GST side, see our piece on spotting GST input credit leakage in Tally.

What we leave OFF the morning dashboard

Just as important:

Inventory levels: belongs on a weekly review, not daily.
P&L: too lagged to act on daily.
Bank balance: useful, but every owner already knows it from their phone.
Trend charts longer than 7 days: pin to a separate page.

The morning dashboard is a trigger system, not a reporting system. Six tiles. If anything is red, you click in and find out what is happening before lunch.

How to actually build this

Two paths:

Build it yourself: Tally OData / TDL export → SQL view → BI tool. Three weeks for a competent team. Allow four.
Use AnalytAI: connect Tally, ask “show me sales, cash, overdue 60+, top branch, top SKU, GST liability MTD”. Pin each answer to a dashboard. About forty minutes.

Either way, the discipline is the same: six numbers, daily, with a drill-down behind each. Anything beyond that lives on a different page.

If you want us to set this up on your own Tally data, book a 20-minute demo. We will bring it live before the call ends.