Debt

A family loan instalment schedule template you can share

A family loan repayment schedule you can copy: month, due date, amount, paid and balance, with a ₹60,000 over 12 months example and spreadsheet formulas.

Editorial illustration for A family loan instalment schedule template you can share

A family loan repayment schedule needs only five columns: month, due date, instalment due, amount paid and balance. Copy the table below, change the numbers, and share it, so everyone can see where the loan stands without anyone chasing anyone.

What does the schedule look like?

Here is a hypothetical loan of ₹60,000 over 12 months, starting in April. The instalment is ₹60,000 divided by 12, which is ₹5,000. The first five months show what actually happened; the rest show the plan if paid on time.

MonthDue dateInstalment duePaidBalance owed after
15 Apr₹5,000₹5,000₹55,000
25 May₹5,000₹5,000₹50,000
35 Jun₹5,000₹5,000₹45,000
45 Jul₹5,000₹3,000₹42,000
55 Aug₹5,000₹7,000₹35,000
65 Sep₹5,000due₹30,000 if paid
75 Oct₹5,000due₹25,000 if paid
85 Nov₹5,000due₹20,000 if paid
95 Dec₹5,000due₹15,000 if paid
105 Jan₹5,000due₹10,000 if paid
115 Feb₹5,000due₹5,000 if paid
125 Mar₹5,000due₹0 if paid

How do I update it when a month goes differently?

Month 4 shows a short payment: ₹3,000 instead of ₹5,000, leaving the balance at ₹42,000 instead of ₹40,000. Month 5 shows a catch-up of ₹7,000, which is the ₹5,000 due plus the ₹2,000 missed. The balance is back on track at ₹35,000, exactly where the plan said it would be.

The rule is simple: never change the instalment due column to hide a shortfall. Leave the plan as agreed, record what was paid, and let the balance column tell the truth. If both people agree to a new pace, add a dated note and start a fresh schedule from the current balance.

Which spreadsheet formulas do I need?

Put the loan amount in cell B1 and the table header in row 3, with data from row 4 down to row 15. Columns: A month, B due date, C instalment, D paid, E balance.

  • Balance after each month, in E4: =$B$1-SUM($D$4:D4). Copy it down to E15.
  • Total paid so far: =SUM($D$4:$D$15)
  • Still owed: =$B$1-SUM($D$4:$D$15)
  • Behind or ahead of plan: =SUM($D$4:$D$15)-SUMIF($B$4:$B$15,"<="&TODAY(),$C$4:$C$15)

The last formula adds up what you planned to have paid by today, using the due dates in column B, and subtracts that from what has actually been paid. A negative number means behind; a positive number means ahead. Due dates must be real dates, not text, for the comparison to work in Excel or Google Sheets.

Who should hold the master copy?

One person keeps the master and shares a read-only view with the other. That avoids two versions arguing with each other. After each payment, the borrower sends a one-line message with the new balance, and the lender can check it against the shared copy.

What about interest or an early finish?

This template assumes no interest. If you agree one, add a column for interest and split each payment between interest and principal so the balance still falls correctly. To finish early, record the extra payment on the actual date and let the schedule end sooner; there is nothing to recalculate beyond the new balance.

A closing checklist

  1. Fix the amount, the instalment and the due day.
  2. Fill the whole plan first, then record payments as they arrive.
  3. Leave the instalment column alone; change only the paid column.
  4. Send the balance after every payment.
  5. Review together if a month is missed twice.

The repayments will also show in your bank statement. When a sheet stops being enough, SpendixAI can import that statement so you can match each payment to the schedule before you update your copy.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports