Making a repayment schedule both people can stick to

A repayment schedule is the least exciting part of a loan between friends, and the part that does the most to keep it friendly. It turns “pay me back over the year” into twelve dates and twelve amounts that both people can see. Below you’ll find what goes into one, a template to copy, and a fully worked example.

Why a written repayment schedule matters

Most disagreements about loans between friends aren’t about whether money is owed. They’re about details: was the payment due on the 1st or the 15th, was it $200 or $250, did the March payment count as two. A written repayment schedule answers all of that before it can become a question.

Think of it as the shared source of truth. When a question comes up in month seven, neither person has to rely on memory or scroll back through months of messages. You both open the same page and the answer is there.

It also changes how the loan feels. A borrower who can see “8 of 12 paid, $1,020 left” feels progress. A lender who can see the same thing stops wondering. Neither has to bring it up, because the schedule says it for them.

The fields, one by one

Every repayment schedule template needs the same core fields. Here’s what each one is for and how to fill it in.

Names and loan date

Both full names and the date the money changed hands. The loan date anchors everything else, including when interest starts, if there is any.

Amount lent

The exact figure in dollars, written in numbers. Not “about three grand,” but $3,000.

Interest

Either “none” or a clear statement such as “6% a year on the unpaid balance.” Avoid a bare percentage with no base; it can be read more than one way.

Payment amount and frequency

How much, how often. Weekly, every two weeks or monthly, matched to the borrower’s paydays.

Due dates

Every single date, listed. Add a rule for dates that fall on weekends or holidays.

Interest and principal columns

Only needed if you charge interest. They show how much of each payment covers interest and how much reduces the loan.

Balance after payment

What’s left once each payment is made. This is the column people look at most.

Payment method

Where the money goes: a bank account, a Zelle email, a Venmo handle. Choose something that leaves a record.

Rules for late and extra payments

What happens if a payment is late, and whether extra money shortens the schedule or lowers later payments.

A worked example: Jesse lends Dana $3,000

Here’s an illustration. Dana borrows $3,000 from Jesse in December to pay for a certification course. They agree on twelve monthly payments, 6% a year on the unpaid balance, and due dates on the 16th, the day after Dana’s mid-month paycheck. The first payment is January 16, 2027.

With interest on the declining balance, each payment is $258.20, except the last, which is $258.17 to absorb the rounding. Dana repays $3,098.37 in total, so the interest over the year is $98.37.

This kind of table is called an amortization table. You don’t need to build it by hand; the loan tool on our calculators page produces the same rows from the amount, rate and number of payments. What matters is that the finished table goes into your agreement, so nobody has to recalculate anything later.

The no-interest version

Most loans between friends skip interest, which makes the schedule much simpler: divide the amount by the number of payments. $3,000 over twelve months is $250 each month, and the balance column counts down by $250: $2,750, $2,500, $2,250 and so on to zero.

If the amount doesn’t divide evenly, put the odd cents on the last payment. $1,000 over six months becomes five payments of $166.67 and a final payment of $166.65. Our guide to installment plans for personal loans has more on choosing the number of payments and the rhythm.

Other rhythms: weekly and every two weeks

Monthly is the easiest rhythm to read, but it isn’t always the easiest to pay. If the borrower is paid every two weeks, a matching repayment schedule usually works better. Say Dana had borrowed $1,300 with no interest and is paid every other Thursday. Thirteen payments of $100, due every other Friday, clear the loan in about six months.

The trap with every-two-weeks schedules is that two months a year contain three paydays, so some months have three payments in them. That’s not a problem as long as every date is written out. It only becomes one when the schedule says “every two weeks” and the borrower is budgeting by the month. Weekly schedules work the same way, with smaller amounts and more rows; they suit people with irregular or tip-based income who prefer small, frequent payments.

When the borrower pays extra: a worked case

Say Dana gets a bonus and pays an extra $500 with the June payment. After June, the balance drops from $1,522.43 to $1,022.43. What happens next depends on the rule you wrote down, which is exactly why the template asks for one.

• Shorten the schedule. Dana keeps paying $258.20. July through September are normal payments, and October’s payment of $260.66 closes the loan, two months early. Interest from July on drops from $26.74 to about $12.83.
• Lower the payments. The $1,022.43 is spread over the remaining six months at the same 6% rate, so each payment falls to $173.40. The end date stays December, and interest from July on is about $17.97.

Both are fair. Shortening is simpler and saves a little more; lowering the payment gives the borrower breathing room. Either way, issue a new version of the schedule with the new rows.

The repayment schedule template

Copy this, fill in the brackets, and delete the interest columns if you’re not charging any. Keep the rules at the bottom; they’re what make the schedule hold up when something goes wrong.

REPAYMENT SCHEDULE

Lender:   [Full name]
Borrower: [Full name]
Loan date: [Date]          Amount lent: $[Amount]
Interest: [None] / [__% a year on the unpaid balance]
Payments: [Number] payments of $[Amount], [monthly]
First payment: [Date]      Last payment: [Date]
Paid to: [Bank account / Zelle email / Venmo handle]

#   Due date    Payment   Interest  Principal  Balance
1   [Date]      $[  ]     $[  ]     $[  ]      $[  ]
2   [Date]      $[  ]     $[  ]     $[  ]      $[  ]
3   [Date]      $[  ]     $[  ]     $[  ]      $[  ]
(continue until the balance reaches $0)

Rules
- A payment due on a weekend or holiday is on time
  if it arrives the next business day.
- If a payment will be late, [Borrower] tells
  [Lender] before the due date and we agree a
  new date in writing.
- A missed payment moves to the end of the schedule.
- Extra payments reduce the balance and shorten
  the schedule. No penalty for paying early.
- Changes are agreed by both of us in writing.

Signed: ______________ (Lender)   Date: ______
Signed: ______________ (Borrower) Date: ______

How to fill it in, step by step

1. Agree the basics out loud

   Amount, interest or none, how often, and when the first payment is. Ask the borrower when they get paid before you pick any dates.

2. Generate the rows

   For no interest, divide the amount by the number of payments. With interest, use a loan calculator to get the payment, then copy the rows into the template.

3. Check every date

   Write each one out in full. Look for weekends, holidays, and months with three paydays if payments are every two weeks.

4. Read the rules together

   Late payments, extra payments, changes. Edit them until both of you would genuinely be happy following them.

5. Sign and share one copy

   Both people should have the same final version. If you change anything later, make a new dated version rather than editing the old one.

Making the repayment schedule stick

A schedule on paper only works if it stays in sight. Three habits keep it alive. First, reminders: a nudge before each due date means nobody has to remember. Second, records: each payment gets logged with its date, amount and method the day it arrives. Third, a quick thank-you after each payment, which keeps the tone warm.

In IOUEZ, you create the agreement with the amount, interest and due date, both people sign on their own devices, and once both have signed the key terms are locked. Reminders go to both of you as payments come due, and each payment you record updates the balance you both see. If you’d rather work on paper, our guide to proof of repayment covers what to keep.

If a payment does slip, the playbook on restarting repayments after a missed payment walks through rebuilding the schedule fairly. And if you’re still deciding whether to charge interest at all, compare the options in simple interest vs a flat fee.

A lighter version for small loans

Not every loan needs a twelve-row table. For $200 lent until the next two paychecks, a full template is overkill and can feel oddly formal. A short message that contains the same essentials does the job: who, how much, which dates, how to pay.

“Confirming: $200 from me to you on Oct 2. You’ll pay $100 on Oct 16 and $100 on Oct 30 by Venmo. If either date won’t work, just tell me before it. Thanks!”

That one paragraph is a complete repayment schedule. It lists the dates, the amounts and a rule for problems, and it lives in your message history where both of you can find it. Ask the borrower to reply “confirmed” so there’s no doubt they saw it.

Our rough line: under a few hundred dollars and two or three payments, a confirming message is enough. Above that, or with interest, or with more than three payments, use the full template. And whatever the size, record each payment as it arrives.

Common mistakes to avoid

• “Monthly” instead of dates. Monthly from when? On which day? List them.
• No balance column. Without it, both people end up doing math in their heads, differently.
• Due dates before payday. A plan that asks for money two days before it arrives is set up to fail.
• Percentage with no base. “6% interest” could mean $180 or $98.37 on Dana’s loan, depending on what it’s charged on.
• No rule for extra payments. If Dana pays $500 in June, does July’s payment shrink or does the loan end sooner? Decide now.

For bigger loans or ones with more moving parts, pair the schedule with a full agreement. Our personal loan agreement template covers the clauses that sit around it.