New Receivables Module Reports

This Help File Page was last Modified on 11/25/2016

<< Click to Display Table of Contents >>

Navigation:  Accounts Receivable System - The Receivables Module > STARK Version 5.1.35.XXXX Accounts Receivable New Features >

New Receivables Module Reports

This Help File Page was last Modified on 11/25/2016

New Accounts Receivable As Of Reporting Capability

The new Accounts Receivable As Of Report - with a user defined As Of Date - has been completely revised and is now presented as a Sortable, Filterable, and Configurable Grid (see the "Understanding Grids" discussion below) with both Print (Print Preview) and Export options

a)It provides an anytime "look-back" and the related Aging information for any Outstanding Balance(s) owed by those Subscribers

b)It lists the Average Monthly Recurring Revenue Amount (AvgRMR) for each listed Subscriber.

c)A Show Detail option offers a detailed view of what was sold on the Invoices making up the Outstanding Balance, and/or any Receipts not been fully Allocated to Invoice(s).

d)The Subscriber Form associated with any line on the List may be displayed with a Double-Click on that line item.

e)Companies who have one or more members of a group of Subscribers assigned to a different Division code can be reported by Division by setting a Filter on the Division column.

f)Display (i.e., View, Print, Export) the Outstanding Balances data for any As Of Date (i.e., Today, or any previous Date in the past for which Sales Invoice and Receipt records have been entered in the MKMS Accounts Receivable System module).

 

When is this Look Back list needed?  

As part of an Accounting Period Closing process which includes the Accounts Receivable module, typically an Accounts Receivable Report is created (and printed to a File or on Paper) to record a snap-shot view of the Company's Receivables that existed at that time.

When you don't have this "look-back" capability:

A reporting (accuracy) problem could occur if the typical type of Accounts Receivable Report was not printed at the end of the month  - before new Sales Invoice and/or Receipt were recorded for the next month.

Thereafter, once Sales Invoices and/or Receipts are posted for the following month, a complex process (i.e., reporting and deducting these new Sales, and then reporting and deducting the new Receipts) is required to recalculate what Accounts Receivable Balance would have existed at the end of the previous month.

This becomes even more difficult as additional months pass before recalculating what the Accounts Receivable Balance should have been at the end of an even "older" month.

 

The solution to this problem is to use this Accounts Receivable (As Of) dialog

The Accounts Receivable (As Of) dialog provides:

i.A List of Subscribers who have Outstanding Balances (i.e., a data grid with this information), plus

ii.Additional columns listing how long (old) those Outstanding Balances are, and

iii.A "look-back" capability so you can view that list of Outstanding Balances as it existed on any Date within any Month (now or in the past)

iv.Assuming that Sales Invoice and/or Receipt records have been entered within the MKMS Accounts Receivable module prior to that Date.

Because this is a true Grid (see the Grids & Lists - Print Preview - Exporting Data chapter for much more information), it also offers the Filtering, Configuration, Sorting, Printing and Export capabilities that are inherently part of an MKMS based data grid - examples of which are discussed later in the chapter.

Again, the solution to this "how much were we owed on?" question is found in this Accounts Receivable (As Of) dialog.

 

To View, Print, and/or Export this Accounts Receivable Outstanding Balances Data:

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

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

Select the Accounts Receivable option

 

Setting Up the Accounts Receivable As Of dialog's data grid Options:

As Of Date - Initially, the default As Of Date field is set as Today (until you make your selections and Select Print or Export) which will provide an "Aged Listing" of all Outstanding Balances owed by Subscribers as of Today.

 

HelpFilesAccountsReceivableAsOfReport

Accounts Receivable As Of Form

 

If the Accounts Receivable Outstanding Balances data for Today is not what needs to be seen (e.g., viewed, reported, saved as a PDF file, or exported), use the Drop-Down Calendar/Date Entry field provided to Choose whatever As Of Date is required.

The only restriction is that Sales Invoice and/or Receipt records must have been entered on or before the Date that is selected.

 

Options - Use the Drop-Down Selection List provided to Choose the type of Invoices that are to be considered when producing this Accounts Receivable As Of report.

 

HelpFilesAccountsReceivableAsOfReport-Options

 

All - All Invoices will be included as long as they have a Balance Due.

Recurring Revenue Only - Only the Recurring Revenue Invoices will be included (assuming they have a Balance Due).

The Show Detail option (see below) is disabled when this option is selected.

Non Recurring Revenue. - Only the Invoices that were not for a Recurring Revenue charge will be included (assuming they have a Balance Due).

The Show Detail option (see below) is disabled when this option is selected.

 

Show Detail - Check this box to display a sidebar drill-down Grid that will list the two (2) Types of data: 1.) Invoice and 2.) Receipt transactions which are affecting the Subscriber's Outstanding Balance and therefore are being Listed.

 

HelpFilesAccountsReceivableAsOfReportShowDetailSidebar

 

1.Invoice - Click the small right arrow } next to the Type : Invoice data line (see the image above) in the Detail Grid to display a List of all Invoices and Credit Memos with an Outstanding Balance for the selected Subscriber.

a.ID - The Invoice Number  listed numerically from lowest to highest.

i.Because this is also functional data grid, you may Click the ID Header Name to sort these Invoices from newest to oldest by the Invoice Number.

b.Gross - The Outstanding Balance owed (based on the As Of date entered - see "As Of Date" above) on this Invoice (the original Total of the Invoice less any Receipts applied to it = Outstanding Balance) .

i.Because this is also functional data grid, you may Click the Gross Header Name to sort these Invoices from highest to lowest (or visa versa) Balance Due.

c.Aged - Number of Days which have passed since the Invoice was created (i.e., its original Sale Date)

i.Because this is also functional data grid, you may Click the Aged Header Name to sort them by Days since Invoiced from oldest to newest (or visa versa).

Double-Click on any Invoice Number to open and view that Invoice Form.

 

Remove the Check from the Show Detail box to hide this sidebar drill-down Grid.

 

HelpFilesAccountsReceivableAsOfReportShowDetailSidebar2

 

2.Receipt - Click the small right arrow } next to the Type : Receipt data line (see the image above) to display a List of all Receipts which have been posted to this Subscriber's Account, and the portion (or all) of that Receipt which has not yet been Allocated to an Invoice.

a.ID - The Record ID of the Receipt listed lowest to highest (based on the system assigned record number).

i.Because this is also functional data grid, you may Click the ID Header Name to sort these Receipts from highest to lowest.

b.Gross - The Amount (i.e., the portion) of the Receipt which has not been Allocated to an Invoice.

i.Whether or not there are Receipts with a remaining Left To Allocate Amount, all Receipt records for this Subscriber will be listed.

ii.Because this is also functional data grid, you may Click the Gross Header Name to sort these Receipts by the remaining Amount left to be allocated.

c.Aged - Number of Days which have passed since the Receipt was posted (i.e., its original Date Received).

i.Because this is also functional data grid, you may Click the Aged Header Name to sort these Receipts based the Number of Days since you posted those Receipt from this Subscriber.

Double-Click on any Record ID to open and view that Receipt Form.

 

Remove the Check from the Show Detail box to hide this sidebar drill-down Grid.

 

Accessing the Subscriber Form for any listed Subscriber who has an Outstanding Balance record.

Double-Click on Subscriber field to open and view that Subscribers Form.

 

Columns - Select which columns of data are to be displayed:

 

HelpFilesAccountsReceivableAsOfReportOptions

Accounts Receivable As Of Form - with Field selection options - The Check has been removed from several fields (they are hidden)

 

Click the asterisk (¬) at the left of the data grid's Header row (see the mouse pointer in the illustration above) to display a list of all of the column names - and associated data - which may be displayed.

By default, all Column Names will be Checked.

Remove the Check mark (Click on the Check to remove it) to hide that column of data from the data grid.

 

 

Understanding Grids

Grids are used extensively through this new version of MKMS.

Setting the Order in which the data in the grid is Listed within the Accounts Receivable As Of Form (Report):

The default sorted order of the Accounts Receivable As Of List is based on the Subscriber's Name - which is ordered from lowest to highest (1 - 9, a-z, then A - Z).

Thereafter, the column that determines the sorted order of the List may be easily changed, whenever needed.

 

HelpFilesAccountsReceivableAsOfGridHeader-ResortByColumn

Accounts Receivable As Of Form - Data Grid sorted by Balance - lowest to highest

To do so:

Click another column's Header Name (the mouse points to the sorting arrow within the Balance Header Name in the illustration above) to change the sorted order to by on that column of data, with the sorted order automatically set from lowest to highest (a-z or 1 - 9).  

To change this newly selected column's sorted order from highest to lowest, Click that column's Header Name again.

An Arrow next to the Header Name indicates the column that is determining the sorted order of the Grid Data.

o~ indicates lowest to highest (a-z or 1 - 9)

o indicates highest to lowest (z-a or 9-1).

 

Creating various Custom Filters for the Accounts Receivable As Of dialog's data grid.

Filtering the data that will be displayed in the grid:

Once the specific columns that are to be displayed have been chosen, and the sorted order in which those columns will be listed is set, then one or more additional filters may be applied to the listed data, if desired.

 

HelpFilesDataGridSpecialSelectionIcon

 

Special Selection - Click the Special Selection Icon (see mouse pointer next to the Balance header name illustrated above) associated with that column's Header Name to display its associated Drop-Down Selection List

 

HelpFilesAccountsPayableAsOfGridHeade-SpecialSelectionOptionsList

 

The List will contain the available options available for that column's Header Name

The List that is presented contains each item in that column (in this case, each Balance Amount)

In the example above, the Balance column will contain the list of available Amounts and a Check Box is positioned next to each Amount

Check each Amount that is to be included.

Any remaining un-checked Amounts will disappear from the Form's data grid.

 

Sometimes the User may need a more refined method to Choose which Data will be included in the Accounts Receivable As Of Form's data grid.

To accommodate this need, the Special Selection Icon's Drop-Down Selection List (see illustration below) also offers a "(Custom...)" option.

 

HelpFilesAccountsPayableAsOfGridHeade-SpecialSelectionCustomOption

 

This Custom Filter option is available whenever the Special Selection Icon is displayed - which is anytime the mouse pointer is positioned over a Header Name in the Grid - and is accessed by Clicking that Icon and then Choosing the (Custom...) option.

 

When the Custom Filter option is selected, the Custom Filter dialog is displayed.

The first filtering choice is "Show rows where" with the selected Header Name shown below.

If a previously defined Special Selection was entered for the selected column (as was documented and illustrated above), that Header Namet will be entered automatically as shown below.

 

HelpFilesAccountsPayableCustomFilterDialog

 

To (re-)define this initial filtering criteria, the User is requested to quantify how the selected column's data should compare to a value (or a different field) in one or two situations (e.g., one comparison, an OR comparison, or an AND comparison).

 

Using the illustration below (unrelated to the illustration above and based on a column containing Dates rather than Amounts) as a training example, let's assume the User needs to see Subscribers Last Payment

 

HelpFilesAccountsReceivableCustomFilterDateDialog

 

Using the first Drop-Down Selection List the User would choose the first "comparative" phrase from the list provided.

 

HelpFilesSubscribersFormGridCustomFilterDialogComparisonOptions

Then, the User would enter the value to be compared, and because the system knows it will be a Sale's Date, it offers a Drop-Down Calendar/Date Entry field from which a Date may be chosen.

Next, the AND button is selected (by default) - but this may be changed, if appropriate; or ignored if no additional comparison is needed (e.g., any Payment Dated on or after 10/01/2015 would be acceptable)

Assuming a comparison is needed (it would be in this case), use the second Drop-Down Selection List to choose the other "comparative" phrase from the list provided.

Finally,  the User would enter the other value to be compared, and because the system knows it too will be a Payment Date, it offers a Drop-Down Calendar/Date Entry field from which a Date may be chosen.

 

HelpFilesAccountsReceivableCustomFilterDateDialogSaveButton

 

Click OK and the Custom Filter is implemented.

 

When a Custom Filter is active, that Filter Criteria is displayed at the bottom of the Grid.

The User may Check and un-check the Filter Criteria box (see hand pointer in the illustration below) to quickly see the data differences when the filter is active, or inactive

 

HelpFilesAccountsReceivableCustomFilter

 

To Cancel the Custom Filter, Click on the Close box on the bottom left side of the Filter Criteria line (see mouse pointer in the illustration above) and that Custom Filter will be canceled.

 

Enhancing the Custom Filter:

Once defined, a Custom Filter may be further refined or expanded by Clicking the "Customize..." button at the bottom right side of the Filter Criteria line (see illustration immediately above).

The Filter Builder dialog will be displayed with the original Custom Filter information already inserted, plus any additional customized filter you enter.

 

HelpFilesAccountsReceivableCustomize-FilterBuilder

 

press the button to add a new condition - Click this button bar to insert a new filter line

By default, the first field name in the Header will be displayed (i.e., Subscriber ID).

Click that Subscriber ID field name to open a Drop Down Selection List of all available field names.

Choose the desired field name and it will replace the original default Vendor ID field name.

equals will be the default logic name displayed next to that field name.

Click that equals logic name to open a Drop Down Selection List of all available logic names.

Choose the desired logic name

Enter the appropriate condition Value.

Repeat this process as needed to define the filter that is needed.

Save - If you will need to use this exact filter again, Click the Save As... button and name this filter.

Apply - To implement this filer, Click the Apply button.

 

Printing the Accounts Receivable As Of dialog's data grid:

Print - Once you have:

a)Chosen which columns of data are to be included,

b)Set the order in which they are to be listed, related any columns (if appropriate),

c)Adjusted any column's width,

d)Then, you are ready to Print the resulting Accounts Receivable Report.

 

Click the Print Icon at the top of the Form to display the Print Preview dialog.

 

HelpFilesAccountsReceivableAsOf-PrintPreview

 

The Print Preview dialog will be displayed exactly as the data grid was formatted.

It is easy to Close the Print Preview, make formatting adjustments (if needed), then Click the Print Icon again until you have the Accounts Receivable report displayed in the Print Preview dialog exactly as needed.

The example below illustrates how an Accounts Receivable Report may ultimately be customized, formatted and printed (or exported as a PDF file).

 

 

New Earned & Deferred Revenue Reporting Capability

Earned and Deferred Revenue is a somewhat complex concept.

Basically, every Sales Invoice that is issued will normally be considered "earned" when it is created within the context of the every day accounting concepts with which most of us are familiar.

However, in the case of Recurring Revenue, those Sales Invoices are almost never fully "earned" when they are "billed" to the Subscriber.

This is because the Invoices for this Recurring Revenue are created a month (or a least a week or so) in advance of when the next period of service begins.

 

So technically, when the money for those Recurring Revenue Sales Invoices is received before the entire period of service (for which they were Invoiced) has ended:

Those Receipts are deposited (and that income is often spent) before those services have been fully provided.

Therefore (that income) those Receipts, for that period of service time, would be considered unearned.

 

The new Deferred Revenue (Daily View) dialog provides a listing in a Grid format (see the "Understanding Grids" discussion above) of the pending Deferred Revenue records including the associated General Ledger information (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.

There are two ways to access the Deferred Revenue dialog:

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 Deferred Revenue (Daily View) option.

 

HelpFilesDeferredRevenueDialog

Deferred Revenue dialog

 

Using the Deferred Revenue dialog

As Of Date - If the Deferred Revenue Amounts that exist as of Today is not what needs to be listed (e.g., viewed, reported, saved as a PDF file, or exported), use the Drop-Down Calendar/Date Entry field provided to Choose whatever As Of Date is required.

The only restriction is that Sales Invoice and/or Receipt records must have been entered on or before the Date that is selected.

 

Look Up - Accessing the Subscriber and/or the Subscriber Form for any listed Deferred Revenue record.

Click on Deferred Revenue record and select either the Subscriber or Invoice Icon to open and view the associated Subscribers Form.

 

Columns - Select which columns of data are to be displayed:

 

HelpFilesDeferredRevenueDialog-Columns

 

Click the asterisk (¬) at the left of the data grid's Header row (see the hand pointer in the illustration above) to display a list of all of the column names - and associated data - which may be displayed.

By default, all Column Names will be Checked.

Remove the Check mark (Click on the Check to remove it) to hide that column of data from the data grid.

 

Sort - Setting the Order in which the Deferred Revenue dialog's data grid is Listed within the Deferred Revenue Form (Daily View):

The default sorted order of the Deferred Revenue List is based on the Subscriber (Name) - which is ordered from lowest to highest (1 - 9, a-z, then A - Z).

Thereafter, the column that determines the sorted order of the List may be easily changed, whenever needed.

 

Filter - This list may be filtered, as needed to choose the data that is actually needed

 

Search - Click the Find Icon HelpFilesNavigatorMenu-StandardSearchon the Ribbon Menu at the bottom of then Detail Data Grid to open the Search-Find-Clear dialog (see the Detail Data Grid Ribbon Menu chapter for additional instructions)..

 

HelpFilesDeferredRevenueDialog-Search

 

Output - The data is presented in a Grid format and therefore has all of the normal Grid features and functions such as Sorting, Relocating, and Filtering the data presented before it is Printed as a report, and/or Exported to a file.

a)Chose which columns of data are to be included,

b)Set the order in which they are to be listed, related any columns (if appropriate),

c)Adjust any column's width,

d)Then, when ready:

i.Print - Click the Print Icon at the top of the Form to display the Print Preview dialog.

ii.Export - Click the Export Icon to display Save as... Windows® dialog.

 

The new Deferred Revenue Report tells how must Revenue may be (has been) Deferred as of a specific Date.

There are two ways to access the Deferred Revenue dialog:

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 Deferred Revenue option.

 

Deferred Revenue tabs - There are three tabs on the Deferred Revenue dialog.

Options - Initially only the Options tab is shown (until you make your Options selections and Select Print).

 

HelpFilesEarned&DeferredRevenueReportOptions

Earned/Deferred Revenue - Options tab

 

As Of - By default, the Date offered will by Today.

Use the Drop-Down Calendar/Date Entry field provided to Choose a different As Of Date for this Earned/Deferred Revenue, if needed.

 

Department - By default, the Earned and Deferred Revenue Amounts for All Departments will be included, but this report may also be limited to a selected Department.

Use the Drop-Down Selection List provided to Choose a specific Department to be the only one reported.

 

Division - By default, the Earned and Deferred Revenue Amounts for All Divisions will be included, but this report may also be limited to a selected Division.

Use the Drop-Down Selection List provided to Choose a specific Division to be the only one reported.

 

Sale Item - By default, the Earned and Deferred Revenue Amounts for Sale Items will be included, but this report may be limited to one Recurring Revenue Sale Item

Use the Drop-Down Selection List provided to Choose the specific Recurring Revenue Sale Item which is to be reported.

To report the Earned/Deferred Revenue for an Alarm Dealer - if you are Billing an Alarm Dealer's Accounts, use the Drop-Down Selection List provided to Choose the Division or Division Group for that Alarm Dealer, .

 

Account - By default, the Earned and Deferred Revenue Amounts for General Ledger Account assigned to Recurring Revenue Sale Items will be included, but this report may also be limited to a specific General Ledger Account assigned to a set of one or more Sale Item(s).

The same General Ledger Account may be assigned to more than one Recurring Revenue Sale Item.

Use the Drop-Down Selection List provided to Choose the specific General Ledger Account assigned to Sale Item(s) which is to be reported.

 

Exclude Sale Dates After As Of Date? - Check this box to any Recurring Revenue Invoice with a Sale Date which is after the As Of Date selected above.

To report the Deferred Revenue for only One Division (or Alarm Dealer - if you are Billing an Alarm Dealer's Accounts), use the Drop-Down Selection List provided to Choose that Alarm Dealer, Division or Division Group.

 

Print - Click the Print button to Preview and optionally Print (to a File or a Printer) this Deferred Revenue Report.

Do you bill a month in Advance? - Unless the Sale Date - of the Invoices created for Recurring Revenues - falls within the actual time period in which the service(s) being billed will also actually be provided,

 

HelpFilesDoYouBillAMonthInAdvance

 

Remember answer and don't ask again - Check this box if this should be the default answer.

oThis setting may be changed later by resetting the Bill In Advance option to False ("F") in the Company Settings Form.

To Exit this Report dialog, Click the Cancel button toward the bottom of the Options tab.

 

Preview - The Preview tab presents the report which resulted from the Options you've selected.

Up Arrow/Down Arrow - hi - Moves the report one line up, or one line down, respectively.

Page Up/Page Down - Moves the report to the previous or next page, respectively.

 

HelpFilesEarned&DeferredRevenueReportPreview

Deferred Revenue Report - Preview tab

Home - HelpFilesHomeKey- Using either the screen Icon or your Keyboard's Home key, moves the report to the top of the first page.

End - HelpFilesEndKey- Using either the screen Icon or your Keyboard's End key, moves the report to the bottom of the last page.

Arrows - The arrows allow you to move back and forth, from page to page.

Number - Indicates the page number you are viewing.

You may also type in a specific page number, Press 8 Enter and that page will be displayed immediately.

If you enter an invalid page number, it will be ignored.

Fit To Page - Click the first button after the arrows to size a full page of the report to fit the screen.

Zoom To 100% - Click the second button after the arrows to display the page at 100% (of the printed view).

Fit To Page Width - Click the third button after the arrows to size the page of the report to fit the full width of the screen.

Zoom To Percentage - Click the fourth button after the arrows to re-size the page of the report by percentage.

 

HelpFilesPercentageOfViewAdjuster

When you Click the Zoom To Percentage button, the Percentage selector will be displayed.

You may then Click the Up  or Down arrow to set the exact amount of Zoom you want.

 

HelpFilesEarned&DeferredRevenueReportPreview2

Deferred Revenue Report - Preview tab - with Summary Recap and GL data

 

Print - Click the Print button to Print (to a File or a Printer) HelpFilesPrintIconthe displayed Deferred Revenue Report.

See Printing to a File for additional information ion how to save this report in several different file formats.

Email - Click the Email button HelpFilesEmailButtonto send the Report to an Email Address of your choosing.

Exit the Form by Clicking the Close button (  X  ) on the right at the top of the Form.

 

Data View - This view provides a tabular (spreadsheet style) presentation of the selected data.

 

HelpFilesEarned&DeferredRevenueReportDataView

Deferred Revenue Report - Data View tab

 

Arrows - Click the arrows to move through the record.

Export - Exporting the data from this Data View tab (note the "fly-over" help available on these buttons):

Export to CSV - Click the first button after the arrows to export the data to a Comma Separated Values (CSV) file format.

Export To Excel - Click the second button after the arrows to export the data to an Excel (.xls) file format.

Export To Html - Click the third button after the arrows to export the data to an HTML formatted file.

To Exit the Data View tab and Close this Report dialog, Click the Close button on the right at the top of the Data View tab.

 

For General Ledger System Users:  We suggest you use the automated Post Deferred Revenue procedure, but this process may be done manually, if desired.

This Deferred Revenue Report may be used as their General Journal Entry manual posting guide to distribute the Earned and Deferred revenues on a Monthly Basis.

That portion of the revenue that was able to be deferred into the next taxable year is defined in your Balance Sheet as a "Deferred Revenue" Liability Account.

 

The General Journal Entry required to post the Deferred Revenues at the end of the year is to Debit each of the General Ledger Sales Account(s) containing the Deferred Revenue Amounts, and Credit the Deferred Revenue Liability Account for the total of that Deferred Revenue.

 

Then, each month in the following year you must recognize that portion of the Deferred Revenue that was subsequently Earned in each of those months.

This is done by Debiting the Liability account for the earned revenue and Crediting each of the Sales account(s) for that portion that was earned within that sales category.

 

HelpFilesEarned&DeferredRevenueReportSample

Deferred Revenue Report - Summary Recap and GL data

 

 

The new Earned Revenue Report tells your Company how much of the previously Deferred Revenue has subsequently been Earned.

This Earned Revenue Report tells your Company how much of that previously Deferred Revenue has subsequently been Earned.

It will itemize the Amounts of the previously Deferred Revenues that have now been earned during the chosen Accounting Period (e.g, within either a designated Month, or a designated Year)

It will be provided in either a Detailed, or a Summarized format, as requested by the User.

For General Ledger System Users, the associated General Ledger Accounts, and the Earned Revenue Values for each, are included in this Earned Revenue Report.

 

There are two ways to access the Earned Revenue Report dialog:

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 Earned Revenue by Month option.

 

Earned Revenue tabs - There two three tabs on the Earned Revenue dialog.

Options - Initially only the Options tab is shown (until you make your Options selections and Select Print).

 

HelpFilesEarnedRevenueReport-OptionsTab

 

 

Report Type - Choose either a Detailed, or a Summarized format

Detail - Click this button to view a report formatted as shown immediately below:

 

HelpFilesEarnedRevenueReport-PreviewTab

 

Summary - Click this button to view a report formatted as shown immediately below:

 

HelpFilesEarnedRevenueReport-PreviewTab-Summary

 

 

Sales Code(s) - Specify whether All or one Recurring Revenue Sales Category will be listed.

All is the default, but you may Click the One button and use the Drop-Down Selection List provided to Choose one Recurring Revenue Category to be reported.

 

HelpFilesEarnedRevenueReport-SalesCodesOption

 

Report Period - Choose whether a One Month or One Year is to be reported

By default One Month is selected and the Date Range representing the most recently completed Month is inserted automatically.

HelpFilesEarnedRevenueReport-DateRange

 

One Year - If this will be an annualized report, Click the One Year button.

If One Year is selected, the Date Range representing the most recently completed Year is inserted automatically.

Date Range - Then, whether reporting for One Month or One Year, if it will be different than the default (i.e., the most recently completed Month or Year based on whether One Month or One Year was chosen), identify the Date Range to be used by entering the Start Date and End Date of that Date Range using the Drop-Down Date/Calendar Selection Boxes provided.

 

Do you Bill in Advance of Month? - Check this box unless the Sale Date - of the Invoices created for Recurring Revenue Invoices falls within the actual time period in which the service(s) being billed will actually be provided

 

Division - By default all Earned Revenue from all Divisions and Division Groups will be reported

To limit this Earned Revenue Report to listing those Earned Revenues from one Division or Division Group only, use the Drop-Down Selection List provided to Choose that Division or Division Group.

 

Print - Click the Print button HelpFilesPrintButton to Preview and optionally Print this Earned Revenue Report.

To Exit this Report dialog, Click the Cancel button toward the bottom of the Options tab.

 

Preview - The Preview tab presents the report which resulted from the Options you've selected.

Up Arrow/Down Arrow - hi - Moves the report one line up, or one line down, respectively.

Page Up/Page Down - Moves the report to the previous or next page, respectively.

 

HelpFilesEarnedRevenueReport-PreviewTab

Earned Revenue Report - Preview tab

Home - HelpFilesHomeKey- Using either the screen Icon or your Keyboard's Home key, moves the report to the top of the first page.

End - HelpFilesEndKey- Using either the screen Icon or your Keyboard's End key, moves the report to the bottom of the last page.

Arrows - The arrows allow you to move back and forth, from page to page.

Number - Indicates the page number you are viewing.

You may also type in a specific page number, Press 8 Enter and that page will be displayed immediately.

If you enter an invalid page number, it will be ignored.

Fit To Page - Click the first button after the arrows to size a full page of the report to fit the screen.

Zoom To 100% - Click the second button after the arrows to display the page at 100% (of the printed view).

Fit To Page Width - Click the third button after the arrows to size the page of the report to fit the full width of the screen.

Zoom To Percentage - Click the fourth button after the arrows to re-size the page of the report by percentage.

 

HelpFilesPercentageOfViewAdjuster

When you Click the Zoom To Percentage button, the Percentage selector will be displayed.

You may then Click the Up  or Down arrow to set the exact amount of Zoom you want.

 

HelpFilesEarnedRevenueReport-PreviewTab-Summary

Earned Revenue Report - Preview tab - with Summary Recap and GL data

 

Print - Click the Print button to Print (to a File or a Printer) HelpFilesPrintIconthe displayed Earned Revenue Report.

See Printing to a File for additional information ion how to save this report in several different file formats.

Email - Click the Email button HelpFilesEmailButtonto send the Report to an Email Address of your choosing.

Exit the Form by Clicking the Close button (  X  ) on the right at the top of the Form.

 

There is also a The new Accounts Receivable Collections 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