A rent split template that does the math for you
Download the template, list the rent and bills, and drop it back in: each roommate's share and who owes whom.
| Roomtally | A blank spreadsheet | |
|---|---|---|
| Room-size weighting | Built in, with an equal-split blend | Write and check the formulas yourself |
| Bills shared by only some people | Split column, e.g. “Sam;Jo” | Extra formulas per bill |
| Settle-up transfers | Listed automatically | Work out by hand |
| Flags | Unknown payers, names that don't match, missing room sizes | None |
Honest take: a spreadsheet you already maintain works fine; keep it and drop it into Roomtally to check the math and get the transfers.
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.