Wholesale Collections Report

This Help File Page was last Modified on 0324/2017

<< Click to Display Table of Contents >>

Navigation:  Accounts Receivable System - The Receivables Module > Receivable Reports - An Overview >

Wholesale Collections Report

This Help File Page was last Modified on 0324/2017

If you are operating a Contract Central Station and your Company is also billing the Alarm Dealer's Monitoring Accounts, this Wholesale Collections Report will report what Recurring Revenue was Billed and what Recurring Revenue was subsequently Paid and Allocated.

Requirements - There are a few things that must be done to ensure the results of this report will be reliable:

Each Subscriber, for whom your Company is are providing monitoring services for another Alarm Dealer, must be assigned the Division code for that Dealer (see the Billing an Alarm Dealers Accounts chapter for related information).

The Automatic Billing entry for the Alarm Dealer's Subscribers must have a Wholesale Rate assigned (see the "Wholesale Group Section" in the Defining Open Term Recurring Billing chapter for more information).

Capabilities - The Wholesale Collections Report will list the amounts Invoiced and Collected, plus any Amount your Company is still owed.

 

To access the Wholesale Collections Report dialog:

a)From the Backstage Menu System Select Reports and Choose Wholesale Collections Report, or

b)From the Quick Access Menu, Select Reports and Choose Wholesale Collections Report

On the Receivable Reports Menu, Choose the Wholesale Collections option to display the Wholesale Collections Report dialog shown below.

 

Wholesale Collections Report tabs - There are three tabs on the Wholesale Collections dialog.

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

Identify the period to be reported, what Division(s) to include, and how much information to include.

 

HelpFilesWholesaleCollectionsReportOptionsDialog

Wholesale Collections Report - Options tab

 

Year - By default, it will be the Year of Next Month.  

To change the Year, use the Drop-Down Selection List.

Month - By default, it will be the current Month.

To change the Month, use the Drop-Down Selection List.

Cycle - By default, it will be the first Recurring Billing Cycle (ordered alphabetically) .  

To change the Cycle, use the Drop-Down Selection List.

Division - By default, All Divisions will be included.  

To select a specific Division, use the Drop-Down Selection List.

Show Invoice Detail? - To include the line item detail of each Invoice that was Paid, Check this box.

Print - Click the Print button HelpFilesPrintButton to Preview and optionally Print (to a File or a Printer) this Wholesale Collections report (see sample below).

To Exit this Report dialog, Click the Close button HelpFilesReportDialogCloseButton 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.

 

HelpFilesWholesaleCollectionsReportPreview

Wholesale Collections 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.

Subscriber Record Number - Click the record number (listed in blue and underlined) of any Subscriber to open the Subscribers Form for that Subscriber.

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

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

To Exit the Preview tab and Close this Report dialog Form, Click the Close box HelpFilesCloseBoxon the right at the top of the Preview tab.

 

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

 

HelpFilesWholesaleCollectionsReportDataView

Wholesale Collections Report - Data View tab

 

Note: The Sales Tax amount shows as a minus value because this revenue belongs to the Taxing Authority, not your Company or the Dealer.

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 Preview tab and Close this Report dialog Form, Click the Close box HelpFilesCloseBoxon the right at the top of the Preview tab.