Split Uneven Cleaning Supplies with a Google Sheet

Did one person just drop eighty dollars on bulk laundry detergent, paper towels, and disinfectant wipes for the entire apartment? It happens constantly. Someone hits Costco, grabs three months of supplies, and ends up floating cash for three other roommates who forget to pay.

Setting up a dedicated Google Sheet fixes this without forcing everyone onto a new financial app. Everyone sees the numbers. You log the receipt, split the cost fairly, and maintain a running balance so nobody subsidizes the household. As noted in this guide on how to split cleaning supplies, agreeing on upfront split rules keeps small store runs from turning into household drama.

Recommended Columns for an Uneven Purchase Ledger

Thing is, equal splits break down when someone buys extra items for personal use. Not every bottle serves everyone. A roommate with a private bathroom might need dedicated bleach spray, while another roommate only chips in for shared dish soap and sponges.

Setting up decimal share columns lets you assign custom weights to every single row in your sheet. Decimals keep the multiplication clean. A four-way split uses 0.25 per person. A two-person split uses 0.50 each while the other two roommates stay at zero. The row shares must equal 1.0.

In their guide to shared household supplies, Vorby points out that specialty products cause friction when someone treats a personal preference as a collective bill. The notes column gives room to clarify weird exceptions.

Step-by-Step Setup and Permission Locking

Setting up permissions protects your sheet from chaos. To be honest, sharing a sheet link directly in a group text without locking the headers almost guarantees somebody will accidentally overwrite a total formula on their phone while riding the bus home. Protect your formulas right away.

1. Create a blank workbook at Google Sheets and paste the table headers across row 1.
2. Add sample transactions in rows 2 and 3 so you can verify that your calculations work before inviting others.
3. Highlight the header row and your formula cells, right-click, and select Protect range. Follow the steps in Sheets Bootcamp to set editing permissions to "Only you" so roommates cannot break your formulas.
4. Click the green Share button in the top right corner.
5. Add each roommate by email address and grant Editor access. Keep the general access set to Restricted instead of "Anyone with the link" so random people cannot view your private household ledger.
6. Bookmark the URL in your household group chat description for fast mobile access.

Frequent logging matters just as much as permissions, because small purchases slip through the cracks when roommates wait until month-end to reconstruct receipts. According to Make It Even, small unlogged items like dish soap quietly add up to hundreds of dollars in accidental subsidies each year. Log expenses within 24 hours.

Formulas to Automate Shares and Balances

You only need three basic formula types. The first calculates what an individual owes on a single purchase row based on the decimal share you entered. Assuming cost sits in column C and Alex's share in column E:

=IF(E2>0, $C2*E2, 0)

Drag this formula across columns for Jordan, Taylor, and Morgan. It outputs the exact dollar amount each person owes.

Next, summarize category totals to see how much the house spends on specific supplies. A standard conditional sum formula searches column B for matching keywords:

=SUMIFS(C2:C100, B2:B100, "*detergent*")

Replace the keyword to audit paper towel spending instead.

Finally, calculate each person's net standing on a summary dashboard tab. Take the total money a person paid upfront and subtract the total shares they consumed across all rows:

=SUMIF($D$2:$D$100, "Alex", $C$2:$C$100) - SUM(I2:I100)

A positive balance means the household owes that person money. A negative balance means they owe the group. It eliminates guesswork completely.

Handling Bulk Buys and Split Exceptions

Turns out, most roommate tension over supplies has nothing to do with bad intentions. It comes from mismatched expectations. When one person orders four large containers of floor cleaner online, the rest of the house might wonder why they must pay immediately.

• Bulk purchases with long lifespans: If a roommate buys a year-long supply of trash bags, decide whether to split the total upfront or have the buyer log half now and half in six months.
• Personal items on shared receipts: When someone tosses personal body wash onto a communal grocery receipt, mark the buyer at 1.0 and everyone else at 0.0 for that specific line item.
• Unequal private space: If one roommate has a private en-suite bathroom, split general kitchen cleaners equally, but assign bathroom cleaners exclusively to the person using that bathroom.

Clear categories keep everybody honest without forcing awkward interrogations.

When to Use Google Sheets Versus Payment Apps

Spreadsheets cost nothing. They give you total control over formulas, never require paid subscription tiers, and do not lock data behind proprietary walls. Anyone with a browser can view them. Official sharing controls from the Tiller Help Center let you manage who edits and who views.

Dedicated expense-splitting apps make sense only when your household has ten or more shared purchases every week and nobody wants to type numbers manually. Apps offer receipt scanning and automated push reminders. But for standard monthly cleaning supplies, a shared spreadsheet backed by Venmo or Zelle requests avoids extra fees and account clutter. Simple tools usually last longer.

Next Steps for Your Household

Put the system in place this weekend. Open Google Sheets, paste the column framework, and drop the link into your household chat alongside a shared Google Drive receipt folder. Agree on a weekly ten-minute check-in. Review new purchases on Sunday evening so balances stay current and nobody gets stuck floating household cash.