Dynamic Payment Plan
A Dynamic Payment Plan is an open ended repayment agreement for completed procedures.
In the Account Module, the Payment Plans grid lists all payment plans associated with the family.
- The grid can also include Patient Payment Plans, Installment Plans and Insurance Payment Plans.
- If production on a dynamic payment plan has been overcharged, the plan will turn yellow. Run the Dynamic Payment Plans Overcharged Report to find any overcharged production.
In the toolbar, click Payment Plan, Dynamic Payment Plan, or double-click an existing plan to edit.
To set when payment plan payments will be due, see Manage Module Preferences, Days in advance to bill payment plans amounts due. To set a time when the Open Dental Service will update dynamic payment plans, see Account Module Preferences, Dynamic Pay Plan run time.
Related Links:
Dynamic payment plans are designed to allow the creation of a flexible repayment agreement.
When a dynamic payment plan is first created the window will default to the Production tab (see below). Dynamic plans require production to be attached before other terms can be determined. Use the Procedure or Adjustment buttons to add production to the plan, after which you can choose terms, including Payment Amount or Number of Payments, and Charge Frequency. Click Create Schedule to generate an Amortization Schedule. Use the Sign & Print button to complete the agreement.
Category: Assign a category to this payment plan (e.g. Ortho, Implant). Useful to distinguish one payment plan from another when families have many plans. Customize the category options in Definitions: Payment Plan Categories.
Patient: The person who was treated. Click Go To to switch to their account. Patients can have multiple payment plans, and each plan can have a different guarantor.
Guarantor: The person who will make the payments. It does not have to be in the same family as the patient. It also can differ from the account's guarantor. Click Change to select. Click Go To to switch to their account.
Full Lock: Check box to lock current terms of payment plan. Prevents any further additions to production or changes to repayment schedule. Adding an APR interest rate requires that the plan be locked.
Terms that affect the Amortization schedule:
- Date of Agreement: Defaults to today's date. Cannot be back dated.
- Total Principal Amount: The total amount of the payment plan, not including interest. It calculates based on the total attached production and adjustments.
- Date of First Payment: Defaults to one month from today's date so amortization calculations will be accurate. If you change the date, there may be minor discrepancies in interest charged. If the first payment is today, enter it as the down payment and set the Date of First Payment as one month in the future.
- Down Payment: The amount of the down payment.
- APR: The percentage of interest to charge. If entered, additional options are available to delay interest charges. Payment Plan must be locked to use.
- No interest for the first [ ] payments: The number of payments before interest is applied.
- Interest start date: The date of the first interest charge.
- Payment Amount: The amortization schedule can be based on a total number of payments or a specific payment amount. Number of payments will be calculated automatically. Enter only one.
- Number of Payments: Enter a number of payments the schedule will be based on. Payment amount will calculate automatically.
- Charge Frequency: Select the frequency of which charges are applied to the payment plan. The options are:
- Weekly
- Every other week
- Specific day of the month
- Monthly
- Quarterly
Create Schedule: Create the amortization schedule based on the terms. Production must be added to the plan before the schedule can be created. A description of the terms will show in the Note field.
Once the schedule is created, these calculations are automatic:
- Total Cost of Loan: Total Amount plus interest and any added charges.
- Accumulated Due: The total amount that has been due up to the current date.
- Paid so far: The total amount that has been paid towards the payment plan to date.
- Principal paid so far: The total that has been paid towards the principal to date.
- Tx Completed Amt: The total fee amount for charges that have come due.
- Total Tx Amt: The total fee amount for all procedures that are attached to the payment plan. Will not display until after plan has been saved by clicking OK.
Amortization Schedule: The amortization schedule is generated based on the terms. Principal and interest are calculated automatically. Due dates are based on the Date of First Payment and selected charge frequency.
- A horizontal bold line indicates today's date and separates past items from future items.
- Line items in black represent charges that have posted to the account. Gray line items are projected future charges. Charges are actually posted to the account using the Open Dental Service daily at the time determined in Account Module Preferences.
- Gray items can change if production is added or removed, or additional payments are made.
- Payments attached to this payment plan show as green credits and affect the running balance. If extra payments show here, but should not, uncheck the Attached to Payment Plan box on the Payment window for each payment.
- Exclude past activity: When checked, only future dated line items show in the Amortization Schedule and past activity is hidden. When unchecked, all activity shows. Totals are not affected by this setting. To set the default setting for the checkbox, see Account Module Preferences, Payment Plans exclude past activity by default.
Interest: Open Dental automatically calculates interest (APR) using the following method. Most online calculators use the same method, but some may differ (e.g. assume down payment is first month's payment). Adding an APR interest rate required that the Plan be fully locked.
- Subtracts the down payment from the payment plan balance.
- Calculates the number of payments, or the payment amount, based on the new balance (balance minus down payment).
Note: When you create the schedule, a detailed note of the terms shows for future reference. Other notes can be added as needed.
Sign & Print: Click to sign and print payment plan. See Sign and Print Payment Plan.
Click OK to create the Payment Plan.
Production tab
From the Production tab you will add procedures and adjustments to the payment plan. Dynamic payment plans require attached production. Unlike normal payment plans, the total amount is not fixed and additional procedures and adjustments can be added.
- Production for a given procedure can only be attached to a single payment plan.
- Only completed procedures can be attached to a Dynamic Payment Plan.
- Negative adjustments and insurance payments applied after the plan was created will reduce the amount of future charges.
Delete: Delete selected production item from the attached production list.
Print: Click to print list of attached production.
Adjustment: Click to open Adjustment Picker window.
Highlight adjustments to be included in the payment plan.
- Show Unattached Only: Checked by default and cannot be changed. Only adjustments that are not attached to procedures are listed. Adjustments attached to procedures reflect in the value of the procedure under the Production tab.
Procedure: Click to open the Select Procedure window.
The procedure or adjustment Amount Attached defaults to the remaining balance of the production fee after insurance estimates/payments, negative adjustments, and patient payments. Edit the amount to override the default production amount attached to the payment plan with a new amount. If the amount is changed, additional insurance payments or adjustments applied towards the production will not automatically update the payment plan.
Editing an Existing Plan
Double-click to open an existing dynamic payment plan. The terms will be grayed out.
Click Unlock to edit the terms or add additional procedures or adjustments.
Delete: Click to delete the entire plan. Payments cannot be attached.
Close Plan: Click when the payment plan is paid off, or if you are writing off the unpaid amount.
Plans with APR cannot be edited. You must create a new plan to add treatment instead.
Payment and Interest Logic
Patient payments made towards a dynamic payment plan are first applied to any pay plan interest charges that have posted to the account. After the interest is covered, any payment amount left over is then applied to the principal balance.
If a patient pays more than what is currently due the excess payment amount is applied to the principal balance and future interest charges are recalculated. However, when the next pay plan charge is posted the excess payment amount is transferred from the principal balance to the interest on the new charges. Payments may also be transferred from the principal balance to interest charges when a payment for a due charge is missed.