Families sharing a home with a live-in coworker need two agreements: a household cost rule and a clear boundary around work or housing. Start by separating rent, utilities, groceries, personal purchases, deposits, and any payment for chores or job duties. Then choose a split method for each category and record it in one shared sheet.

Equal shares are simple when incomes, rooms, and usage are close. Room-size, income-based, per-person, or usage-based shares can fit a less even setup. Keep the math visible. That small habit prevents a minor grocery run from turning into a larger argument.

Define the household ledger before choosing percentages

Fairness starts with scope, not arithmetic. Decide which purchases belong to everybody before deciding who pays what.

Cost Rule to consider What to record
Rent or room cost Use an agreed fixed share, room-size method, or another written formula Monthly amount, due date, move-in date, and move-out rule
Utilities Split equally, by person, or by an agreed usage estimate Bill, billing period, and calculation
Groceries Share only agreed meals and household items Receipt, participants, and personal items excluded
Household supplies Use an equal or per-person share Category, receipt, and participating people
Deposit and move-in costs Record each advance and the plan for any refund or deduction Payer, amount, date, and settlement rule
Work or chores Keep separate unless the household documents a credit Task, period, value, and approval

Personal toiletries, private meals, clothing, and work equipment usually belong in a person's own column. The group can choose a different rule, but write it down before the charge appears.

A live-in coworker may be a colleague renting a room, a working relative, or someone whose housing is connected to a job. If work, chores, meals, or a room are part of the arrangement, keep those terms separate from ordinary reimbursements and check state and local requirements before treating one as payment for another.

Choose a split method for each cost

One formula rarely fits every line. Rent and groceries often need different logic.

Equal split. Divide the cost by the number of participating people. For two adults, a $200 bill becomes $100 each. It is easy to audit, but it can feel rough when incomes or usage differ.

Income-based split. Use total cost x person's income / participating income. If one person earns $500 a week and another earns $300, a $200 bill becomes $125 and $75. Use the same income period and definition for both people, and share only the financial detail the group actually needs.

Room-size split. Assign rent according to bedroom area. A 200-square-foot room in a two-room total of 350 square feet represents about 57.1% of the bedroom area. On $1,800 rent, that share is about $1,029 after rounding. Room size does not account for private bathrooms, light, noise, storage, or common space, so add an agreed adjustment rather than pretending the formula is perfect.

Per-person or usage-based split. This can work better for groceries, water, or electricity when participation differs. A person who is away often may not want the same grocery share; someone working from home may use more electricity. Estimate openly, not silently.

Turns out, a hybrid is often easier to explain. Use room size for rent, equal or per-person shares for utilities, and participant counts for shared meals. You do not need one rule for every expense.

  • Similar rooms, incomes, and usage: use an equal split.
  • Uneven bedrooms or private features: use a room-size split for rent.
  • A large income difference and mutual consent: consider an income-based split.
  • Different schedules or meal habits: use a per-person or usage-based split.

Try the rule for one billing cycle. Then change only the category that caused trouble.

Put the agreement in writing

Write the agreement before move-in or before the next billing cycle. A shared message, document, or signed page can work; clarity matters more than the format.

Name each person, the effective date, cost categories, percentages, due dates, payment method, receipt standard, deposit treatment, move-out calculation, and approval process for changes. Include a rule for late entries and disputed charges, even if the rule is simply to pause the row and discuss it at the next check-in.

Lease obligations sit outside your spreadsheet. A private agreement between occupants may not change what a leaseholder, landlord, or property owner can require, so read the lease and check local rules before someone moves in.

Chores should not quietly cancel rent. If the household wants a credit for cleaning, cooking, or maintenance, name the task, amount, period, and approval process in writing.

Build a Google Sheets tracker

Use one row per expense. That makes corrections easier and keeps receipts tied to the math.

Column Example or formula
Date 2026-05-10
Category Electricity
Description May electric bill
Total $200.00
Person A % 50%
Person B % 50%
Person A share =D2*E2
Person B share =D2*F2
Share check =IF(SUM(E2:F2)=1,"OK","CHECK")
Paid by Person A
Status Pending, Partial, Paid, or Disputed
Receipt link Shared Drive link or photo location
Notes Why someone was excluded or why the split changed

The percentages in each row should total 100%. For three or more adults, add a share and owed column for each participant, or use a separate split table linked to the expense ID.

On a Summary tab, =SUMIFS($G$2:$G$200,$B$2:$B$200,"Utilities") totals Person A's utility share when Person A's share is column G. To see the net position, subtract what that person paid with =SUM(G2:G200)-SUMIF(I2:I200,"Person A",D2:D200). A positive result means that person has advanced less than their calculated share and may owe the group.

Protect formula ranges and give edit access only to people who enter expenses. Everyone else can view or comment. Use version history to inspect changes, and save a dated copy if the household needs a fixed record.

To be honest, put receipt links in as you go, even if the note looks a little messy at first. Do not put full bank account numbers in the sheet. Income is sensitive too.

Keep income and room calculations visible

An income ratio belongs on a Settings tab if the household wants it to update. Put Person A income in B2, Person B income in B3, and total income in B4 with =SUM(B2:B3). Person A's share can then use =D2*(Settings!$B$2/Settings!$B$4), while Person B's share uses =D2*(Settings!$B$3/Settings!$B$4).

Use the same period for both incomes. Weekly and monthly numbers cannot be mixed.

Dynamic formulas have a catch. If you change the Settings values later, old expense rows may change too. For clean records, save the agreed percentages in each row or keep a dated settings table with an effective date.

For a room-size split, store bedroom areas in a Rooms tab, total them with =SUM(B2:B3), and calculate a rent share as =D2*(B2/Rooms!$B$4) if B4 holds total area. Apply that calculation to rent only unless the household agrees on another use. Round at the final share and make sure the rounded amounts still equal the bill.

Run a simple reimbursement routine

Tracking and paying are separate jobs. The sheet records who should bear the cost; cash, a bank transfer, or a payment app handles the handoff.

  1. Enter the expense, category, payer, and receipt as soon as practical.
  2. Apply the agreed percentages and confirm the share check says OK.
  3. Send the person who owes money the amount, receipt, and agreed due date.
  4. Record the payment outside the sheet using the household's chosen method.
  5. Update the row with the settlement date and mark it Paid, Partial, or Disputed.

A request can stay plain: "I logged $200 for May electric. Your share is $100. The receipt is linked in row 12. Please settle by Friday and mark the row paid afterward."

If payment is partial, record the amount and date. Do not mark the full row paid. Do not delete or overwrite the original expense after reimbursement.

Review the rules before small problems grow

Hold a 10-minute check-in each week, perhaps Sunday evening or Monday morning. Review new rows, unpaid balances, missing receipts, and any change in occupants, work schedules, meals, or rooms.

Keep the conversation about rows and rules. If a split feels wrong, name the category, propose a replacement, and set an effective date. Apply the new method to future expenses unless everyone agrees to recalculate an older one.

Thing is, the most useful review is boring. A quick check catches a missing receipt before memory gets fuzzy.

Keep tax and lease questions separate

Shared household math does not answer tax questions. A transfer between occupants might be a reimbursement, rent, compensation, or something else depending on the facts.

If a homeowner or leaseholder receives payment for the use of real estate, the IRS Topic 414 guidance says rental income and related expenses are generally reported on Schedule E, with depreciation and other rules covered in Publication 527. Personal-use and mixed-use arrangements can change the analysis.

Do not use the spreadsheet as a tax classification tool. Ask a qualified tax professional about a specific arrangement, and keep the written agreement, receipts, and payment records together.

Start with one clean billing cycle

Before the next bill, create the Expenses and Settings tabs, write the category rules in one shared note, and schedule the first 10-minute review. Start with one billing cycle, then adjust only the rows that caused friction.