A payment schedule lists every payment a customer owes under a plan and tracks what has actually been received. Use the template below for one customer, or one sheet per plan.
Download the CSV template and open it in Excel, Google Sheets or Numbers.
Example: $3,000 program, $600 deposit, six installments
| # | Due date | Description | Amount due | Amount paid | Date paid | Remaining |
|---|---|---|---|---|---|---|
| 0 | Oct 1 | Deposit | $600.00 | $600.00 | Oct 1 | $2,400.00 |
| 1 | Nov 1 | Installment 1 of 6 | $400.00 | $400.00 | Nov 2 | $2,000.00 |
| 2 | Dec 1 | Installment 2 of 6 | $400.00 | $2,000.00 | ||
| 3 | Jan 1 | Installment 3 of 6 | $400.00 | $2,000.00 | ||
| 4 | Feb 1 | Installment 4 of 6 | $400.00 | $2,000.00 | ||
| 5 | Mar 1 | Installment 5 of 6 | $400.00 | $2,000.00 | ||
| 6 | Apr 1 | Installment 6 of 6 | $400.00 | $2,000.00 | ||
| Total | $3,000.00 | $1,000.00 | $2,000.00 |
Fictional example.
How to use it
- Fill in the header: customer, what they bought, agreed total, deposit and currency.
- List every payment with its due date and amount. Check that the amounts add up to the total.
- Record payments only when they clear, not when an invoice is sent or a customer says they’ve paid.
- Remaining balance is the total minus everything actually received.
- Never edit a paid row. If the schedule changes, add new rows for the new dates and note why.
When a spreadsheet stops working
A schedule template works for a handful of plans. Past that, the hard parts are keeping it in step with your payment processor and noticing when something doesn’t match.
Cadence keeps this schedule for you on top of Stripe: it splits the total to the cent, records the customer’s acceptance, issues each installment as a Stripe invoice and updates the remaining balance only when Stripe confirms the payment. Collection is currently in a sandbox pilot. See how it works.