List & Reports

Master Lists

    SIM Cards Type List
    Sales Executive List
    Zone List
    Handset List
    Channel Partner Type List
    Channel Partner Type Category List
        All /Selected Channel Partner Type
        Group on type --> Category name, Description, Period, Criteria

    Channel Partner List
        All /Selected Channel Partner Type wise
        All /Selected Executive wise
        All /Selected Zone wise
            * Active/Non-Active/Both * should include all contacts?

    Connection Scheme List
        All /Selected Connection Scheme (Group Scheme, Order Date)
             * Active/Non-Active/Both

    Air-Time Scheme List
        All /Selected Air-Time Scheme
            * Active/Non-Active/Both * should include All Facilities             (V.A.S.) under it?

    Value Added Services List
        All /Selected Value Added Services (Group VAS, Order Date)

    Application Received (Connection) Register
        All /Selected Application type wise (for any selected period         From date - to date)
        All /Selected Channel Partners wise (for any selected period         From date - to date)
        All /Selected Connection Scheme wise (for any selected period         From date - to date)
        All /Selected Zone wise (for any selected period From date - to         date)

    GroupWise Subscribers list/View

    Applications Current Status list - Subscriber wise
        Not activated Connections list (due to Discrepancy/ Credit         verification fail)

    Payment Received from channel
        Connection wise/Date range/Monthly/Partner wise/Scheme wise

    Payment due from channel / subscribers
        Connection wise/Date range/Monthly/Partner wise/Scheme wise

    Connection wise payment made to operator
    Connection wise payment due to operator
    Channel wise / executive wise aging analysis of payment received

Applications
    Subscribers list
    Groupwise Subscribers list/View
    List of connections for analysis:
        Individual Channel wise connection list
        Channel Category wise connection list
        Sub-Channel/reference wise connection list
        Subscriber Family/group wise connection list
        Zone/Pin wise connection list
        Executive wise connection list
        Channel connection (Direct/Indirect) list

    Applications Received list (Datewise/Partnerswise/Zonewise/ApplicationsTypewise/SchemeWise)
    Applications Returned for correction to Channel Partner
    Applications Returned for correction to Subscribers
    Applications not forwarded to Operator (as incomplete)
    Applications forwarded for connection to Operator but not activated     with reasons
    Application Register
    Summary Reports
    Analysis Reports
    Performance Analysis
        Activation Analysis
            No of Activation in a particular period by partner || Partner             Type wise /Zone wise / Executive wise /
            Discrepancy analysis
            Deactivation , Reject , Net Off , Credit Verification Analysis

Commission
    Commission Group List
    Commission Cycle List
    Commission Master list (All/Selected)
    Commission Receivable Summary (Cycle wise / Operator wise)
    Commission Head wise (All/Selected)
    Channel Partner wise (All/Selected)

    Commission Payable Summary (Cycle wise / Operator wise)
        Commission Head wise (All/Selected)
        Channel Partner wise (All/Selected)

    Commission Received Summary (Cycle wise / Operator wise)
        Commission Head wise (All/Selected)
        Channel Partner wise (All/Selected)

    Commission Paid Summary (Cycle wise / Operator wise)
        Commission Head wise (All/Selected)
         Channel Partner wise (All/Selected)

    List of Connections where commission is not paid by operator
        Due to discrepancy connections (Incomplete documents)
        Deactivated connections, activated in the same month
        Total /Executive wise/Partner wise/ Partner type wise

    List of Connections where the commission is deducted by operator     for pre-activated card & amount
        List of pre-activated cards – Deactivated in the current month         (Channel Partner wise)

    List of Connections where the commission is to be deducted from     Channel Partner for pre-activated cards
    List of pre-activated cards – Deactivated in the current month

    Monthly Commission Statement Reconciliation
    Commission Registers
    Summary Reports

    Analysis Reports
        Commission Receivable Analysis
             No of Activation done for each cycle for different types of              commission.
             Recd Commission, due commission, discrepancy Not solved
        Commission Payable Analysis
             Avg. Commission Paid, Total commission with No of activation              Paid,
             Avg. earning of Partner by Connections
    Profitability Analysis
        Earning per connection, Earning zone wise, Earning partner type         wise, Individual partner wise

Sim card

    SIM Card Received Register
    All /Selected operator wise (for any selected period From date - to     date)
    All /Selected SIM Card Type Wise (for any selected period From     date- to date)

    SIM Cards Issue Register
    All /Selected Partner wise (for any selected period From date - to     date)
    All /Selected SIM Card Type Wise (for any selected period From     date- to date)
    (Issued to Subscriber/Issued to Channel Partner/Both)

    SIM Cards Returned Register
    All /Selected operator/Partner wise (for any selected period From     date - to date)
    All /Selected SIM Card Type Wise (for any selected period From     date- to date)
    (Returned from Subscriber/Returned from Channel     Partner/Returned to Operator)

    SIM Cards In Stock -- Physical
    All /Selected SIM Card Type Wise (as on date)

    SIM Cards with Channel Partners
    All /Selected Channel Partners wise (as on date)
    All /Selected SIM Card Type Wise (as on date)

    SIM Cards with Subscribers
    All /Selected Subscribers wise (as on date)
    All /Selected SIM Card Type Wise (as on date)

    SIM Cards list
    All /Selected SIM Card Type Wise (for any selected period From     date- to date)
    Select [Activated only/De-activated Only/Re-activated     Only/Cancelled Only]

    SIM Card Status (Summary)
    All /Selected SIM Card Type Wise (for any selected period From     date- to date),
    Recd date, IMSI No, Mobile no, Issue Date, Issue to, Subscriber,     Status (Activated/deactivated/re/cancel/Pending)

    SIM Cards in Hand [To be submitted to Operator, excludes all     cards once activated]
    All /Selected SIM Card Type Wise (as on date), Recd date, IMSI     No, Mobile no,Issue Date, Issue to

    SIM Cards Reconciliation [To be submitted to Operator]
    Recd date, IMSI No, Mobile no, Issue Date, Issue to (Opening ->     Received-> Less activated -> Closing)

    SIM Cards Activation Summary [To be submitted to Operator]
    All /Selected SIM Card Type Wise (for any selected period From     date - to date)
    (Channel Partner name grouped with type, date 1,2,3,4,5,6,7     Total Channel Partner total Connection for the day, for the week,     one dates total connection)

    SIM Cards History Sheet (Like accounts Ledger)
    All /Selected SIM Card Type Wise (for any selected period From     date - to date)

    Sim Registers

        Summary Reports
            Sim Issued to Dealers and Used by them in Previous             Months
            Sim Not Activated by dealer and returned
            Avg. no of days taken for Activation by dealer
            Sim in hand of Partner Zone Wise / Partner Type Wise /             Executive Wise Analysis
            Sims lost by dealer : recd not activated but not in hand of             dealer

Facilities/Schemes
    Facilities List (Effective date wise/Close date wise/Name wise)
    Schemes List (Effective date wise/Close date wise/Name wise)     (Summary/Details)

Payments
    Payment Received from channel (Connection wise/Date     range/Monthly/Partner wise/Scheme wise)
   Connection wise payment made to operator

Mobile Numbers
    List of numbers in Hand
    List of Booked mobile numbers
    List of Used mobile numbers
    List of Canceled mobile numbers
    Mobile numbers Received (Operator Wise/ Date Wise/ Status)