Yes. A shared Google Sheet can handle rent, utilities, groceries, reimbursements, and costs tied to household chores. The useful version records who paid, who owes a share, which rule split the bill, and whether money changed hands later.

Keep unpaid tasks separate from dollar amounts. That way, a $30 purchase of trash bags does not get confused with taking the trash out.

Choose a workbook structure

Use four tabs if you want clean balances: Expenses, Summary, Settlements, and Chores. Expenses holds bill rows, Summary calculates each person's position, Settlements records actual transfers, and Chores holds unpaid tasks.

The Chores tab is optional. The first three tabs create the money workflow.

Build the shared bills and chores-cost log

Create a blank workbook in Google Sheets, then rename the main tabs before entering data. Start with the Expenses tab and put these headers in row 1:

Column What it records
Date The date the bill was paid or incurred.
Description A clear label such as electricity, groceries, or cleaning supplies.
Category Rent, utility, groceries, supplies, cleaning service, or another useful group.
Paid By The person who covered the charge.
Total Amount The full amount before splitting.
Split Type Equal, usage-based, income-based, room-size, nights-stayed, or reimbursement.
Participant percentage columns One column per person, such as Alex %, Blair %, Casey %, and Dana %.
Check Split A formula that flags whether the percentages total 100%.
Participant share columns The dollar share generated from each person's percentage.
Settlement Status An optional label such as Open, Partial, or Settled.
Notes Receipt location, approval, exceptions, or other context.

Format Date as a date, Total Amount and the share columns as currency, and the percentage columns as percent. Formatting changes how values appear; it does not fix an incorrect value.

Use actual participant names in the headers. Do not use a share column to show what someone already paid. Paid By shows the advance, while the percentage and share columns show the final obligation.

For a $150 utility bill split four ways, enter 25% for each person. For three people, use 33.33%, 33.33%, and 33.34% so the row reaches 100%.

Split Type is mainly a label for the agreed rule. If one person paid upfront for a shared bill, you can label the row Reimbursement, but the percentage columns should still show who ultimately owes the cost.

Add split formulas and a 100% check

With the layout above, percentage cells run from G through J, the check is in K, and dollar shares run from L through O. Put this formula in K2:

=IF($E2="","",IF(ROUND(SUM($G2:$J2),4)=1,"OK","Check split"))

Put this formula in L2, then copy it across to O2 and down the sheet:

=IF($E2="","",ROUND($E2*G2,2))

When the formula moves across, G2 should become H2, I2, and J2. If you add another participant, add both a percentage column and a share column, then extend the check formula to include the new percentage cell.

Enter 25%, not 25. You can also enter =1/4 in each percentage cell and format those cells as percent. If you prefer whole numbers such as 25, rewrite every share formula to divide by 100 and use that convention consistently.

Turns out, a percentage check can be correct even when a split feels unfair. The formula checks arithmetic, not the agreement behind the numbers.

Because each share is rounded to cents, a one-cent difference can appear. Assign that cent to an agreed participant and note the choice in the row.

Agree on the split rule first

Equal splits are simple for shared groceries, rent, or supplies when use is similar. Usage-based splits fit utilities or household items that people consume differently.

Income-based contributions can work for couples who agree to contribute by ability. Room-size splits may fit rent when bedrooms differ, while nights-stayed splits can fit guests or irregular household use.

Reimbursement-after-proof works when a person buys something only after a receipt or approval. Put the rule in Split Type and record exceptions in Notes. The sheet records an agreement; it cannot create one.

Add a summary and reimbursement log

Create a Summary tab with these columns: Person, Paid, Assigned Share, Net Before Settlements, and Net After Paid Settlements. Put participant names in A2:A5, or replace the example names with your group's names.

For Alex in row 2, use these formulas:

B2: =SUMIF(Expenses!$D$2:$D$100,$A2,Expenses!$E$2:$E$100)
C2: =SUM(Expenses!$L$2:$L$100)
D2: =B2-C2
E2: =D2+SUMIFS(Settlements!$D$2:$D$100,Settlements!$B$2:$B$100,$A2,Settlements!$E$2:$E$100,"Paid")-SUMIFS(Settlements!$D$2:$D$100,Settlements!$C$2:$C$100,$A2,Settlements!$E$2:$E$100,"Paid")

For Blair, Casey, and Dana, change the formula in column C to sum M, N, and O respectively. Copy the other formulas down. Extend the row ranges beyond 100 if your group needs more entries.

A positive net means the person should receive money. A negative net means the person needs to pay. Zero means that person's recorded balance is settled.

Add a group check somewhere on the Summary tab:

=ROUND(SUM(D2:D5),2)

It should normally show 0.00 before settlements. If it does not, look for a missing share, a missing payer, or a rounding difference. A zero group total does not mean every person is settled, so review each individual net.

On the Settlements tab, use Date, From, To, Amount, Status, and Note. Mark a transfer Planned until money actually changes hands, then change it to Paid. The Summary formula counts only Paid settlements.

Do not delete the original expense after reimbursement. If Blair paid a $100 bill and Casey later sent Blair $25, keep the $100 expense and add a $25 settlement row.

Share and protect the Google Sheet

Share only the access people need. The labels can change as Google updates its interface, but the basic workflow is straightforward:

  1. Open the workbook and select Share.
  2. Add participant email addresses.
  3. Choose Editor for people who need to enter expenses, or Viewer for people who only need to review them.
  4. Review General access before copying a link. Keep household financial records restricted unless your group has a clear reason to use broader access.
  5. Use Data > Protect sheets and ranges to protect the formula columns, Summary tab, and header row.
  6. Leave the expense input cells and Chores tab editable.
  7. Test one new row before asking everyone to use the file.

For another explanation of editor, viewer, and protected-range controls, see the Tiller Help Center's sharing and permissions notes.

Protection helps prevent accidental edits. It does not make a public link private, so access settings still matter.

Choose one person to maintain participant names and formulas. Everyone else can add rows without changing the calculation structure.

Keep unpaid chores on their own tab

Not every chore belongs in the bill log. Use the Chores tab for Task, Assigned To, Due Date, Completed, Completed Date, and Notes.

Record cleaning services, lawn care, supplies, or other paid costs in Expenses. Link the related task in Notes if that helps.

Thing is, one person may do more unpaid work and still owe money for groceries. Do not use a chore count as a hidden offset unless everyone agreed on that rule beforehand. If the group assigns a dollar value to labor, document the rate and approval rule first, then record the approved amount as an expense.

Use a simple review routine

Log a cost when it happens, not at the end of the month. The payer adds the receipt location, enters the agreed percentages, and checks the row before memory gets fuzzy.

Before closing a weekly or monthly review, check:

  • Every expense has a date, payer, amount, and description.
  • Every percentage row shows OK in Check Split.
  • The share columns add up to the total after rounding.
  • Actual transfers appear on Settlements with the correct From, To, and Status.
  • The Summary shows the remaining balance for each person.

Most errors are boring. Names change, formulas do not always follow the changes you meant to make, and an old column can quietly point at the wrong person. When someone moves out, update the participant headers, percentage columns, share formulas, Summary, and any open rows together.

Know when a spreadsheet is enough

A spreadsheet fits groups that can enter expenses, agree on split rules, and review balances manually. It works for households, couples, trips, dinners, clubs, teams, and small committees with a manageable number of transactions.

Use a different workflow, or add another tool, if your group needs automated payment requests, reminders, receipt capture, or more detailed access controls. Tracking and paying are separate jobs: use the payment method your group already prefers, then record the completed transfer in Settlements.

To be honest, the harder part is usually agreement, not formulas. Write the rule down before the next bill arrives.

FAQ

What if one person paid the whole bill upfront?

Put that person in Paid By. If the bill is shared, enter the agreed percentages for everyone who owes part of it. The Summary will show the payer's positive position and the others' amounts due.

When should one person's share be 100%?

Use 100% only when that person agreed to bear the entire cost. The person with 100% responsibility does not have to be the person who paid upfront.

How do I split a bill three ways?

Use 33.33%, 33.33%, and 33.34%, or use a formula such as =1/3 if you are managing the rounding deliberately. Check the resulting dollar shares before settling.

How do I add or remove a participant?

Add or remove both the percentage and share columns, update the Check Split range, and revise the Summary formulas. Test one row after the change.

Can I use this for family bills or group trips?

Yes. Replace household categories with items such as lodging, gas, meals, deposits, tickets, or cancellation costs. The payer, percentage, share, and settlement workflow stays the same.

Start with one recent bill, confirm the check says OK, and then add the remaining rows.