Settle the rule before the next store run, not in the aisle. The practical default is simple: treat basic common-space supplies as shared, then split them equally or by whatever usage ratio the house agrees on. Reimbursement answers who paid first. It doesn't decide who ultimately owes what, and keeping those two questions apart is most of the job.

Why does a $6 bottle of dish soap get so awkward? Cleaning supplies are small money that repeats. One roommate keeps buying it, everyone keeps using it, and nobody wants to look petty bringing it up. The fix isn't perfect math. It's a visible rule, a receipt, and one place where anyone can check the balance.

Decide what the house shares

Don't debate every sponge. Start with a short list, and treat a product as shared when it serves a common area or most roommates can reasonably use it.

Category Typical examples Default treatment
Shared household Dish soap, trash bags, paper towels, basic kitchen and bathroom cleaners Split under the house rule
Personal Laundry detergent, a preferred brand, or a specialty cleaner for one person's private bathroom The buyer pays
Conditional Bulk refills, premium products, or supplies used mainly in a private area Share only after agreement

These labels are defaults, not permanent ones. If a roommate rarely touches a product, the group can still share it, because keeping the house stocked is its own convenience. Just write that choice down.

To be honest, the written list matters more than any category system. It's what stops one roommate from assuming a bulk purchase is shared while everybody else assumed it was personal.

Choose a split method that fits the household

Every method solves a different problem, so pick the one your roommates can keep up without re-litigating each receipt.

Method Works well when Main tradeoff
Equal split Usage is broadly similar and the purchases are modest A heavy user pays the same as a light user
Usage-based split One person's cooking, guests, or cleaning habits clearly affect consumption Estimates require trust and occasional review
Room or area adjustment A private bathroom or larger area needs noticeably more product It can be hard to isolate the extra use
Reimbursement after purchase One roommate usually shops and pays upfront Others need to repay their shares promptly

Equal is the easiest place to start. For a $20 purchase shared by three people, log $6.67, $6.67, and $6.66 instead of pretending each share is exact. Somebody eats the extra cent. Decide who before it happens.

Usage-based shares can stay loose. If the group agrees one person's cooking drives about 40% of the dish-soap use, a 40/30/30 split is reasonable. It's an agreed estimate, not a measurement.

Room and area adjustments run on the same logic, so a private bathroom that needs its own cleaner can justify a bigger share for that roommate, provided the bump stays modest and written down, because the second the adjustment turns vague is the second it turns into a grudge. An income-based ratio is also an option if the household already splits costs that way. Never assume the higher earner automatically pays more, though.

Reimbursement is not a competing fairness method. It's the collection step after someone fronts the money. You can reimburse an equal split, a usage-based split, or an area-adjusted one.

Run whichever method you pick for a month. Then look at the actual purchases and change the rule if it's creating more work than value.

Build a shared cleaning-supply tracker

For most households, a plain spreadsheet is plenty. It records what was bought, who paid, and what each person finally owes.

Use one Expenses tab with columns like these:

Column What to enter Why it helps
Date Purchase date Keeps old expenses from getting forgotten
Item Dish soap, trash bags, or cleaner Makes the charge recognizable
Paid by The roommate who paid at checkout Shows who fronted the money
Total The full receipt amount Provides the calculation base
Split type Equal, usage-based, or area adjustment Explains the percentages
Each roommate's share One percentage per person Shows the final responsibility
Receipt A photo, file name, or shared-folder link Gives everyone a record
Status Unsettled or paid Prevents duplicate requests
Split check A formula result Catches percentages that do not total 100%

Names need to stay consistent, and that's not just about tidiness. Alex, Blair, and Casey shouldn't become A, B, and C on some rows while other rows use full names, because every formula that matches on a name will quietly skip whatever it doesn't recognize.

  1. Create Expenses, Settlements, and Rules tabs. Give edit access to the roommates who maintain the log, and leave unrelated personal information out of the file.
  2. Log each purchase while the details are still clear: item, date, total, payer, split, receipt reference.
  3. Enter each person's final responsibility percentage. Three equal shares means 33.33%, 33.33%, and 33.34%, or you can calculate dollar amounts directly.
  4. Record repayments on the Settlements tab with Date, From, To, Amount, and Note.
  5. At the agreed check-in, review the open rows and mark each payment once it's confirmed.

If the file lives in Google Sheets, share it with specific roommates rather than posting an unrestricted link. This Google Sheets sharing permissions guide covers the usual access controls in a narrow walkthrough; the labels may differ in your current interface.

Keep fronted costs separate from fair shares

Turns out, the classic spreadsheet mistake is blending who paid with who should bear the cost. Those are two different facts.

Paid by records the roommate who laid out the money. The percentage columns record the final split. If your template has a separate paid-allocation area, mark the buyer at 100% and everyone else at 0% until the expense is repaid. Keep that allocation away from the fair-share numbers.

Here's the worked version. Suppose D holds Total, C holds Paid by, and F holds Alex's final share. Alex's balance before repayments is:

=SUMIF($C$2:$C$100,"Alex",$D$2:$D$100)-SUMPRODUCT($D$2:$D$100,$F$2:$F$100)

A positive result means Alex paid more than Alex's fair share and is owed money. A negative result means Alex owes.

To confirm three shares total 100%, put this in a Split check cell:

=IF(ROUND(SUM(F2:H2),4)=1,"OK","Check split")

If the Settlements tab uses column B for From, column C for To, and column D for Amount, adjust Alex's balance by adding:

-SUMIF(Settlements!$B$2:$B$100,"Alex",Settlements!$D$2:$D$100)+SUMIF(Settlements!$C$2:$C$100,"Alex",Settlements!$D$2:$D$100)

One error will quietly corrupt the totals: erasing the original expense after you've recorded its payment. The same purchase just got counted twice. For more examples of roommate balance formulas, see Spark's roommate expense tracker formula guide.

Write the house rules before problems start

Put the agreement in the Rules tab, then paste it into the household chat. A short written rule is far easier to follow than an informal expectation nobody remembers agreeing to.

  • Category rule: List which supplies are shared, personal, and conditional.
  • Receipt rule: Upload a receipt photo and add the row within a set window, say 24 hours.
  • Approval rule: Set a purchase cap, such as $50, above which a bulk order needs group approval.
  • Settlement rule: Review open balances monthly and pay the way the household already accepts, whether that's cash, a bank transfer, or a payment app.
  • Change rule: Don't rewrite past splits unless everyone agrees.
  • Opt-out rule: A roommate who doesn't want a shared product buys and stores their own supply.

The sheet is the record, not the payment system. It documents a cash handoff or a payment-app transfer fine; it never moves the money itself.

Handle the awkward cases plainly

Picture it. One roommate buys the bulk box, another says nobody agreed, and the receipt sits in a shopping bag while everyone slowly gets irritated. Thing is, the argument usually starts before the purchase ever happens, so the bulk-buy rule needs to exist before checkout.

For an unapproved order, ask whether the group wants to opt in. If not, the buyer can keep it personal, or use it only for the purpose they chose.

A missing receipt needs a quick decision, made once. Ask for a photo or some other purchase record, then write down whether the group will reimburse the amount, reimburse a verified portion, or treat it as personal. Rebuilding the whole month from memory is the outcome to avoid.

When someone pays late, keep the reminder factual, not personal. Try: "I logged the $12 trash bags. Your share is $4. Please send it before our next household check-in."

And if a roommate repeatedly opts out of shared products, move that item to the personal list. The goal is a rule everyone can follow, not a ledger that wins every argument.

Open the spreadsheet before the next shopping trip. Write the three category rules, and add the first receipt while it's still in your hand.