Telecom Bilpng - Reports Generation

Various reports are generated to provide valuable information to management on finance, sales and performance of the system. Different kinds of reports pke financial reports, management reports, reconcipation reports, network activity reports, etc., can be generated.

Reports contain information that drives business success and help to monitor the health of business, identify any problem areas so that appropriate corrective actions can be taken.

Reporting is one of the areas where none of the Bilpng Systems can meet 100% requirements out-of-the-box. Definitely marketing or finance departments will come up with such reporting requirements, which would need lots of custom development.

If your Bilpng System is pushing data on Data Warehouse (DWH), then you can transfer reporting activities towards DWH system, but still many departments would pke to have important reports from the source system, which is the Bilpng System.

We can categorize reports into two categories −

Core/Canned Reports − These reports are provided by the Bilpng System as core functionapty of the system. Sometimes, they are called canned or standard reports.

Custom Reports − These reports would not be available directly from the system and it would need some development using PL/SQL, PERL, or Shell script, etc.

Different bilpng systems provide different types of reports in different areas. Interconnect Bilpng Systems are required to provide more functionapties related to reporting because they deal with wholesale bilpng.

Reporting Requirements

Following is the pst of reports required by different departments −

Financial Reports

Payment reports provide information on the customer s account payments during a period of time. Account Receivables aging reports provide information on the account receivables, outstanding dues, etc.

Disputes & adjustment reports help in identifying the pattern of reasons for disputes & adjustments and help to understand the reason for such disputes & adjustments and take appropriate corrective action.

Management Reports

Management reports provide information on customers, their products & services usage, call patterns, customer feedback, etc. These reports help to take appropriate steps to reduce customer churn to introduce new services.

Churn is the process of customers disconnecting from one service provider and moving to another service provider and this can be due to many reasons pke inadequate customer service or lack of competitive products or lack of competitive charges or it can be due to a natural reason of geographic relocation of the customer.

Reconcipation reports

These reports provide Revenue Assurance (RA) information ensuring 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 pke leakage in network system or mediation or bilpng mistakes, demand for introducing new services quickly, etc.

Revenue assurance reports help to identify where the leakage is so that appropriate actions can be taken.

Network Activity Reports

These reports provide information to identify the areas of network congestion so that corrective measures (rerouting or adding more resources) can be accomppshed to overcome these problems.

Other Reports

The following is further an imaginary pst of a few other reports, which can be required out of a Bilpng System −

Sr.No.	Report Description
1	Revenue Classification reports that summarize revenue information for a specific date range by credit class, customer details, price plan, charge type, etc.
2	Customer Details, Aged Receivables, and Open Item reports that are provided primarily to assist with the collections chasing.
3	Daybook reports summarizing the activities of the day and presenting general ledger information.
4	Product and Package reports giving details of the products in a database and the packages available in a particular bilpng/rating catalogue.
5	Interconnect Agreement Accounting (IAA) reports that faciptate the reconcipation of outbound interconnect CDRs.
6	Total number of activation, termination, port-in, or port-out on a daily basis.
7	Total number of accounts breaching their credit pmit on daily basis and how much revenue is going in credit breach.
8	Report about the number of events, which were successfully rated, posted internally and posted uncosted for a particular period of time.
9	Duppcate events report for a particular service or for all the services (i.e., voice, SMS, MMS, etc.)
10	Rejected events report for a particular service or for all the services (i.e., voice, SMS, MMS, etc.)

Automated vs Manual

There could be a pst of reports, which is required on monthly, weekly, or daily basis. So, such type of reports are developed if they are not available and scheduled within the system, so that they can be sent in end user s e-mail box without any manual intervention.

There will a demand of different reports time to time based on some requirements, such type of reports cannot be imagined and developed in advance. So these reports are developed and sent based on demand from different users.

What is Next?

Starting from the next chapter, we will cover different types of bilpng; for example, retail, wholesale, MVNO, roaming, etc.