Reports (TrafficXP)

Standard Reports

The following are the standard reports. There are several other reports that are available as part of optional features, please review the information specific to those optional features to find what report(s) are available.

A/R

Accounts Receivable Aging Detail

Details line items for each customer of the A/R balance as of the chosen date.

Accounts Receivable Reconciliation Detail

Detailed line items showing A/R activity for each customer in a chosen time period.

Unapplied Prepayment

Detail line item(s) for each payment (or portion of) still unapplied to invoice(s).

Clients

Agency

List of agencies.

Billing History

Billing history by month, by quarter or annually.

Customer

Details of each and every customer.

Payment History

Payment history by month, quarter or annually.

Inventory

Inventory

Estimates how much of your broadcast inventory is sold and/or unsold based on log templates and orders entered as of the date of the report.

Log

After Aired

Print report showing customer spots on logs.

Log Detail

Details each item that invoiced per customer scheduled for logs during the report period. Includes individual times, rates, cart number, etc.

Log Time

Detail list of dates/times for each item that invoiced for each customer of what aired on logs during the report period.

Off Air Revenue Detail

Details off air revenue that will bill (or have billed) during the report period.

Orders

Order List

Summary of each order containing run dates, etc.

Order Confirmation

Prints multiple order confirmations filtered based on date, status and customer.

Average Spot Rate

Quick summary of average rate for spot(s) during specified date range.

Make Good

Details orders containing spots scheduled during the report period that need to be made good or trashed.

Expiring Orders

Can choose expiring on the left hand side/choose dates and this will give you a report showing your expiring orders.

Sales

Revenue Projection

Details expected revenue up to the next 12 months based on approved orders.

Transactions

Adjustment Detail

Detail line of the adjustments received during the report period; includes debit and credit amounts.

Aged Collections

Detail line of the payments received during the report period where amounts are shown based on the number of days between invoice collections.

Invoice Detail

Detail line of the invoices issued during the report period; includes gross, discount, agency commission, net, tax and sales commission.

Payment Detail

Detail line of the payments received during the report period; includes gross, discount, agency commission, net, tax and sales commission.

Premium Reports

A/R

Aged Receipts/Adjustments (Premium)

Report of receipts and adjustments based on days between invoices and completion.

Audit Trail (Premium)

Details all activity related to Accounts Receivable during a chosen time period.

Administration

User Usage (Premium)

Details individual user logon times, machine and duration.

Aired Fill Spots (Premium)

Details all fill spots that have aired (on logs) during the report period.

Bump (Premium)

Details all spots currently on the bump list during the report period.

Orders

Copy Assignment (Premium)

Shows orders that do and do not have copy assigned.

Invalid Order/Rotation (Premium)

Details orders during the report period that have missing and/or invalid rotations.

Sales

Goal (Premium)

Details sales goals on a per station / sales person basis.

Tips and Hints

On the Accounts Receivable Reconciliation Detail report it is missing info that I need

If you don’t have a column you need do a right click on any column header area and choose Column Chooser and look for the columns you need, then drag them up to your column header area.