Debt

Track money lent or borrowed with a repayment schedule for gig workers

A simple repayment schedule for informal loans between friends, built around irregular gig and freelance income, with a worked example and a sheet.

Editorial illustration for Track money lent or borrowed with a repayment schedule for gig workers

Write the loan down as a schedule: amount, date, how many parts, on which day each part is due, and what happens if a part is missed. Informal loans between friends fade because nobody wrote a schedule, and a gig worker's uneven earnings make that worse. A five-line note saved on both phones is usually enough.

Why do loans between friends vanish from memory?

A bank loan nags you through debit messages. A loan from a friend has no system behind it. If you drive for a delivery platform, take design projects or teach online, your income arrives in uneven lumps, so a fixed date such as the first of the month rarely suits you. The loan gets pushed to 'when the client pays', and then the client pays and you spend the money on something else. A schedule that follows your payments, not the calendar, is kinder to both of you.

What should the written terms contain?

  • Who lent, who borrowed, the amount and the date it was handed over.
  • How it was paid: UPI, bank transfer or cash. Keep the transaction reference for UPI or bank transfers.
  • The number of parts and the amount of each.
  • The due date of each part, or a trigger such as 'within three days of a client payment'.
  • What happens when a part is short: it carries forward and the final date moves.

Send this as a message to the friend and ask for a thumbs-up. It takes two minutes, and it turns a vague favour into something you can both check.

What does a month-by-month schedule look like?

Say you borrowed ₹24,000 from a friend and agreed to repay ₹4,000 on the 10th of each month for six months. In May you could pay only ₹2,000. This is how the balance moves.

MonthDuePaidBalance left
March₹4,000₹4,000₹20,000
April₹4,000₹4,000₹16,000
May₹4,000₹2,000₹14,000
June₹4,000₹4,000₹10,000
July₹4,000₹4,000₹6,000
August₹4,000₹4,000₹2,000
September₹2,000₹2,000₹0

The May shortfall of ₹2,000 was not forgotten; it pushed the last payment into September. The balance column is simply the previous balance minus what was paid, so the arithmetic is easy to repeat in a sheet: with the loan amount in B1 and payments in C2 to C8, the balance is =B1-SUM(C$2:C2) copied down.

What if you are the one who lent the money?

The same table works in reverse. Suppose you lent ₹9,000 to a colleague who will return ₹3,000 on three Fridays. Put the three dates in your calendar, and note each repayment the day it arrives. If a Friday passes, send one short message that day. Waiting three weeks to mention it is how small loans turn into awkward silences. Decide beforehand whether you are comfortable if the loan is never returned; lend only what you can live without.

How do you match repayments to uneven income?

  1. List your usual payment days from clients or platforms for the last three months.
  2. Choose a repayment day that falls two or three days after your most reliable payment.
  3. Move the money for the instalment into a separate pocket as soon as that payment lands.
  4. If a month is thin, pay a smaller fixed part rather than skipping, and write the difference in the schedule.
  5. Tell the friend before the due date, not after.

Can an app help with this?

Mostly the habit does the work, not the tool. If you already import bank statements into SpendixAI, the UPI repayments you make appear as rows you can review and label, and you can add cash repayments by hand as expenses. SpendixAI is not a lending ledger, so keep the schedule note alongside it.

Before you close the loan

  • Add up the paid column and check it equals the original amount.
  • Send a final message saying 'all settled' and keep it.
  • Note what you learned about your payment gaps for the next time a friend needs help or you do.
SPENDIXAI JOURNAL

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

Explore your reports