Use a Google Sheets template with columns for date, item, total cost, payer, shares per person, and running balances. Apply formulas like =SUMIFS for category totals (Relayfi) and set editor permissions via the Share button for group edits (Tiller Help Center). This setup helps U.S. roommates track uneven cleaning supply purchases, such as one person ordering $50 in bulk detergent or paper towels for a four-person household, calculate fair shares, request reimbursements, and keep records.

For small groups with occasional overspends on shared household items, a spreadsheet provides a lightweight way to document expenses without apps. Enter purchases as they happen, use formulas to auto-calculate owed amounts, and review weekly. Share the sheet with roommates' emails set to "Editor" for collaborative updates, while protecting summary ranges from changes (Tiller Help Center).

Recommended Columns for Cleaning Supplies Reimbursement Tracker

Set up a Google Sheet with these columns to handle cases where one roommate orders more than their share, like bulk cleaning supplies used by all. Tailor shares to group size or usage; for example, in a four-person house, each might owe 1/4 of a $40 mop purchase, but adjust if one person buys extras for their room only.

  • Date: When the purchase happened (format as MM/DD/YYYY for sorting).
  • Item: Description, e.g., "Bulk detergent (128 oz)" or "Paper towels (12-pack)".
  • Total Cost: Full receipt amount, e.g., $50.
  • Payer: Name or initial of who paid, e.g., "Alex".
  • Shares: Roommate 1: Fraction or decimal owed, e.g., 0.25 for equal split.
  • Shares: Roommate 2: Same, e.g., 0.25.
  • Shares: Roommate 3: e.g., 0.25.
  • Shares: Roommate 4: e.g., 0.25 (add/delete columns for group size).
  • Balance: Formula-calculated running total per person (see formulas below).

Place shares as decimals (e.g., 0.25 = 1/4 share) so formulas multiply easily: individual owed = Total Cost * their share. Sum shares across columns should equal 1 for full coverage. For partial shares, like two roommates splitting toilet cleaner (0.5 each, others 0), note it in a "Notes" column if needed. This structure supports uneven orders by letting the payer enter 1 for their share initially, then others update theirs.

Keep the first row as headers. Start data entry in row 2. For group size changes, insert/delete share columns and copy formulas down.

Setup Steps to Build and Share the Tracker

Follow these steps to create and share the tracker securely for real-time updates.

  1. Go to sheets.google.com and click "Blank" for a new sheet. Name it "Cleaning Supplies Reimbursement Tracker".

  2. In row 1, enter the recommended columns from above (A1 to J1 or as needed).

  3. Input sample data: Row 2 - Date: 01/15/2026, Item: "Detergent bulk", Total Cost: 50 (in C2), Payer: "Alex" (D2), Shares: 0.25 each in E2:H2.

  4. Add formulas (detailed next section) in a "Summary" section below data or on a second sheet.

  5. Click the green "Share" button (top right). Add roommates' email addresses. Set to "Editor" for them to add rows/edit shares. Uncheck "Notify people" if preferring a group chat intro. Avoid "Anyone with link" to limit access (GeeksforGeeks).

  6. Protect key areas: Select summary range (e.g., totals), right-click > Protect range. Set only yourself or specific editors (Tiller Help Center). On mobile, tap three dots > Share & export > Manage access.

  7. Test: Have a roommate add a row for their purchase. Review on phone via Google Sheets app.

Share the link in your group chat with rules: "Add purchases weekly; update your share; no deleting rows." Set update cadence to weekly reviews.

Key Formulas for Tracking Overspend and Reimbursements

Use these copy-paste formulas, attributed from Relayfi, to automate tracking. Assume data starts at A2 (Date) to J100 (Balance). Place summaries in row 102+ or a new sheet.

  • Total cleaning supplies spend: In a cell like K102, =SUMIFS(C2:C100, B2:B100, "cleaning") sums costs (column C) where item (B) contains "cleaning" (Relayfi). Adjust "detergent" for specifics.

  • Category summary: =QUERY(A2:J100, "SELECT B, SUM(C) GROUP BY B LABEL SUM(C) 'Total Cost'") lists items and totals, e.g., all paper towels grouped (Relayfi). Paste in a new sheet for overview.

  • Filter large orders: =FILTER(A2:J100, C2:C100>20) shows rows over $20, spotting overspends like bulk buys (Relayfi).

  • Individual owed (per row): In column I (next to shares), for Roommate 1: =IF(E2>0, $C2*E2, 0). Copy across for others; shows what each owes per purchase.

  • Running balance per person: Below data, sum owed minus paid. E.g., Roommate 1 balance: =SUMIFS(I2:I100, D2:D100, "Alex") - SUM(payments column). Add a "Paid" column for reimbursements.

  • Overspend warning (conditional formatting): Select cost column > Format > Conditional formatting > Custom formula: =AND(C2>20, SUMIFS(C$2:C2, B$2:B2, B2)>15) to highlight large or repeated item buys (adapted from Relayfi).

Drag formulas down as rows grow. For balances, use a dashboard sheet with =SUM for each person's column.

Tiller Help Center on sharing and permissions

Common Mistakes and How to Avoid Them

Shared sheets fail from simple errors; here's how to sidestep them.

  • Over-sharing: Setting "Anyone with link" to Editor lets outsiders edit. Fix: Use email invites only, set to Editor, disable "Editors can change permissions" (Tiller Help Center).

  • Formula breaks on new rows: Absolute references like $C2 drag wrong. Fix: Use mixed $C$2:C2 or ARRAYFORMULA for auto-expansion.

  • Partial shares ignored: Entering 1 for payer only, forgetting others. Fix: Rule - payer enters their share; others update within 48 hours.

  • No mobile access planned: Desktop formulas don't show well on phones. Fix: Test in app; use QUERY for summaries that fit screens (GeeksforGeeks).

  • Unprotected summaries: Roommates edit totals accidentally. Fix: Protect ranges immediately after setup (Tiller Help Center).

  • Rare updates: Sheet forgotten until disputes. Fix: Weekly group review; add "Last Updated" cell with =TODAY().

  • No receipts: Disputes over costs. Fix: Add "Receipt Link" column with Google Drive shares.

Backup monthly via File > Version history.

When a Spreadsheet Works vs. When to Consider Apps

A Google Sheet suffices for small households (2-6 people) with low-volume cleaning supply buys (under 10/month). It handles tracking, basic splits (equal, usage-based), and records without fees. Export to PDF for proof.

Consider apps if needs grow:

  • High volume or receipt scanning: Apps with photo upload streamline entry.
  • Auto-reminders for shares: Beyond sheet notifications.
  • Payment integration: Separate tracking from paying; use apps for requests after sheet confirms balances.

Decision tree:

  • Low volume, tech-comfortable group? Stick to sheet.
  • Frequent disputes, scanning needed? Layer app for requests.
  • Always document first; apps for execution.

Sheets work for most roommate cleaning reimbursements; scale up only if weekly time exceeds 15 minutes.

FAQ

How do I add more roommates to the shares columns?
Insert new columns between shares (e.g., after Roommate 2). Copy formulas from adjacent columns. Adjust shares to sum to 1, e.g., five people at 0.2 each.

What if someone disputes a cleaning supplies reimbursement?
Review receipt in shared Drive link (add column). Recalculate with group input. Document agreement in "Notes" column; keep chat records separate.

Can I protect the formulas from accidental changes?
Yes, select formula range > Right-click > Protect range > Set permissions to you only or specific editors (Tiller Help Center).

How often should we review the tracker?
Weekly, or after big buys. Set Google Calendar reminder for group check-in.

Does this work for other household items like groceries?
Yes, same columns/formulas; filter by item keywords like "groceries" in SUMIFS.

Is there a free template gallery from Google?
Google Sheets has general templates via File > New > From template gallery, but none specific to reimbursements; build custom as above.

Next, create your sheet today, input last month's buys, and share with rules. Review after two weeks to refine shares.