Google Sheets can handle rent, utilities, groceries, and chore-related costs without a separate bill-splitting app. Build the expense tab around two facts: who paid, and what each person owes.

Keep the chore checklist separate from the money ledger. A completed chore isn't automatically a debt. Record a dollar amount only when your group has agreed on a charge, reimbursement, or service cost.

Separate chores from expenses

Use one spreadsheet with two tabs. The Expenses tab records money, while the Chores tab records assignments, due dates, and completion.

If a missed chore triggers a previously agreed charge, or the group hires lawn care after a missed task, add that cost to Expenses. Mention the task in the description or notes. Don't assign a dollar value to ordinary unpaid help after the fact.

That distinction prevents a tracker from quietly turning household work into disputed IOUs.

Choose columns that answer the money question

The basic date, description, amount, split type, and share columns need two additions: Paid By and calculated dollar shares. Without them, the sheet can show percentages but not who should receive reimbursement.

Use names instead of generic labels once the group is ready to share the file.

Column or columns What to enter
Date The expense date, such as 2026-01-15
Description A clear label such as Electricity bill - January or Cleaning supplies
Paid By The person who paid the merchant
Total Amount A numeric amount such as 120.00, formatted as U.S. currency
Split Method A label such as Equal, Custom, or Reimbursement
Alex %, Blair %, Casey %, Dana % Each person's percentage of the cost
Alex Owes, Blair Owes, Casey Owes, Dana Owes Formula columns showing dollar shares
Status Use Open until the group has settled the row, then use Settled
Notes Receipt name, payment method, chore connection, or a short explanation

Add one percentage column and one calculated share column for each additional person. Keep the input columns on the left and formula columns on the right.

Format Date as a date, Total Amount and the Owes columns as currency, and the percentage columns as percent. Names must be spelled consistently in the Paid By column.

Enter the share formulas

Assume Total Amount is column D, percentage inputs run from F through I, and calculated dollar shares run from J through M.

In J2, enter:

=IF(OR($D2="",F2=""),"",$D2*F2)

Copy the formula across to M2 and then down through the rows you plan to use. The $D keeps the amount column fixed as the formula moves across, while F2 changes to G2, H2, and I2.

Use a real percentage entry. Type 25%, not 25. For a four-way equal split, you can also enter =1/4 in each percentage cell and format the cells as percent. Custom rows should use the percentages the group agreed on.

If you prefer to type whole numbers such as 25, use this version consistently:

=IF(OR($D2="",F2=""),"",$D2*F2/100)

Don't mix the two formats. A row's percentages should total 100%.

Here are three ways the rows might look:

Expense Paid By Split entries Result
Electricity, $120 Alex Alex, Blair, Casey, and Dana each at 25% Each person owes $30
Cleaning supplies, $40 Alex Four people each at 25% Each person owes $10
One-person reimbursement, $40 Alex Blair at 100%; everyone else at 0% Blair owes Alex $40

That last row causes confusion. A 100% share belongs to the person responsible for the cost, not automatically to the person who paid. If Alex buys shared cleaning supplies, use an equal or custom split. If Blair agreed to cover the entire item, put 100% in Blair's share column.

Use dropdowns for Split Method and Status. The split label explains the rule, but the percentage entries drive the formulas.

Calculate who owes whom

A share column shows what each person should bear. A balance also needs the amount each person fronted.

Create a small summary around row 30 or on a separate Summary tab:

  • Column A: Person
  • Column B: Paid
  • Column C: Share owed
  • Column D: Net

Put Alex in A31, then use these formulas:

B31: =SUMIFS($D$2:$D$100,$C$2:$C$100,$A31,$N$2:$N$100,"Open")
C31: =SUMIFS($J$2:$J$100,$N$2:$N$100,"Open")
D31: =B31-C31

The C31 formula uses J, Alex's calculated share column. In Blair's row, use K. Use L for Casey and M for Dana.

A positive net means the group still owes that person. A negative net means that person owes the group. For example, if Alex pays a $120 electricity bill and owes $30, Alex's net is positive $90 before any reimbursement.

Every active expense needs an Open status for these formulas to include it. Once the full row has been reimbursed, change it to Settled.

Add a total for open expenses if useful:

=SUMIFS($D$2:$D$100,$N$2:$N$100,"Open")

You can also place this check in P2:

=IF($D2="","",SUM(F2:I2))

Format P as a percentage. Every populated row should show 100%. A different result usually means a percentage was missed, typed in the wrong format, or assigned to the wrong person.

Keep the chore checklist separate

The Chores tab can stay simple:

  1. Add headers for Task, Assigned To, Due Date, Completed, Completed On, and Notes.
  2. Add checkboxes in the Completed column.
  3. Record a related expense only when the task creates an agreed cost.

A count of completed tasks can use:

=COUNTIF(D2:D100,TRUE)

Keep the chore count separate from the bill balance. Someone completing three chores shouldn't automatically receive a credit unless the group has a written rule for that exchange.

Share access without exposing formulas

Google Sheets allows several access levels, so not everyone needs permission to edit the ledger.

  • Editors: People who enter bills, receipts, and split percentages.
  • Commenters: People who review a charge or ask for clarification without changing values.
  • Viewers: People who only need to check the current balance.

Give editor access to active bill payers, and use commenter or viewer access for occasional reviewers. Remove access when someone leaves the household or group.

Protect the formula columns, the percentage check, and the summary cells through Data > Protect sheets and ranges. Leave the expense input cells and notes editable. A protected formula range is a useful guardrail, but it won't fix a wrong percentage or an incorrect Paid By name.

If someone overwrites a formula, check version history before rebuilding the sheet. Review the earlier version and restore the affected cells if needed.

Handle reimbursements and recurring bills

Record the original expense once. Then follow the reimbursement through the status field.

  1. Enter the bill, payer, amount, and agreed percentages.
  2. Leave the row marked Open.
  3. Ask for reimbursement using the net balance or the row's calculated share.
  4. Mark the row Settled after the full amount has arrived.

A cash payment, Venmo transfer, or bank transfer is a settlement record, not a second grocery or utility expense. Add the method in Notes if that helps the group keep a clear record.

Partial payments need more care. For a few partial transactions, add a Paid Back column and subtract it from the balance formula. For more complicated activity, create a Payments tab with Date, From, To, Amount, Related Expense, Method, and Notes. Don't mark the original row Settled while money is still outstanding.

Recurring bills can be copied from the prior month, but check the date, amount, participants, percentages, and status before saving the new row. Old rows often carry a settled status or an outdated roommate list.

Catch the mistakes that break a tracker

Thing is, most spreadsheet failures come from small input mismatches rather than difficult formulas. A name typed two different ways will split a person's total, a dollar amount stored as text may not sum correctly, and 25 can produce a very different result from 25%.

Click a formula cell before editing it. Check the formula bar, and keep the summary area away from the normal entry rows so nobody mistakes it for a blank place to type.

Review the sheet on a regular schedule, such as when the recurring bills arrive. Keep receipts in a shared folder or record a receipt filename in Notes. A periodic PDF, CSV, or spreadsheet copy can help preserve the record if the group later needs to check an old reimbursement.

Know when the spreadsheet is enough

A sheet works well when the group is small, the bills are predictable, and people can enter expenses promptly. It gives everyone a shared record without blending expense tracking and payment activity.

Consider another tool when receipt scanning, payment requests, many partial settlements, or a large number of participants creates too much manual work. Even then, keep a written rule for equal, custom, usage-based, or owner-specific splits. The tool won't decide what the group considers fair.

To be honest, a spreadsheet plus receipts and a clear household rule is often enough for routine rent, utilities, groceries, and cleaning costs.

Test the tracker before inviting everyone

Create the two tabs, add an electricity row for $120 split four ways, and add a $40 cleaning-supplies row. Confirm that each share calculates correctly, the percentage check shows 100%, and the summary nets to zero across the group.

Protect the formula columns next. Have one other person add a test expense, then verify that the row appears in the balance summary. Remove or relabel the sample rows before using the tracker for live expenses.