Usage-based splitting works best when each item has a consistent unit. In one shared Google Sheet, log the receipt, record each use, and calculate the amount each roommate owes the buyer. Equal splitting remains sensible for cheap supplies used in similar amounts.

Fairness comes from an agreed rule, not from a complicated formula. Decide what counts as shared, how to handle unfinished bottles, and what happens when someone forgets a row.

Turns out, the formula is the easy part. The real work is setting boundaries that everyone can follow.

Set the fairness boundary

Start by classifying each product before you track it.

Standard shared supplies. Basic cleaners, dish soap, trash bags, and paper towels can be split equally when use is similar. Use a usage-based rule when one person's consumption is noticeably higher.

Personal products. Shampoo, skincare, and personal laundry detergent usually stay outside the shared log. The person who buys them pays unless the household has agreed otherwise.

Optional upgrades. A specialty cleaner, scented product, or premium brand needs a clear rule. One workable approach is to split the standard version and have the person choosing the upgrade cover the difference.

Durable equipment. A vacuum, mop, or bucket is not the same as a bottle of disinfectant. Agree on ownership, storage, repair, and replacement instead of charging each person for every use.

Write these decisions in a Notes tab. Otherwise, the rule changes every time someone shops.

Choose a split method that fits the item

Equal sharing is the simplest approach. A $20 bottle split among four roommates costs $5 per person, whether one roommate uses more or less.

Usage-based splitting fits supplies with countable, uneven use. It can work for sprays, trash bags, or specialty products, but only if people record quantities consistently.

Reimbursement after proof describes the payment timing. One roommate pays the full receipt upfront, then the others reimburse their documented shares.

Method Works best when Main tradeoff
Equal share Use is similar and the items are inexpensive Minimal recordkeeping, but heavy users may pay less than their share of use
Usage-based Consumption differs and a unit is easy to define More accurate, but someone must log each use
Purchase-time custom split Everyone agrees on shares before buying Avoids later logging, but relies on an estimate
Reimbursement after proof One person regularly fronts purchases Clear buyer records, but the group must review the log

These methods can coexist by item. Don't split a bottle at purchase and charge the same usage again later.

Build the Google Sheets workbook

Create one file with three tabs. Keep the layout plain so a roommate can understand it without a tutorial.

Purchases: Purchase ID | Date | Item | Paid by | Receipt total | Receipt link | Status
Usage: Date | Purchase ID | Item | Used by | Quantity | Unit | Unit cost | Allocated cost | Entry type | Notes
Settlement: Purchase ID | Owed by | Paid to | Amount | Paid? | Date paid

Give each receipt a simple ID, such as P-001. Put that same ID on every usage row tied to the purchase.

The Purchases tab records the full amount paid. The Usage tab records consumption. The Settlement tab turns those usage records into specific reimbursement requests.

Share the file with the roommates who need to enter data. Use the narrowest sharing setting that fits your group; Google's Drive sharing help describes the available choices. Agree not to overwrite formula cells, and keep receipt links beside the purchase record rather than scattered through text messages.

Measure usage without fake precision

Use a numeric quantity and a separate unit. For example, enter 2 in Quantity and sprays in Unit. Don't put 2 sprays in the numeric cell.

Pick one unit per item. A cleaner might use sprays, trash bags might use bags, and paper towels might use sheets. A reusable microfiber cloth usually makes more sense as a replacement expense than as a charge for every wipe.

If an assumed $4 bottle contains 40 logged sprays, its unit cost is $0.10. Record that assumption in Notes, because bottle sizes and actual use can vary.

Date Purchase ID Item Used by Quantity Unit Unit cost Allocated cost
2026-01-15 P-001 All-purpose cleaner Alex 10 sprays $0.05 $0.50

The $0.05 figure is a house estimate, not a universal product rate. Mark rows as Actual or Estimate in Entry type, and never use vague entries such as "some."

Add formulas and a simple summary

In the Usage tab, place this formula in H2:

=E2*G2

Copy it down the Allocated cost column. Format Unit cost and Allocated cost as currency.

For a person-by-person total, create a small summary area. Put roommate names in K2:K5 and place this formula in L2:

=SUMIF($D$2:$D,K2,$H$2:$H)

Copy the formula down. It adds the allocated costs for the roommate named in K2. See SpreadsheetPoint's SUMIF examples for related formula patterns.

A pivot table can help when the log grows. Select the Usage range, choose Insert, then Pivot table, and summarize Allocated cost by Used by or Item. This Google Sheets pivot table walkthrough covers that setup.

Review the summary for one month at a time. Don't treat the full receipt total as used cost when product remains in the cabinet.

Turn the log into reimbursements

Use a monthly review for most households. Review sooner after a large purchase or when someone is moving out.

  1. Enter the full receipt on Purchases. Record who paid, the receipt total, and the purchase ID.
  2. Check Usage rows for that purchase. Correct obvious errors and label estimates instead of silently changing them.
  3. Add one Settlement row for each non-buyer who owes money. If A2 contains the purchase ID and B2 contains the roommate who owes, use this formula in the Amount column:
=SUMIFS(Usage!$H:$H,Usage!$B:$B,A2,Usage!$D:$D,B2)
  1. Send a written request that names the item, amount, and buyer. For example: "January cleaning supplies: Jordan owes Alex $9 for disinfectant use. Please reply after sending so I can mark it paid."
  2. Mark the row as paid after the roommate confirms payment. Keep the original receipt and usage rows.

Suppose Alex buys a $30 disinfectant bottle. The Usage tab assigns $12 to Alex, $9 to Jordan, and $9 to Casey. Jordan owes Alex $9, and Casey owes Alex $9. Alex's $12 is Alex's own share.

If only $18 of the bottle has been used, allocate only $18. The remaining product carries forward. A household that wants to split the entire purchase immediately should use a purchase-time rule instead and skip later usage charges for that item.

The sheet records the calculation. It doesn't send money or verify that a payment happened. Use whatever payment method the household already accepts, then update the Settlement tab.

Put the house rules in writing

Store a short version of the agreement in the workbook. You can adapt this wording:

Shared items: only products on the shared list are reimbursable.

Units: cleaner is counted by sprays, and trash bags by bags.

Timing: log use the same day or within 24 hours.

Missed entries: mark an estimate and add a note explaining it.

Upgrades: approve a premium product before buying it.

Unused stock: carry unallocated value forward unless the group agrees to split at purchase.

Review: check entries weekly and settle totals monthly.

A written rule prevents a small forgotten entry from becoming a larger argument. Keep it practical. Nobody needs a measurement system that takes longer than the cleaning.

Handle the awkward cases

Someone forgets to log. Use a prior pattern only as an estimate, label it clearly, and let the group correct it during the monthly review. If missed entries become common, switch that item to an equal split.

The product size changes. Give the new purchase a new ID and calculate its unit cost separately. Don't mix a concentrated refill with the original bottle's rate.

A roommate chooses an expensive brand. Decide the standard product before buying. Without that agreement, a later reimbursement request can feel like a surprise.

The group owns a vacuum or mop. Record who owns it and what happens if that person moves out. Durable items need an ownership rule, not a spray-by-spray charge.

A simple shared receipt folder may be enough for infrequent, evenly used purchases. Add the tracker when usage differs, receipts go missing, or the same disagreement keeps returning. If the group later needs automated payments or receipt scanning, compare those functions separately; a spreadsheet remains a record, not a payment service.

Start with one test item

Choose the cleaner or supply most likely to cause disagreement. Create P-001, agree on one unit, enter a test row for each roommate, and check the formula together before the next purchase.