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
A/R Aging Detail
Details line items for each customer of the A/R balance as of the chosen date.
Accounts Receivable Reconciliation DetailDetailed line items showing A/R activity for each customer in a chosen time period.
Unapplied PrepaymentDetail line item(s) for each payment (or portion of) still unapplied to invoice(s).
Clients
AgencyList of agencies.
Billing HistoryBilling history by month, by quarter or annually.
CustomerDetails of each and every customer.
Payment HistoryPayment history by month, quarter or annually.
Inventory
InventoryEstimates 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 AiredPrint report showing customer spots on logs.
Log DetailDetails each item that invoiced per customer scheduled for logs during the report period. Includes individual times, rates, cart number, etc.
Log TimeDetail list of dates/times for each item that invoiced for each customer of what aired on logs during the report period.
Off Air Revenue DetailDetails off air revenue that will bill (or have billed) during the report period.
Orders
Order ListSummary of each order containing run dates, etc.
Order ConfirmationPrints multiple order confirmations filtered based on date, status and customer.
Average Spot RateQuick summary of average rate for spot(s) during specified date range.
Make GoodDetails orders containing spots scheduled during the report period that need to be made good or trashed.
Expiring OrdersCan choose expiring on the left hand side/choose dates and this will give you a report showing your expiring orders.
Sales
Revenue ProjectionDetails expected revenue up to the next 12 months based on approved orders.
Transactions
Adjustment DetailDetail line of the adjustments received during the report period; includes debit and credit amounts.
Aged CollectionsDetail line of the payments received during the report period where amounts are shown based on the number of days between invoice collections.
Invoice DetailDetail line of the invoices issued during the report period; includes gross, discount, agency commission, net, tax and sales commission.
Payment DetailDetail 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.