Daily Sales Report

To show sales for a specific period, regardless of billing frequency, while also including spot length breakouts, average rate, and lowest rate information.

Information Gathering

When the report is run for current sales it pulls the spots from online log days for current and future log dates as well as current invoices for any logs that are accepted for the specified date range. Once an invoice is committed to history, those spots will be removed from the current report.

If the report is run for historical sales, the report will pull spots from historical invoices in Invoice History. Invoices must be committed to be historical. The report pulls in the spots based on the date they literally ran (not the invoice date).

Important Information

This is an INCOME based report. The report will exclude bumped spots. Non-Spot and Billable Program dollars will show up in the Misc. $ column based on the "run date" or "billing date" of the item. A common grouping or filter for this report is by Daypart. The daypart info used on this report is found in VT by selecting the System Menu then Edit Stations. Then go to the Station Daypart Setup Tab. Be sure this section is set up correctly for each station when running this report by daypart.

 FYI - The report will show daypart information based on Spot Placement rather than the schedule target of the order.

Report Options

Grouping Options Filter Options Other Options
A/R Account Name
Date Scheduled
Daypart
Income Account
Industry Code
Primary Product Code
Salesperson
Spot Type
Statement Group
Station
A/R Account
Advertiser
Daypart
Income Account Station
Industry Code
Primary Product Code
Salesperson
Spot Type
Statement Group
Station
Current/Historical
Include/Exclude Non-Commercial Spot
Include/Exclude Network Spots
Include/Exclude Zero Rate Spots
Include/Exclude Non-Spots
Gross or Net Income
Summary/Detail
Summary Page 1
Summary Page 2
Summary Page 3

Sample Daily Report