A roommate expense spreadsheet that does the math
One row per bill with who paid and who shares it; Roomtally totals each roommate's share and flags payers who aren't on the list.
How the split works
List the rent and every shared bill with its amount and who paid it. Rent is split by room size — or any weight you choose, like 1.2 for a room with a private bathroom — and you can blend it with an equal split (50% means half by size, half equal). Bills are split equally among everyone, or only among the people named in the split column. Each roommate's balance is what they paid minus their fair share, and Roomtally lists suggested transfers that settle everyone up.
Keep one row per bill: item, kind (rent or bill), amount, paid by and split. Payers not in the roommate list, names that don't match and missing room sizes are flagged.
Your figures stay on your computer
Roomtally reads your file with JavaScript in this browser tab. Nothing is uploaded, and the rows are gone when you close the tab.
How it works
- List the rent and bills — item, rent or bill, amount, who paid and who shares it — in the template, or try the sample.
- Enter the roommates and room sizes, and how much of the rent follows room size.
- Print the split with each fair share and the settle-up transfers to share with the household.
FAQ
Is my data uploaded?
No. Your files are read by JavaScript in your browser tab and never sent to us or anyone else. Bill rows aren't stored, so closing the tab clears them. Settings can be saved in this browser if you ask.
What does Roomtally do?
It reads a list of a household's rent and shared bills, splits the rent by room size (or a blend with an equal split), splits bills equally or among the people who share them, shows each roommate's fair share and balance, and lists the transfers that settle everyone up.
How is rent split by room size?
Each roommate pays the rent times their room's size divided by the total of all rooms. At a 50% blend, half the rent is split that way and half equally, which accounts for shared space everyone uses.
Can I weigh a private bathroom or parking?
Yes. Room sizes can be any weight: add square feet or use numbers like 1.2 and 1 for rooms with and without a private bathroom. A parking spot can also be its own bill split only to the person who uses it.
What's free?
Importing any number of bills, every fair share, the settle-up transfers, every flag, 3 rent what-ifs and 12 bills on screen and in print (with a footer). Pro shows everything and adds the Excel workbook and CSV exports.
What isn't covered?
Security deposits, move-in and move-out mid-month proration, subletting, the landlord's own rules and local rent laws. It is a worksheet, not legal or tax advice.
Is this legal or tax advice?
No. Roomtally applies the arithmetic it describes to the figures you provide. On a joint lease every tenant is usually liable for the whole rent whatever you agree among yourselves. Check your lease and local law. It is not affiliated with any landlord.