Paid Up

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)

Country
Taken on the booking date. Use 0 for none.
At least 14. Many businesses use 30–90, so a failed payment can be retried in time.
More options

Start again with the example

$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.

Booked Nov 18, 2026Paid in full by Oct 19, 2027Date Nov 18, 2027
PaymentDueAmountLeft to pay
DepositNov 18, 2026$1,200.00$10,800.00
Installment 1Dec 18, 2026$981.81$9,818.19
Installment 2Jan 18, 2027$981.81$8,836.38
Installment 3Feb 18, 2027$981.81$7,854.57
Installment 4Mar 18, 2027$981.81$6,872.76
Installment 5Apr 18, 2027$981.81$5,890.95
Installment 6May 18, 2027$981.81$4,909.14
Installment 7Jun 18, 2027$981.81$3,927.33
Installment 8Jul 18, 2027$981.81$2,945.52
Installment 9Aug 18, 2027$981.81$1,963.71
Installment 10Sep 18, 2027$981.81$981.90
Final paymentOct 18, 2027$981.90$0.00
Total$12,000.00
How it's worked out, with your numbers
  1. Total $12,000.00 minus deposit $1,200.00 = $10,800.00 to spread.
  2. Cut-off: Nov 18, 2027 minus 30 days = Oct 19, 2027. Every payment is on or before this date.
  3. $10,800.00 ÷ 11 payments = $981.81 each (rounded down to the cent); the final payment is $981.90 so the total is exact.
  4. 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

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

Was this useful?