Your rent looks too high because you recorded the full payment as your expense and the money your flatmates sent back as something else, or nothing at all. Fix it by giving the incoming shares their own category and reading rent and shares together, so the net figure equals your own share of the flat.
What exactly is going wrong?
Say rent is ₹36,000 and three people share it equally. You pay the landlord ₹36,000. Two flatmates each send you ₹12,000 by UPI. In your statement, one large debit and two smaller credits appear. If the credits are treated as income or ignored, your housing cost shows as ₹36,000 when you actually bear ₹12,000.
How big is the distortion?
Take a monthly income of ₹70,000, a made-up figure. Compare what a tracker shows before and after netting.
| View | Rent shown | Rent as share of ₹70,000 |
|---|---|---|
| Full payment, shares ignored | ₹36,000 | ₹36,000 / ₹70,000 = about 51% |
| Shares netted off | ₹36,000 - ₹24,000 = ₹12,000 | ₹12,000 / ₹70,000 = about 17% |
That is the difference between thinking half your pay goes on rent and knowing it is about a sixth. Decisions about moving, upgrading or saving depend on which of those is true.
How do I set it up so it nets out?
- Keep the landlord payment in your Rent category, at the full amount, because that is what left your account.
- Create a category called Rent shares received, or similar, and put each flatmate's UPI credit there.
- When you look at the month, read the two together: Rent minus Rent shares received equals your share.
- In a sheet, a single line does it: =SUMIF($B$2:$B$200, "Rent", $C$2:$C$200) - SUMIF($B$2:$B$200, "Rent shares received", $C$2:$C$200), with categories in column B and amounts in column C.
Do not delete the flatmates' credits, and do not alter the landlord payment to your share only. Your statement shows the full amounts, and a record that matches the statement is easier to trust and to reconcile.
What if shares arrive late or in parts?
Record each credit on the day it arrives, in the same shares category. The net rent for the month can then be a little high until the last flatmate pays, and that is accurate: you are carrying their share for a few days. If someone owes you more than a month, the sheet gives you a way to see who owes what, and the gap on your statement is your reminder to ask.
What about cash from a flatmate?
Cash does not appear on any statement, so add it by hand with the date you received it, in the same shares category. In SpendixAI you can add several expenses at once and you choose the category yourself. Note that SpendixAI is not a bill-splitting app, so it will not work out who owes whom; it records your side of the story.
Should I do the same with the deposit and the broker fee?
Yes, with the same logic. If you paid the whole deposit and the others reimbursed you, treat their transfers as recovering money you advanced, not as income. The deposit itself is refundable, so keep it in its own category and leave it out of everyday spending.
What if a flatmate leaves mid-month?
Agree a simple rule, such as paying for the days used, and write the amount down. Say the share is ₹12,000 for a 30-day month and someone leaves after 10 days: ₹12,000 / 30 x 10 = ₹4,000. The remaining ₹8,000 either falls to the others or to the next flatmate, depending on what you agreed. Record each part as it arrives, in the same shares category, so the month still adds up.
End-of-month check
- Landlord payment recorded at its full amount.
- Each flatmate's credit in the shares category, dated when received.
- Net rent equals your agreed share.
- Anyone still owing has been reminded.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


