Report Module
The Report Module of iBasis Billing Portal enables the user
to View /Export Customer
Reports
including Callingcard Usage Reports,
CDRs Reports, Callingcard information, Orders Reports, Revenue Reports, Account
information Miscellaneous Reports
To use Report Module, click the Reports button of the Main
Menu Bar. The Report Menu appears as shown below:

Traffic by
Month
Purpose: To retrieve information on monthly
traffic(based on minutes).
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Month (mm/yyyy):
You have to follow “mm/yyyy” format to enter The Start Month.
- End
Month (mm/yyyy):
You have to follow “mm/yyyy” format to enter The End Month. If you do not specify the End
Month, by default, it is up to date.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box. By default, it is
“sort by Date”.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Number of Minutes | Date
Traffic by Date
Purpose: To retrieve information on daily
traffic(based on minutes).
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to date.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box. By default, it is
“sort by Date”.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Number of Minutes | Date
Traffic by Hour
Purpose: To retrieve information on hourly
traffic(based on minutes).
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy hh24):
You have to follow “mm/dd/yyyy hh24” format to enter The Start Date.
- End
Date (mm/dd/yyyy hh24):
You have to follow “mm/dd/yyyy hh24” format to enter The End Date. If you do not specify the End
Date, by default, it is up to date.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box. By default, it is
“sort by Date”.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Number of Minutes | Date
All CDRs
Purpose: To retrieve information on CDRs.
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End
Date (mm/dd/yyyy ):
You have to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to
date.
- HH24:
Hour with value 1-23. If you do
not specify the HH24, by default, it is 00.
- MI: Minute with value 1- 59. If you do not specify the MI, by default, it is 00 .
- SS: Second with value 1-59 If you do not specify the SS, by default, it is 00 .
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box. By default, it is
“sort by Date”.
- Select
Table: By default, voip_cdr is
selected.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data : Account|Batch_no|Date|Time|Calling_no|Called_no|Disconnect_cause|Min:Sec|Destination|Charge
Account CDRs
Purpose: To retrieve information on account
CDRs.
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Account No: If you do
not specify the Account No, that is all account.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End Date (mm/dd/yyyy ): You
have to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to
date.
- HH24:
Hour with value 1-23. If you do
not specify the HH24, by default, it is 00.
- MI: Minute with value 1- 59. If you do not specify the MI, by default, it is 00 .
- SS: Second with value 1-59 If you do not specify the SS, by default, it is 00 .
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box. By default, it is
“sort by Date”.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Account|Name|Date|Time|Calling_no|Called_no|Min:Sec|Destination|Charge
Lot
Purpose: To retrieve information on calling
cards.
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Activation
Start Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Activation Start
Date.
- Activation
End Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Activation End
Date. Expiration Start Date (mm/dd/yyyy): You have
to follow “mm/dd/yyyy” format to enter The Expiration Start Date.
- Expiration
End Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Expiration End
Date.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data : Porvider|Lot_No|Issue_Date|Cards_in_Lot|Card_Value|Exp_Date|Cards_in_Use|Cards_in_Use(%)
Calling card
Utilization
Purpose: To retrieve information on calling card utilization
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to date.
- HH24:
Hour with value 1-23. If you do
not specify the HH24, by default, it is 00.
- MI: Minute with value 1- 59. If you do not specify the MI, by default, it is 00 .
- SS: Second with value 1-59 If you do not specify the SS, by default, it is 00 .
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box. By default, it is
“sort by Date”.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
CallingCardDescription
| Minutes
Number of
Refreshes
Purpose: To retrieve information on the calling card recharge
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Auth_code | Number of refreshes | Amount
Revenue
Purpose: To retrieve the revenue information
.
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to date.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Num of Calls | Number of Minutes | Revenue
Revenue with
Destination Summary
Purpose: To retrieve the revenue (with
destination summary) information .
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to date.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Destination
| Num of Calls | Number of Minutes | Revenue
Denied Service
Purpose: To retrieve information on "Denied
Service"..
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to date.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box.
- Select
Table: By default, voip_cdr is
selected.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Account_id|Disconnect
Cause|Connection_id|Number of Minutes|Orig_pop_id|Date
Number of Service Denials
Purpose: To retrieve information on "Number of Service Denials"..
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End Date (mm/dd/yyyy): You have
to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to date.
- Sort
By: You can specify sort order
from the “Sort By” Selection Drop-Down box.
- Select
Table: By default, voip_cdr is
selected.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
Disconnect Cause | Number of times | Times(%)
Top 5 Terminations
Purpose:
To lookup the Top 5 Termination.
Input Data:
Enter the data on the request form as follows:
- ISP_NV Provider : Choose the ISP_NV Provider from the “ISP_NV Provide” Selection Drop-Down box.
- Start
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The Start Date.
- End
Date (mm/dd/yyyy):
You have to follow “mm/dd/yyyy” format to enter The End Date. If you do not specify the End
Date, by default, it is up to date.
After specifying
the parameters, click the View Report
button. The system displays a progress clock while you wait for the Report to
be fetched.
Output Data :
PROVIDER
| Destination | Number of Minutes