PhixFlow - Full Data Reconcilliation – PhixFlow
This site uses cookies in accordance with our privacy policy. By continuing to use this site, you agree to these terms. Learn more

HLR vs. Billing Reconciliation

Increasing revenue through full data reconciliation


Our client knew that errors in their provisioning processes had resulted in some of their post paid subscribers receiving free mobile services. The problems ranged from subscribers who were receiving individual services that weren't billed for to subscribers who had not been provisioned on their billing systems at all and so were receiving all services free of charge. Our client wanted a solution that would perform a full reconciliation of all HLR subscribers and services vs. the subscribers and subscriber products on the billing system.


The HLR team provide a binary encoded export file for each of their fourteen Ericsson HLRs once a month (this is the maximum operational frequency that they can handle to avoid disruption to live service queries against the HLR). PhixFlow's configurable file collectors decompress the files and read the binary data to extract the subscriber details and associated service tags.

The receipt of the HLR data triggers PhixFlow to query the billing system and load details of all active subscribers and their associated billed products as of the date and time of the HLR data extract. A "billed product to service" reference table (see note below) provides the mapping between billed product and expected services. PhixFlow checks:

  • That each postpaid subscriber is present on both the billing system and HLR
  • That the subscriber is active or inactive on both the billing system and HLR
  • That the subscriber’s billable services matches the services implied by the billable products

Any mismatches are reported at the subscriber, product and service levels. Management level, formatted spreadsheets are generated by PhixFlow and automatically emailed to the configured distribution list.

Note:  "billed product to service" reference table

Initially, the client in question had no clear rules about which services should be in place for each billing product (the provisioning process was long and complex). To resolve this issue, PhixFlow was used to carry out a statistical analysis in which the percentage occurrence of each HLR service was measured against every billed product (about 4.5 billion combinations). The output of this analysis was a "billed product to service" reference table based on the 95% probability percentile. This initial reference table is now updated directly as new products are rules are introduced.


Using PhixFlow, the client realised the following benefits:

Billed revenue increased

Subscribers missing on the billing system are re-provisioned from the CRM system (if known) or are terminated on the HLR.

More subscribers retained

PhixFlow also identifies subscribers being billed for services and generates a list of missing subscriber + services for provisioning.

Reduced operational spend

Staff no longer have to spend many hours investigating issues manually.

Improved management visibility

management can monitor the level of problem subscribers. Trending charts verify that the number of problems is reducing over time.

Dig deeper

Discover how our professional services, support and training resources can advance your business.

Our services