If you need to divide trash bags, bin fees, or bulk-disposal charges, a receipt-item sheet is usually enough. Put each line item in Google Sheets, assign a percentage to each person, and let the workbook calculate who paid more than their share.

That is enough for a small group. It also works for a municipal trash bill with separate service lines; a one-line bill can simply be entered as one row.

Keep expenses and reimbursements separate. The Items tab says what the household bought, while the Payments tab says who later sent money to whom. That prevents a reimbursement from being counted as a second trash expense.

Turns out, most disputes start with an unclear rule, not difficult math.

Create the workbook

Open a blank Google Sheet and add three tabs named Items, Payments, and Summary. Use the first tab for purchases, the second for completed or pending money transfers, and the third for formulas.

Freeze row 1 on the entry tabs. Format amount columns as currency and percentage columns as percentages. Everything below uses standard Sheets formulas, so a separate split-bill app is not required.

Set the sharing rule before entering rows

Trash charges can follow different rules. Choose one for each item instead of applying the same split to an entire receipt by habit.

Sharing rule Useful for What to enter
Equal Shared bags, liners, or fixed household fees The same percentage for every participant
Usage-based Bulk pickup, landfill fees, or uneven trash volume Percentages based on an agreed usage estimate
Owner only A personal disposal charge or one person's project 100 percent for the beneficiary and 0 percent for everyone else
Mixed receipt A receipt containing shared and personal items Separate rows, each with its own sharing rule

Agree on how to handle service fees, tax, discounts, and delivery charges before entering data. A simple rule that everyone understands beats a complicated formula nobody trusts.

Build the Items tab

Use one row for each charge line. A receipt with bags, a bin rental, and a bulk pickup fee should create three rows.

Column What it records
A - Date Purchase or bill date
B - Receipt ID Identifier shared by all rows from one receipt
C - Item Description such as heavy-duty bags or bulk pickup
D - Amount Cost for that line item
E - Paid by Person who paid the merchant or bill
F - Split type Equal, Usage, Owner only, or another agreed label
G:J - Share percentage One column per participant
K - Share check Formula confirming the percentages total 100 percent
L:O - Share amount One calculated amount per participant
P - Receipt reference Photo, PDF, file name, or shared-folder reference

Replace Alex, Jordan, Sam, and Taylor with your actual group members. Use fewer or more share columns as needed, but update the formulas when the group changes.

For example, enter 2026-03-15, receipt R-001, 50 heavy-duty trash bags, and an amount of $25.99. If Alex paid and four people share it equally, enter 25 percent in each of the four share columns. The check should show 100 percent.

One expense row equals one charge line.

Add checks and share formulas

Put these formulas in row 2, then fill them down. Fill the share formula across from column L through column O.

K2: =IF(COUNTA($A2:$F2)=0,"",SUM($G2:$J2))
L2: =IF($D2="","",$D2*G2)

The formula in L2 changes its percentage reference as you fill it across. In column M it uses H, in column N it uses I, and in column O it uses J.

Format column K as a percentage. Add conditional formatting that flags rows where the check is not 100 percent. Leave nonparticipants at 0 percent instead of leaving their cells blank.

Don't round the share formulas themselves. Currency formatting can display a quarter of $25.99 as about $6.50, while the underlying values still add up to exactly $25.99. Rounding every share first can create a small leftover amount.

Calculate each person's net balance

On the Summary tab, list your group members in column A. Add these headers in columns B through G:

Column Meaning
B - Paid for items What the person initially paid
C - Assigned share What that person was responsible for
D - Sent Completed payments sent to others
E - Received Completed payments received from others
F - Net before payments Paid amount minus assigned share
G - Balance after payments Remaining amount to receive or pay

For the example names, put Alex in A2, Jordan in A3, Sam in A4, and Taylor in A5. Use these formulas:

B2: =SUMIF(Items!$E$2:$E,A2,Items!$D$2:$D)
C2: =SUM(Items!$L$2:$L)
C3: =SUM(Items!$M$2:$M)
C4: =SUM(Items!$N$2:$N)
C5: =SUM(Items!$O$2:$O)
D2: =SUMIFS(Payments!$D$2:$D,Payments!$B$2:$B,A2,Payments!$F$2:$F,"Paid")
E2: =SUMIFS(Payments!$D$2:$D,Payments!$C$2:$C,A2,Payments!$F$2:$F,"Paid")
F2: =B2-C2
G2: =F2+D2-E2

Fill B2 and D2:G2 down for each person. The assigned-share formula in column C must point to the matching share column in Items.

A positive balance in column G means that person should receive money. A negative balance means they still need to pay. Pending payments stay out of the calculation until their status changes to Paid.

Record reimbursements in a Payments tab

Set up the second tab like this:

Column What it records
A - Date Date the payment was requested or sent
B - From Person sending money
C - To Person receiving money
D - Amount Amount of the payment
E - Type Reimbursement, adjustment, or another agreed label
F - Status Pending or Paid
G - Note Receipt ID or explanation

Suppose Alex paid for the bags and Jordan later sends Alex $6.50. The purchase remains in Items with Alex in Paid by. Add a payment row with Jordan as From, Alex as To, $6.50 as the amount, Reimbursement as the type, and the correct payment status.

Thing is, a reimbursement is not a new purchase. Don't add a negative reimbursement row to cancel the original item, because that can distort both the expense total and each person's share.

Some one-tab templates use Reimbursement as a split type for an owner-only charge. You can keep that label for clarity, but the underlying item should still have 100 percent assigned to the person responsible. Actual money movement belongs in Payments.

Settle balances after each receipt or haul

  1. Add every receipt line to Items, even when one person paid the entire receipt.
  2. Check that each row shows 100 percent in the share check and that the item total matches the receipt.
  3. To check a receipt with several rows, use a temporary formula such as =SUMIF(Items!$B$2:$B,B2,Items!$D$2:$D) and compare the result with the receipt total.
  4. Read the positive and negative balances on Summary, then agree which payments will settle them.
  5. Add each planned payment to Payments and leave it as Pending until the money has actually arrived.
  6. Change the status to Paid after settlement so the summary reflects the completed transfer.

You can review after every purchase, after each waste haul, or on another schedule your group agrees to. The key is consistency.

Handle mixed receipts, tax, discounts, and refunds

Sometimes the receipt is messy, the coupon is strange, and nobody remembers who filled the extra bin. The row structure can still stay simple.

Situation Practical entry
Shared bags and personal cleaners appear together Create separate rows and assign the cleaners to the person who owns them
A bulk item belongs to one household member Use 100 percent for that person
Tax appears as one total Add a tax row and use the agreed shared rule, or allocate it in proportion to the pre-tax item amounts
A discount applies to one item Reduce that item's amount
A coupon covers the whole receipt Agree whether to distribute the discount proportionally or use another written rule
The store issues a refund Add a negative item row with the original receipt reference and matching share percentages
Rounded payments leave a tiny difference Decide who absorbs the cent difference and record it in the payment note

A store refund reverses a purchase, so a negative item row can be appropriate. A roommate reimbursement is different and belongs in Payments.

Share the sheet without breaking formulas

Give Editor access to people who need to enter receipts or payments. Use Viewer access for people who only need to inspect the balances.

Protect the header, formula, and summary ranges, while leaving the input fields editable. For this layout, columns K:O and the Summary tab are the main formula areas to protect. Protection reduces accidental overwrites; it doesn't decide whether your sharing rule is fair.

Keep receipt photos or PDFs in a shared folder and place the file name or reference in column P. To be honest, a tidy receipt trail is often more useful than another complicated formula.

Common mistakes that change the result

  • Entering one total for a mixed receipt instead of separating personal and shared items.
  • Leaving a nonparticipant's percentage blank rather than entering 0 percent.
  • Adding a negative roommate reimbursement as if it were a new expense.
  • Rounding every individual share before calculating the group balance.
  • Adding a new person without updating the share check and Summary formulas.
  • Marking a payment as Paid before the recipient confirms it arrived.

FAQ

Can I split every trash charge equally?

Yes, if the group has agreed to do that and everyone benefits in roughly the same way. Enter the same percentage for each participant on every shared row.

What if one person pays the entire trash bill upfront?

Put that person's name in Paid by, then assign each participant's share normally. The Summary tab will show the payer's positive balance and the other participants' negative balances.

Do I need a separate Payments tab?

You can calculate a one-time bill with only the Items tab, but a Payments tab is safer when reimbursements happen later. It separates the original expense from the money used to settle it.

What if a roommate moves out?

Keep old rows unchanged so the historical record remains accurate. Update future rows and the Summary list, then make sure the remaining share columns still total 100 percent.

Can a payment app replace this spreadsheet?

A payment app may move money, but it doesn't necessarily document how a mixed receipt was divided. Keep the receipt allocation and settlement record wherever your group can review them easily.

Create the three tabs, enter the $25.99 sample row, and confirm the share check reads 100 percent before adding older receipts.