Small loans that are repaid in a few weeks are easy to lose track of, especially when more than one is open. Keep one sheet with a row per loan: when you took it, what you received, what you must repay, and the due date. A running total of what falls due shows you the real size of the month, and one simple rule helps you spot a cycle.
What should each row contain?
- Loan label (App 1, App 2, so you can tell them apart)
- Date taken
- Amount received in your account
- Total to repay, as stated in the offer before you accepted
- Due date
- Date actually repaid and status (Open or Repaid)
Write down the full repayment amount at the time you accept. Fees and charges are part of the cost, and they are easy to forget later.
What does a busy month look like?
Four invented loans in one month, with a salary of ₹30,000 arriving on the 1st:
| Loan | Taken | Received (₹) | To repay (₹) | Due | Due so far (₹) |
|---|---|---|---|---|---|
| App 1 | 1st | 5,000 | 5,400 | 8th | 5,400 |
| App 2 | 5th | 3,000 | 3,300 | 12th | 8,700 |
| App 3 | 10th | 8,000 | 8,600 | 20th | 17,300 |
| App 4 | 18th | 4,000 | 4,350 | 27th | 21,650 |
Received in total: 5,000 + 3,000 + 8,000 + 4,000 = ₹20,000. To repay: 5,400 + 3,300 + 8,600 + 4,350 = ₹21,650. The extra paid for the month is ₹1,650, which is 1,650 / 20,000 = 8.25% of the amount borrowed, in just a few weeks. The last column is the running total of what has fallen due by each date.
In a sheet, if due dates are in column E and repay amounts in column D, the running total in F2 is =SUMIFS($D$2:$D$20,$E$2:$E$20,"<="&E2) and can be copied down. It adds every repayment due on or before that row's due date.
How do you spot a cycle?
A simple rule: if a new loan lands within three days of another loan's repayment, or if you repaid one loan using money from another, mark it as a roll-over. One mark is worth noticing. Two or more in a month is a signal that the loans are paying for each other. By that rule, Apps 2, 3 and 4 in the example are all roll-overs, since each was taken within three days before another loan fell due.
Another check: add up what falls due this month and compare it with your take-home pay. Here, 21,650 / 30,000 is about 72%, before rent or food.
What are the small habits that help?
- Enter a loan in the sheet before spending the money.
- Set a reminder two days before each due date.
- Repay from the account you listed, on the due date, and record the date.
- Once a month, add up total received and total repaid.
Never share an OTP, PIN or net-banking login with anyone offering to help you manage or settle loans.
How can SpendixAI help?
Uploading your bank statements into SpendixAI shows each loan credit and each repayment as transactions, which is a handy way to confirm the dates and amounts against your sheet, and a custom category lets you see them together. The due-date sheet and the cycle rule remain your own.
What should you look at beyond the due date?
Read the full terms before you accept: the amount you will actually receive, every fee, the total to repay and the date. Compare the total to repay with what you receive, as in the 8.25% example above. The same percentage over a few weeks is a far heavier cost than the same percentage over a year, so do not judge a short loan by its headline number alone.
Monthly review
- All open loans listed with due dates
- Running total compared with take-home pay
- Roll-over marks counted
- Anything overdue contacted about in writing
Useful ideas start with a clearer picture of your own spending.
Explore your reports

