← All articles

·3 min read

The Owner's Dashboard: Turning Sales, Stock and Finance Data Into Numbers You Actually Check

Most business dashboards get opened twice and forgotten. Here is how to pick the handful of numbers that matter, get clean data behind them, and build a dashboard an owner checks every morning.

  • dashboard
  • business intelligence
  • reporting
  • data analytics
  • sme
The Owner's Dashboard: Turning Sales, Stock and Finance Data Into Numbers You Actually Check

"I just want to see how the business is doing" is a request we hear often from owners. What they usually have instead is a collection of reports: a sales export from the POS, a stock sheet from the warehouse, a bank statement, a marketplace payout file. Getting a clear picture means asking three people and waiting until the end of the month.

A good dashboard fixes that. A bad one becomes another tab nobody opens. The difference has less to do with charts than with the decisions made before the first chart is drawn.

Start with decisions, not data

Before choosing a single metric, write down the decisions you make every week. For example:

  • Which products should we reorder, and how much?
  • Which branch or channel needs attention?
  • Do we have enough cash to pay suppliers next week?
  • Is the promotion we ran actually working?

Each decision points to a few numbers. Those numbers, and nothing else, belong on the first version of the dashboard.

The metrics most owners need

Sales

Revenue today, this week and this month compared with the same period last year, broken down by branch or channel. Add average transaction value and the number of transactions, because revenue can stay flat while both change underneath.

Margin

Gross margin by product category. Revenue growth that comes from discounted, low-margin items can look healthy while profit shrinks.

Stock

Items below their reorder point, days of stock remaining for best sellers, and slow-moving stock that ties up cash.

Cash

Cash on hand, receivables that are overdue, and payables due in the next two weeks. Many profitable businesses get into trouble because cash arrives later than bills do.

Customers

New versus returning customers, and for B2B companies, the sales pipeline by stage.

The hard part is the data, not the dashboard

A dashboard is only as trustworthy as the data behind it. The usual problems are:

  • Different names for the same thing. One product appears under three spellings across the POS, the marketplace and the warehouse sheet.
  • Manual steps. Someone has to download and paste files every day, and when they are on leave the dashboard goes stale.
  • Different definitions. Is revenue counted when the order is placed, paid or delivered? If finance and sales disagree, the dashboard will start arguments instead of ending them.

That is why dashboards work best on top of a single source of truth for orders, stock and the ledger, the idea behind an ERP like our Legacy ERP. If your data still lives in several spreadsheets, our guide to signs your business has outgrown spreadsheets may be the better first step.

Choosing a tool

  • Built-in reports in your POS, accounting or ERP software. Free and already connected, but usually limited to that one system.
  • BI tools such as Looker Studio, Power BI or Metabase. Flexible and affordable, and a good fit when data from several systems already lands in one database.
  • A custom dashboard inside your own system. Worth it when the dashboard needs to trigger actions, such as creating a purchase order from a low-stock alert, or when many staff need different views with strict access rules.

Design rules that keep it in use

  1. One screen, five to seven numbers. If it needs scrolling, it is a report, not a dashboard.
  2. Always show a comparison. "Rp85 million" means nothing alone; "Rp85 million, 12% above last month" does.
  3. Make it work on a phone. Owners check numbers between meetings, not at a desk.
  4. Refresh automatically. Daily at minimum, hourly for sales if it matters.
  5. Send alerts for exceptions. A WhatsApp or email message when stock runs low or a branch has a bad day is often more useful than the dashboard itself.

Start small, use it for a month, and add only what you find yourself asking for. If you want help connecting your systems and building a dashboard your team will actually use, talk to CodeWorks.