Run the payment plans report to view a list of payment plans by guarantor that can be filtered.

In Standard Reports, in the Monthly section, click Payment Plans.

This report is often used with the Aging of Accounts Receivable (A/R) Report to determine which patients owe the office money.

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

Filters

Date Range: To limit the report to plans created in a date range:

• 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.
• In the Date Start field, click the dropdown to select the start date.
• In the Date End field, click the dropdown to select the end date.

  Unchecking Limit to Plans Created in Date Range shows all plans meeting the remaining criteria, regardless of date.

Payment Plan Types: Select which types of payment plans to include:

• Insurance: Select to view only Insurance Payment Plans.
• Patient: Select to view only Patient Payment Plans and Dynamic Payment Plans
• Both: Select to view all payment plan types.

Hide Completed Payment Plans: Check to exclude closed payment plans from the report.

Show Family Balance: Check to include Fam Balance column in the report. Shows payment plan guarantor's family balance.

Providers: Highlight the providers to include. Click All to select all providers.

Clinics: Select the clinics to include. Click All to select all clinics, including those that are hidden. The report is grouped by clinic.

Report Preview

After setting the report filters, click OK to launch a print preview of the report results. Below is an example of the report and descriptions of each column of the report.

For a description of toolbar buttons, see Complex Report System.

• Provider: Last name of the provider attached to the payment plan.
• Guarantor: The guarantor of the payment plan. This may differ from the family guarantor.
• Ins: X indicates insurance payment plan.
• Princ: The total principal amount.
• Accum Int: Accumulated interest for the plan.
• Paid: 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 (is due in the future). (Balance - Due Now). Only shows when the Pay Plan charge logic Preference is set to Age Credits and Debits.
• Fam Balance: Only appears when Show Family Balance is checked. The total family balance for the payment plan guarantor.