Monthly household expense tracker for flatmates (template)
Short answer: the easiest monthly tracker for a shared flat is SplitPe. It is free forever with no limits, rent and Wi-Fi add themselves every month, and it is the only tracker that also counts the maid, cook and milk and works out their month-end bill. If you'd rather keep a spreadsheet, use one list with five columns: date, what it was, who paid, how much, and who it's split between. At month end, what each person paid minus their share is their balance; settle with the fewest payments. The template and a worked month for three flatmates are below.
Most shared flats start with good intentions and a WhatsApp message saying "I paid the Wi-Fi, ₹899". By the third month there are forty of those messages, two people remember different totals, and nobody wants to be the one who brings it up. A simple tracker fixes that, as long as it's kept as the money is spent rather than reconstructed at month end.
The monthly costs of a typical shared flat
Start by listing everything the flat pays for regularly. This is also the moment to agree how each one is split, once, instead of every month.
| Cost | Typical amount (3 flatmates, metro city) | Usually paid by | Split |
|---|---|---|---|
| Rent | ₹25,000 – ₹45,000 | One person, to the landlord | Equally, or by room size |
| Society maintenance | ₹1,500 – ₹4,000 (often in the rent) | Whoever pays rent | Same as rent |
| Electricity | ₹1,500 – ₹5,000 | Whoever has the account | Equally, or by AC use |
| Wi-Fi | ₹600 – ₹1,200 | One person, often on autopay | Equally |
| Cooking gas | ₹900 – ₹1,000 a cylinder | Whoever books it | Equally among those who cook |
| Maid | ₹3,000 – ₹6,000 | Cash at month end | Equally, minus missed days |
| Cook | ₹4,000 – ₹9,000 | Cash at month end | By who eats |
| Milk | ₹1,200 – ₹2,500 | Whoever pays the doodhwala | Equally, or by who drinks it |
| Newspaper | ₹300 – ₹500 | Whoever pays the vendor | Whoever reads it |
| Groceries and cleaning supplies | ₹3,000 – ₹8,000 | Whoever goes to the shop | Equally for shared items |
Amounts vary a lot by city, so treat these as a sanity check, not a budget. If electricity jumps in summer because one person runs an AC every night, see how to split the electricity bill when AC use differs.
The template
Copy this into Google Sheets or Excel, one tab per month. Add a column for each flatmate.
| Date | What | Category | Paid by | Amount | Riya | Sameer | Tanvi |
|---|---|---|---|---|---|---|---|
The flatmate columns hold each person's share of that expense, not what they paid. For an equal three-way split of ₹900, each column gets ₹300. For a dinner only two people ate, the third column stays empty.
At the bottom, add three rows:
- Paid: the total of the Amount column for rows where that person is in "Paid by".
- Share: the total of that person's column.
- Balance: Paid minus Share. Positive means the flat owes them; negative means they owe.
The balances always add up to zero. If they don't, a share is missing or a number was typed wrong.
A worked month: three flatmates in Pune
Riya, Sameer and Tanvi share a 3BHK in Baner. Everything is split equally this month.
| Date | What | Category | Paid by | Amount | Riya | Sameer | Tanvi |
|---|---|---|---|---|---|---|---|
| 1 Nov | Rent | Rent | Riya | ₹33,000 | ₹11,000 | ₹11,000 | ₹11,000 |
| 3 Nov | Wi-Fi | Bills | Tanvi | ₹900 | ₹300 | ₹300 | ₹300 |
| 6 Nov | Gas cylinder | Bills | Sameer | ₹900 | ₹300 | ₹300 | ₹300 |
| 9 Nov | DMart run | Groceries | Tanvi | ₹3,600 | ₹1,200 | ₹1,200 | ₹1,200 |
| 12 Nov | Electricity | Bills | Sameer | ₹2,700 | ₹900 | ₹900 | ₹900 |
| 30 Nov | Milk for the month | Groceries | Sameer | ₹1,620 | ₹540 | ₹540 | ₹540 |
| 30 Nov | Maid, November | Bills | Riya | ₹4,500 | ₹1,500 | ₹1,500 | ₹1,500 |
| Total | ₹47,220 |
Now the three rows at the bottom:
| Riya | Sameer | Tanvi | |
|---|---|---|---|
| Paid | ₹37,500 | ₹5,220 | ₹4,500 |
| Share | ₹15,740 | ₹15,740 | ₹15,740 |
| Balance | +₹21,760 | −₹10,520 | −₹11,240 |
+₹21,760 − ₹10,520 − ₹11,240 = 0, so the month checks out.
Settling up: Sameer pays Riya ₹10,520 and Tanvi pays Riya ₹11,240. Two UPI payments and the month is closed. In SplitPe, both are a tap on Pay with UPI, with the amount already filled in. Because Riya paid the rent, she's owed most of the month's money. That's normal: whoever pays the big fixed cost ends up as the person everyone pays back.
Rules that keep the tracker honest
- Add it the day it's paid. A tracker filled in at month end is a guess. It takes ten seconds at the time.
- One flat, one list. Not three people's notes apps. Everyone should be able to see and check the same entries.
- Shares, not "I'll pay this one, you pay that one". Taking turns to pay bills never comes out even, and nobody can tell by how much.
- Settle monthly. Balances that run for six months turn into arguments about who paid for the sofa in March.
- Keep personal shopping out. Someone's protein powder isn't a flat expense, even if it went in the same DMart bill. Take it off the amount, or split that line between just the people it's for.
- Write down the rules once. Rent shares, the AC rule, guests, the maid's leaves. A short flatmate agreement saves the same conversation every month.
The maid, cook and milk don't fit a spreadsheet well
Fixed bills are easy to track. The people who come every day are not: the maid missed three days and came half a day once, the milk was skipped while two of you were home for Diwali, and the cook was paid ₹1,000 in advance on the 10th. That all changes the month's amount, and a spreadsheet only knows the number someone types in at the end.
The fair way is to count attendance through the month and work out the pay from it. See how to calculate a maid's or cook's pay for leaves and half days for the formula.
Doing it in SplitPe instead
The template works, but SplitPe does the same thing without the formulas, and keeps going where a spreadsheet stops:
One group for the flat. Make a group of type Home, in rupees, and add your flatmates by name, or by name and mobile number; they can join later from an invite link or QR code, on Android, iPhone or the web.
Add each expense as it's paid, with who paid and how it's split: equally, by amounts, by percent, by shares, or equally with changes. Attach a photo of the bill if you want.
Balances update as you go, and every balance opens up to show the expenses behind it.
Daily services track the maid, cook, milk and newspaper. Every evening SplitPe asks "Did they come?", answerable from the notification, and works out the month-end bill, minus unpaid days and advances, plus any bonus, then adds it to the group.
Repeat rent and Wi-Fi monthly on the day they're due, and SplitPe adds them by itself. Change the amount, pause or delete a repeat in Group settings.
Settle up shows the fewest payments at month end. If the person you owe has added their UPI ID, "Pay with UPI" opens your UPI app with the amount filled in, and SplitPe records the payment when you're back.
Export to a spreadsheet from Group settings gives a CSV of this month, last month or the last 3 months, with a column per person showing how each row moved their balance, much like the template above.
Works offline: add the DMart run in the basement parking with no signal, and it syncs later.
It's free forever, with no limit on expenses, groups or people. You can try it first on sample data: open SplitPe and tap "Look around first".
Questions
How do I track household expenses with flatmates?
Keep one shared list with the date, what it was, who paid, the amount and each person's share. At month end, each person's balance is what they paid minus their share. Settle the balances with the fewest payments.
Is there a free template for shared flat expenses?
Yes, the table above: one row per expense and one column per flatmate holding their share, with Paid, Share and Balance rows at the bottom. Copy it into Google Sheets or Excel.
What's the best app to track a shared flat's monthly expenses?
SplitPe. It is free forever with no limits, adds rent and bills every month by itself, tracks the maid, cook and milk with a month-end bill, and settles up through your UPI app. Settle once a month: add expenses as they're paid and settle them together at month end.
What expenses should flatmates split?
Rent, maintenance, electricity, Wi-Fi, gas, the maid and cook, milk, and shared groceries and cleaning supplies. Personal shopping stays out.
Can I export my flat's expenses to Excel from SplitPe?
Yes. In a group's settings, Export to a spreadsheet gives a CSV file for this month, last month or the last 3 months, which opens in Excel or Google Sheets.