I-Billing filters

I-Billing is a Business Account feature offered by T-Mobile to help you get information on your charges and call history. With I-Billing, you can save time and gain valuable insight into your wireless business account by viewing customized usage reports and statements or simply reviewing and paying your bill online. For more information, read the I-Billing FAQs.

 

This page contains a list of the most common I-Billing filters, based on the most common business usage types.

  • The filters for night and weekend usage are based on business plans, not consumer plans. Business plans rate a nighttime T-Mobile to T-Mobile call as T-Mobile to T-Mobile, which consumer plans do not.
  • Before creating a report from I-Billing, make sure the filters in the I-Billing account reflect the information listed below.

 

 

Airtime and Toll

 

FilterActions
Domestic Directory AssistanceDestination Number is equal to 411 and Roaming Servicing Area contains USA
All Directory AssistanceDestination City contains Dir Asst or Destination Number is equal to 411
Charged Directory Assistance FLYERSDestination Number    contains    Dir Asst

And    Cost    is greater than    0

Or    Destination Number    is equal to    411

And    Cost    is greater than    0

Toll ChargesToll Charges is greater than 0.00

And  Bill Category    does not contain      Data

And  Bill Category    does not contain      Roaming

And  Bill Category    does not contain      Premium

And  Bill Category    does not contain      Messaging

Airtime Charges Excluding Voice and Data OverageRun this, then subtract these dollar amounts from the Airtime Charges column in the SSR to get true voice and data airtime charges, as seen on the bill.

 

Roaming Servicing Area    does not contain    Canada

And    Bill Category    contains    messaging

Or    Bill Category    contains    Premium

Or    Bill Category    contains    T-Mobile Purchases

Or    Bill Category    contains    Data Service Roaming

Or    Bill Category    contains    Data Service Charges

Airtime Charges Excluding Voice OverageRun this, then subtract these dollar amounts from the Airtime Charges column in the SSR to get true voice airtime charges, as seen on the bill.

 

Roaming Servicing Area    does not contain    Canada

And    Bill Category    contains    messaging

Or    Bill Category    contains    Premium

Or    Bill Category    contains    T-Mobile Purchases

Or    Bill Category    contains    Data Service Roaming

 

 

Canada and Mexico

 

FilterActions
Canada and Mexico
(this includes ALL usage,
including calls made in the US
and calls made to a US number)
Roaming Servicing Area    contains    Mexico

Or    Roaming Servicing Area    contains    Canada

Or    Roaming Servicing Area    contains    (USA)

And    Call Destination    contains    ,

And    Call Direction    is equal to    Outgoing

Canada and Mexico Charges
(will exclude usage

that was not billed extra)

Roaming Servicing Area    contains    Mexico

And    Cost    is greater than    0

Or    Roaming Service Area    contains    Canada

And    Cost    is greater than    0

Or    Roaming Service Area    contains    (USA)

And    Call Destination    contains    ,

And    Toll Charges    is greater than    0

Canada and Mexico Toll
(Stateside; will exclude usage

that was not billed extra)

Roaming Servicing Area    contains    (USA)

And    Call Destination    contains    ,

And    Toll Charges    is greater than    0

Canada and Mexico Voice calls only (Toll)Roaming Servicing Area    contains    Mexico

And    Bill Category    is equal to    ROAMING CHARGES

Or    Roaming Servicing Area    contains    Canada

And    Bill Category    is equal to    ROAMING CHARGES

Or    Roaming Servicing Area    contains    (USA)

And    Call Destination    contains    ,

And    Bill Category    contains    LOCAL

And    Toll Charges    is greater than    0

Canada and Mexico Data usage onlyRoaming Servicing Area    contains    Mexico

And    Bill Category    contains    DATA

Or    Roaming Servicing Area    contains    Canada

And    Bill Category    contains    DATA

Or    Roaming Servicing Area    contains    (USA)

And    Call Destination    contains    ,

And    Bill Category    contains    DATA

Canada and Mexico

  Roaming Message usage only

Roaming Servicing Area    contains    Mexico

And    Bill Category    is equal to    MESSAGING CHARGES

Or    Roaming Servicing Area    contains    Canada

And    Bill Category    is equal to    MESSAGING CHARGES

 

 

Custom Call Usage

 

FilterAction
Serono Text and

  Data Charges

Bill Category    contains    Messaging

Or    Bill Category    contains    Premium

Or    Bill Category    contains    T-Mobile Purchases

Or    Bill Category    contains    Data Service Roaming

 

 

Data Usage

 

FilterAction
Roaming (Data Only)Bill Category    is equal to    Data Servicing Roaming Charges
All DataBill Category    contains    Data
Domestic DataBill Category    contains    Data

And    Bill Category    does not contain    Roaming

 

 

International Dialing

 

FilterAction

International Dialing for NW plans

(All long distance for regional plans)

Toll Charges    is greater than    0.00

And    Bill Category    contains    Local Airtime

And    Call Direction    is equal to    Outgoing

And    Destination Number    is not equal to    411

And    Destination Number    does not contain    5551212

International Dialing (for regional plans)Destination Number    is greater than    99999999999

And    Special Feature    is not equal to    D

And    Bill Category    does not contain    Roaming

And    Call Direction    is equal to    Outgoing

International Dialing to Mobile

(for lines with IDC feature)

Special Feature    is equal to    I

International Dialing to Landline

(for lines with IDC feature)

Special Feature    is equal to    I

 

 

Messaging

 

FilterActions
All MessagesBill Category    is equal to    Messaging Charges
All Text MessagesBill Category    is equal to    Messaging Charges

And    Type    contains    Text

All Picture MessagesBill Category    is equal to    Messaging Charges

And    Type    is equal to    Picture

Domestic Messages

This filter will return all messages impacting bucket usage.

(There isn't a way to separate outgoing international messages in I-Bill or ART.)

 

Bill Category    contains    Messaging Charges

And    Roaming Servicing Area    contains    USA

Or    Bill Category    contains    Messaging Charges

And    Cost    is equal to    .XX (See Messaging Rates and replace XX with applicable cost.)

Domestic MessagesThis filter will return all messages sent or received while in the US.

 

Bill Category    is equal to    Messaging Charges

And    Type    does not contain    Roam Text

Domestic Text MessagesBill Category    is equal to    Messaging Charges

And    Type    does not contain    Roam Text

And    Type    does not contain    Picture

Roaming Messages–AllIncludes all messages sent and/or received while roaming.

 

Bill Category    is equal to    Messaging Charges

And    Roaming Servicing Area    does not contain    USA

And    Roaming Servicing Area    does not contain    U.S. (Wi-Fi Text)

And    Type    is not equal to    Picture

Roaming Sent MessagesIncludes messages sent while roaming.

 

Bill Category    is equal to    Messaging Charges

And    Type    contains    Roam Text

And    Call Direction    is equal to    Outgoing

Roaming Incoming MessagesBill Category    is equal to    Messaging Charges

And    Type    contains    Roam Text

And    Call Direction    is equal to    Incoming

International MMS (Incoming or Outgoing)We're not able to report this at this time.

 

 

Spend Report

 

FilterActions
Spend Domestic Voice CoverageAirtime Charges    is greater than    0

And    Bill Category    does not contain    Data

And    Bill Category    is not equal to    Roaming Charges

And    Bill Category    does not contain    Messaging

Spend Report International DialingToll Charges    is greater than    0.00

And    Bill Category    contains    Local Airtime

And    Call Direction    is equal to    Outgoing

And    Destination Number    is not equal to    411

And    Destination Number    does not contain    5551212

Spend Report Roaming (Voice Only)Bill Category    is equal to    Roaming Charges

And    Special Feature    is not equal to    H

Spend Report International MessagingBill Category    contains    Messaging

And    Destination Number    is greater than    99999999999

Spend Report Roaming (Data Only)Bill Category    is equal to    Data Service Roaming Charges

 

 

Standard Call Usage

 

FilterActions
Total Voice Minutes UsedBill Category    does not contain    Data

And    Bill Category    does not contain    Data

And    Bill Category    does not contain    Premium

And    Bill Category    does not contain    T-Mobile Purchases

And    Bill Category    does not contain    Messaging

And    Bill Category    is not equal to    Other Charges

T-Mobile to T-Mobile

(for plans without night buckets)

A time period named “Nights” must be created first, for 21:00 to 06:59.

 

Bill Category    contains    Local Airtime

And    Day of Week    does not start with    S

And    Special Feature    is equal to    F

Or    Special Feature    is equal to    T

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

T-Mobile to T-Mobile

(for plans with night buckets)

A time period named “Nights” must be created first, for 21:00 to 06:59.

 

Bill Category    contains    Local Airtime

And    Time Period    is not equal to    Nights

And    Day of Week    does not start with    S

And    Special Feature    is equal to    F

Or    Special Feature    is equal to    T

And    Day of Week    does not start with    S

And    Time Period    is not equal to    Nights

And    Bill Category    contains    Local Airtime

Anytime Minutes (Stackable Usage)Special Feature    is not equal to    T

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Special Feature    is not equal to    H

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

And    Time Period    is not equal to    Nights

Or    Special Feature    is not equal to    M

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Special Feature    is not equal to    H

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

And    Time Period    is not equal to    Nights

Out of Plan NumbersCall Destination    is equal to    Out-Of-Plan Num
WeekendDay of Week    starts with    S

And    Special Feature    is not equal to    E

And    Bill Category    contains    Local Airtime

Nights

(for plans without night buckets)

A time period named “Nights” must be created first, for 21:00 to 06:59.

 

Time Period    is equal to    Nights

And    Special Feature    is not equal to    T

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    E

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

Nights

(for plans with night buckets)

A time period named “Nights” must be created first, for 21:00 to 06:59.

 

Time Period    is equal to    Nights

And    Special Feature    is not equal to    E

And    Day of Week    does not start with    S

And    Bill Category    contains Local Airtime

Roaming (All)Bill Category    contains    Roam
Roaming (Voice Only)Bill Category    is equal to    Roaming Charges
Anytime Minutes

(customers with unlimited M2M,

Weekends, and HotSpot Calling)

Special Feature    is not equal to    T

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Special Feature    is not equal to    U

And    Special Feature    is not equal to    W

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

Or    Special Feature    is not equal to    M

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Special Feature    is not equal to    U

And    Special Feature    is not equal to    X

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

Anytime Minutes

(customers with

unlimited M2M and Weekends)

Special Feature    is not equal to    T

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

Or    Special Feature    is not equal to    M

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

Anytime Minutes

(customers with

unlimited M2M, Weekends,

Nights, and HotSpot Calling)

A time period named “Nights” must be created first, for 21:00 to 06:59.

 

Special Feature    is not equal to    T

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Special Feature    is not equal to    U

And    Special Feature    is not equal to    W

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

And    Time Period    is not equal to    Nights

Or    Special Feature    is not equal to    M

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Special Feature    is not equal to    U

And    Special Feature    is not equal to    X

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

And    Time Period    is not equal to    Nights

Anytime Minutes

(customers with unlimited M2M,

Weekends, and Nights)

A time period named “Nights” must be created first, for 21:00 to 06:59.

 

Special Feature    is not equal to    T

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

And    Time Period    is not equal to    Nights

Or    Special Feature    is not equal to    M

And    Special Feature    is not equal to    F

And    Special Feature    is not equal to    V

And    Day of Week    does not start with    S

And    Bill Category    contains    Local Airtime

And    Time Period    is not equal to    Nights

 

 

T-Mobile Purchases

 

FilterAction
T-Mobile PurchasesBill Category    is equal to    Premium Services

Or    Bill Category    is equal to    T-Mobile Purchases

 

 

Wi-Fi

 

FilterAction
Wi-FiType    is equal to    WiFi Call

Or    Type    is equal to    WiFi Call