Use a single Google Sheets file to track shared bills, reimbursements, and chores without crowding your phone screen. Put each expense on one row, record each person's share, and keep chores in a small companion tab.

That is enough for most small groups. Roommates, couples, family members, travel buddies, clubs, and committees can all use this layout. Thing is, a sheet records an agreement; it doesn't decide whether an equal split, a 60/40 split, or a chore credit is fair. Write that rule down first.

Start with one row per expense

Build the main tab as a ledger. Each row should represent one bill, purchase, deposit, or other shared expense.

Column What to record Example
Date When the expense happened or the bill was due May 3
Description A plain label people will recognize Electric bill
Category Rent, utilities, groceries, travel, or supplies Utilities
Amount The full amount charged 120.00
Paid by The person who paid the seller Alex
Split method Equal, percentage, custom, or reimbursement 50/50
Alex share Alex's agreed portion 60.00
Jordan share Jordan's agreed portion 60.00
Settlement status Not requested, requested, settled, or disputed Requested
Note or receipt A short explanation or receipt reference Trash duty, no credit

Use real names in the share columns. The sheet becomes easier to read on a phone when nobody has to remember who "Person 1" is.

For three or more people, don't keep adding share columns forever. Create a separate Shares tab with Entry ID, Person, and Share columns instead. It takes one extra tab, but the main ledger stays narrower and group totals are easier to review.

Keep repayment transfers out of the expense ledger unless you build formulas that exclude them. A separate Transfers tab is usually clearer.

Give chores their own tab

Chores need a schedule, not a fake expense row.

Create a Chores tab with these headers: Due date, Chore, Assigned to, Repeat, Status, Completed date, and Note or agreed credit.

An example row could look like this:

May 10 | Take out trash | Jordan | Weekly | Open | | No bill credit

Keep the financial record and chore schedule separate. If the group agrees that a chore changes someone's bill, write the exact amount or rule in the Rules tab and reference it in the ledger. A completed checkbox should never silently change a balance.

Build the workbook in Google Sheets

  1. Create a blank spreadsheet and name the first tab Ledger. Add Chores, Summary, and Rules tabs.
  2. Add the ledger headers in row 1. Keep the first columns short so the important details appear before the horizontal scroll.
  3. Format dates as dates and amounts as currency. Use the number-format controls rather than typing dollar signs into every amount.
  4. Add dropdowns through Data > Data validation for categories, split methods, settlement statuses, and chore statuses.
  5. Freeze the header with View > Freeze > 1 row. If the ledger is wide, freezing the first column can also help.
  6. Use alternating row colors and conditional formatting for statuses. Keep the written status visible; color should support the label, not replace it.
  7. Protect the header and formula cells through Data > Protect sheets and ranges. Leave the entry cells editable.
  8. Open the file on your phone, add a test expense, and check the result before sharing it with the group.

Create a new row for each month's recurring bill. Don't overwrite last month's rent or utility entry, because the old amount and settlement history may matter later.

Make the file comfortable on a phone

Put Date, Description, Amount, Paid by, and Settlement status near the left side of the ledger. Move long notes and receipt references to the right. Short labels, wrapped notes, and a frozen header make more difference than decorative formatting.

Turns out, a plain sheet is often easier to use than a busy dashboard. Keep the active table compact, avoid merged cells inside it, and let people scroll to the optional details only when they need them. Test one edit in the Google Sheets app or mobile browser, then adjust column widths on a larger screen if necessary.

Add formulas for the routine math

For a two-person setup, formulas can remove repetitive calculations. They should show the rule clearly, not hide it.

Assume D is the total amount, G is Alex's share, and H is Jordan's share. For a 50/50 expense, enter these in row 2:

G2 (Alex share): =D2*50%
H2 (Jordan share): =D2-G2

Replace 50% only when the group has agreed to a different split. A percentage is a method, not proof that the result is fair.

On the Summary tab, put Alex in A2 and use:

B2 (Alex paid): =SUMIF(Ledger!$E$2:$E$500,A2,Ledger!$D$2:$D$500)
C2 (Alex share): =SUM(Ledger!$G$2:$G$500)
D2 (Alex net): =B2-C2

For Jordan in row 3, use the same paid formula with A3, then total Jordan's share from column H:

C3 (Jordan share): =SUM(Ledger!$H$2:$H$500)
D3 (Jordan net): =B3-C3

A positive net means the person paid more than their recorded share. A negative net means they owe more than they have paid, assuming the ledger contains only shared expense rows and no repayment transfers.

To total a category named in F2, use:

=SUMIF(Ledger!$C$2:$C$500,F2,Ledger!$D$2:$D$500)

Keep the formula range long enough for your group, but avoid creating formulas that include a separate repayment row unless you have deliberately accounted for it.

Agree on the split before linking chores to money

Different households need different rules. Record the choice in the Rules tab and use the same method until the group agrees to change it.

Split rule When it may fit What to record
Equal split People use the shared item in roughly similar ways 50/50 or an equal per-person share
Usage-based split One person uses noticeably more of a bill or item The agreed percentage or item-specific amount
Income-based contribution Partners or family members choose contributions based on income The percentage and when it will be reviewed
Room-size or nights-stayed split Rooms, occupancy, or trip participation differ The room or night-based rationale
Chore credit Everyone explicitly values certain work as part of the arrangement The credit amount, duration, and approval rule

Chore credits deserve extra care. A household might agree that taking on a recurring duty offsets part of a shared cost, but that agreement should be written before the work is counted. Don't introduce a charge or credit after the fact.

Share access without creating edit chaos

Give people the smallest permission they need. Editors can enter bills, update chores, and mark settlements. Commenters can flag a missing receipt or question a split. Viewers can see the record without changing it.

  • Share with named group members when the ledger contains personal spending details.
  • Keep editor access with people who actually maintain the file.
  • Use comments for questions instead of replacing someone else's amount.
  • Add a rule for who approves a changed split or chore credit.

Protect formula cells and summary ranges after the layout is stable. Protection helps prevent accidental edits, but it does not hide the sheet from someone who already has access.

Use the Rules tab for practical decisions: who logs recurring bills, what each status means, how receipts are stored, when a balance is settled, and how a disputed row is handled. Keep those rules short enough to read on a phone.

Review the ledger once a week

Try a short weekly review, often around 10 minutes for a tidy sheet. The point is to catch missing information while the purchase is still easy to remember.

Check Action
New expenses Confirm the date, amount, payer, and split
Pending entries Decide whether the bill was paid or still needs action
Unsettled balances Confirm the share before requesting repayment
Chores Mark completed work and assign the next due items
Recurring costs Add the next bill as a new row instead of editing history
Disputes Leave the original row in place and add a comment or note

A neutral message keeps the conversation practical: "I added the utility bill. Your recorded share is $60. Please check the row and mark it settled after payment."

Don't mark a reimbursement settled just because someone said they will send it. Record the request first, then update the status when the group has confirmed the payment.

Know when a spreadsheet is enough

A spreadsheet fits when the group is small, the split rules are explainable, and everyone can follow one shared record.

Situation Spreadsheet approach Consider adding
A household has recurring rent, utilities, and groceries Use the ledger, summary, and chore tabs A reminder system for due dates
A trip has a few shared purchases Log each expense and keep receipt references A receipt folder for photos
Many people submit one-off expenses Use a Shares tab and clear entry IDs A process for approving submissions
Chores have complex rotations Keep money in the ledger A calendar or dedicated chore schedule
The group often disputes amounts Preserve notes and receipts Written approval before changing rows

To be honest, another app won't fix an unclear split rule. It may help with reminders, receipt capture, or payment requests, but tracking, requesting, paying, and keeping records are separate jobs. If you use a payment tool, record the request date and settlement result in the sheet rather than assuming the payment history is the group's only record.

Check the file before inviting everyone

  • Confirm every expense has a date, amount, payer, split method, and status.
  • Check that each person's shares add up to the total amount.
  • Define the difference between a paid bill and a settled reimbursement.
  • Protect formulas, headers, and summary cells.
  • Test one bill and one chore from a phone.
  • Keep a periodic copy or export if the records matter to the group.

Questions people commonly ask

Can a completed chore automatically reduce a bill?

It can, but that setup is easy to misunderstand. Record the agreed credit in the ledger or summary only after the group has decided the amount, timing, and approval method.

Can I protect the bill totals?

Yes. Use protected sheets or ranges for headers, formulas, and summary cells while leaving entry rows open. Protection is an editing safeguard, not a privacy boundary.

Should every person be an editor?

No. Give editing access to people who enter or maintain data, and use comments or view access for everyone else when that fits the group's workflow.

Will the tracker work offline on a phone?

Check the offline setting in the Google Sheets app and test an edit before relying on it. An offline change is useful only if it syncs correctly after the device reconnects.

Create the four tabs, enter one recent bill and one chore, test the balance formula on your phone, and fill in the group rules before sending the share invitation.