120 likes | 342 Views
What is Reconciliation?. Carrier Statement. $$. The process of resolving Activations, Upgrades, and Features reported in RQ4 with Carrier Payments. Reconciliation Events. Gross Profit Refund Activation, Upgrade, or Feature refunded by the commission team identified as non-commissionable
E N D
What is Reconciliation? Carrier Statement $$ The process of resolving Activations, Upgrades, and Features reported in RQ4 with Carrier Payments Express Locations: Manager University
Reconciliation Events • Gross Profit Refund • Activation, Upgrade, or Feature refunded by the commission team identified as non-commissionable • GP Impact: Current Reporting Month • Commission Impact: Current Commission Month ? ? ? • Chargeback • Reduction of GP posted to RQ4 due to a Chargeback to Express Locations caused by the deactivation of Subscriber and/or Service • GP Impact: Commission Month in which Chargeback occurred • Commission Impact: Current Commission Month (Base Compensation) • Gross Profit Adjustment • Reduction or Increase of GP for an Activation, Upgrade, or Feature in which Express Locations received compensation, however; the compensation received is different than the value reported in RQ4 • GP Impact: Current Reporting Month • Commission Impact: Current Commission Month Express Locations: Manager University
Reconciliation Reporting • GP Adjustment & Refund Report • MTD Summary • Refund Reason Codes by Day • BI – GP Reconciliation Report • MTD Summary Report • RQ4 Reports Express Locations: Manager University
RQ4 - GP Adjustments • Product Detail Report • Search by Category • Select Location(s) • Recommend 1 or 2 locations at a time • Pick Date(s) • Recommend smaller date ranges • Select Run Report Express Locations: Manager University
GP Adjustment Examples Filter by Quantity Example 1 • PDP Deduction Example 2 • Payment Difference Example 3 • Transposed Rate Plans for a multiple line Activation – $0 net adjustment Express Locations: Manager University
Gross Profit Refund Reasons • Duplicate Error • Issue: A ‘similar’ Service has been processed for the same subscriber multiple times • Resolution: Process sale correctly and/or provide additional training on recording sales in RQ4 • Feature Policy Non-Compliance • Issue: A Feature has been processed which does not follow the Express Locations Feature Policy • Resolution: None • Non Opp • Issue: A FlexPay No Contract Activation has been processed as a contract Opp in RQ4 • Resolution: Process Non Opp through Activation Wizard • Not On Account • Issue: The feature is not on the subscriber line on the day of the research and Express Locations never received payment for feature • Resolution: None • No Contract / Ineligible • Issue: A contract extension was not identified in the research of the upgrade and/or the customer was ineligible to receive a handset upgrade for the contract pricing when recorded in RQ4 • Resolution: None • SMD / Return / Inactive • Issue: Subscriber Deactivated prior to Express Locations receiving commission on a monthly statement • Resolution: None • 30 Day Deactivation • Issue: Subscriber Deactivated within 30 days of original activation date • Resolution: None Express Locations: Manager University
Gross Profit Refunds – RQ4 Reports • Product Detail Report • Original Salesperson • Amount Refunded • Product Refunded • Refund Summary Report • Original Invoice Date • Refund Reason Code • Vendor Rebate History Report • Details by Tracking # (Service Number) Express Locations: Manager University
RQ4 – Product Detail Report Filter by Tendered By • Search by Category • Select Location(s) • Pick Date(s) • Recommend smaller date ranges • Date Range • Yesterday • MTD Express Locations: Manager University
RQ4 – Refund Summary Report Filter by Tendered By • Search by Category • Select Location(s) • Pick Date(s) • Recommend smaller date ranges) • Date Range • Yesterday • MTD Express Locations: Manager University
RQ4 – Vendor Rebate History Report Filter by Multiple Descriptions • Search Method • Status • Pick Date(s) • Recommend smaller date ranges • Date Range • Yesterday • MTD Express Locations: Manager University
RQ4 – Chargeback History Report Turn Report Filters On • Select Location(s) • Must always be Express Locations • Pick Date(s) • Recommend smaller date ranges) • Date Range • Yesterday • MTD Express Locations: Manager University