Repay family or relatives' money with a fixed monthly amount, one planned top-up in your bonus month, and a running balance that you update after every payment. Set the fixed amount after your own survival budget is covered, not before, or the plan breaks in the second month. Here is how to build it with invented numbers.
Start with your own survival budget
A repayment schedule that leaves you short on rent will be abandoned. So list what has to be paid each month before any repayment: rent or home contribution, food, commute, phone, insurance premiums and a little spending room. Say your take-home is ₹45,000 and that list comes to ₹32,000. That leaves ₹13,000 for everything else, including repayment.
Resist using all ₹13,000. Keep some for savings and surprises. In this example, ₹5,000 goes to repayment and ₹8,000 stays with you.
What does a schedule that holds look like?
Say you owe relatives ₹2,40,000 from an education loan taken inside the family. Two components keep the schedule realistic:
- A fixed monthly amount: ₹5,000 on the same date every month, ideally the day after salary arrives.
- A top-up in your bonus month: ₹20,000 when the annual bonus is credited, decided now, not when the money arrives and other wishes appear.
That gives 5,000 × 12 = 60,000 a year from the fixed part plus 20,000 from the top-up, so 80,000 a year. The loan of 2,40,000 divided by 80,000 is exactly 3 years.
| Year | Fixed payments (₹) | Bonus top-up (₹) | Paid in year (₹) | Balance at year end (₹) |
|---|---|---|---|---|
| Year 1 | 60,000 | 20,000 | 80,000 | 1,60,000 |
| Year 2 | 60,000 | 20,000 | 80,000 | 80,000 |
| Year 3 | 60,000 | 20,000 | 80,000 | 0 |
How do you track the balance owed?
Keep one running figure, not a pile of receipts. In a sheet, put the opening balance in D2, then each payment in column C starting at C3, and calculate the balance in D3:
- =D2-C3
Copy it down. The latest value in column D is what you still owe. Add the payment date and the person's name next to it. If a relative later says they remember a different figure, you have a dated record to look at together.
Agree the terms with the family in a message, not just in conversation: the amount, the date, and whether any interest was ever agreed. Neither of you needs an argument about it in three years.
What if a month goes wrong?
Decide the rule in advance. A sensible one is: a missed payment is carried forward and added to the next month, but only once, and you tell the person before the date, not after it. If two months in a row are tight, shrink the fixed amount for a while and extend the end date rather than dipping into rent money. Show the new end date to the family.
Where does SpendixAI fit?
A custom category such as Family repayment lets you see every transfer in one place, whether you add it by hand or find it in an uploaded statement. The statement import lets you review rows before saving, so a mis-tagged transfer is caught early. A sheet is enough for the balance; the app helps when you want the monthly total next to the rest of your spending.
A short checklist
- Write down your survival budget and the amount left after it.
- Pick a fixed repayment amount smaller than that remainder.
- Decide the bonus-month top-up in advance.
- Message the family the schedule and the expected end date.
- Update the balance the day each payment goes out.
- Review in January and July. If life has changed, change the schedule openly.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


