A Google Sheet can handle a recurring family trash bill without an expense app: enter the bill once, record the agreed shares, and track reimbursements.

Keep it simple. With a $50 bill split 60/40, the sheet should show $30 for one adult and $20 for the other.

Turns out, the hard part is the household rule, not the arithmetic. Decide whether the family will split the charge equally, by income, or by an agreed measure of usage before entering older bills.

Pick the split rule first

Choose the method that matches how your household thinks about the service.

Method When it fits Example
Equal split Similar incomes and roughly similar household use Two people pay 50% each
Income-based split One person earns substantially more or less Incomes of $60,000 and $40,000 produce a 60/40 split
Usage-based split One person or household creates more of the trash Assign a higher percentage to the heavier generator

For curbside trash, usage can be difficult to measure precisely. A written percentage that everyone accepts may be more useful than a complicated count nobody maintains.

Write the rule in a note at the top of the sheet. That small step prevents the same argument next month.

Use this Google Sheets column layout

Start with one row for each trash bill. The member names below are placeholders, so replace them with names or labels your family uses.

Column What to enter
A - Date Due date or payment date
B - Expense Monthly Trash Bill or Quarterly Trash Service Fee
C - Amount Total bill, such as 50
D - Split Type Equal, Proportional, or Reimbursement
E - Member 1 % 60% or 50%
F - Member 2 % 40% or 50%
G - Member 1 Share Formula-calculated amount
H - Member 2 Share Formula-calculated amount
I - Paid By Person who paid the bill upfront
J - Reimbursement Status Pending, Paid, or Not needed
K - Receipt or Note File link, confirmation number, or explanation
L - Share Check Confirms the percentages total 100%

Add another percentage and share pair for each additional family member. Keep the percentage columns together so the total range stays easy to audit.

Add the share formulas

Enter percentages as 60% and 40%, not 60 and 40. Google Sheets stores the first format as 0.6, which is what these formulas expect.

In G2, enter:

=IFERROR(C2*E2/SUM($E2:$F2),"No participants")

In H2, enter:

=IFERROR(C2*F2/SUM($E2:$F2),"No participants")

In L2, enter this check:

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

Copy G2, H2, and L2 down the sheet. The first formula uses Member 1's percentage; the second uses Member 2's.

For a $50 bill with 60% and 40%, the results are $30 and $20. With 50% in each share column, the results are $25 and $25.

The share formulas still calculate if the percentages do not total 100% because they divide by the row total. Treat Check split as a stop sign, though. Fix the percentages before asking anyone to reimburse another person.

If you have three members and their percentages are in E2:G2, change each formula's total range to $E2:$G2.

Calculate percentages from income or usage

You can type the agreed percentages directly into each bill row. That is usually the clearest option when a household wants to keep income details private.

If the same income-based rule applies to every bill, store the income inputs in a small Rules area or on a separate tab. For example, place Member 1's income in N2 and Member 2's income in O2.

In E2, use:

=IFERROR($N$2/SUM($N$2:$O$2),0)

In F2, use:

=IFERROR($O$2/SUM($N$2:$O$2),0)

With 60,000 in N2 and 40,000 in O2, these formulas produce 60% and 40%. The share formulas then apply those percentages to the trash bill.

The same setup can use agreed usage weights instead of income dollars. If usage varies from one bill to the next, enter that row's percentages manually rather than forcing one household-wide rule.

Thing is, a formula can't decide what fair usage means. The family still needs to agree on the weights.

Build the calculator step by step

  1. Open a blank file in Google Sheets.

  2. Add the column headers from the table above in row 1. Name the file something recognizable, such as Family Trash Bills.

  3. Add a test row in row 2. Use a date such as 2026-01-15, Monthly Trash Bill, 50, Proportional, 60%, and 40%.

  4. Set the payer in I2 and use Pending in J2 if another person still owes money.

  5. Paste the formulas into G2, H2, and L2. Confirm that the share check says OK.

  6. Format column C and columns G:H as currency. Format columns E:F as percentages.

  7. Copy the formulas down for future bills. Keep an untouched copy of the sheet so you can reuse the layout.

The test row matters. It catches a misplaced column reference before real reimbursement amounts enter the record.

Keep reimbursements separate from the bill

The original bill should show what each person owes, regardless of who paid at checkout. If Member 1 pays the entire $50 bill, keep the bill's 60/40 shares and set Paid By to Member 1. Member 2 then owes Member 1 $20.

A second tab called Payments keeps that money movement clear:

Date From To Amount Status Note
Payment date Member 2 Member 1 $20 Pending 40% share of monthly trash bill

Change the status to Paid after the transfer happens. Keep the original bill row unchanged.

Some spreadsheet templates use a 100%/0% pattern for reimbursement rows. That can work if the row is clearly marked as a payment record and is not counted again in the trash bill total. Do not change the original bill to 100% for the person who paid upfront unless your agreed split is genuinely 100%/0%.

To be honest, separating bills from payments removes a lot of confusion. One row answers "What was owed?" The other answers "Who paid whom?"

Share the sheet with the right access

Click Share and choose access based on what each person needs to do.

Access level Suitable use
Viewer Someone who only needs to read the bill history
Commenter Someone who needs to leave questions without changing formulas
Editor An adult who will add bills, update statuses, or maintain the file

Protect the calculated ranges after the formulas work. Select G:H and L, open Data, then choose Protect sheets and ranges. You can also use this guide to protecting sheets and ranges for the range-selection steps.

Leave the input columns editable for the people maintaining the record. Protect E:F too if those percentages come from formulas or a fixed income rule.

Sharing permissions and cell protection do different jobs. Permissions control who opens the file; protection helps prevent an editor from replacing a formula by accident.

Use a short maintenance routine

A recurring bill only needs a small amount of attention. Update it when the bill arrives instead of reconstructing several months at once.

Moment Action
Bill arrives Add the date, description, amount, receipt note, and split percentages
Before reimbursement Check the payer, share amounts, and Share Check result
Payment is sent Add a Payments row and change the status
Month or quarter ends Save a copy or download a PDF if the household wants a fixed record

Keep receipts in a shared folder if the household needs proof of the amount. Paste the file link into column K rather than relying on memory.

Fix the common spreadsheet mistakes

Typing 60 instead of 60% makes the share check fail. Format the cells as percentages and enter the percent sign.

Copying the G2 formula into H2 without changing E2 to F2 gives both members the same result. Test the 60/40 example before filling the sheet down.

Mixing a reimbursement payment into the bill total can make the household appear to owe twice. Keep the Payments tab separate, or clearly exclude payment rows from any bill-total formula.

A blank row may show No participants in the share columns. That is the error handling working; leave unused rows blank or copy formulas only as far as needed.

Rules can drift too. If the family changes from equal splitting to income-based contributions, record the change in a note and apply it consistently from an agreed date.

Create the sheet, enter the latest trash bill, and test both a 50/50 row and a 60/40 row. Once the amounts, payer, and reimbursement status all look right, share the file with the adults who will maintain it.