Payment Plans Overcharged Report

Use the Payment Plans Overcharged Report to find and fix overcharged production on Payment Plans.

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

A Payment Plan is considered overcharged if the sum of the payment plan debits (before interest) exceeds the sum of the production attached to the plan. Overcharged plans turn yellow in the Payment Plans grid of the Account Module.

Note:
  • Adjustments, payments, and write-offs must be allocated to procedures in order for this report to pull data correctly.
  • Payment plan debits (PayPln: Debit) are the charges created by the payment plan for the principal balance.
  • To control user access to this report, see Report Setup: Security Permissions.

Filters

Select filters to affect the Payment Plans listed in the grid.

From / To: Enter a date range to filter Payment Plans by the plan Start Date. Defaults to one month prior to the current date.

Providers: Click the dropdown to select providers. Click All to include all listed providers. Filters by provider associated with the overcharged production.

Clinics: Only available when Clinics are enabled in Show Features. Select the clinics to include in the report. Select All (includes hidden) to include all clinics, including those marked hidden.

Patient: Lists the name of the selected account currently filtering the report. The currently selected patient is entered automatically when opening the report. If no patient is selected, the report returns results for all patients that meet the other filter criteria.

Overcharged Production

Click Refresh to update the Overcharged Production grid. Right-click any item in the grid and select Go To Account to launch the Account Module for the patient associated with the selected Payment Plan. The following is a description of each column included in the grid:

Click Print to launch a print preview of the report. The print preview includes the same data columns as the preceding Overcharged Production grid. For a description of toolbar buttons, see Complex Report System.

Fixing Overcharged Production

To fix the overcharged production items in the list, select one or more items in the grid and click Fix. If nothing is selected, clicking Fix corrects all listed production. A negative charge and negative payment plan debit are added for each item selected.

The negative charge is added to the Payment Plan Amortization Schedule for the total amount overcharged on the production item.

The negative payment plan debit is added to the Patient Account if the Pay Plan charge logic, Age Credits and Debits, is set in Preferences. This is to offset the pay plan debits that overcharged the production item.

The total cost of the loan is reduced to reflect the updated total tx amount (attached production). If the patient has been actively making payments to the Payment Plan, it may become overpaid after fixing the production. Run the Income Transfer Manager to re-allocate the income from the overpaid charges to other charges or to Unearned Income to be allocated later.