Home User Manual Discussion Forum Search

Payment Plan Report  

This report lists guarantors who owe money on a Patient Payment Plan and the total amounts owed.  It is often used with the Aging of A/R Report to determine which patients owe the office money.

Note: To control user access to this report, see Report Setup - Security Permissions.

  1. In the main menu, click Reports, Standard 
  2. In the Monthly section, click Payment Plans.

  1. Select the report criteria:

    Date Range:  To limit the report to plans created in a date range:
    a. Check the Limit to Plans Created in a Date Range box. This is the default selection and enables the Date Start and Date End fields.
    b. In the Date Start field, click the dropdown to select the start date. 
    c. In the Date End field, click the dropdown to select the end date. 
    If you uncheck the 'Limit to Plans Created in Date Range' box, the report will show all plans, regardless of date.

    Payment Plan Types: Select which types of payment plans to include:
    - Insurance (payment plans that have the Track expected insurance payments checkbox selected)
    - Patient
    - Both

    Hide Completed Payment Plans: Check this box to exclude Closed Payment Plans from the report.
    Note: In version 16.1 and earlier, plans were considered 'completed' when the balance was zero and there were no future charges. In 16.2 and greater, a plan has to be closed to be considered complete.

    Show Family Balance: Check this box to show each guarantor's total family balance.
    Providers: Highlight the providers to include. Click All to select all providers.
    Clinics:  If using Clinic(s), select the clinics to include. Click All to select all clinics. The report will be grouped by clinic.

  2. Click OK to generate the report. For a description of toolbar buttons, see Complex Report System.

Provider: The provider attached to the plan.
Guarantor: The guarantor of the plan.
Ins: Indicates insurance payment plans.
Princ: The total principal amount.
Accum Int: Accumulated interest for the plan.
The total amount paid on the plan.
Balance: The current payment plan balance (Princ + Accum Int - Paid).
Due Now:
The amount that is due now.
Balance Not Due: The total payment plan balance that is not yet due (due in the future). (Balance - Due Now). Only shows when the pay plan logic is AgedCreditsandDebits.
Fam Balance:
The total family balance.


Open Dental Software 1-503-363-5432