When two co-borrowers pay one home loan from separate accounts, keep a sheet with one row per EMI that records who paid how much, from which account, and the matching bank entry. The loan only sees one repayment, so this sheet is your own proof of how it was funded.
Why do joint borrowers need their own record?
The bank's loan statement shows the EMI arriving, usually from one account. It does not know that one of you transferred ₹25,000 and the other ₹17,000 into that account first. If you later need to explain the split, to each other or to a CA, the evidence sits in two separate bank statements. A linking sheet puts it in one place.
What should the sheet contain?
- EMI month and the date the loan account was debited.
- Total EMI as per the loan statement.
- Amount paid by borrower one, the account it came from and the bank reference or narration.
- Amount paid by borrower two, with the same details.
- A check column showing whether the two parts add up to the EMI.
- A note column for anything unusual, such as a part-prepayment.
What does a worked example look like?
Say the EMI is ₹42,000. Meera pays ₹25,000 from her account and Karan pays ₹17,000 from his, both transferred to the loan repayment account before the due date. These figures are made up.
| Month | EMI | Meera | Karan | Check |
|---|---|---|---|---|
| April | ₹42,000 | ₹25,000 (UPI ref noted) | ₹17,000 (NEFT ref noted) | 25,000 + 17,000 = 42,000 |
| May | ₹42,000 | ₹25,000 (UPI ref noted) | ₹17,000 (NEFT ref noted) | 25,000 + 17,000 = 42,000 |
| June | ₹42,000 | ₹25,000 (UPI ref noted) | ₹17,000 (NEFT ref noted) | 25,000 + 17,000 = 42,000 |
Over twelve months Meera's share is 25,000 x 12 = ₹3,00,000 and Karan's is 17,000 x 12 = ₹2,04,000. Added together that is ₹5,04,000, which equals 42,000 x 12. If your sheet puts the amounts in columns C and D from row 2 to row 13, a total per person is =SUM($C$2:$C$13) and =SUM($D$2:$D$13). A check column can read =IF(C2+D2=B2,"OK","Check") and be copied down.
How do I link each payment to a bank entry?
For every month, open each borrower's own bank statement and find the debit that moved money to the repayment account. Write the date and the narration or UPI/NEFT reference into the sheet. If someone paid in cash, or paid the bank directly in some other way, note that too, and keep the receipt. Anything you cannot trace to an entry should be marked as unconfirmed instead of left blank.
Keep screenshots or PDF statements for each payment in a folder per financial year, named by month. A UPI reference that sits only in an app can disappear when a phone is changed, so export the monthly statement from each of your banks and save it beside the sheet.
What if the shares are not equal every month?
They often are not. A bonus month, a missed month or a one-off prepayment from one person should each get their own row or a note. Keep the arithmetic honest: if one month shows 25,000 from Meera and 10,000 from Karan, the check column will flag a ₹7,000 gap, and that gap needs an explanation, perhaps a third payment you forgot to record.
When does a spreadsheet stop being enough?
Once both of you have a year or two of entries, hunting through two bank statements each April gets tiring. SpendixAI lets each person import their own statements into a workspace and keeps each transaction tied to its account, which makes the debit lines easier to find. It is still your job to link them to the EMI, and the loan statement remains the master record.
A quick monthly routine
- Download the loan statement line and note the EMI amount.
- Record each borrower's transfer and its reference.
- Confirm the two add up.
- File screenshots or statements in a folder named by financial year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
