Payment plan calculator
For businesses whose clients pay before the work: venues and event suppliers, retreat and workshop hosts, studios with terms, creative studios. Enter the price, deposit and date; get a plan that's paid in full before it.
Free. No signup. Excel, Word and CSV. No watermark.
$1,200.00 today, then 11 payments of $981.81 monthly. Paid off Oct 18, 2027.
Total $12,000.00. Everything paid by Oct 19, 2027. No interest or fees.
| Payment | Due | Amount | Left to pay |
|---|---|---|---|
| Deposit | Nov 18, 2026 | $1,200.00 | $10,800.00 |
| Installment 1 | Dec 18, 2026 | $981.81 | $9,818.19 |
| Installment 2 | Jan 18, 2027 | $981.81 | $8,836.38 |
| Installment 3 | Feb 18, 2027 | $981.81 | $7,854.57 |
| Installment 4 | Mar 18, 2027 | $981.81 | $6,872.76 |
| Installment 5 | Apr 18, 2027 | $981.81 | $5,890.95 |
| Installment 6 | May 18, 2027 | $981.81 | $4,909.14 |
| Installment 7 | Jun 18, 2027 | $981.81 | $3,927.33 |
| Installment 8 | Jul 18, 2027 | $981.81 | $2,945.52 |
| Installment 9 | Aug 18, 2027 | $981.81 | $1,963.71 |
| Installment 10 | Sep 18, 2027 | $981.81 | $981.90 |
| Final payment | Oct 18, 2027 | $981.90 | $0.00 |
| Total | $12,000.00 | ||
We'll carry these numbers over. No names or emails go in the link.
Turn this into an agreement Make the deposit invoiceHow it's worked out, with your numbers
- Total $12,000.00 minus deposit $1,200.00 = $10,800.00 to spread.
- Cut-off: Nov 18, 2027 minus 30 days = Oct 19, 2027. Every payment is on or before this date.
- $10,800.00 ÷ 11 payments = $981.81 each (rounded down to the cent); the final payment is $981.90 so the total is exact.
- 11 monthly payments fit between the first payment date and the cut-off, so that's how many we used.
Assumes: no interest or fees; the deposit is paid on the booking date; payments are equal and the last one absorbs rounding; monthly payments keep the same day, moving to the last day in shorter months.
Agreement wording you can paste
The total price is $12,000.00. Payments: $1,200.00 deposit on Nov 18, 2026; 10 monthly payments of $981.81 and a final payment of $981.90, from Dec 18, 2026 to Oct 18, 2027. All payments will be made by October 19, 2027, 30 days before the service date. No interest or fees are charged.
How the calculator works
- The deposit is taken on the booking date.
- The rest is split into equal payments. Rounding goes on the last payment, so the total is exact.
- Payments stop at your cut-off: the booked date minus the days you choose. Ask for more payments than fit and it tells you the most that do.
- Monthly payments keep the same day each month. On the 29th to 31st they move to the last day of shorter months.
- If the booking is already inside the cut-off, it tells you to take the full amount now.
Repaying a personal loan or a tax bill? This calculator is for businesses taking payments for a future service. For money owed between people, use the personal payment agreement.
Questions people ask
How do I work out instalment amounts?
Take the deposit off the total, then divide what's left by the number of payments. Amounts are rounded to the cent or penny, and the last payment absorbs any rounding so the total is exact.
When should the final payment be due?
Most venues and suppliers ask for everything 30–90 days before the date. Leave at least two weeks so a failed card or bank payment can be retried before the date.
How many instalments should I offer?
As many as fit before your cut-off is the easiest to sell. Monthly payments are the norm for bookings made a year or more ahead; every two weeks works for shorter windows.
Should a payment plan cost more than paying up front?
We'd say no. A plan that's paid off before the service is a prepayment, not credit. Adding interest or fees can turn it into credit, which brings extra rules in both the US and the UK.
What if the client books too late for a plan?
If the booking is already inside your cut-off, the calculator tells you to take the full amount now.
What if a client misses a payment?
Retry, remind, and give a fixed number of days to catch up. After that your cancellation terms apply. Put this in the agreement before the first payment.
Other free tools
- Payment plan agreement templateWrite a US payment plan agreement with card and ACH authorization wording.
- Deposit invoice templateMake a deposit invoice that shows the total, the deposit and the balance due.
- Payment schedule templateFill in a payment schedule online, then download it for Excel, Sheets or Word.