Use one rule for each kind of expense, not one rule for the whole apartment. Equal shares keep things simple; income-based shares change the burden by ability to pay; room adjustments account for unequal private space. Put the choice in writing and track it in a shared Google Sheet. Keep it visible.
With $2,000 monthly for Roommate A and $3,000 for Roommate B, the agreed total is $5,000. An income-based split is 40% and 60%, so a $500 shared bill becomes $200 and $300. The arithmetic is easy. Agreement on the inputs is harder.
Choose a fair roommate bill-splitting rule
Fair does not always mean identical. It means everyone understands the rule, accepts the tradeoff, and can repeat the math without an argument.
Choose the rule before anyone pays a deposit or first bill.
| Rule | A practical fit | Tradeoff to discuss |
|---|---|---|
| Equal split | Incomes are close, roughly within 20%, or simplicity matters most. | The same dollar amount can press harder on the lower earner. |
| Income-proportional | Monthly incomes differ and everyone accepts the chosen income definition. | Exact figures can create privacy concerns and need periodic review. |
| Room-adjusted | Bedrooms have noticeably different sizes or features. | This measures private space, not utility use. |
| Usage-based | A bill can be tied to credible usage records. | Detailed tracking can add more friction than it saves. |
| Hybrid | Room value and ability to pay both matter. | Write the sequence so no one has to guess. |
A mixed setup is perfectly workable. Rent might reflect room size, utilities might be equal, and personal groceries might stay separate.
Calculate an income-based share
Use the same time period and definition for everyone. The example below uses monthly after-tax income, but your group should decide whether recurring aid or irregular work belongs in that figure.
- Write each person's agreed monthly amount.
- Add all amounts to find the group total.
- Divide each person's amount by that total.
- Multiply each percentage by every expense covered by the rule.
For the example, Roommate A earns $2,000 and Roommate B earns $3,000. The total is $5,000. A's share is 2000 / 5000 = 40%, and B's share is 3000 / 5000 = 60%.
In Google Sheets, put the incomes in B1:C1. In B2, enter =B1/SUM($B$1:$C$1), then copy the formula across. Format row 2 as a percentage. If a total bill is in C5, A's share is =C5*B2.
If you enter 40 instead of 40%, use =C5*(B2/100) instead. Pick one format and use it consistently.
Review the percentages in January and July, or sooner if jobs, aid, or household membership changes. Record the effective date. Do not quietly rewrite old expense rows.
Separate shared costs from personal spending
The spreadsheet cannot fix a vague definition of shared. Decide which costs enter the common pot and which costs remain personal.
| Expense | Starting point | Rule to write down |
|---|---|---|
| Rent and housing deposits | Use the selected rent rule. | State whether room size changes the base share. |
| Utilities, internet, and trash | Split equally or use the household's selected percentage. | Decide how unusual usage or guests are handled. |
| Groceries | Keep personal groceries separate or create an equal shared pot. | Separate communal staples from snacks, bulk foods, and meal delivery. |
| Household supplies | Equal shares often keep restocking simple. | Include cleaning supplies, paper goods, and replacement items if agreed. |
| Personal subscriptions, guests, pet costs, and personal purchases | Keep them personal unless approved. | State who approves an exception and how it is recorded. |
An unlisted purchase should stay personal until the group approves it. That one fallback rule prevents many small disagreements.
Adjust rent for unequal rooms and actual use
Room-size splitting addresses a different issue from income. If one bedroom is notably larger, has a private bathroom, or includes a feature the other room lacks, an equal rent split may not feel balanced.
Measure each private room and divide its area by the total private-room area. Treat that result as a starting percentage, then agree how shared spaces affect the final rent. Write the calculation down before signing the lease.
Turns out, utilities need their own decision. Equal shares can be easier because individual use is difficult to measure. A usage-based split can fit electricity when reliable usage data exists, but detailed tracking may create more debate than the savings justify.
If you combine room size and income, define the order of operations. For example, you might use room-adjusted shares for rent and income shares for utilities instead of stacking two formulas on every bill. If you do combine them, create one sample row and check that the final percentages total 100%.
Build a Google Sheets roommate budget tracker
Use one row per expense. For two roommates, these columns show the bill, each person's share, who fronted the money, and the resulting balance.
| Column | What to enter |
|---|---|
| A | Date |
| B | Description |
| C | Total amount |
| D | Paid by: A or B |
| E | Split type: equal, income, room, usage, or reimbursement |
| F | A's share, such as 40% |
| G | B's share, such as 60% |
| H | A's share of the bill |
| I | B's share of the bill |
| J | Amount A paid |
| K | Amount B paid |
| L | A's net position |
| M | B's net position |
For row 2, use these formulas:
| Cell | Formula | Purpose |
|---|---|---|
| H2 | =C2*F2 |
Calculates A's share |
| I2 | =C2*G2 |
Calculates B's share |
| J2 | =IF(D2="A",C2,0) |
Records whether A fronted the bill |
| K2 | =IF(D2="B",C2,0) |
Records whether B fronted the bill |
| L2 | =J2-H2 |
Shows A's net position |
| M2 | =K2-I2 |
Shows B's net position |
A positive net means the group owes that person. A negative net means that person owes the group.
If A pays a $500 bill and A's share is $200, A's net is positive $300. B's net is negative $300. That is clearer than marking the expense simply unpaid.
For a pure reimbursement, use a 100% share for the person who should bear the cost and 0% for the others, but only after the group agrees it is reimbursable. Ordinary shared bills should show each person's real share.
Create a second tab named Settlements with Date, From, To, Amount, and Note. If A's expense net is in Expenses!L2:L, the settlement-adjusted position for A can use:
=SUM(Expenses!L2:L)+SUMIF(Settlements!B:B,"A",Settlements!D:D)-SUMIF(Settlements!C:C,"A",Settlements!D:D)
This adds payments A sends and subtracts payments A receives. For three or more roommates, add a share and net column for each person, or use a longer ledger with one person per row.
Keep input cells editable and formula cells protected or visually distinct. For a menu walkthrough, see Sheets Bootcamp's instructions for protecting ranges. Save a monthly PDF or spreadsheet copy if the group needs a fixed record.
Keep income details private when needed
The shared sheet usually needs agreed percentages, not everyone's full financial history. Thing is, no roommate should have to turn the expense log into an income diary.
| Approach | What the group sees | Best fit |
|---|---|---|
| Private calculation | Only final percentages appear in the shared sheet. | The group accepts the method but wants privacy. |
| Income bands | Roommates use ranges, such as "under $2,500," instead of exact figures. | Rough proportionality is acceptable. |
| No income sharing | The group uses equal, room-adjusted, or usage-based rules. | People do not agree to disclose income. |
Income proof can be optional. Roommates may use pay stubs, a private calculation, or an honor system, but decide that before applying the formula.
Put the roommate budget rules in writing
Write the agreement in ordinary language. Include the shared categories, split percentages, receipt process, payment deadline, review dates, and approval rule for exceptions.
A sample agreement could read:
Rent and utilities use 40% and 60% shares. Groceries stay separate unless added to the shared list. The buyer records the expense and receipt within seven days. Reimbursements are due within seven days of the request. We review the percentages in January and July. Changes require group approval, and an unlisted purchase stays personal until approved.
Keep receipt images in one shared folder. Add the receipt link or file name to the relevant Sheet row.
The written rule should also say who logs bills. One roommate can handle it, or the task can rotate. Either way, everyone should know where the current file lives.
Review balances without creating friction
Make the routine boring. A weekly update, such as Sunday night, prevents several unrecorded bills from piling up.
A short meeting on the first day of each month can clear old balances. Fifteen minutes is enough for many small households. Review the sheet, confirm receipts, record settlements, and identify any rule that keeps causing confusion.
Keep reminders factual:
The sheet shows $50 for utilities, due under our seven-day rule. Can you check row 12?
A payment app may move the money, but the Sheet should still record the expense, receipt, and settlement. If payments are repeatedly late, refer to the written rule and discuss whether the deadline or split needs to change.
Keep the spreadsheet beside the lease
A roommate budget agreement documents what roommates owe one another. It does not automatically change the obligations written in a lease.
If co-tenants share one lease, the landlord's rights and each tenant's obligations depend on the lease and local law. Check the lease and local tenant resources for questions about rent, deposits, late fees, or liability.
Common sticking points
What if someone will not share income information?
Use a private calculation, income bands, or a different split method. Equal or room-adjusted shares may be simpler if the group cannot agree on disclosure.
Should utilities follow the rent formula?
Not necessarily. Equal utilities may be easier, while income-based or usage-based shares can work when the group chooses them and can explain the records.
Can room size and income rules be combined?
Yes, but write the formula first. Many groups use room adjustments for rent and a separate rule for utilities rather than applying two percentages to every expense.
What happens if someone buys a personal item by mistake?
Mark it personal unless the group approves reimbursement. If it is approved, add the receipt, use the reimbursement split, and record the settlement.
Before the next bill arrives, create Expenses and Settlements tabs, enter the agreed percentages, and test one $500 row together. If both roommates can follow the result, the rule is ready for daily use.