To show historical monthly transaction totals for Gross/Net Sales, Spot Count, Payments, A/R Adjustments, & Finance Charges in any combination for up to 5 years at a time all on one report.
The report pulls from advertiser purchase history to get the gross/net sales & spot count; therefore, invoices must be committed to history in order to show up on this report. All A/R transactions must be posted to the A/R Journal in order to show up on this report.
When running the report using the combined cycle, it will age A/R transactions based on the aging type that is set up for the statement group (Monthly Calendar or Monthly Media). If the Daily aging type is used, then A/R transactions will age based on the calendar month.
Rules for A/R Transactions & Income Accounts: If the transaction is applied to an invoice using only one type of income, then those dollars will be shown under that specific income account. If, however, multiple types of income accounts are used on the invoice or the transaction is not applied to an invoice, then the dollars will be shown under the advertiser's Default Income Account.
Rules for A/R Transactions & Station reference: If the transaction is applied to an invoice using only one station, then those dollars will be shown under that specific station; however, if multiple stations are found on the invoice or the A/R transactions are not applied to an invoice, then those dollars will be shown under an station.
| Grouping Options | Filter Options | Other Options |
|---|---|---|
| A/R Account Advertiser Agency Default Salesperson Electronic Invoicing Income Account Industry Code Primary Product Code Receivables Group Salesperson Secondary Product Code Statement Group Station Zip/Postal Code |
A/R Account Advertiser Agency Default Salesperson Electronic Invoicing Income Account Industry Code Primary Product Code Receivables Group Salesperson Secondary Product Code Statement Group Station Zip/Postal Code |
Sales to Display (Gross/Net/Both) Billing or Income Based Electronic Invoicing Include/Exclude Non-Spot Billing Include/Exclude Optional Billing Include/Exclude Payments Include/Exclude A/R Adjustments Include/Exclude Finance Charges Include/Exclude Spot Count Media/Calendar/Combined Cycle 1st Summary Page 2nd Summary Page 3rd Summary Page 4th Summary Page 5th Summary Page |