Spend & Usage Detail Report

This detail report returns billing information by region, country, account number, invoice number and invoice dates; however, it drills down into bill detail information at the service number level. The Spend & Usage Detail report provides pre-defined filters on key data elements allowing for more accurate data analysis.

The report is pre-filtered for services that record charges in calls, data, messages, recurring, non-recurring, hardware, adjustments, credits, or other.

To view the Spend & Usage Detail Report

1. From the VTR menu, choose Reporting.
2. On the Reporting page, under Spend & Usage Detail Reporting, click the Run button on the Spend & Usage Detail Report tile.
3. On the report filters page that appears, select criteria to narrow the result set.
It is recommended that you set filters on the report, as VTR supports a maximum of 350,000 rows.

Invoice start date and Invoice end date are required filters: you must set this range of dates to run the report. By default, the date range is one month.

Select Filters

• Invoice start date (Between): Choose the range of dates on which you want to report. To view all invoices, choose a very early start date. To view all invoices after your start date, choose a future date. Note that this will increase processing time.
• Region: Filters the results to a specific region. Drop down and select the region from the list. Make sure you choose the is equal to/is in operator.
• Country: Filters the results to a specific country in the region. Drop down and select the country from the list. Make sure you choose the is equal to/is in operator.
• Carrier: Filters the results to those services provided by the selected carrier. Drop down and select the carrier from the list. Make sure you choose the is equal to/is in operator.
• Account number: Filters the results to only those services associated with a selected account. Type as much of the account number as you know. The results will be filtered to just those account numbers containing those matching digits. Note that if data slicing is enabled, the list is always filtered to only those accounts for which you have permission to access. Make sure you choose the is equal to/is in operator.
• Invoice number: Filters the results to specific invoices. Type as much of the invoice number as you know, and the results will be filtered to just those invoice numbers containing those matching digits. Make sure you choose the contains any operator.
• Service owner: Filters the results to service owners with the name you type. You may type a specific name, such as Maria Louisa Rivera, and see only that user's records, or you may type a partial name such as J and see all service owners with J in any place in their name. Make sure you choose the contains any operator.
• Employee ID: Filters the results to employee id's that contain the characters you enter. By default, all employee id's will be included.
• Service number: Filters the results to service numbers that contain the digits you type here. Make sure you choose the contains operator.
• Currency code: Choose the currency in which you want amounts displayed. By default, the currency is the same as the one specified in your profile.

For more options on filters, see Report filter operators and advanced options.

4. Review the Spend & Usage Detail Data, as described below:
Spend & Usage Detail Data

Region: The region associated with the location of an account.  

Country: The country associated with the location of an account.

Carrier: The service provider of the communications services.

Company:  The name of the company to which the telecom services are being supplied.

Account Number: The ID of the account to which the services belong.

Account Name 1: The primary account name associated with the account. For central billing accounts, it represents the legal entity name, as referenced on the invoice. For all the other types of accounts, it represents the global account name.

Invoice Number:  The identifier of the bill for the service.

Invoice Issue Date:  The date when the bill was issued.

Bill year-month: Year and month of the bill date.

Invoice Start Date:  The date on which the billing cycle starts.

Invoice End Date:  The date on which the billing cycle ends.

Currency:  The currency in which the report values appear.

Owner name: The owner assigned to the service.

Employee ID: The Employee ID associated to a service.

Cost centre n - %:  The cost centre and percentage allocation identified on the service. This is used for charge allocation. Up to 4 cost centres are supported.

Service Number: The unique number to identify the service.

Custom Attribute 1-4: Primarily populated by the Gemini feed, but can be edited, if the VCO (UK Only) on the account is false. Otherwise, these fields will be disabled from editing.

Number of Calls:  Count of all charges identified as Calls. Data is aggregated by Roaming country and Zone so this number represents the number of calls rolled up into a single row.

Voice National (mins):  The total minutes for all charges identified as National calls on the invoice using the VGE codes.

Voice International (mins):  The total minutes for all charges identified as International calls on the invoice using the VGE codes.

Voice roaming (mins):  The total minutes for all charges identified as Roaming calls on the invoice using the VGE codes. Calls include those made while overseas.

Voice Premium (mins):  The total minutes for all charges identified as Premium calls on the invoice using the VGE codes. Premium calls includes calls made to and from premium numbers, such as competitions and voting services.

Conferencing (mins):  The total minutes for all charges identified as Conference calls on the invoice using the VGE codes.

Data National (GB):  The total amount of data in gigabytes for all charges identified as Data National on the invoice. Data usage includes charges such as internet access, use of mobile phone and modem (WAP excluded).

Data Roaming (GB):  The total amount of data in gigabytes for all charges identified as Data Roaming on the invoice. Roaming includes data usage while overseas.

Data Premium (GB):  The total amount of data in gigabytes for all charges identified as Data Premium on the invoice using the VGE codes. This includes charges that apply to data sent and received from premium numbers, such as those for competitions and voting services.

Messaging National: The total amount of data for all charges identified as messaging (SMS and MMS) national on the invoice using the VGE codes.

Messaging International:  The total amount of data for all charges identified as messaging (SMS and MMS) International on the invoice using the VGE codes.

Messaging roaming:  The total amount of data in gigabytes for all charges identified as messaging (SMS and MMS) roaming on the invoice using the VGE codes. This includes messages sent and received while overseas.

Messaging Premium: The total number of messages (SMS and MMS) premium on the invoice using the VGE codes. Premium charges that apply to messages sent and received from premium numbers, such as competitions and voting services.

Voice national charge (ex. Tax):  The total sum, excluding tax, for charges identified as National usage on the invoice using the VGE codes

Voice international charge (ex. Tax):  The charges identified as International usage on the invoice using the VGE codes

Voice roaming charge (ex. Tax):  The charges identified as Roaming usage on the invoice using the VGE codes. Roaming includes voice usage while overseas.

Voice premium charge (ex. Tax):  The charges identified as Premium usage on the invoice using the VGE codes. Premium includes calls made to and from premium numbers, such as competitions and voting services.

Data national (ex tax):  The total sum, excluding tax, of charges identified as data national on the invoice using the VGE codes.

Data roaming charge (ex. Tax):  The total sum, excluding tax, of charges identified as data roaming on the invoice using the VGE codes. Roaming charges include data usage while overseas.

Data premium charge (ex. Tax):  The total sum, excluding tax, of charges identified as data premium on the invoice using the VGE codes. Premium charges apply to data sent to and from premium numbers, which include things such as competitions and voting services.

Messaging national charge (ex. Tax):  The total sum, excluding tax, of charges identified as messaging national (SMS and MMS) on the invoice using the VGE codes

Messaging international charge (ex. Tax):  The total sum, excluding tax, of charges identified as messaging international (SMS and MMS) on the invoice using the VGE codes

Messaging roaming charge (ex. Tax):  The total sum, excluding tax, of charges identified as messaging roaming on the invoice using the VGE codes. This includes messages (SMS and MMS) sent and received while overseas.

Messaging premium charge (ex. Tax):  The total sum, excluding tax, of charges identified as messaging premium on the invoice using the VGE codes. Premium charges apply to messages (SMS and MMS) sent and received from premium numbers, such as competitions and voting services.

Usage Charge (ex. Tax):  The total sum, excluding tax, of charges identified as usage charges on the invoice. This charge includes daily roaming fees.

Recurring Charge (ex. Tax):  The number of recurring charges identified as recurring or automatic charges on the invoice. An example is a subscription fee or paper bill fee. This charge includes monthly roaming fees.

Non-recurring Charge (ex. Tax):  The total sum, excluding tax, of charges identified as non-recurring or one-time charges on the invoice using the VGE codes, including hardware purchases.

Adjustment (ex. Tax):  The total sum, excluding tax, of charges identified as adjustments on the invoice. An example of an adjustment is a one-off adjustment to the charges on an earlier bill, such as billing corrections.

Credit (ex. Tax):  The total sum, excluding tax, of charges identified as credits on the invoice.

Total (ex. Tax):  The sum of all charges, excluding tax, on the invoice.


User ID:  An internal identifier used to manage data visibility (slicing) rules. This column is hidden by default, and you can ignore it.

5. Modify the report page layout in real time to see the data in the sort order and column order you want.
6. (Optional) Export the report. See Export a report.