The Request Custom Reports [TSV] functionality allows users to generate downloaded text files of the subscribed invoice Bill Reports. These Bill Reports include:
- Calls by Area Code
- Calls by Lata
- High Call Volume
- Long Duration Calls
- Project Code Summary
- Recurring Charges Summary
- Short Call Duration
- Toll Free Feature Charges Summary
- Toll Free Unanswered
- Top City, Total Usage
- Usage Summary
The Bill Report text files are grouped in a zip file, and are delimited files using tilde (~) as a delimiter. The text files can also be opened in Excel.
Note: Depending on the long distance product, the Usage Summary Bill Report may generate several different formatted text files (0-7).
Once you submit a request, an email will be sent to you within 24 hours letting you know the Data Download copy of Custom Reports is available. Once it is available, you will click on the Bill PDFs/Data Downloads link/tab (Control Center > Billing) and click on the appropriate zip file.
Follow the steps in the procedure below to request (and open in Excel) the Bill Reports by using Request Custom Reports [TSV].