Menu

Lumen help

Requesting custom reports on your invoice

As a wholesale customer, you can request text files (in .tsv format—tilde delimited) of your subscribed invoice bill reports that you can download open using Excel. The 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 calls
  • top city, total usage
  • usage summary

Once you submit a request, Control Center emails you using the address in your profile when the report is available for you to download (usually within 24 hours). Depending on the long distance service, the usage summary report may be created as several text files (up to seven).

To request custom reports on your invoice:

  1. Click Billing, then click Invoices.
Invoices
  1. Once you find the bill/invoice you want, click the blue arrow () on the right side of the line for the account.

    Control Center shows details for the account such as billing address, due date, last payment (and date received), delivery method, etc.
  1. To view the invoice, click Online Invoice.
Online invoice
  1. Click the Request Custom Reports [TSV] link.
  1. Click Submit Request.

    The Request Status field changes to Submitted, and the Request Creation Date field populates.
  1. Click Return to Request List. (You can also click Billing, then click Invoice PDFs & Data Downloads.)

    Control Center lists the reports you requested. When the report is ready, Control Center emails you using the address in your user profile.
Invoice PDFs & Data Downloads
  1. Click Billing, then click Invoice PDFs and Data Downloads.
Invoice PDFs & Data Downloads (showing TSV file)
  1. In the Status column, click the linked file name and save the file to your computer. The .zip file contains text files of the subscribed invoice bill reports. (If you requested files for multiple accounts, use the .zip file name to locate the file you want: WCSV.enterpriseID.username.reportID.accountID.YYYYMMDD.zip.)
  1. Unzip the .zip file to extract the billing reports.
  1. Open the files in Excel and use the import wizard to convert the .tsv into a spreadsheet:

    1. Open Excel, then click File, then Open.

    2. Change the type of files you can see to see all files.

    3. Browse to one of the billing report files, then click Open.

      Excel opens the Text Import Wizard to format the text file into a spreadsheet.

    4. Click the Delimited radio button, then click Next.

    5. Select the Other checkbox and type a tilde (~) in the field, then click Next.

      Excel update the preview pane to show the data formatted as a spreadsheet.

    6. If everything looks ok in the preview, click Finish.

      Excel opens the text file as a spreadsheet so you can work with the report data.