Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
This report includes the same content as the General Ledger Interface Journal, but transactions are listed in general ledger transaction order rather than by GL account.
Select Audit GL Journal from the Management menu to display the Audit GL Interface Journal window.
Click Add and complete the following fields.
REPORT TYPE
predefined
Indicate whether this report is being run for a batch or a date range.
COMPANY
setup
If you are running the report for a specific date range, enter the company to include in the report.
BATCH NUMBER
setup
If you are running the report for a specific batch, enter the batch number here. This is the number the system creates whenever a certain transaction type (such as a transfer or a group of subscriber payments) is processed by the system.
ONLY BLANK GL RECORDS
yes/no
Indicate if the report should be limited to those GL transactions that have a blank GL account number.
ALL JOURNAL CODES, JOURNAL
yes/no predefined
Indicate whether the report should include all journal codes and, if not, enter the journal code to list.
ALL GL ACCOUNTS, GL ACCOUNT
yes/no setup
Indicate whether the report should include all GL accounts and, if not, enter the GL account(s) to include.
START DATE END DATE
date
Enter the date range that should be covered in the report. Only transactions that have a transaction date within this range will be included.
EXPORT
yes/no
Select this checkbox if you want to create an export file.
FILE FORMAT
setup
Select the file map to use for this export. A file map must be set up previously (“GLAudit” usage).
FILE NAME
open
You can accept the default file name or modify it.
FILE OPTION
predefined
Select append (add to an existing file with the same name) or replace (replace the existing file).
Two additional checkboxes that do not appear in the GL Interface Journal are All Accounts and Account. If All Accounts is not selected, a specific GL account can be specified for the report; only transactions affecting the GL account will be included.
Click OK and then Continue to produce the report.
Circulation transactions that affect the general ledger are interfaced to the GL via several different menu options. These transactions can be broken down into different reporting areas, known as journal codes, as indicated below. The GL Interface Journal, which is one of the reports you can use to record GL activity, can be run for specific journal codes or all codes.
The GL Interface Journal is used primarily for balancing the general ledger at the end of the month. If you do not automatically interface Circulation transactions to the GL, you may also use this report when making manual GL entries. It can be created for either a batch (a specific entry session) or a date range.
Notes:
Business Rules govern whether account GL activity should be retained for each transaction, net activity for each carrier/dealer, or net activity for the entire GL account. Regardless of how you set the Business Rules, subscriber activity will always be kept at a transaction level.
The GL Interface Journal reports only net activities in the GL accounts. This is different from the Billing Journal, which records all transactions to a carrier/dealer’s account. Keep this in mind when comparing the two.
The export option requires that a “GLInterJrnl” file map be set up in advance. See Appendix B for the data elements that can be included in this file map.
Select GL Interface Journal from the Management menu to display the GL Interface Journal window.
Click Add and complete the following fields.
Click OK and then Continue to process the journal.
The Daily Draw Impact report is used to show changes in draw, by publication and delivery schedule, between two dates. Each transaction that changes the draw can be included, and the net change in draw is also shown.
Note: If you allow copies to vary by day or draw changes to be made manually to home-delivered routes, the transaction detail may not match the net draw difference shown on the report. Only transaction changes (i.e., from starts, stops, delivery schedule changes, etc.) are shown in the detailed report.
Select Daily Draw Impact from the Management menu to display the Daily Draw Impact Report window.
Click Add and complete the following fields.
Click OK and then Continue to produce the report.
Information on this report is displayed in general ledger account order. The displays the same information in general ledger transaction order, for audit purposes.
Account accruals, which post GL entries for reporting purposes when fiscal periods do not match Circulation billing periods
Accruals
AcctAcrl
Most account charges and credits (including draw, returns, and miscellaneous charges)
Account Billing Close
AcctBill
Account credits transferred to AP (where a check can be issued) or directly deposited into carrier’s account
Interface to AP Direct Deposit
AcctCred
Account payments
Payments to GL
Cash
Subscriber donation (during stop, restart, or transfer)
Transaction Processing
Donation
Expire change
Transaction Processing
ExpireCh
Subscriber grace accrual
Grace Due Report
GraceAcc
Subscriber grace due
Transaction Processing
GraceDue
Subscriber grace writeoff
Immediate (Grace Writeoff)
GraceWO
Subscriber refunds
Immediate (Batch Refunds)
Refund
Subscriber refund writeoff
Immediate (Refund Writeoff)
RefundWO
Revenue adjustment
Revenue Comparison Report
RevAdj
Subscriber payment
Sub. Payment Processing
SubsPymt
Tax liability (if tax authority remits on delivery)
Tax Liability
TaxLiab
Subscriber transfers
Transaction Processing
Transfer
Transportation exclusion (if tax authority allows cost of delivery to be deducted from tax)
Account Billing Close
TrExclsn
Tax exclusion (reverses transportation exclusion if subscription rate is below cost of delivery)
Tax Exclusion
TxExclsn
Taxes associated with a move transaction (if tax authority remits on delivery). This will not be included in Tax Liability.
Transaction Processing
TxMove
Unearned revenue (subscription amounts that have been paid for but not delivered)
Unearned Revenue
Unearnrv
REPORT TYPE
predefined
Indicate whether this report is being run for a batch or a date range.
COMPANY
setup
If you are running the report for a specific date range, enter the company to include in the report.
BATCH NUMBER
setup
If you are running the report for a specific batch, enter the batch number here. This is the number the system creates whenever a certain transaction type (such as a transfer or a group of subscriber payments) is processed by the system.
SORT BY SUBSCRIPTION ID
yes/no
Select this checkbox if you wish to sort the journal by subscription ID. This option applies only to subscription-related journal codes:
Donation, ExpireCh, GraceAcc, GraceDue, GraceWO, Refund, RefundWO, SubsPymt TaxLiab, Transfer, TrExclsn, TxExclsn, TxMove, and Unearnrv.
SUMMARIZE
predefined
Indicate whether the journal should include both detail and summary (individual transactions are listed for each GL account) or only summary (only total debits and credits for each GL account).
USE ROLL-UP
yes/no
Check this field if the journal should report debits and credits by rollup account, rather than individual GL account. If no rollup account is defined for a GL account (in Chart of Accounts setup), the individual GL account will be reported.
ALL JOURNAL CODES, JOURNAL
yes/no predefined
Indicate whether the report should include all journal codes and, if not, enter the journal code to list.
PAGE ON JOURNAL CODE
yes/no
Indicate whether a page break should be inserted in front of each new journal code.
ALL GL ACCOUNTS GL ACCOUNT
yes/no setup
Indicate whether the report should include all GL accounts and, if not, enter the GL account(s) to include.
START DATE END DATE
date
Enter the date range that should be covered in the report. Only transactions that have a transaction date within this range will be included.
EXPORT
yes/no
Select this checkbox if you want to create an export file.
FILE FORMAT
setup
Select the file map to use for this export. A file map must be set up previously (“GLInterJrnl” usage).
FILE NAME
open
You can accept the default file name or modify it.
This section guides the user through the menu options that are available under the Management menu.
The Rate by 100 Report is a useful summary of a publication’s per-copy rates for accounts, broken out by AAM zone. For two date ranges, it lists:
Total charges:
Draw charges and credits, including draw adjustments (draw * rate)
Return credits (returns * rate)
Net charges (draw charges - return credits)
Total copies:
Total draw, including draw adjustments
Total returns
Net draw (draw - returns)
Average copies:
Total draw / number of publishing days in range
Total returns / number of publishing days in range
Net draw / number of publishing days in range
Average rate per 100:
(Draw charges / total draw) * 100
(Return credits / total returns) * 100
(Net charges / net total) * 100
The report will print in publication order and, within each publication, in AAM zone order. The report does not rate draw on its own, but relies on draw information created by Account Billing Processing (see the Accounting chapter of the User Manual). Therefore, if you want unbilled charges included on the report you must start an account billing run, process it, create the Rate by 100 Report, and then undo the billing run. Bulk and unpaid circulation is not included on the report.
Select Rate By 100 from the Management menu to display the Rate By 100 Report window.
Click Add and complete the following fields.
Click OK and then Continue to produce the report.
PRODUCT
setup
Enter the product for which to run the report. Enter “*” to multi-select products.
SUMMARIZE
predefined
Select Both if you want to generate detail (i.e., broken out by transaction type) and summary information. Select Only to generate only summary information (i.e., the net change for each delivery schedule).
START DATE END DATE
date
Enter the date range for the report. Subscription transactions entered after the start date and through the end date will be included. Transactions that suspend the subscription, and vacation pack temp stops, are not included.
The Age Analysis Detail report is similar to the Age Analysis Summary report, but individual account transactions are also listed here.
Select Detail Age Analysis from the Management menu to display the Age Analysis–Detail window.
Click Add and complete the following fields.
COMPANY
setup
Enter the company for which to run the aging report (enter “*” to select all companies).
BILL SOURCE
setup
Enter the bill source for which to run the report (enter “*” to select all bill sources).
AGING DATE
date
Enter the date on which the aging should be based.
SELECTION TYPE
predefined
Indicate whether this report should include one or more district, zone, region, or area, or account.
SELECTION
setup
Enter a particular district, zone, region, or area (depending on the selection type entered above) to include in the report, or enter “*” to multi-select. If Selection Type is “Account”, enter the account ID of the carrier/dealer for whom you are running the report, or enter “*” to include all accounts.
SELECT BY
predefined
Indicate whether this report should further select by route type, account class, account group, or collector. If not, select all in this field.
SELECTION
setup
If you entered “all” in Select By, this field will be skipped. Otherwise, enter one or more route types, account classes, account groups, or collectors, depending on what you entered in Select BY. Use * to multi-select.
DEMOGRAPHIC
setup
If you selected account class or account group in Select By, you will be able to select a single account demographic.
ANSWER
setup
Enter a valid answer to the demographic question selected.
AGING CRITERIA
predefined
Enter one of the following to indicate the aging period or type of content that is to appear in the report: All aging periods 1st aging period 2nd aging period 3rd aging period 4th aging period 5th-8th periods 9th-12th periods Unapplied payments
BALANCE TYPE
predefined
Select the type of balance to include in the report: credit, debit, or both.
BALANCE MINIMUM
decimal
If you selected a balance type of “credit” or “debit”, enter the minimum balance an account must have to be selected for the report.
PERIODS TO DISPLAY
open (2)
Enter the number of age periods to display on the report (between 4 and 12).
ZERO BALANCE ACCOUNTS
yes/no
Indicate whether to include zero balance accounts in the report.
SORT BY
predefined
Indicate whether the report should sort by account or name (alphabetical) within the sort area defined above.
GENERATE TASKS
yes/no
Select this checkbox to generate event tasks for qualifying accounts when running this report. Note: Event tasks must be set up previously.
EXPORT
yes/no
Select this checkbox if you want to create an export file.
FILE FORMAT
setup
Select the file map to use for this export. A file map must be set up previously.
FILE NAME
open
You can accept the default file name or modify it.
Click OK and then Continue to produce the report.
The Start/Stop Analysis Report can be used to show which of your new starts have now stopped. The report can be run for a specified product or date range. For example, a subscriber may have started on 02/05 but then stopped on 03/15. If the report is run for 02/01 - 02/28, this subscriber would be included.
Select Start/Stop Analysis from the Management menu to display the Start/Stop Analysis Report window.
Click Add and complete the following fields.
PRODUCT
setup
Enter the product for which to run the report. Enter “*” to multi-select products.
START DATE END DATE
date
Enter the date range for the report. All subscribers who started in this date range and subsequently stopped (regardless of the date) will be included.
ALL REASONS, REASON CODE
yes/no setup
To run the Start/Stop Analysis Report for all start reason codes, check the All Reasons field. Otherwise, enter the start reason code to include in the Reason Code field, or enter “*” to multi-select start reason codes.
Click OK and then Continue to produce the report.
The Stop Analysis report can help you analyze your stops—for example, how many customers who stopped for a specific reason have since started, and how many temporary stops have become permanent.
Select Stop Analysis from the Management menu to display the Stop Analysis Report window.
Click Add and complete the following fields.
PRODUCT
setup
Enter the product to include in the report.
START DATE END DATE
date
Enter the date range to be covered by the report. If you specify a date range in the future, the report will list starts as they are projected to be in that future date range. However, the status of those subscribers (temp. stop, perm. stop, etc.) will be as of the current date. The holds also for date ranges in the past.
SELECTION TYPE
predefined
Indicate whether the report should include specific Zip Codes, areas, regions, zones, or districts. Enter All to include all areas.
SELECTION
setup
Enter the Zip, area, region, zone or district (depending on what type is entered above) to include, or enter “*” to multi-select. If you entered “All” above, this field will be skipped.
Click OK and then Continue to produce the report.
The table below explains the column headings in the report.
PERM NO START
Subscribers who became permanently stopped within the time frame selected and remained permanently stopped.
PERM ACTIVE
Subscribers who became permanently stopped within the time frame selected and are now permanently active.
PERM INACTIVE
Subscribers who (a) became permanently stopped, within the time frame selected (b) restarted, and (c) then became temporarily stopped.
TEMP NO RESTART
Subscribers who became temporarily stopped within the time frame selected and have not restarted.
TEMP RESTART
Subscribers who became temporarily stopped within the time frame selected and have restarted.
TEMP NOW PERM
Subscribers who became temporarily stopped within the time frame selected and are now permanently stopped.
TOTAL PERM
(PERM NO START) + (PERM ACTIVE) + (PERM INACTIVE).
TOTAL TEMP
(TEMP NO RESTART) + (TEMP RESTART) + (TEMP NOW PERM).
TOTAL STOPS
(TOTAL PERM) + (TOTAL TEMP).
TEMP VAC PACK
Subscribers who became temporarily stopped within the time frame selected and received a vacation pack.
This report lists subscriber payments by rate code, payment term, and length for a date range. You can select unprocessed payments, processed payments, or both.
Select Sub Payment Analysis from the Management menu to display the Formal Subscriber Payment Analysis window.
Click Add and complete the following fields.
Click OK and then Continue to create the report.
When a certain number of complaints are entered for a subscriber within a certain timeframe, the complaints can be escalated: e-mail can be sent to key personnel, contact and resolution information can be entered, and the escalated complaint will appear on this report, the Formal Complaint Report.
The Formal Complaint Report can be run for resolved and/or unresolved complaints, and complaints that were or were not resolved within the allotted number of resolution days.
Select Formal Complaint from the Management menu to display the Formal Complaint Report window.
Click Add and complete the following fields.
Click OK and then Continue to create the report.
The Age Analysis Summary and Age Analysis Detail reports provide the primary means by which carrier/dealer account balances and aging amounts can be reviewed (aging can also be viewed in ). The total account balance will be divided into as many as 12 aging periods, including the current aging period.
Note: Business Rules govern whether aging is based on days past due, periods past due, or the Aging Calendar. Business Rules also determine whether credit memos and unapplied payments should be aged.
Billing periods (see Bill Period in the Setup Manual). If aging is based on billing periods, an account charge will be in the current billing period from the time it is billed to the next billing date; then it will move to period 1. It will move to period 2 on the billing date after that, and so on.
The Aging Calendar (see Aging Calendar in the Setup Manual). If aging is based on age periods, an account charge will be in the current aging period from the time it is billed to the next aging date; then it will move to period 1. It will move to period 2 on the aging date after that, and so on.
A user-defined number of days (see Age Period in the Setup Manual). If aging is based on a user-defined number of days, a charge will be in the current aging group for the number of due days allowed in the carrier’s account terms (see Terms in the Setup Manual). After this, the charge will move to aging group 1 for the number of days defined for the first aging group, and so on.
For example, say an account draw charge of 160.00 is billed on 05/31, and the number of due days is 15 (or the 15th of the month). Also assume the paper bills again on 6/30. If aging is done by billing period, and the carrier does not pay this charge, it will be in the current aging group from 5/31 to 6/29, and will move to aging group 1 on 6/30. If aging is done by a user-defined number of days, and each aging group is, say, 20 days, the charge will be in the current aging group for 15 days (5/31- 6/14) and be in aging group 1 for 20 (6/15 - 7/4).
The Age Analysis Summary report provides a summary of account aging. Individual charges and credits are not shown, only totals for each aging period.
Select Summary Age Analysis from the Management menu to display the Age Analysis–Summary window.
Click Add and complete the following fields.
Click OK and then Continue to produce the report.
The Dispatch Report allows you to track where and when dispatches are occurring, and how long they take to be resolved.
Select Dispatch Report from the Management menu to display the Dispatch Report window.
Click Add and complete the following fields.
Click OK and then Continue to produce the report.
The District Manager Summary Report lists starts, stops, restarts and complaints by source and reason codes. This can be useful in locating general circulation trends.
Note: Only complaint codes flagged as a delivery complaints (see Complaint in the Setup Manual) will be included in this report.
Select District Summary from the Management menu to display the District Manager Summary Report window.
Click Add and complete the following fields.
Click OK and then Continue to process the report.
The Complaint Rate Analysis Report is a summarized version of the and can be used to identify problem routes.
Note: Only complaints with a complaint code flagged as a delivery complaint (see Complaint in the Setup Manual) will be included in the Delivery Complaint columns.
Select Complaint Rate from the Management menu to display the Complaint Rate Analysis window.
Click Add and complete the following fields.
Click OK and then Continue to produce the report.
This report lists all routes for the publication(s) selected. Each route’s delivery type, total draw for the report period, and number of complaints is shown. The complaints are divided by 1000 to get the complaints per thousand figure. Notice that the report lists delivery complaints separately (when a complaint code is set up, it is defined as delivery or non-delivery related). Also, since the complaint code can be changed after the complaint is processed, the report distinguishes between original delivery complaints (at the time of the End Date) and current delivery complaints, and lists the number of delivery complaints whose complaint code was changed.
Note: If a complaint was inadvertently entered as a delivery complaint or vice versa, you can change the complaint code after that complaint has processed (if you have security to modify a processed complaint code).
Unearned revenue (also known as “prepaid liability” and “subscriber liability”) is made up of subscriber payments which have been processed but for which products have not yet been delivered. As products are delivered, unearned revenue becomes earned revenue.
Run this report at the end of each fiscal period to update the general ledger Unearned Revenue GL account. This account is credited for subscriber payments and debited as subscriptions are delivered. The Unearned Revenue report can be created in a summary form, listing totals by delivery method or district, or it can be created in detail form, listing individual subscribers as well. You may choose to create the report without updating the general ledger, to study account information.
Business Rules determine whether you report unearned revenue separately for a certain day of the week (such as Sunday). If you do, unearned revenue for this day will be displayed in a separate column from the other days. Otherwise, all unearned revenue will be reported in one column. Business Rules also determine if “earned” revenue is stored by Circulation (this may be necessary for taxing purposes).
Unearned revenue is calculated by first determining the remaining copies or publishing days in the subscription. This is done by subtracting the run date from the expiration date, and taking into account the subscriber’s delivery schedule and the publishing calendar. The average copy rate (based on the payment amount and the subscription period) is then multiplied by the number of days remaining in the subscription. Unearned revenue will be calculated differently based on whether the newspaper uses a single average copy rate or varies copy rates by day of the week.
If the subscriber renews early, the entire payment amount is included in the unearned revenue calculations. In addition, discount amounts are amortized over the subscription term, just as payment amounts are amortized. For example, say Circulation determines that the actual rate for the subscription discussed in the first example should be 20.00 (based on the subscription rate code):
Discount amounts are shown in the Unearned Revenue report under the appropriate column (current payments, earned revenue, prior period, and so on), and on a separate line for each account (or summary total), along with any refund write-offs for the account.
Although payments make the most impact, unearned revenue is also adjusted by transfers, grace, refunds, and donations. A subscriber’s unearned revenue might be listed as shown here:
Notes:
If subscriber rates are changed within a subscription term, the subscription will not be affected (unearned revenue will be calculated based on the old rate). Only payments processed after the date of a rate change will be affected.
Earned revenue is calculated using this formula: Prior period’s unearned revenue + payments + transfers - refunds - donations - grace - writeoffs - current unearned revenue.
The formula for calculating current discounts is Prior period’s discounts + payment discounts - new unearned discounts = discounts earned.
If you offer day pass subscriptions, single day passes are earned when they are paid for, while day pass bundles are earned as they are used.
If any of the following activities have taken place since the last day of the period, a Historical Unearned or Grace Due should not be run.
Change in the Premium Day Calendar
Run any Premium Day processing
Note: If you are using Premium Day or a wallet of any kind, it is time sensitive.
To update unearned revenue and create the report:
Select Unearned Revenue from the Management menu to display the Unearned Revenue Report window.
Click Add and complete the following fields.
Click OK and then Continue to create general ledger entries (if Create G/L is selected) and the Unearned Revenue Report.
A warning message— “Unearned revenue report is already in process for the same parameters in update mode.” will be displayed if you run a second Unearned Revenue report while the first report with the same parameters is still being processed.
The Credit Card (CC) Success Report includes a detailed analysis of the credit card success rate for each Subscription Type, including information on declined and successful transactions.
Select CC Success Report from the Management menu to display the Credit Card Success Report window.
Click Add and complete the following fields.
Click OK and then Continue to produce the report.
An important aspect of managing circulation is the relationship between the draw distributed and the revenue it yields. The Draw and Revenue Report can help by comparing the total draw to the total revenue for each AAM zone and column; draw adjustments and returns are also reported.
Only draw and revenue for copies that have been billed will be included in the report totals. The draw charge to the account will be used to calculate the revenue. So, for office pay draw, only the charge will be included (not the office pay credit).
Select Draw And Revenue from the Management menu to display the Draw and Revenue Report window.
Click Add and complete the following fields.
Click OK and then Continue to create the report. Draw, returns and draw adjustments that have been billed for the product and date range entered will be totalled by AAM zone and AAM column. If a route is assigned to multiple AAM zones, the AAM zone with the highest percentage will receive the route’s draw.
Duplicate addresses may unknowingly be entered in Circulation. For example, a Customer Service associate might misspell a street name during an address find and so add the address again. This can cause your TM draw and other figures to be inaccurate.
Select Address Duplicates from the Management menu to display the Duplicate Addresses Report window.
Click Add and enter the publication for which the report should be run and the criteria that should be used to decide what addresses are duplicates. The three possible criteria are displayed on window.
Click OK and then Continue to produce the report.
Note: Addresses are matched based only on criteria you specify. Therefore, List #2 is most reliable for listing actual address duplicates. Choose List #1 or List #3 when you want to list addresses that are close but not exact.
Some states, such as California, tax newspaper subscriptions based on the portion that has been delivered—that is, earned revenue.
For example, say the tax is 3% and a subscriber has a 6-month, 60.00 subscription. If taxes are reported three months later, about half of the subscription (or 30.00) will have been delivered. The total tax on the subscription will be 3% * 60, or 1.80, but since only half of it is earned, only 0.90 should be reported in this tax period.
This report lists tax amounts for earned revenue, and can be useful for tax reporting if a state’s tax is based on goods delivered. Earned revenue is calculated when the is run with Update selected.
Select Taxable Revenue from the Management menu to display the Taxable Revenue Report window.
Click Add and enter the publication and date range for which the report should be run. Tax amounts will be calculated for earned revenue created in this date range.
Click OK and then Continue to produce the report.
If you charge for bonus days using the “premium day” method (see ), premium amounts will be included in the full payment amount in the Payments column. The subscriber’s wallet amount will be included in their ending Unearned balance. Premium days are “earned” with a negative payment adjustment, and so amounts for premium days delivered during a period will not affect the Earned Revenue column. Instead they will be a negative adjustment to the Payments column. Therefore if the premium day is paid for and delivered within the same reporting period, it will have no impact on the Unearned Revenue report.
PRODUCT
setup
Enter the publication to include in this report (enter “*” to multi-select publications).
PERIOD 1 PERIOD 2
date
In the four date fields, specify the two ranges of dates to compare.
WEEKDAYS
predefined
Indicate which days of the week should be included in the report. For example, you may want to include only Thursdays. Enter “*” to multi-select days.
Payment amount = 18.00 for a 3-month subscription
Average copy rate = 0.20
Subscription expiration date = 6/30
Report date = 5/31
Publishing days remaining in subscription = 6/30 - 5/31 = 30
0.20 x 30 days remaining in subscription = 6.00 unearned revenue
Payment amount = 18.00 for a 3-month subscription (Sundays = 22% of subscription, other days = 13% each)
Sunday average copy rate = 0.31
Average copy rate for other days = 0.18
Subscription expiration date = 6/30
Report date = 5/31
Sundays remaining in subscription (5/31 to 6/30) = 4
Other days remaining in subscription (5/31 to 6/30) = 26
0.31 x 4 Sundays remaining in subscription = 1.24 unearned revenue
0.18 x 26 other days remaining in subscription = 4.68 unearned revenue
Total unearned revenue = 5.92
Subscription rate 20.00 - Payment amount 18.00 = 2.00 discount amount for the subscription term
2.00 divided by 90 days (number of days in the subscription term) = 0.02, the average discount rate
0.02 x 30 days remaining in the subscription = 0.60
Prior Period Unearned Revenue
34.67
+
Payments
72.05
+
Transfers
-
Grace Paid
15.68
-
Refunds
-
Write-offs
-
Donations
-
New Unearned Revenue
54.37
+
Expire Changes
=
Current Earned Revenue (Sunday - 12.33) (Other - 24.34)
36.67
ALL ACCOUNTS
yes/no
Indicate whether unearned revenue should be run for all accounts. If you do not select this checkbox, the Account Ranges Entry screen will appear after completing this screen for entering specific accounts to include.
PRODUCT
setup
Enter the product for which unearned revenue should be updated (enter “*” to multi-select products).
START DATE END DATE
date
Enter the date range for which to run the report. If you are updating the general ledger, enter the first and last dates of this (ending) fiscal period. Final transaction processing and payment processing must be complete through the end date. No payments can be processed after this date until unearned revenue for this fiscal period is updated.
REPORT TYPE
predefined
Indicate whether this should be a detail or summary report.
UPDATE
yes/no
Indicate whether unearned revenue information should be updated in Circulation (the updated unearned revenue becomes the “Prior Period’s Unearned Revenue” the next time you generate the report). If unearned revenue has not been updated through the day prior to the START DATE, then PRIOR PERIOD will have only zeros.
CREATE G/L
yes/no
If you selected UPDATE, indicate whether general ledger entries for the unearned and earned revenue should be created.
EXPORT
yes/no
Select this checkbox if you want to create an export file.
FILE FORMAT
setup
Select the file map to use for this export. A file map must be set up previously.
FILE NAME
open
You can accept the default file name or modify it.
Account, Name
The subscription ID and name.
Prior Unearned Revenue / Disc
The subscriber’s unearned revenue at the beginning of the report period. The associated discount is displayed on the second line.
Earned Revenue / Disc
The portion of the subscription that was earned (delivered) during the report period. This will decrease the unearned revenue. The associated discount is displayed on the second line.
Payments / Disc
Payments that were effective in this report period. Payments increase unearned revenue. The associated discount is displayed on the second line.
Exp Chg / Disc
Changes to the subscription period caused by complaints or expire date modifications. These typically increase unearned revenue. The associated discount is displayed on the second line.
Transfer / Donations
Changes to the subscription period caused by money being transferred into or out of the account, or donations. Transfer-outs and donations decrease unearned revenue; transfer-ins increase it.
Grace / New Grace / Vac Pacs
If the subscriber was in grace during the report period, the value of the grace paid is displayed. The second line displays new grace. Any discounts for vacation packs are displayed on a third line.
Refunds / Writeoffs
If the subscriber received a refund during the report period, it is displayed in this column. Refunds decrease unearned revenue, and so do refund writeoffs, which are printed on the second line.
Unearned Revenue
The subscriber’s unearned revenue at the end of the report period.
Discounts
If the subscriber rate has a discount, the discount amount for each column will be displayed on the third line.
Columns in Second Section of Report
The second section of the report contains the subscription ID, name, current status, credit status, expire date, end grace date and invoice flag for subscribers currently in grace. The value of the grace days the subscriber has received within this reporting period is displayed in the Amount Owed column; the discount for that amount is listed in the Discount column. Note that Amount Owed is not the same as grace owed, which is typically created only after the grace period ends.
PRODUCT
setup
Enter the product for which you want to list subscriber payments.
START DATE END DATE
date
Enter the date range within which subscriber payments were made.
PROCESS STATUS
predefined
Select processed or unprocessed payments, or both.
PRODUCT
setup
Enter the publication for which you are creating the Formal Complaint report.
START DATE END DATE
date
Enter the date range for the report. Only escalated complaints escalated within this date range will be included.
COMPLAINT CODE
setup
Enter the formal complaint code to include in the report, or enter “*” to multi-select complaint codes. Only formal complaints entered with the complaint codes selected here will be included in the report.
RESOLUTION TYPE
predefined
Indicate whether the report should include resolved escalated complaints, unresolved escalated complaints, or all escalated complaints.
RESOLUTION BASIS
predefined
Indicate whether the report should include escalated complaints that were resolved within the allotted resolution days, that were not resolved within the allotted resolution days, or all complaints. The allotted number of resolution days are defined in Publication setup.
DELIVERY TYPE
predefined
Indicate which delivery types should be included in the report: route, mail, unassigned (for example, complaints from non- subscribers), or all.
SELECTION TYPE
predefined
Indicate whether this report should include a particular district, zone, region, or area, or enter all to include all routes.
SELECTION
setup
Enter a particular district, zone, region, or area (depending on the selection type entered above) to include in the report, or enter “*” to multi-select. This field is inactive if the report type is “all”.
COMPANY
setup
Enter the company for which to run the aging report (enter “*” to select all companies).
BILL SOURCE
setup
Enter the bill source for which to run the report (enter “*” to select all bill sources).
AGING DATE
date
Enter the date on which the aging should be based.
SELECTION TYPE
predefined
Indicate whether this report should include one or more district, zone, region, or area, or account.
SELECTION
setup
Enter a particular district, zone, region, or area (depending on the selection type entered above) to include in the report, or enter “*” to multi-select. If Selection Type is “Account”, enter the account ID of the carrier/dealer for whom you are running the report, or enter “*” to include all accounts.
SELECT BY
predefined
Indicate whether this report should further select by route type, account class, account group, or collector. If not, select all in this field.
SELECTION
setup
If you entered “all” in Select By, this field will be skipped. Otherwise, enter one or more route types, account classes, account groups, or collectors, depending on what you entered in Select BY. Use * to multi-select.
DEMOGRAPHIC
setup
If you selected account class or account group in Select By, you will be able to select a single account demographic.
ANSWER
setup
Enter a valid answer to the demographic question selected.
AGING CRITERIA
predefined
Enter one of the following to indicate the aging period or type of content that is to appear in the report: All aging periods 1st aging period 2nd aging period 3rd aging period 4th aging period 5th-8th periods 9th-12th periods Unapplied payments
BALANCE TYPE
predefined
Select the type of balance to include in the report: credit, debit, or both.
BALANCE MINIMUM
decimal
If you selected a balance type of “credit” or “debit”, enter the minimum balance an account must have to be selected for the report.
PERIODS TO DISPLAY
open (2)
Enter the number of age periods to display on the report (between 4 and 12).
ZERO BALANCE ACCOUNTS
yes/no
Indicate whether to include zero balance accounts in the report.
SORT BY
predefined
Indicate whether the report should sort by account or name (alphabetical) within the sort area defined above.
GENERATE TASKS
yes/no
Select this checkbox to generate event tasks for qualifying accounts when running this report. Note: Event tasks must be set up previously.
EXPORT
yes/no
Select this checkbox if you want to create an export file.
FILE FORMAT
setup
Select the file map to use for this export. A file map must be set up previously.
FILE NAME
open
You can accept the default file name or modify it.
PRODUCT
setup
Enter the product for which you want to run the report (enter “*” to multi-select products).
START DATE END DATE
date
Enter a date range for the report.
DISPATCH TYPE
predefined
Indicate whether the report should list shortages, complaints, or both.
PRINT ORDER
predefined
Indicate whether the report should sort by area, region, distribution zone, district, service area or truck. Our example sorts by distrib zone.
PRINT ENTITY
predefined
Depending on what you entered in PRINT ORDER, you can indicate a particular district, distribution zone, service area, or truck that should be included in the report. Enter “*” to include all areas.
PRINT FORMAT
predefined
Indicate whether you want a detailed report, a summary, or both.
PRODUCT
setup
Enter the product ID.
START DATE END DATE
date
Enter the date range to be covered by the report.
SELECTION TYPE
predefined
Indicate whether this report should include a particular district, zone, region, or area, or enter all to include all areas.
SELECTION
setup
Enter a particular district, zone, region, or area (depending on the report type entered above) to include in the report, or enter “*” to multi-select. This field is inactive if the report type is “all”.
PRODUCT
setup
Enter the publication to include in this report (enter “*” to multi-select publications).
START DATE END DATE
date
Enter the date range to be covered by the report.
SELECTION TYPE
predefined
Indicate whether this report should include a particular district, zone, region, or area, or all indicate all routes.
DISTRICT OPTION
predefined
If a district should be sorted by district manager, enter detail here. Otherwise enter summary. If you select “detail”, information for old and new district managers will be reported separately.
SELECTION
setup
Enter a particular district, zone, region, or area (depending on the selection type entered above) to include in the report, or enter “*” to multi-select. This field is inactive if the report type is “all”.
DELIVERY TYPE
predefined
Enter the route type you want included in the report, or enter “*” to multi-select route types. Only routes with the selected route types will appear on the report. See Route Type in the Setup Manual for more information.
COMPLAINT CODE OPTION
predefined
The reason code for a complaint can be changed after the complaint is processed. In this field, indicate whether to use the actual reason code for the complaint on the END DATE entered above, or the complaint’s current reason code.
DATABASE
display
Name of the database.
START DATE, END DATE
date
Enter a date range for which the report is to be extracted.
FILE NAME
open (30)
Enter the file name for the export.
PRODUCT
setup
Enter the publication to include in the report, or enter “*” to multi-select.
START DATE END DATE
date
Enter a date range for the report. Only draw that has been billed during this date range will be included.
INCLUDE MAIL, COPY RATE
yes/no setup
Indicate whether mailed draw should be included on the report. If it is, specify the copy rate that should be used to determine revenue for mailed draw.
The Revenue Comparison report is used to compare subscriber revenue (from revenue and grace-owed records) to the delivery cost (i.e., account credits) of the same period. In non-update mode, the report lists any discrepancies between the two. In update mode, it lists the discrepancies and also creates an adjusting GL batch with the journal code of “RevAdj”. A field in Publication Setup, Discrepancy GL Account, is used to identify the GL account to which adjusting entries are added.
Before running this report, be sure to run the Unearned Revenue and Grace Due reports in update mode. Then, run the Revenue Comparison report for the same time period.
Select Revenue Comparison from the Management menu to display the Revenue Comparison Report window.
Click Add and complete the following fields.
ALL ACCOUNTS
yes/no
By default, All Accounts is selected, but you can specify account ranges by clicking the Account Ranges Entry button. This will display another window where you can specify the product and ranges of account IDs to include.
PRODUCT
setup
If All Accounts is selected, enter the product.
START DATE END DATE
date
Specify the date range. The date range must match the date range of the Unearned Revenue and Grace Due reports, which must be run before comparing revenue.
REPORT TYPE
predefined
Specify whether you want a Detail or Summary report.
INCLUDE MAIL SUBSCRIBERS
yes/no
Select this checkbox if you want to include the mail portion of the subscription.
UPDATE
yes/no
Indicate if you are running this report in update mode.
Click OK and then Continue to produce the report.
The Retention Analysis Report can be used to indicate which types of starts (promos, solicited, call-ins, etc.) tend to continue with their subscriptions.
Select Retention Analysis from the Management menu to display the Retention Analysis Report window.
Click Add and complete the following fields.
PRODUCT
setup
Enter the product to include in this report.
START DATE END DATE
date
Enter the date range to be covered by the report. If you specify a date range in the future, the report will list starts as they are projected to be in that future date range. However, the status of those subscribers (temp. stop, perm. stop, etc.) will be as of the current date. The also holds for date ranges in the past.
INACTIVE DAYS
integer (3)
Enter the number of days a subscription can be temporarily stopped before it should be thought of as permanently stopped. The report will divide temporary stops into two groups: those that have been inactive longer than the number of days you enter here, and those that have not.
MAX DAYS STOPPED
integer (3)
Any subscriber who has been stopped for less than or equal to the number of days entered in this field will be considered a continuing subscriber. A new Business Rule, What is the maximum number of days a subscription may be stopped and then started to be considered continuous? (Reports section), can be used to establish a default value in this field
SELECTION TYPE
predefined
Indicate whether the report should be sorted by area, region, zone, district, Zip code, or all.
SELECTION
yes/no
Enter the Zip, area, region or district (depending on what type is entered above) to include, or enter “*” to multi-select. If you entered “All” above, this field will be skipped.
Click OK and then Continue to produce the report.
The columns that appear on this report are described below.
Active
Number of subscribers that started within time frame selected and are still active.
Inactive Future Restart
Number of subscribers that started within time frame selected and are now temporarily stopped with a future restart date.
Temp Inactive < x Days
Number of subscribers that started within time frame selected and have been temporarily stopped (with no restart date) for less than the number of days entered in Inactive Days.
Temp Inactive > x Days
Number of subscribers that started within time frame selected and have been temporarily stopped (with no restart date) for greater than the number of days entered in Inactive Days.
Perm Inactive
Number of subscribers who started within time frame selected and are now permanently stopped.
Total Active
(Active) + (Inactive Future Restart).
Total Inactive
(Temp Inactive < x Days) +
(Temp Inactive > x Days) +
(Perm Inactive).
Total Starts
Number of subscribers that started within time frame selected.
Pct. Retention
Total Active / Total Starts.
