Recovering $9 Million Through Automated Revenue Reconciliation
Over $9 million was recovered in four months by automating large-scale SIM reconciliation and eliminating revenue leakage caused by untracked connections.
Context
For large telecommunications providers, asset leakage at scale becomes a silent financial risk. In this case, more than one million SIMs and numbers existed without clear ownership, allocation or cost-centre alignment.
Billing data was unreliable. Revenue figures were distorted. And manual remediation was impossible at this scale. The organisation was bleeding money, but couldn’t see precisely where or why.
This wasn’t a reporting issue. It was a control problem.
Approach
Big House was engaged to design a solution that could operate at enterprise scale, quietly and continuously.
Define
We began by mapping the problem across multiple legacy environments, including an IBM mainframe and several asset repositories.
This work established where data fragmentation occurred, how SIMs became “lost” in the system, and why traditional audit approaches could never keep pace with the volume of assets involved.
Clear definition allowed the problem to be solved once, not repeatedly chased.
Align
With the problem understood, we engineered a purpose-built solution.
Big House designed and built a bespoke Automated Reconciliation Service (ARS) on the ServiceNow platform. The application pulled SIMs classified as lost, stolen or unknown and executed a fully automated recovery workflow at scale.
The system polled numbers via outbound SMS and, based on response rules, automatically:
Reallocated valid assets to the correct cost centre, or
Flagged numbers for disconnection where no legitimate owner existed
All actions were executed without manual intervention.
Govern
Governance was embedded directly into the workflow.
Every recovery batch produced a full audit trail, contact attempts, responses, actions taken and final outcomes. The ARS continues to operate quietly in the background, providing an ongoing, auditable control layer for risk, finance and compliance teams.
Outcome
Within four months of deployment, the automated recovery process delivered a verified $9 million saving by eliminating ghost connections and correcting revenue leakage.
The organisation gained the ability to initiate recovery runs in controlled batches, scaling activity without operational disruption. Most importantly, asset reconciliation moved from an impossible manual task to a governed, repeatable capability.
Revenue integrity was restored, and remains protected.