01The monthly report takes more than two days to produce

If someone has to export from the ERP or POS, pivot in Excel, reconcile the branches, and format the result, every single month, you have raw material, not a reporting system. By the time the report lands, it describes a month that has already passed, and the person producing it is a single point of failure.

What this signals The fix isn't a better Excel template. It's a pipeline that turns raw exports into the report automatically, so the report becomes a by-product, not a project.

02Every manager has a different "correct" number

Ask three managers for last month's revenue and get three answers. That's not a data-quality problem, it's a definition problem. Each is pulling a different source, filter, or cutoff date. The meeting becomes a debate about whose number is right instead of what to do next.

The fix: one source of truth, with every key metric defined once, measured the same way, from the same place.

03You know what sells, but not what earns

Revenue is easy to see. Earnings per product require knowing costs at the product level, and often nobody calculates it. A product bringing 20% of revenue can bring 5% of the profit once production, storage, returns, and delivery are counted, while a "small" product quietly earns the most per unit.

Price lists, production schedules, and sales bonuses built on revenue alone are optimizing the wrong number.

04Revenue is growing but cash isn't showing up

The most dangerous sign, because the business looks healthy. Sales are up, targets are hit, and the owner keeps bridging cash gaps. The money is almost always hiding in one of three places:

  • Customers paying late: on 30-day terms, money routinely arriving past 45 days means collections is the cash problem
  • Stock sitting too long: inventory that takes more than ~3 months to sell is working capital parked on shelves
  • Margins compressing: costs rising faster than prices, invisible in a revenue-only report

None of these appear in a revenue report. Each of them appears the moment you look at the business as money flowing in and out, not sales going up.

05Decisions follow the latest story, not the trend

A manager reports a great week at Branch 2, and the owner thinks Branch 2 is doing better. Next week, another story changes the owner's mind again. It feels like staying informed; it's actually reacting to noise. Whether Branch 2 is growing, flat, or declining over three months is a question nobody in the room can answer.

The test: pick any number that matters and say its 12-week trend without pulling a report. If you can't, decisions are leaning on what happened most recently rather than on the trend.

06The common root cause

All five signs point to the same gap: the data exists, but nobody has organized it to guide decisions. It answers "what happened?" and goes silent on "what should we do?"

The good news: much of the data needed to fix all five often already sits in the ERP, POS, or accounting system. We structure that data, define the numbers, and set up a reporting routine.

Data qualityAll industries