Lumen help
The Request Custom Reports [TSV] functionality allows users to generate downloaded text files of the subscribed invoice Bill Reports. These Bill Reports include:
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].
To request custom reports on your invoice:
When the Custom Report Request is ready, an email will be sent to the email address on your user profile.
The zip file will contain text files of the subscribed invoice Bill Reports:
Note that the zip file opens in Temporary Internet Files. Please ensure that you save all the text files to your computer, such as on the Desktop, so you can browse to them easily from Excel, as shown in following steps.
Example of Usage Summary reports in Notepad:
The screen will now appear as shown below, note the change to the Data preview (the tildes [~] have now become columns).
You can now click the Finish button, you do not need to click Next and proceed to step 3.
The imported text file will now display in Excel. You can auto size the columns and proceed to work with the data.
Try one of these popular searches: