Payment plan report

This report displays information about customer payment plans.

 

Each customer's payment plans are listed, including the payment plan number, date created, receipt number, billing cycle, first payment date, amount charged and paid, and balance due.

 

The report also displays credits linked from other accounts (and linked credit is subtracted from the balance due).

 

Tip: Click the Recall / Schedule a saved report definition button at the top of the page to go to the Report Definitions page, and select a previously saved report definition.

Location

Reports > Financial Reports > Payment Plan

Filters

Set up the following filters:

Customer

    1. Click the Customer link to open the Customer Search pop-up dialog box.

    2. Enter your search criteria, then click Search.

    3. Select the customers you want to include, then at the bottom of the page, click Add All Selected.

    4. Click Done to close the pop-up dialog box and return to the report.

Company

    1. Click the Company link to open the Company Search pop-up dialog box.

    2. Enter your search criteria, then click Search.

    3. Select the companies you want to include, then at the bottom of the page, click Add All Selected.

    4. Click Done to close the pop-up dialog box and return to the report.

Purchase Date

    1. To select a From Date (start of the range), click the calendar button.

    2. Click a date link in the calendar.

    3. To select a To Date (end of the range), click the calendar button.

    4. Click a date link in the calendar.

Only Show Payments Due On

    1. To select a From Date (start of the range), click the calendar button.

    2. Click a date link in the calendar.

    3. To select a To Date (end of the range), click the calendar button.

    4. Click a date link in the calendar.

Revenue Site - Site where the revenue is recognized

    1. Click the Revenue Site link to open the Site List pop-up dialog box.

    2. Enter your search criteria, then click Search.

    3. Select the sites you want to include, then at the bottom of the page, click Add All Selected.

    4. Click Done to close the pop-up dialog box and return to the report.

Transaction Site - Site where the transaction was originally entered

    1. Click the Transaction Site link to open the Site List pop-up dialog box.

    2. Enter your search criteria, then click Search.

    3. Select the sites you want to include, then at the bottom of the page, click Add All Selected.

    4. Click Done to close the pop-up dialog box and return to the report.

Options

Only Show Past Due Balance?

Option to filter out everything from the report except past due balances (payments that did not process successfully).

Only Show Automatic Payment Plan?

Option to filter out everything from the report except data for automatic payment plans.

 

Note: To show only past due balances which originated from the auto-pay process, select both of the options above.

Only Show Flex Registration Payment Plan?

Option to filter out everything from the report except data for Flex Registration programs.

 

Note: Payment plans containing both Flex Registration/Child Care and other modules, are also displayed in the report.

Show Customer Email?

Option to display customer email addresses in the report result.

Include Online Transactions?

Option to include data from transactions that were created on the customer (public access) site.

 

Note: This option is only visible to system users who do not have a multi-site user profile.

 

From the Output Type dropdown list, select a format to display the report:

Running the Report

Click Run Report.

Save Report Definition

To save your settings as a report template:

    1. In the Report Title field, enter a name for the template.

    2. Do one of the following: