Sales reports growth. Finance sees less confirmed business. Operations plans additional capacity. Everyone has done the calculations, but not necessarily on the same basis. The executive meeting then becomes a discussion about where the figures came from, when it should be deciding on staffing, investment or delivery commitments.
This is more than an inconvenience. Mistaking the value of open proposals for confirmed order intake can lead a company to build capacity too early. Failing to see confirmed orders because a system update is delayed can mean withholding the very resources needed to fulfil them. There is no universal loss rate for this. The business question is more specific: which decision are we making and which figure are we using to make it?
I would therefore not start with a new dashboard. First, the functions need to agree what their decision-critical metrics mean, how differences are explained and when a figure is reliable enough to support a particular decision. The definition belongs in the shared operating model, not in the memory of the person preparing the report.
Different figures are not automatically wrong
A sales forecast, a confirmed order, work delivered and an amount invoiced represent different stages of business activity. They can legitimately differ. An order is not yet revenue and an invoice is not yet a cash receipt. These distinctions are particularly important in longer-running projects.
Problems arise when all four figures appear under the same heading or when their boundaries have to be explained in the meeting. A factually correct figure can then support the wrong decision. A more precise presentation will not resolve this if the meaning remains unclear.
A shared order intake metric, for example, needs agreed rules on contract status, cancellations and the cut-off date. International business also requires a consistent currency, exchange rate and allocation within group reporting. A margin comparison needs the same cost basis. One function may include variable delivery costs, while another also includes project management. Initially, these are different questions, not calculation errors.
The first step is therefore to identify differences before trying to eliminate them. Function-specific views that serve a useful business purpose can remain. For cross-functional decisions, however, they must be reconcilable to an agreed management metric.
Why an expensive reporting system cannot solve this on its own
A carefully bounded finding from banking shows how demanding shared data architecture and reporting can be. In the Basel Committee's progress report published in 2023, based on the assessment as at June 2022, only 2 of the 31 assessed global systemically important banks fully complied with every assessed BCBS 239 principle. The assessment was conducted by the relevant supervisors. The report also states that most banks had achieved largely or fully compliant ratings across the principles.1
This is not a data error rate, a claim that banks' reports are unusable or a benchmark for SMEs. The regulatory requirements and the complexity of international banks are exceptionally high. The finding does, however, show why existing systems do not guarantee a fully reconciled data foundation. The same report identifies the absence of common data classifications and incomplete data lineage, meaning the traceability of data from its origin, as obstacles.1
BCBS 239 requires banks to establish, among other things, consistent definitions, traceable reconciliation and accountability on both the business and IT sides. A single physical data model is not mandatory; multiple models require robust reconciliation procedures. This is a useful architectural principle, not a general regulatory obligation for mid-sized companies.2
For a CEO, the implication is clear: bringing data together may be worthwhile. It does not replace the decision about which meaning should apply and who is accountable for it.
A reconciliation bridge instead of another debate
Consider an explicitly illustrative example, not a client case. A CRM extract purportedly shows CHF 1,200,000 in order intake. For capacity planning, however, the company wants to use only net confirmed new order intake up to an agreed cut-off date. Assume that all the following amounts are in CHF, exclude VAT and have been calculated without overlap.
The review finds that CHF 100,000 relates to business not yet confirmed. CHF 50,000 comes from duplicate records. A further CHF 150,000 was confirmed only after the cut-off date and belongs in the next period.
The reconciliation is as follows:
CHF 1,200,000 in the initial extract, less CHF 100,000 of unconfirmed business, CHF 50,000 of duplicate records and CHF 150,000 outside the period, gives CHF 900,000 for the agreed management metric. This is an illustrative calculation, not an observed company result.
The CHF 300,000 difference is not automatically lost business. Some of it may be confirmed later. The duplicate records, by contrast, are a data error. Calling the entire difference lost revenue would create the next misleading metric.
Nor is CHF 900,000 alone enough to authorise a staffing decision. Operations needs to know when the orders will be fulfilled, which skills they require and how much existing capacity is available. The shared figure enables this next step. It does not determine the decision in advance.
A reconciliation bridge of this kind should be traceable to the affected records. Otherwise, it is merely another explanation on a slide. If a difference remains unresolved, its amount, possible cause and responsible person must be visibly documented. A new total must not conceal the unresolved balance.
A metric specification jointly owned by the functions
I would start with a small number of metrics that genuinely inform a management decision. Each gets a short specification. There is no need for a hundred-page data manual before the first useful result.
First, the decision it supports. Is the figure intended to support capacity approval, a pricing decision or a liquidity measure? The same data source may need different analyses for different purposes. A forecast is useful when its uncertainty is disclosed. Presenting it as business already secured would be misleading.
Then, the definition. What is counted and what is excluded? Which period, currency and unit apply? How are cancellations, partial orders and subsequent changes handled? Ratios need a clear numerator and denominator. A win rate based on the number of orders is not the same as one based on order value.
Next, the data flow. Where does the relevant business transaction originate, which source is authoritative for each stage and which calculation produces the management figure? A manual adjustment needs a reason, a traceable approval and a date. The original data must be retained.
Finally, accountability. A named business owner confirms the definition and fitness for use. IT ensures that technical processing and controls work. Users of the metric provide feedback on requirements and identifiable problems. A data owner can resolve a question about a figure; the business decision remains with the executive authorised to make it.
The UK's Government Data Quality Framework, published in 2020, supports this use-based approach. It calls for critical data to be prioritised, quality to be documented clearly and accountability to be established. It was developed for UK central government and is not a mandatory corporate standard.3
When a decision can proceed despite uncertainty
Insisting on fully reconciled figures can also cause harm. An operational decision may be needed today, while a final accounting entry will only be available later. That calls for a visibly provisional figure, not a pretence of finality.
The UK framework distinguishes, among other dimensions, consistency, accuracy, completeness and timeliness. Data can be internally consistent yet still misrepresent reality. It also describes the trade-off between timely availability and completeness. Quality must be assessed against the intended use.3
I would distinguish three usage statuses. A verified figure is approved for its stated purpose. A provisional figure may be used only for explicitly specified, limited decisions. A blocked metric must not be used to justify the affected decision until the material uncertainty has been resolved.
Materiality is not simply about the size of a discrepancy. Even a small unexplained difference can matter if it changes whether a minimum margin is met or a capacity bottleneck exists. Conversely, an immaterial, explained rounding difference need not bring all operational planning to a halt. The test is whether it could change the decision.
In practice, Finance and the affected function should explain how sensitive the decision is to the unresolved difference. If the proposed action remains sensible under plausible scenarios, limited approval with a review date may be justified. If the decision changes depending on the interpretation, further clarification is needed before approval. Reversible actions and long-term commitments warrant different requirements.