Client Payment Plan Calculator

For service businesses that let clients spread the cost of a job: home services and trades, contractors, practices' front desks, tutors, course creators, photographers and coaches.

The Plan Calculator quotes a plan in seconds. Enter the price, a deposit (amount or percentage), any setup fee, the annual interest rate (0% for interest-free), the number of payments (1–60) and weekly, every-2-weeks or monthly. It shows the regular payment, the last payment (which absorbs cent rounding so the plan pays off exactly), total interest, the total cost and a full schedule with interest and balance, plus a side-by-side of 6 to 48 payments. Agreed plans go on the Plans Register. Log payments as they arrive, and each plan shows what was due to date, what's been paid, the amount behind after your grace period, the next due date and amount, and a status: On track, Behind, Paid in full, Not started or Cancelled. The Plan Schedule sheet marks every instalment Paid, Part paid, Due, Late or Upcoming. The Cash Forecast shows instalments still to come for the next 12 months, and the Dashboard shows collected, outstanding, behind, the collection rate and the plans furthest behind.

Included: worked-example and blank workbooks (8 sheets, 8,542 formulas; 100 plans, 2,000 payment records), plus a 6-page PDF in US Letter and A4 with a worked example, tips on setting plan terms, and blank and filled payment-plan summary, payment record and receipt pages.

General information, not legal, credit or financial advice. If you charge interest or fees on consumer plans, lending and disclosure rules may apply.