Payment schedule template
A client payment schedule: money coming in from a customer who pays before a service date. Fill it in here and download it, or start from a blank one.
Free. No signup. Excel with working formulas, Word and CSV.
Blank template (Excel)Blank (Word)Blank (CSV for Google Sheets)
$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.
What's in the template
- Each payment's name, due date and amount, and what's left to pay after it.
- In Excel, "left to pay" is a formula: change an amount and it updates.
- "Paid on" and "Status" columns so you can track it.
Payment schedule calculator: a monthly schedule worked out for you
Pick monthly, every 2 weeks or weekly. The form works as a payment schedule calculator: it takes off the deposit, spreads the rest evenly, and makes sure the last payment is due before the service date. Download the monthly payment schedule as Excel, Word or CSV for Google Sheets.
Looking for a construction or supplier payment schedule? This one is for customer prepayments; construction schedules follow different rules.
Questions people ask
What should a client payment schedule include?
The total price, the deposit, each payment's due date and amount, the balance left after each payment, and the date everything must be paid by.
Can I use this in Google Sheets?
Yes. Download the Excel or CSV file and open it in Google Sheets (File → Import). The Excel version keeps the running-balance formulas.
Is this a construction payment schedule?
No. This is for money coming in from a client who pays before a service date. Construction payment schedules (progress payments, NSW/NZ payment schedules) follow different rules.
Can I change the dates after I download it?
Yes. In the Excel file the balance column recalculates when you change an amount.
Other free tools
- Payment plan calculatorEnter a price and a date. Get a deposit and dated payments that finish in time.
- 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.