Red Spend & Usage Detail Report

The Red Bundle Spend & Usage Detail report includes only services using the Red tariff. It displays spend details to determine bundle costs vs. out of bundle costs and out of bundle roaming costs to allow you a complete view of your device fleet and mobile applications using Vodafone Red.

To view the Red Spend & Usage Detail Report

  1. From the VTR menu, choose Reporting.
  2. On the Reporting page, under Red - Worry Free Roaming Reporting, click the Run button on the Red Spend & Usage Detail Report tile.
  3. On the report filters page that appears, select criteria to narrow the result set.
    4. 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. By default, the date range is two months.

    • 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: The name of the person in charge of this service. Type as much of the first and or last name as you know. The results will be filtered to just those matching names. Make sure you choose the is equal to/is in 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 any 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 Red Spend & Usage Detail data, as described below:

    5. 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.

    Sub-account: Child account of the account associated with the service number. This account typically does not exist on its own in VTM; rather, it exists in relationship to the master account only.

    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.

    Service Number: The unique number to identify the service.

    Service Owner:  The owner assigned to the service.

    Employee ID: The Employee ID associated to a service.

    Bundle: The bundle tier (Tariff) applied for the billing period.

    Invoice label: A text description of the charge.

    Roaming country: The country in which the roaming charges occurred.

    Zone: The Zone used for the bundle pricing. Zones are based on regions.

    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.

    Recurring Units: The number of recurring charges.

    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.

    Conferencing charge (ex. Tax):  The total number of minutes for all charges identified as Conference calls on the invoice using the VGE codes, excluding tax charges.

    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.

    Proration Ratio: Ratio that is applied to the full monthly recurring charges for connections that are activated or terminated throughout the month. This ensures that the users only pay the amount that corresponds to the number of active days in that month.

    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.

    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.
Depending on your configuration, certain data may be masked to ensure privacy. For more information, see Understanding call masking.
If your administrator has enabled data slicing, then your reports will also be restricted to only those accounts to which you have been given access.