Receivable Reports - An Overview

This Help File Page was last Modified on 11/09/2017

<< Click to Display Table of Contents >>

Navigation:  Accounts Receivable System - The Receivables Module >

Receivable Reports - An Overview

This Help File Page was last Modified on 11/09/2017

These Accounts Receivable System Reports provide virtually every revenue related, and sales analysis report needed to evaluate your Company's Accounts Receivable related Financial Transactions.

Charts - Using the Drop-Down Selection List when it is provided, a Pie or Bar Chart may be included as part of some report outputs.

Spreadsheets - Many reports may be exported as an Excel® file.

There are two ways to view the Receivable Reports Menu:

a)From the Backstage Menu System Select Reports and Choose Receivable Reports, or

b)From the Quick Access Menu, Select Reports and Choose Receivable Reports.

Then, Select the desired Receivable Reports Menu option.



Receivable Reports options


Accounts Receivable Collections - The Accounts Receivable Collection Report is a multi-purpose Report that assists in the management and Collection of Past Due Accounts, offers a one page Accounts Receivable Summary format with or without a Chart, and can offer a snap-shot view of the Company's potential Cash Flow, a list the Average Monthly Recurring Revenue being billed to each Account, or list those Dealers (Divisions) for whom your Company provides Monitoring Services and is also billing those Alarm Dealer's Monitoring Accounts

Accounts Receivable Report - The Accounts Receivable (As Of) Report is the essential listing of all unpaid, or specifically past due, outstanding Invoices with several really useful special selection options and provides a current, and a snap-shot view of Accounts Receivable balances for any Month in the past - regardless of whether that Month has been Closed or is still Open - even when additional Sales and/or Receipts have been posted beyond those Months.

RMR Differential (attrition Reports) - Based on the Acquisition and Attrition information entered in the Auto Billing, when an Account is acquired, and when it is lost, this report lists those Subscribers that were acquired or lost within a specified date range, and why it occurred.

Auto Draft Accounts - With many report options, it lists Accounts that pay automatically via Credit Card or an ACH Debit.

Average Recurring Revenue - Allows you to accurately report the average monthly amount of each Types of Recurring Revenue that you bill, and provides additional formatting, and detailed reporting, options.

Billing Cycles - Lists each Subscriber that is automatically billed for their Recurring Revenue, separated by each of your Recurring Billing Cycles, and for what Types of Recurring Revenue they are being billed.

Bill Payer Listing - Provides many options to filter and refine the content of the list of Bill Payers.

Cash Receipts - This report provides the detail as to the way in which the Receipts were paid (e.g., Cash, Check, Credit Card), the Date and Batch number used when those Receipts were posted, and from whom those Receipts came.

Cash Receipts by Employee - This report allows the User to specify which Receipts are to be listed based on which Employee Posted the Receipts, on the Sales Date or Receipt Date of those Receipts, within a specified Date Range.

Cash Receipts by Payment Method - This report provides a summary list of all, or a selected set of (one or more) Receipts by Date, for each Day within a specified Date Range of All, or filtered for a selected set of (one or more of the 8 possible) Payment Methods.

Cash Receipts by Sales Category - This report lists what was the paid and the allocated dollar volume of each Sales Category and what was the paid and allocated unit volume of each Sales Category based on a specified Date Range.

Cash Receipts by Salesman - This report is produced based on a selected Date Range, Bank (into which the Receipts were deposited), and/or Division; and lists those Paid Sales by (selected or all) Salesperson(s), by Sales Category and provides other Sales Invoice, Receipt and Allocation information, as well.

Cash Receipts Summary by Month - This report  lists each (or a specified) Batch Number and the Total Amount received for the specified Month and Year.

Cash Receipt Totals - This report creates a spreadsheet like list with columns for each of (up to) the past five full years plus the current year, the months of each year are listed on the left, and the value of the Receipts that were posted for each Month.

Credits Issued - The listing of all Credit Memos created with date range and format selection options.

Customer Deposit - This report displays a Grid with all of the designated Receipts listed (based on the Option selected) which may be Printed and/or Exported, as needed.

Customer Ranking Report - Provides a list of those Subscribers including the Account Name, ID and (based on the selected report options) Amount identifying the Top 5 (10, or 20) Customers based on one of three selection criteria (Recurring Revenue, Invoices, or Receipts) within a User designated Date Range.

Optionally, a Bar Chart and Legend graphing the results may be requested.

Deferred Revenue (Daily View) - Provides a listing of the pending Deferred Revenue records (those Recurring Revenue Sales Invoices which have yet to be recorded as fully Earned) which may be Printed as a report, and/or Exported to an Excel style Spreadsheet.

Deferred Revenue - The report tells your Company how much of that previously billed Recurring Revenue has to be Deferred.

See the Earned and Deferred Revenues chapter for more information.

Earned Revenue by Month - This report tells your Company how much of that previously Deferred Revenue has subsequently been Earned.

Expiring Contracts - Lists all Subscribers whose Monitoring Contracts are about to expire.

Fixed Term Recurring Revenue - The Fix Term Recurring Revenue dialog's data grid lists those Subscribers who have Fix Term Recurring Revenue record(s) defined - including those that are currently Inactive (or only still Active Fix Term Recurring Revenue records) - and shows the details of those Fix Term Recurring Revenue records - including any outstanding Balance - with this data presented as a Grid

Inventory Replacement Value - The Inventory Replacement Value dialog lists those Sale-Purchase Items identified as Inventory Items with the associated On Hand quantities, Warehouse, replacement Cost, and Total (current) Value - presented as a Grid

Invoices - Comprehensive Invoice Printing capability, allowing a precise selection of specifically which Invoices will be (re-) printed.

Any predefined Custom Report Formats  for Invoices may also be accessed.

Invoice Statements -  Lists all of the Open Invoices (only Invoices with a Balance that is Unpaid) for One or All Subscribers, with or without Detail.

Outstanding Invoices

Quality of Sales - Graphs a basic analysis of the quality of the Accounts Receivable being added to the system.

Recurring Revenue Breakdown - Reports Recurring Revenue Invoiced - by Department - with additional filtering selections for billing frequency and date.

Recurring Revenue Preview - List those Subscribers who will be automatically billed, and for what service(s) they will be billed.

Revenue by Month and Year - Provides a long range view of your Company's gross revenues - separated month over month and year over year to help identify your strong and weak months (if such a pattern exists); and the growth (or lack of it) of your gross annual revenue.

Revenue by Type and Year - Provides a long range analysis of your revenue growth - for recurring revenues, overall sales, sales that are not for-recurring revenue, or any selected group of Sales Categories.

RMR Rate Changes -

Sales Analysis - The essential listing of all Sales - sorted by their Sales Category Codes - with date range and other selection options.

Sales Categories - Provides a list of all the Sales Category Codes that have been defined.

Sales Taxes Collected - Reports all Sales Tax collected within a specified date range for each Tax Rate ID.

Sales Taxes Invoiced -  Reports all Sales Tax invoiced within a specified date range for each Tax Rate ID.

Sales Taxes Breakdown - For those companies that have multiple jurisdictions (local, city, county, state etc.) that are sharing the sales tax percentage charged, reports all Sales Tax Collected, or Invoiced - based on your selection - within a specified date range for each Tax Rate ID.

Subscriber Statements - Prints the Statement of Accounts for Subscribers based on your special criteria.  

Any predefined Custom Report Formats  for Subscriber Statements may also be accessed.

Unallocated Receipts/Credits - Lists each Receipt and/or Credit Memo that has yet to be allocated to an invoice.

Wholesale Collections - For those operating a Contract Central Station and providing the Billing of the Alarm Dealer's Monitoring Fees as part of that service, this report shows what Recurring Revenue was Billed and what has been subsequently Paid and Allocated.

Wholesale Groups Report - This report lists the Wholesale Rate that was Paid (indicating your Company's share) from the Allocations of Receipts from Invoices that were generated for Recurring Revenues (based on the specified Date Range of those Allocated Receipts).

Also see the Recurring Revenue Related Reports chapter for a list and explanation for the available Recurring Revenue reporting.