The cost of competing records
Finance may close the month on one set of numbers while operations plans against another. Both teams can explain how they reached their figures, yet leadership still has to reconcile the difference before deciding. The cost is more than maintaining software: it is the time spent establishing which version of the business everyone should trust.
Consolidation starts by deciding where each record becomes authoritative. Technology supports that agreement; it cannot make it on behalf of the organization.
Start with the decisions
Map the decisions that keep the organization running: what to produce, purchase, price, hold and pay. For each decision, identify the current source, the person responsible and the consequences of an incorrect record. This exposes the ambiguities that a module list can easily hide.
The objective is not simply a new general ledger. It is for finance and operations to see the same working-capital figure, built from the same records and cut-off rules.
Treat migration as its own workstream
Extracting records is only one part of migration. Customer duplicates, reused item codes and inactive cost centers carry the history of local workarounds. These need business decisions, not just technical transformations.
Assign an owner to each data domain and start validation early. Define acceptance criteria, rehearse the transfer and reconcile totals and sample records. The accountable business owner should know what was moved, what was excluded and why.
Keep useful systems, clarify their role
A consolidated environment does not require replacing every application. Specialized systems may remain where they serve a clear purpose. The important change is that they consume or maintain agreed records instead of competing to define them.
Document integration contracts, ownership and exception routes. When a transaction fails, teams should know which record is correct and how the issue will be resolved.
Measure the operation after launch
Go-live is a milestone, not the whole outcome. Review close time, reconciliation effort and the questions leadership still asks about the data. A useful foundation makes decisions easier to take and explain.
For your next workshop, bring three decisions that currently require manual reconciliation. They are a practical starting point for defining the scope of consolidation.
