Validating Invoices with JPO Reports in AT&T Control Center

Introduction
Retail Trial Cost Share
Customer Acquisition Bounty
Settlement

Introduction – Using JPO Reports to Validate Line Item on an Invoice

Customers can use the JPO reports to check detail and validate the detail against the invoice.

• Customers do not have access to pull JPO reports, but can be set up to receive feeds on a monthly basis.

Retail Trial Cost Share – Invoice Line Item Breakdown

This section near the top of the invoice provides a breakdown of the following:

1. Description (Trial)
2. Description (SOC associated to trial)
3. Count of devices
4. Rate
5. Charge
   Count x Rate = Charge

   

JPO Report Columns used for Retail Trial Cost Share Invoice Validation

Column A/1: ICCID – For count totals
Column G/7: SOC
Column J/10: Rate
Column L/12: Bill Cycle

Note: Headers are not shown here, but will populate when loaded into database.

Validating Retail Cost Share Line Items – Count of Devices

Count of ICCID Devices on Report
Select Ctrl+Shift+down arrow in Column A to obtain the count of devices.
Total ICCID Count = 20791

Validate Count of Devices on Invoice
The invoice device counts match the ICCID count on the report.
20783+8=20791

Filtering JPO Report by SOC – CCLTRS

Filter Column G
Filter Column G to CCLTRS

Filtered Results

JPO Report Breakdown by SOC – CCLTRS

CCLTRS Count and Rate Sum
Select Ctrl+Shift+down arrow in Column J to obtain the CCLTRS Count and Rate Sum

Total CCLTRS Count = 20783
Rate Sum = $155,872.50

Validate Count, Rate, and Charge on Invoice
The invoice count, rate, and charge match the data on the report.
Count = 20783
Rate = $7.50
Charge = $155,872.50
This validates the line item.

Filtering JPO Report by SOC – XXXTRL

Filter Column G
Filter Column G to XXXTRL

Filtered Results

JPO Report Breakdown by SOC – XXXTRL

XXXTRL Count and Rate Sum
Select Ctrl+Shift+down arrow in Column J to obtain the XXXTRL count and rate sum.
Total XXXTRL Count = 8
Rate Sum = $96.00

Validate count, rate, and charge on invoice
The invoice count, rate, and charge match the data on the report
Counts = 8
Rate = $12.00
Charge = $96.00
This validates the line item

Customer Acquisition Bounty

Invoice Line Item Breakdown

The section near the middle of the invoice provides a breakdown of the following:

1. Description (Customer Acquisition Bounty)
   • Yes = Credit
   • No = Debit
2. Count of devices
3. Rate
4. Credits to customer
5. Debits to customer
   • Chargebacks, etc.

     

JPO Report Columns used for Customer Acquisition Bounty Invoice Validation

Column A/1: ICCID – For count totals
Column G/7: SOC
Column J/10: Rate
Column L/12: Bill Cycle

Note: Headers are not shown here, but will populate when loaded into database.

Validating Customer Acquisition Bounty Line Items – Count of Devices

Count of ICCID Devices on Report
Select Ctrl+Shift+down arrow in Column A to obtain the count of devices.
Total ICCID Count = 8505

Validate Count of Devices on Invoice
The invoice device counts match the ICCD count on the report.
7974 + 531 = 8505

Validating Customer Acquisition Bounty Line Items – Revenue

Revenue
Select Ctrl+Shift+down arrow in Column J to obtain the Revenue Sum.
Count = 8505
Sum = $73,950

Validate Count and Revenue on Invoice
The invoice count and charge (revenue) match the data on the report.
Counts = 8505
7974 + 531 = 8505

Sum/Charge = $73,950
$78,580 – 4630 = $73,950 credit

This validates the Customer Acquisition Bounty line items.

Settlement

Invoice Line Item

This section near the middle of the invoice provides the following:

1. Description (Retail Revenue Share)
2. Counts
3. Adjustment Charge

   

JPO Report Columns used for Settlement – Invoice Validation

Column A: CTN
Column B: SOC
Column E: Amount (credit or debit to customer)
Column H: Bill Cycle
Column L: Charge Type
(RS = Revenue Share)
Column M: Revenue Share Amount
In this example, Revenue Share is 10%. The amount in Column E multiplied by 10% = the Revenue Share in Column M.

Validating the Settlement Line Item – Count

Count on Report
Select Ctrl+Shift+down arrow in Column B to obtain the count.
Count = 32811

Validate Count on Invoice
The invoice counts match the count on the report.
Count = 32811

Validating the Settlement Line Item – Charge

Charge on Report
Select Ctrl+Shift+down arrow in Column M to obtain the sum.
Count = 32811
Sum = -$76,089.49

Validate Charge on Invoice
The invoice charge matches the charge on the report.
Count = 32811
Charge/Sum = -$76,089.49

This validates the Settlement line item.