Continuity during absence: who really knows the numbers?

In many organizations, there is one person who truly understands the numbers. That person manages the Excel file that was set up years ago, knows which formulas need to be dragged down, which ERP exports first need to be cleaned up manually, and which exceptions always come back in the reporting. As long as that person is available, it seems workable.

But what happens when that colleague leaves, is absent for a long period of time, or is unavailable at the very moment when up-to-date insights are urgently needed? Then you immediately have an acute management problem. This vulnerability can be prevented.

The real risk is not in the data, but in dependency

Continuity is not only about processes and staffing, but also about the reliability and transferability of management information. As a managing director or CFO, you want to be able to rely on the numbers at any time. Not only when the right employee is present, but especially when someone drops out.

In practice, we see that this risk usually arises in three places: in knowledge, in processes, and in the way information is spread across the organization.

Management information must not depend on one employee

In many organizations, crucial knowledge about reporting is implicitly held by one or a few employees. Think of KPI definitions that were never formally documented, manual corrections to ERP exports, exceptions per customer or product, and specific methods behind margin, revenue, or cost calculations.

As long as that knowledge is not properly documented, a problem arises immediately when someone is absent or leaves. Reports become less reliable or cannot be produced at all, checks take longer, and reconstructing reports takes a great deal of time.

Manual processes make you vulnerable

The way reports are produced is often a risk in itself. Budget versus actual analyses, forecast updates, consolidation, inventory valuation, and cash overviews still often rely in practice on manual copy-paste work and formula drag-downs in spreadsheets.

This makes processes error-prone and difficult to transfer. If someone drops out, this immediately leads to problems, extra workload, and a higher risk of errors. For a CFO, that means less control over the planning and control cycle, invoicing, audit checks, and more. For a managing director, it means less certainty that you can make timely adjustments to operations, margins, or performance.

Fragmented information undermines trust

When teams work with their own spreadsheets, filters, and definitions, discrepancies arise. Then you no longer have one version of the truth, but multiple versions side by side. That leads to discussions about the numbers instead of decisions based on the numbers, delays in decision-making, and declining trust in reporting.

The information is often there, but not consistent enough to steer quickly and with confidence. And that is exactly where the problem lies. Not in a lack of data, but in the absence of robust insights that can easily be transferred between teams.

What do you need to solve this problem?

If you recognize this, the core question is not whether you have enough reports. The real question is whether your management information is reliable and transferable, even when people change roles or are absent.

At a basic level, you need three things. Everyone must look at the same KPIs, with the same definitions. You must be able to trace where the numbers come from and why they are correct. And reporting must not depend on one specialist or one manual process.

If you have this in order, you can absorb absences and continue making the right decisions.

Where BI comes into the picture

This is exactly where Business Intelligence adds value. BI brings together data from ERP, CRM, and other systems, standardizes definitions, improves data quality, and turns information into clear management insights. The goal is not to create attractive charts, but to enable faster and better steering based on reliable numbers.

For a managing director or CFO, this mainly means more peace of mind and more control. Instead of being dependent on one person, one spreadsheet, or one manual process, a central information foundation is created that the wider organization can rely on. That allows you to move faster, even when staffing changes.

Why Cadran Analytics? 

Cadran Analytics combines BI expertise with in-depth knowledge of ERP processes. That is an important difference, because good management information does not arise from unlocking data technically alone. You also need to understand how financial and operational processes work in practice, where dependencies arise, and which insights management truly needs in order to steer effectively.

That is exactly where our strength lies. We have a strong ERP background and deep knowledge of NetSuite. This means we understand how valuable management information is often already present in the ERP system, but in practice does not come out properly because of separate exports, limited standard reporting, or manual enrichment in Excel. This applies not only to NetSuite, but also to other ERP systems such as JD Edwards and Exact. instead of an accelerator of your operations.