If two people share a loan, the lender sees one EMI, but the two of you need to see who actually pays what. A simple ledger with the EMI, the share each person agreed to, the transfers between you and the running difference answers that, and it prevents small misunderstandings from growing. This example uses invented figures and a 70:30 split.
What should the ledger record?
- The EMI amount and the date it is debited, and from whose account.
- The agreed split, written as percentages and as rupee amounts.
- Every transfer one co-borrower makes to the other, with the date and a payment reference.
- The difference each month between what a person owed and what they actually sent.
- Notes for anything unusual, such as a prepayment or a month when someone paid in cash.
What does a 70:30 example look like?
Say the EMI is ₹25,000 and is debited from Meera's account on the 5th. She and her brother Karan agreed that Meera takes 70 per cent and Karan 30 per cent. Seventy per cent of ₹25,000 is ₹17,500; thirty per cent is ₹7,500. Each month Karan transfers his share to Meera.
| Month | EMI debited from Meera | Karan's share due | Karan sent | Shortfall carried |
|---|---|---|---|---|
| January | ₹25,000 | ₹7,500 | ₹7,500 | ₹0 |
| February | ₹25,000 | ₹7,500 | ₹7,500 | ₹0 |
| March | ₹25,000 | ₹7,500 | ₹5,000 | ₹2,500 |
| April | ₹25,000 | ₹7,500 | ₹10,000 | ₹0 |
In March Karan sent ₹5,000, so ₹2,500 was short. In April he owed ₹7,500 plus the ₹2,500, which is ₹10,000, and he sent exactly that, so the carried shortfall is back to zero. Over four months, Karan's share was ₹30,000 and he sent ₹30,000.
Which formulas can you use in a sheet?
Set up columns A month, B EMI, C share due, D amount sent, E shortfall carried. Put the share percentage, 30 per cent, as 0.3 in cell H1. Then:
- C2: =B2*$H$1 gives the share due.
- E2: =C2-D2 for the first month.
- E3: =E2+C3-D3, copied down, carries any shortfall into the next month. A negative number means the person has paid ahead.
- A running check in a spare cell: =SUM($C$2:C5)-SUM($D$2:D5) should equal the latest shortfall.
What if the split is not the same every month?
Splits shift. One person may pay a larger share while the other is between jobs, or someone may make a lump-sum prepayment from their own money. Do not rewrite old rows. Add a dated note, such as 'From July, 60:40 for six months, agreed on call on 28 June, confirmed by message', and change the percentage from that row onwards.
How often should you review it?
Look at the ledger together once every quarter. Agree on the carried shortfall, correct any mistakes and decide whether the split still feels fair. Keep these conversations short, factual and in writing afterwards.
Both of you can keep the record in a shared sheet. If Meera imports her account statement into SpendixAI, the EMI debit and Karan's transfers both appear as rows against that account, which makes the month-end check quicker.
What does the ledger not tell you?
It records the arrangement between the two of you. It does not describe each person's position towards the lender or anyone else, which depends on the loan papers you both signed. Read them, or ask a professional if you are unsure.
Cash and non-bank payments deserve a line too. If Karan hands over ₹7,500 in cash one month, write the date and what the money was for, and ask Meera to confirm by message. An entry that only one of you remembers is not much of a record.
Setup checklist
- Write the split down, in percentages and in rupees.
- Create the ledger with the five columns above.
- Fill it in within a day of each EMI and each transfer.
- Review the carried shortfall every quarter, and note decisions with dates.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

