Free Excel download β’ Edit online β’ Save & share with Drive β’ Export to PDF
A Payment Schedule is a structured table β typically attached as an exhibit to a loan, installment sale, or services contract β that lists every payment in a repayment series with its due date, total amount, principal component, interest component, and the running outstanding balance after each installment. It converts the high-level repayment terms stated in the parent agreement into a row-by-row record both parties can track against. For financing arrangements, it also shows the amortization of the debt, confirming how the interest and principal split shifts over time until the balance reaches zero at the maturity date.
Without a payment schedule, both parties must re-derive repayment dates and amounts from the contract terms every time a payment approaches β creating room for arithmetic disagreements, missed due dates, and disputes over how much principal remains. Lenders who extend credit without an attached schedule have no clean audit trail when a borrower claims a payment was applied incorrectly. Service providers billing in milestones need a signed exhibit to enforce a specific date and amount, not just a clause referencing "installment payments." A completed payment schedule eliminates all of this ambiguity before the first payment is due, gives each party a reference they can check in under 30 seconds, and provides the paper trail needed to calculate default and late fees accurately if a payment is missed. This template gives you a ready-to-attach exhibit in under 30 minutes.
| If your situation is⦠| Use this template |
|---|---|
| Fixed monthly payments on a business or personal loan | Loan Amortization Schedule |
| Seller-financed property or asset sale | Installment Sale Agreement |
| Milestone-based billing for a services project | Service Agreement with Payment Schedule |
| Recurring billing under a subscription or retainer | Recurring Invoice |
| Structured settlement or debt repayment plan | Debt Settlement Agreement |
| Construction project with draw schedule | Construction Payment Schedule |
Why it matters: Terms like 'due on the 1st of each month' create disputes when months start on weekends or holidays, and make it impossible to calculate the exact default date.
Fix: List every due date as a specific MM/DD/YYYY entry in the table so both parties have a single, unambiguous record.
Why it matters: This overstates interest charges in later periods, causes the schedule to not fully amortize, and may constitute a usury violation in some jurisdictions.
Fix: Recalculate each row's interest as the prior period's outstanding balance multiplied by the periodic rate, or use a standard amortization spreadsheet formula.
Why it matters: A non-zero ending balance means the schedule does not match the contracted loan amount β either the parties disagree on the total owed or arithmetic errors exist.
Fix: Adjust the final payment amount to absorb any rounding difference and confirm the totals row principal matches the original loan principal exactly.
Why it matters: A standalone schedule with no link to the governing contract is difficult to enforce because the late fee terms, default remedies, and governing law are all in the parent agreement.
Fix: Include the parent agreement's name, date, and parties in the schedule header and confirm the exhibit label matches the reference in the contract body.
Enter the full name and date of the underlying contract this schedule will be attached to, and confirm the exhibit label (e.g., Exhibit A) matches what the contract references.
π‘ Check the parent agreement's exhibit list before you assign a letter β duplicate exhibit labels are a common source of confusion during execution.
Record the total principal amount, the annual interest rate (if any), and the start date from which interest begins to accrue.
π‘ For zero-interest installment contracts, leave the interest column at $0.00 and note 'interest-free' in the header to prevent ambiguity.
Choose monthly, quarterly, or milestone-based frequency and list every specific calendar due date in the due-date column β do not use relative terms.
π‘ If a due date falls on a weekend or public holiday, decide in advance whether to move it to the prior Friday or next Monday, and note the rule in the schedule footer.
For amortizing loans, use the standard amortization formula or a spreadsheet PMT function to derive each row's principal and interest components. For milestone contracts, set the payment amount per milestone and leave the interest column blank.
π‘ Build the schedule in a spreadsheet first so formulas auto-calculate, then paste the final values into the Word template to eliminate formula errors in the distributed document.
Each row's balance equals the prior row's balance minus the current row's principal component. Verify the final row equals $0.00.
π‘ If the final balance is not zero, adjust the last payment amount rather than changing the interest rate β this keeps the schedule consistent with the contract terms.
Sum the payment, principal, and interest columns in the totals row. Add a footer referencing the late fee rate and grace period from the parent agreement.
π‘ Cross-check total principal in the summary row against the original loan amount β they must match to confirm the schedule fully amortizes the debt.
Append the completed schedule to the parent agreement as the specified exhibit and confirm the body of the contract references it by the correct exhibit label and date.
π‘ Both parties should initial the payment schedule exhibit separately at signing so there is no dispute that they reviewed and accepted the specific figures.
A payment schedule is a structured table attached to a loan, installment sale, or services contract that lists every payment due date, the total amount owed on each date, the principal and interest breakdown, and the running outstanding balance. It gives both parties a single, unambiguous record of the full repayment obligation and is typically included as an exhibit to the governing agreement.
Use a separate payment schedule whenever a contract involves more than two or three installments, an amortizing loan with changing principal/interest splits, or milestone-based billing tied to specific deliverable dates. Embedding a multi-row table in contract body text is hard to read and harder to update β a standalone exhibit is cleaner and easier to reference in a dispute.
An amortization schedule is a specific type of payment schedule used for interest-bearing loans, where each row shows how the payment splits between principal reduction and interest. A payment schedule is the broader term β it covers amortizing loans, interest-free installments, and milestone payments alike. Every amortization schedule is a payment schedule, but not every payment schedule involves amortization.
The payment schedule itself typically does not require a separate signature β it is executed as an exhibit to the parent agreement. However, both parties should initial each page of the schedule at signing to confirm they reviewed and accepted the specific figures, particularly for large loans or long repayment terms.
The schedule should include a rule β either in the footer or in the parent agreement β specifying whether the payment moves to the prior business day or the next. Without this rule, the parties may disagree on whether a payment made on the following Monday is on time or late. State the rule explicitly and apply it consistently to all dates in the table.
Yes, but any modification should be documented as a written amendment signed by both parties, replacing or supplementing the original exhibit. Verbally agreeing to change a due date or amount without amending the schedule creates conflicting records and complicates enforcement if the borrower later disputes the modified terms.
For straightforward installment sales and private loans, a template is sufficient. Consider a lawyer review when the loan amount exceeds $50,000, the schedule involves variable interest rates or balloon payments, or the transaction crosses state or national borders where usury and consumer credit laws vary. A one-hour review typically costs $150β$400 and is worthwhile for any arrangement where default remedies may need to be enforced.
List all regular installment rows with their normal payment amounts, then add a final row labeled 'Balloon Payment' showing the full remaining principal as the payment amount. The interest component on that row should reflect only the final period's interest, and the balance after that row should be $0.00. Note 'Balloon Payment Due' prominently in that row to ensure the debtor is not surprised at maturity.
An invoice is a one-time billing document requesting payment for goods or services already delivered. A payment schedule is a forward-looking table of all installments due under a contract β it is attached to the agreement at signing, before any payments are made. Use an invoice to bill; use a payment schedule to document a multi-payment obligation upfront.
A promissory note is the legally binding instrument in which the borrower promises to repay a sum β it states the interest rate, term, and default consequences. A payment schedule is typically attached as an exhibit to the note and shows the exact repayment rows in table form. The note creates the obligation; the schedule operationalizes it.
A debt settlement agreement resolves an existing debt dispute by accepting a reduced lump sum or restructured repayment. A payment schedule documents the agreed installment terms within that settlement. The settlement agreement governs the legal terms; the payment schedule shows the specific payment rows both parties have agreed to.
A service agreement governs the scope, deliverables, and terms of a professional engagement. A payment schedule is an exhibit attached to the service agreement when fees are paid in installments rather than on a single invoice. The agreement sets the rules; the payment schedule sets the dates and amounts.
Loan amortization schedules with precise principal/interest splits and balloon payment rows for private credit and bridge financing arrangements.
Seller-financed property transactions and land contracts where a payment schedule exhibit documents the installment terms and balloon maturity date.
Draw schedules tied to project milestones β foundation, framing, substantial completion β where each payment row links to a defined deliverable rather than a calendar date.
Milestone-based billing schedules for consulting, legal, or IT projects where payments are triggered by deliverable acceptance rather than fixed dates.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Private loans, installment sales, and services contracts with straightforward fixed payment terms | Free | 15β30 minutes |
| Template + professional review | Loans above $50,000, variable-rate or balloon structures, or cross-border financing arrangements | $150β$400 (accountant or attorney review) | 1β2 days |
| Custom drafted | Complex structured financing, regulated consumer credit products, or multi-party syndicated arrangements | $500β$2,000+ | 3β7 days |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start freeΒ Β·Β No credit card required
