Work In Progress

back

Reports

Allow you to access your data in multiple ways to track station performance. You may or may not be able to access all reports depending on the level of package you have purchased from RadioTraffic. If you see a report that is not available with your current package, contact our sales team to discuss how you can upgrade your account to access those reports.

Category: 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.

Aged Receipts/Adjustments

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

Audit Trail

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

Cash Receipts Application Analysis

Shows when payments received were applied to invoices.

Unbilled Spots Detail

Details unbilled spots that will be billed during the next billing cycle that transpire during the calendar portion of broadcast invoices for the selected calendar month.

Deposits

Details regarding deposits (if used) made between two specified dates.

Undeposited Payments

Details regarding payments that have not been attached to a deposit.

Unapplied Payments

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

Receivables Analysis

Detailed accounts receivable analysis.

Category: Admin

User Usage

Details individual user logon times, machine and duration.

Category: Clients

Agencies

Detailed list of agencies.

Billing History

Billing history by month, by quarter or annually.

Customers

Details of every customer.

Payment History

Payment history by month, quarter or annually.

Category: Informational

Emailed Invoices

Provides a view of invoices that were emailed between two specified dates.

Category: 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.

Category: Log

After Aired

Shows spots placement on logs.

Aired Fill Spots

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

Bump

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

Log Detail

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

Log Summary

Summary (per customer) of items invoiced as scheduled for logs during the report period. Includes columns for total count, total duration, etc.

Log Times

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.

Off Air Revenue Summary

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

Category: 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.

Copy Assignment

Shows orders that do and do not have copy assigned.

Invalid Order/Rotation

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

Make Good

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

Category: Projection

Revenue Projection

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

Revenue Reflection

Details reflected revenue based on invoicing and/or spot placement for the report period specified.

Category: Transactions

Adjustment Detail

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

Adjustment Summary

Summary 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.

Finance Charge Detail

Detail of the finance charges added during the report period; columns include amount, tax and total.

Finance Charge Summary

Summary of the finance charges added during the report period; columns include amount, tax and total.

Invoice Detail

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

Invoice Summary

Summary 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.

Payment Summary

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

Tax Due (Invoices)

Outlines the tax due assuming taxes must be forwarded to the tax collector based on issued invoices.

Tax Due (Payment)

Outlines the tax due assuming taxes must be forwarded to the tax collector based on payments received.

Lowest Unit Rate

To calculate lowest unit rate for political announcements do the following:

1. Set the dates you wish to use for the report.

2. Right click on CUSTOMER and choose the COLUMN CHOOSER option.

3. Drag CUSTOMER to the CUSTOMIZATION box.

4. Click the "Rate" column header to sort by rate.

5. Right click "Rate" and chose "filter editor"

6. Change filter to "rate does not equal 0."