How to split roommate expenses and settle the month
Agree on shared expenses and the split before paying. Record who paid each bill, total each person’s share, and reimburse anyone who paid more than their share at month-end.
Write down the rules before paying
Separate rent, utilities and shared shopping from personal purchases. You can agree on equal shares or different percentages; different rooms do not impose one universal rule.
Keep one shared record
Each entry needs a month, purpose, amount, payer and participants. Keep any receipts you need. Avoid counting the same bill in a chat and again when moving it into a spreadsheet.
Rent, utilities and groceries shared by three roommates
Ana, Bruno and Carla agree to split these expenses equally for a full month. These fictional USD amounts are not a suggested household budget.
| Expense | Paid by | Amount |
|---|---|---|
| Rent | Ana | $1,200 |
| Utilities | Bruno | $300 |
| Groceries | Carla | $300 |
| Shared total | $1,800 | |
| Person | Paid | Their share | Balance |
|---|---|---|---|
| Ana | $1,200 | $600 | Receives $600 |
| Bruno | $300 | $600 | Owes $300 |
| Carla | $300 | $600 | Owes $300 |
Check each roommate’s share
The shared total is $1,800, so each person owes $600. Ana paid $1,200, Bruno paid $300 and Carla paid $300. Splitting the remaining bank balance is not enough: account for what everyone already paid.
Close the month and carry balances explicitly
Agree on a review date. If someone moves in or out mid-month, decide which expenses they share and the split before calculating them. Carry an unpaid balance forward explicitly without counting the original bill twice.
How to settle up
Bruno pays Ana $300 and Carla pays Ana $300. After reimbursement, each person has paid their $600 share. Confirm payments together and keep the completed record for next month.
Different rooms and a half-month stay
Fictional example: the roommates agree to split USD 1,200 rent as USD 600 for Ana, USD 400 for Bruno and USD 200 for Carla. This is their agreement, not a universal rule about room sizes. USD 300 utilities are split by 30, 30 and 15 days of occupancy: USD 120, USD 120 and USD 60. Carla pays USD 300 groceries shared only by Ana and Bruno. Bruno has already repaid Ana USD 100.
Balances after the partial repayment:
| Person | Paid | Their share | Balance |
|---|---|---|---|
| Ana | $1,200.00 | $870.00 | Receives $230.00 |
| Bruno | $300.00 | $670.00 | Owes $270.00 |
| Carla | $300.00 | $260.00 | Receives $40.00 |
To settle this example: Bruno pays Ana: $230.00. Bruno pays Carla: $40.00.
Agree which costs are prorated by days. Rent can follow a different rule from utilities. Do not count a repayment as another expense.
For another currency, retain the original amount and record that expense or payment’s rate: 1 original unit = X result currency units. Rates may vary between movements. EUR 1 = USD 1.20 is not the same as USD 1 = EUR 1.20.
Calculate my own expenses
Split trip, roommate or group expenses. Record who paid, choose participants and calculate balances and repayments, even across currencies.
Shared expense calculator: who owes whomDownload Excel template
An editable file with formulas. You can also import it into Google Sheets. Includes a fictional example and instructions to replace it.
Download Excel templateFor Google Sheets: upload the file to your Drive, open it with Sheets and save a copy in that format. Replace the fictional people and rows with your data and keep the formulas. Downloaded or uploaded files remain under your control.
Frequently asked questions
Does rent have to be split equally?
No. You can agree on different amounts or percentages. Make the rule explicit and check that all shares add up to the total.
How do we separate personal groceries?
Record personal items separately or exclude the people who did not share them. Keep that decision with the expense.
Does Debtly pay bills or collect from roommates?
No. Debtly records and organizes expenses and payments. Transfers happen separately through the payment method you agree on.