MKMS Help

Reporting the Results - An Overview

This Help File Page was last Modified on 04/13/2013

Reporting the Results - An Overview

This Help File Page was last Modified on 04/13/2013

Previous topic Next topic  

Reporting the Results - An Overview

This Help File Page was last Modified on 04/13/2013

Previous topic Next topic  
These Accounts Receivable System Reports provide virtually every revenue related, and sales analysis report you will need to evaluate the Accounts Receivable related financial transactions of your business.
Also, be sure to read the Recurring and Other Revenue Related Reports page.
Charts - Using the Drop-Down Selection List when it is provided, you may include a Pie or Bar Chart as part of some report outputs.
Spreadsheets - Many reports may be exported as an Excel® file.
To view the Accounts Receivable Reports menu, on the Main Menu, Choose Reports and then Select Accounts Receivable Reports.

 

HelpFilesAccountsReceivableReportsList

Accounts Receivable Report Selections

 

Accounts Receivable - there are two options available on the Accounts Receivable sub-menu:
1.The Accounts Receivable Report is the essential listing of all unpaid, or specifically past due, outstanding Invoices with several really useful special selection options.
2.The Accounts Receivable As Of Report provides 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.
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 Receipt Reports - The essential listing of all Receipts with several really useful special date range and selection options are provided within this Sub-Menu.
a)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.
b)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.
c)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.
d)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.
e)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.
f)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 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.
Earned/Deferred Revenue - The definitive report on all Earned and Deferred Revenues for selected accounting periods.
Expiring Contracts - Lists all Subscribers whose Monitoring Contracts are about to expire.
Accounts Receivable Funding - Lists Past Due Accounts for those Dealers (Divisions) for whom your provide Monitoring Services and Dealer Billing, or for Acquired Accounts that you've purchased so you (and/or your Bank/Funding partner) can track their performance.
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.
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.
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 Class.
Sales Taxes Invoiced -  Reports all Sales Tax invoiced within a specified date range for each Tax Class.
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 Class.
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 Dealer Billing is part of that service, this report shows what Recurring Revenue was Billed and what has been subsequently Paid and Allocated.