Download individual invoice reports

Invoice data can be downloaded in several formats, such as XLSX and CSV, as well as in various views for the type of data you require.

To generate and download a CDR zip file for each regular invoice or bundled Hardware Billing PO invoice in CSV format, select Download CDR zip file from the More button drop-down. This drop-down menu option is not available if the CDR zip file is not available.

A bundled Hardware Billing PO invoice is created when there are multiple Hardware Billing invoices for the same account number and the same Bill cycle start date. For each of the calculated fields, the value will represent the total values across all the invoices included in the bundled PO, and for each of the non-calculated fields, the values in the report will follow specific business rules:

  • Min of all bundled PO Invoices - Issue date, Invoice start date, Creation date
  • Max of all bundled PO Invoices - Invoice end date, Import date, Payment date,

The CDR report will be based on the invoice's local currency and call masking rules will apply. The CDR file will be purged when the corresponding invoice data is purged based on your customer configuration setting for Months to retain billing data.

The default fields for regular and Hardware Billing invoices include the following:

  • USER_ID: User ID associated with the user of the service. Not available for DLM Product Type.
  • SERVICE_ID_CTN: Service Number. Masked value possible.
  • CHILD_ACCOUNT_NUMBER: The non-billable account ID provided by the Carrier. Hidden if not available from the central billing system.
  • USAGE_DATE: Usage Date.
  • INVOICE_LABEL: Invoice Label.
  • USAGE_TYPE_CLASSIFICATION: Usage Type Classification. Not available for DLM Product Type.
  • USAGE_TYPE_CLASSIFICATION_DET: Charge Type Classification Detail. Not available for DLM Product Type.
  • USAGE_TYPE_CODE: Usage: Type Code. Not available for DLM Product Type.
  • CALLING_NUMBER: Calling number. Masked value possible. Not available for DLM Product Type.
  • CALLED_NUMBER: Called number. Either masked or unmasked, depending on the customer's request towards the carrier. Not available for DLM Product Type.
  • SOURCE_COUNTRY: Source Country. Not available for DLM Product Type.
  • TARGET_COUNTRY: Target Country. Not available for DLM Product Type.
  • METRIC: Metric: KB, SEC or UNITS. Not available for DLM Product Type.
  • UNITS: Units. Not available for DLM Product Type.
  • CHARGEABLE: Is this item line chargeable?
  • VAT_RATE: Tax Rate
  • NET_CHARGE: Charge excluding tax.
  • VAT: Tax.
  • TOTAL: Total including tax.
  • CURRENCY: The currency type in which the charge was calculated. Visible only if the account Product type is DLM.
  • CHARGE_START_DATE: Charge start date.
  • CHARGE_END_DATE: Charge end date.
  • PRODUCT_CODE: Product code.
  • MT_MO_INDICATOR: MT = Mobile Terminate call, MO = Mobile Originate call, FO = Fixed Line Originate call, NU = Non usage. Not available for DLM Product Type.
  • USAGE_TIME: Usage time. Not available for DLM Product Type.
  • VCO columns:
    • MAX_SUBSCRIBER_NAME: Maximum value of owner first name and last name from services for the USER_ID. Visible only if any of the 4 custom attributes or the price plan code or description fields have a value for any of the services in the invoice. Not available for DLM Product Type.
    • MAX_ALLOCATION_CODE_1: Maximum value of custom attribute 1 from services for the USER_ID. Visible only if any of the 4 custom attributes or the price plan code or description fields have a value for any of the services in the invoice.
    • MAX_ALLOCATION_CODE_2: Maximum value of custom attribute 2 from services for the USER_ID. Visible only if any of the 4 custom attributes or the price plan code or description fields have a value for any of the services in the invoice.
    • MAX_ALLOCATION_CODE_3: Maximum value of custom attribute 3 from services for the USER_ID. Visible only if any of the 4 custom attributes or the price plan code or description fields have a value for any of the services in the invoice and if the Display allocation codes 3/4 column has been set to Yes in the Accounts section.
    • MAX_ALLOCATION_CODE_4: Maximum value of custom attribute 4 from services for the USER_ID. Only visible if any of the 4 custom attributes or the price plan code or description fields have a value for any of the services in the invoice and if the Display allocation codes 3/4 column has been set to Yes in the Accounts section.
  • ORDER_NUMBER: Order number for specific hardware. Visible only for Hardware billing invoices
  • PRODUCT_NUMBER: Product number of specific hardware. Visible only for Hardware billing invoices.
  • PURCHASE_ORDER_NUMBER: Purchase Order number for specific hardware transaction. Visible only for Hardware billing invoices.

Fields visible only if the account Product type is DLM:

  • DLM ID: Unique asset ID for a device/accessory.
  • USER NAME: User name or user email.
  • END _USER_ID: Unique identifier of the end user.
  • CHARGE_TYPE: Charge type.
  • CHARGE_TYPE_CLASSIFICATION: Charge type classification.
  • BUSINESS_UNIT: The contract ID.
  • COST_CENTER_1: The Subscriber Cost Centre.
  • IMEI: IMEI Number of device.
  • CONTRACT_START_DATE: The date on which the contract starts.
  • CONTRACT_END_DATE: The date when the contract ends.
  • CHARGE_TYPE_CL: Charge type code classification.

The default fields for IoT invoices include the following:

  • Transaction ID: The IoT event's transaction ID.
  • IMSI: Uniquely identifies a SIM.
  • Usage Start Date Time: The start date of the reported usage.
  • Usage End Date Time: The end date of the reported usage.
  • Usage Type: Code of the usage type used describe the specific IoT event.
  • Called Number: The service number to which a call was placed as identified on the report.
  • Volume: The actual usage volume.
  • Rounded Volume: The rounded usage volume.
  • Metric: The type of the usage, expressed in Bytes (data), Units (SMS and API), or Seconds (voice).
  • Event Charge: The reported event charge.
  • Event Type: Type indicator of usage events.
  • Serving OpCo Code: Network group derivation identifier, mandatory when network group based charging is required.
  • Network Tier Code: Network tier code.
  • Network Tier Name: Describes the network group or tier for the serving network.
  • Country: Called or calling country.
  • Tariff Name: GDSP Tariff name.
  • CSP Name: Customer Service Profile Name.
  • Rate Profile: The reported rate profile.
  • IP Address: The identifying number that is associated with a specific computer or computer network.

To download the Invoice Report in XLSX format, select Download Invoice Report from the More button drop-down. The report will be based on the invoice's local currency. The Invoice Report will be purged when the corresponding invoice is purged base on your customer configuration setting for Months to retain billing data.

The Invoice Report is not available for IoT invoices.

The Invoice Report will contain three tabs:

  • Customer Name: The Customer for the invoice.
  • Invoice Month: Based on the Invoice Start Date.
  • Account number: The ID of the account to which the services belong.
  • Invoice Address: Address 1 + Address 2 + City + Postcode + Country.
  • Invoice Number: The identifier of the bill for the service.
  • Invoice Issue Date: The date when the bill was issued.
  • Invoice Start Date: The date on which the billing cycle starts.
  • Invoice End Date: The date on which the billing cycle ends.
  • Invoice Currency: The original currency in which the invoice was generated.
  • Number of CTNs: Count of all unique customer telephone numbers on the invoice. Not available for DLM Product Type.
  • 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. Not available for DLM Product Type.
  • Voice Minutes: Sum of duration of all voice calls in minutes. Not available for DLM Product Type.
  • National Data (MB): Sum of volume of all data usages excluding roaming (national and international) in megabytes. Not available for DLM Product Type.
  • Roaming Data (MB): Sum of volume of roaming (national and international) only data usages in megabytes. Not available for DLM Product Type.
  • Usage Charge ex. Tax: Sum of all charges except recurring charges and credits, including daily roaming charges (includes daily roaming fees). Not available for DLM Product Type.
  • Recurring Charge ex. Tax: Sum of all recurring charges, including LTE Access charges, content services, subscribed services and monthly roaming charges, including recurring DLM Charges (includes monthly roaming fees).
  • Other Non-Recurring Charges ex. Tax: Sum of all DLM one-off charges. This column only present for DLM accounts.
  • Device Fee ex. Tax: Sum of all Device fee recurring charges.
  • Credit ex. Tax: Sum of all Credits, Discounts and Refunds.
  • Average Rate per User ex. Tax: Sum of all Invoice Average Revenue Per User ex. VAT.
  • Adjustments ex. Tax: sum of all Adjustments.
  • Total Taxable: Total ex. Tax where Tax rate is not 0 from Billing system, minus Tax Other value.
  • Total Non-Taxable: Total ex. Tax where Tax rate is 0 from Billing system, minus Tax Other value.
  • Total ex. Tax: Total ex. Tax from Billing System, minus Tax Other value.
  • Tax: Total Tax on Invoice from Billing System.
  • Tax Other: Sum of all recurring tax charges, e.g. Italian government tax. This column only present if the invoice total value is 0.
  • Total: Total from Billing System.
  • Company Name: The Company for the invoice.
  • Account Number: The ID of the account to which the services belong.
  • Child Account Number: The non-billable account ID provided by the Carrier. Only included in the report if different from the account number.
  • Invoice Number: The identifier of the bill for the service.
  • Invoice Issue Date: The date when the bill was issued.
  • Invoice Start Date: The date on which the billing cycle starts.
  • Invoice End Date: The date on which the billing cycle ends.
  • User Id: User ID associated with the user of the service. Not available for DLM Product Type.
  • DLM ID (only available for DLM Product Type): Unique asset ID for a device/ accessory.
  • User Name (only available for DLM Product Type): User name or user email.
  • End User ID (only available for DLM Product Type): Unique identifier of the end user.
  • Cost Centre 1(only available for DLM Product Type): The Subscriber Cost Centre.
  • VCO columns:
    • Max User Ref): Maximum value of owner first name and last name from services for the USER_ID, only shown if any of the 4 custom attributes (aka. Allocation Codes) or the price plan code and description fields have a value for any of the services in the invoice.
    • Max Allocation Code 1: Maximum value of custom attribute 1 from services for the USER_ID, only shown if any of the 4 custom attributes (aka. Allocation Codes) or the price plan code and description fields have a value for any of the services in the invoice.
    • Max Allocation Code 2: Maximum value of custom attribute 2 from services for the USER_ID, only shown if any of the 4 custom attributes (aka. Allocation Codes) or the price plan code and description fields have a value for any of the services in the invoice.
    • Max Allocation Code 3: Maximum value of custom attribute 3 from services for the USER_ID. Only visible if any of the 4 custom attributes or the price plan code or description fields have a value for any of the services in the invoice and if the Display allocation codes 3/4 column has been set to Yes in the Accounts section.
    • Max Allocation Code 4: Maximum value of custom attribute 4 from services for the USER_ID. Only visible if any of the 4 custom attributes or the price plan code or description fields have a value for any of the services in the invoice and if the Display allocation codes 3/4 column has been set to Yes in the Accounts section.
  • Red Bundle Code: Self-optimised Red bundle code. This column present only if there is Red Bundle information for the invoice for any account for the customer. Not available for DLM Product Type.
  • Red Bundle: Self-optimised Red bundle description. If blank, this column will not appear. Not available for DLM Product Type.
  • Number of CTNs: Count of all unique customer telephone numbers on the invoice. Not available for DLM Product Type.
  • 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. Not available for DLM Product Type.
  • Voice National (Min.): Sum of duration of all national calls in minutes. Not available for DLM Product Type.
  • Voice International (Min.): Sum of duration of all international calls in minutes. Not available for DLM Product Type.
  • Voice Roaming (Min.): Sum of duration of all roaming calls in minutes. Not available for DLM Product Type.
  • Voice Premium (Min.): Sum of duration of all premium calls in minutes. Not available for DLM Product Type.
  • Data National (MB): Sum of volume of all national data usage in megabytes. Not available for DLM Product Type.
  • Data Roaming (MB): Sum of volume of all roaming data usage in megabytes. Not available for DLM Product Type.
  • Data Premium (MB): Sum of volume of all premium data usage in megabytes. Not available for DLM Product Type.
  • Messaging National (Min.): Distinct count of national SMS and MMS CDRs. Not available for DLM Product Type.
  • Messaging International (Min.): Distinct count of international SMS and MMS CDRs. Not available for DLM Product Type.
  • Messaging Roaming (Min.): Distinct count of roaming SMS and MMS CDRs. Not available for DLM Product Type.
  • Messaging Premium (Min.): Distinct count of premium SMS and MMS CDRs. Not available for DLM Product Type.
  • Voice National Charge ex. Tax: Sum of charge ex. Tax of all national calls in minutes. Not available for DLM Product Type.
  • Voice International Charge ex. Tax: Sum of charge ex. Tax of all international calls in minutes. Not available for DLM Product Type.
  • Voice Roaming Charge ex. Tax: Sum of charge ex. Tax of all roaming calls in minutes. Not available for DLM Product Type.
  • Voice Premium Charge ex. Tax: Sum of charge ex. Tax of all premium calls in minutes. Not available for DLM Product Type.
  • Data National Charge ex. Tax: Sum of charge ex. Tax of all national data usage in megabytes. Not available for DLM Product Type.
  • Data Roaming Charge ex. Tax: Sum of charge ex. Tax of all roaming data usage in megabytes. Not available for DLM Product Type.
  • Data Premium Charge ex. Tax: Sum of charge ex. Tax of all premium data usage in megabytes. Not available for DLM Product Type.
  • Messaging National Charge ex. Tax: Sum of charge ex. Tax of all national SMS and MMS CDRs. Not available for DLM Product Type.
  • Messaging International Charge ex. Tax: Sum of charge ex. Tax of all international SMS and MMS CDRs. Not available for DLM Product Type.
  • Messaging Roaming Charge ex. Tax: Sum of charge ex. Tax of all roaming SMS and MMS CDRs. Not available for DLM Product Type.
  • Messaging Premium Charge ex. Tax: Sum of charge ex. Tax of all premium SMS and MMS CDRs. Not available for DLM Product Type.
  • Usage Charge ex. Tax: Sum of all charges except recurring charges and credits, including daily roaming charges. Not available for DLM Product Type.
  • Recurring Charge ex. Tax: Sum of all recurring charges, including LTE Access charges, content services, subscribed services and monthly roaming charges, including recurring DLM Charges.
  • Other Non-Recurring Charges ex. Tax: Sum of all DLM one-off charges. This column only present for DLM accounts.
  • Device Fee ex. Tax: Sum of all Device fee recurring charges.
  • Daily Roaming Fee ex. Tax: Sum of all device fee recurring charges. Not available for DLM Product Type.
  • Monthly Roaming Fee ex. Tax: Sum of all monthly roaming fees. Not available for DLM Product Type.
  • Adjustments ex. Tax: sum of all Adjustments. Not available for DLM Product Type.
  • Credit ex. Tax: Sum of all Credits, Discounts and Refunds.
  • Total Taxable: Total ex. Tax where Tax rate is not 0 from Billing system, minus Tax Other value.
  • Total Non-Taxable: Total ex. Tax where Tax rate is 0 from Billing system, minus Tax Other value.
  • Total ex. Tax: Total ex. Tax from Billing System, minus Tax Other value.
  • Total Tax: Total Tax on Invoice from Billing System.
  • Tax Other: Sum of all recurring tax charges, e.g. Italian government tax. This column only present if the invoice total value is 0.
  • Total: Total from Billing System.
The CTNs Tab is not available for DLM Product Type.
  • Company Name: The Company for the invoice.
  • Account Number: The ID of the account to which the services belong.
  • Child Account Number: The non-billable account ID provided by the Carrier. Only included in the report if different from the account number.
  • Invoice Number: The identifier of the bill for the service.
  • Invoice Issue Date: The date when the bill was issued.
  • Invoice Start Date: The date on which the billing cycle starts.
  • Invoice End Date: The date on which the billing cycle ends.
  • User Id: User ID associated with the user of the service.
  • VCO columns:
    • User Ref: Value of owner first name and last name from services for the USER_ID, only shown if any of the 4 custom attributes (aka. Allocation Codes) or the price plan code and description fields have a value for any of the services in the invoice.
    • Allocation Code 1: Allocation / attribute used to provide grouping of services for UK provisioning. If blank, these columns will not appear.
    • Allocation Code 2: Allocation / attribute used to provide grouping of services for UK provisioning. If blank, these columns will not appear.
    • Allocation Code 3: Allocation / attribute used to provide grouping of services for UK provisioning. If blank, these columns will not appear.
    • Allocation Code 4: Allocation / attribute used to provide grouping of services for UK provisioning. If blank, these columns will not appear.
    • Red Bundle Code/Price Plan: Self-optimised Red bundle code or UK non-Red users price plan code. If blank, these columns will not appear.
    • Red Bundle/Price Plan Description: Self-optimised Red bundle description or UK non-Red users price plan description. If blank, these columns will not appear.
  • CTN: The unique customer telephone numbers on the invoice. This column may be masked.
  • 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 (Min.): Sum of duration of all national calls in minutes.
  • Voice International (Min.): Sum of duration of all international calls in minutes.
  • Voice Roaming (Min.): Sum of duration of all roaming calls in minutes.
  • Voice Premium (Min.): Sum of duration of all premium calls in minutes.
  • Data National (MB): Sum of volume of all national data usage in megabytes.
  • Data Roaming (MB): Sum of volume of all roaming data usage in megabytes.
  • Data Premium (MB): Sum of volume of all premium data usage in megabytes.
  • Messaging National: Distinct count of national SMS and MMS CDRs.
  • Messaging International: Distinct count of international SMS and MMS CDRs.
  • Messaging Roaming: Distinct count of roaming SMS and MMS CDRs.
  • Messaging Premium: Distinct count of premium SMS and MMS CDRs.