History for Outstanding Balances (history as of 2/19/2019 11:10:06 PM)

Overview

This report allows you to view what money is owed from applicants to the provider, according to Online Mooring's records.  It can also be used to view when money WILL BE owed from applicants to the provider.

It is very import to run this report and correct and problems BEFORE doing having people renew their permits.  Online Mooring will attempt to collect fees that it thinks are outstanding, in addition to any new fees incurred during the processing of the renewals.

Report Options

There are two options that control the contents of the report.

Include Projected Actions - If you check this box, then we will run the report including fees that we expect to happen during the current year.  This would include an action for all active applications that have not yet had a Submitted action this year.  

Include Fee Calculation Errors - If you checked the "include Projected Actions" box, it is possible that we are unable to calculate the fee that will be charged for an application, because the database does not contain values for all the fields used to calculate the fee.  Normally, these errors are excluded from the report, but if you check the box you will see all of the applications listed.  Applications with errors will have a negative value in the FeesCharged column, and a value of 1 in the FeeCalcRowError.    Even if you don't include these errors, you can see whether there were any errors by looking at the FeeCalcReportError column, which will contain the value TRUE if there were any errors in any application.

Page Content

You can view the report in one of two ways:  as a PDF file, or as a CSV file (which is viewable in Microsoft Excel and other software packages).  Click the "View Report" button to generate the PDF file, and the "Export Data" button to generate the CSV file.  The CSV file contains additional information that cannot fit on a single page.

Each row in the report lists an Application Action that has not been fully paid.  There are a number of reasons why an action might be listed here:
1)  The applicant didn't pay the required fee at all.  In this situation, you will not see a payment in the Payments section of the application during the appropriate timeframe.
2)  The applicant tried paying the fee online, but the credit card was rejected.
3)  The applicant paid by check or in person, and the "offline" payment was never recorded in the database.  You can reconcile your bank deposits versus Online Mooring's records by running the Payments Report.
4)  The applicant paid their required fee, but Online Mooring incorrectly lists the fees that the applicant owed.  Check to make sure that there aren't any duplicate charges (two submittals for the same year, for example), and delete the extra unpaid charge if it is there.

Navigation

To get to this page, click the Reports > Financial Reports > Balances option from the menu.

Security

To view this page, the user needs Reports_View rights.  

|<< Back |