Telecom Billing Reports Generation - Telecom Billing

How reports are generated in telecom billing?

Different reports can be generated for providing important information to management on finance, sales and performance of the system. Various reports like financial reports, management reports, reconciliation reports, network activity reports, etc., can be generated.

Reports include information that drives business success and helps in monitoring the health of business; identifying any problem areas so that suitable corrective actions can be taken.

In reporting, none of the Billing Systems meets 100% requirements out-of-the-box and marketing or finance departments usually come up with such reporting requirements which require lot of custom development.

If your Billing System pushes data on Data Warehouse (DWH), then you can transfer reporting activities towards DWH system, but still most of the departments would be interested in getting important reports from the source system, which is the Billing System.

Reports can be categorized into two categories

  • Core/Canned Reports − Billing System provides these reports as a core functionality of the system. Sometimes, they are called canned or standard reports.
  • Custom Reports − these reports are not available directly from the system and some development using PL/SQL, PERL, or Shell script, etc is not needed.

Various billing systems provide various types of reports in various areas. Interconnect Billing Systems are necessary for providing more functionalities related to reporting as they deal with wholesale billing.

Reporting Requirements

Below is the list of reports needed by various departments

Financial Reports

Payment reports give information on the customer's account payments for a certain period of time. Account Receivables aging reports give information on the account receivables, outstanding dues, etc.

Disputes & adjustment reports allow identifying the pattern of reasons for disputes & adjustments and help in understanding the cause for such disputes & adjustments and take appropriate corrective action.

Management Reports

Management reports will provide information on customers, their products & services usage, call patterns, customer feedback, etc. These reports will help in taking suitable steps for reducing customer churn to introduce new services.

Churn is the process of disconnecting the customers from one service provider and shift to another service provider. This can happen because of many reasons like insufficient customer service or not having competitive products or lack of competitive charges or it can be due to a normal reason of geographic relocation of the customer.

Reconciliation reports

These reports provide Revenue Assurance (RA) information to make sure that all the sources of revenue and expenses are under observation and there is no leakage of any sort of revenues. For example, revenue can be lost due to many reasons like leakage in network system or mediation or billing mistakes, demand for introducing new services quickly, etc.

Revenue assurance reports will help in identifying the leakage so that necessary actions can be taken.

Network Activity Reports

These reports will provide information for identifying the areas of network congestion to take corrective measures (rerouting or adding more resources) which can be achieved to overcome these problems.

Other Reports

Below is a list of a few other reports, which are required out of a Billing System

S. No.

Report Description

1

Revenue Classification reports summarize revenue information for a particular date range by credit class, customer details, price plan, charge type, etc.

2

Customer Details, Aged Receivables and Open Item reports that are offered mainly to help the collections chasing.

3

Daybook reports summarize the activities of the day and present general ledger information.

4

Product and Package reports give details of the products in a database and the packages available in a particular billing/rating catalogue.

5

Interconnect Agreement Accounting (IAA) reports that assist the reconciliation of outbound interconnect CDRs.

6

Total numbers of activation, termination, port-in or port-out on a daily basis.

7

Total number of accounts violating their credit limit on daily basis and how much revenue is going in credit breach.

8

Reports about the number of successfully rated events, posted internally and posted uncosted for a specific period of time.

9

Duplicate events report for a specific service or for all the services (i.e., voice, SMS, MMS, etc.)

10

Rejected events report for a specific service or for all the services (i.e., voice, SMS, MMS, etc.)

Automated vs Manual

There is a list of reports which are required on monthly, weekly, or daily basis. Therefore, such type of reports will be developed when they are not available and scheduled within the system. These will be sent to the end user's e-mail box without any manual intervention.

Different reports may be required from time to time based on some requirements; such type of reports cannot be imagined and developed in advance. Therefore, these reports will be developed and sent as per the demand from different users.

What is Next?

We will cover different types of billing; for example, retail, wholesale, MVNO, roaming, etc, in the next chapter.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Telecom Billing Topics