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.

Fictional example · USD
ExpensePaid byAmount
RentAna$1,200
UtilitiesBruno$300
GroceriesCarla$300
Shared total$1,800
Balance · USD
PersonPaidTheir shareBalance
Ana$1,200$600Receives $600
Bruno$300$600Owes $300
Carla$300$600Owes $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:

Fictional example · USD
PersonPaidTheir shareBalance
Ana$1,200.00$870.00Receives $230.00
Bruno$300.00$670.00Owes $270.00
Carla$300.00$260.00Receives $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 whom

Download 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 template

For 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.

Keep reading

How to split travel expenses with friends