Use a Google Sheets or Excel spreadsheet to build a shared expense tracker with a "who owes what" column. Start with columns for date, description, amount, payer, split type, and participants. Add a summary section to calculate net balances per person - positive amounts show money owed to them, negative amounts show what they owe the group.

This approach suits U.S. roommates splitting rent and utilities, travel groups tracking vacation costs, families managing budgets, or clubs handling dues. Enter expenses as they happen, apply equal or custom splits, and review balances weekly. No apps needed for basic tracking and reimbursements.

Recommended Columns for a Shared Expense Tracker

A clear column setup captures who paid what and how to split it. Use one main sheet for transactions and a second for summaries showing "who owes what."

Essential columns include:

  • Date: When the expense occurred (e.g., 2026-01-15).
  • Description: Details like "February rent" or "gas for road trip."
  • Amount: Total cost (e.g., $800).
  • Category: Rent, groceries, travel, utilities - helps filter later.
  • Payer(s): Name of who paid (e.g., "John" or "Sarah and Mike").
  • Split Type: Equal, exact shares, reimbursement, or income-based (e.g., "equal/4" for four people).
  • Participants/Share %: List names or percentages (e.g., "John 25%, Sarah 25%, Mike 25%, Alex 25%" or mark yes/no for equal splits).

For the "who owes what" summary, create a separate sheet or section. List each person with a net balance column. Positive values mean the group owes them (they overpaid); negative means they owe the group (underpaid after splits).

This structure works for roommate rent splits, group dinners, or family recurring bills. Adjust split types for uneven shares, like room size or nights stayed.

Setup Steps for Google Sheets or Excel

Follow these steps to build the tracker from scratch.

  1. Create the sheet: Open Google Sheets or Excel. Name the file "Group Expenses 2026." Add a "Transactions" sheet with the recommended columns in row 1 (A to H).

  2. Enter sample data: Add rows for real expenses. Example: Date 2026-01-10, Description "Groceries," Amount 120, Category "Groceries," Payer "John," Split Type "equal/4," Participants "John,Sarah,Mike,Alex."

  3. Calculate individual shares: In a new column I ("John Share"), use a formula to divide the amount by the number of participants for equal splits. Repeat for others or use helper columns for custom %.

  4. Build summary sheet: Add a "Balances" sheet. List names in column A (e.g., A2: John). In B2 for John's net: subtract his total share from contributions.

  5. Share and set permissions: In Google Sheets, click Share > add emails or generate link. Use "Viewer" for records-only groups; "Editor" for active updates. In Excel, save to OneDrive and share similarly. Set weekly reviews: one person logs new receipts Saturdays.

Update after each expense or batch weekly. Back up monthly via File > Download.

Example Formulas for "Who Owes What" Calculations

Use these as starting points - test in your sheet, as results depend on data setup.

For total contributions by payer (e.g., John's payments, assuming F is payer column, E is amount):
=SUMIF('Transactions'!F:F, "John", 'Transactions'!E:E)

For category-specific payer totals (e.g., John's groceries, C=category, F=payer, E=amount):
=SUMIFS(E:E, C:C, "Groceries", F:F, "John")

For category summaries (A=date, C=category, D=amount):
=QUERY(A2:D100, "SELECT C, SUM(D) GROUP BY C LABEL SUM(D) 'Total'")

For multi-condition totals like travel (B=amount, D=category, F=flag):
=SUMIFS(B2:B100, D2:D100, "Travel", F2:F100, "Yes")

Net "who owes what" per person: Contributions minus shares. Example for equal split:
[SUMIF for contributions] - (total group expenses / number of people)

Tradeoffs: Equal splits simplify formulas but ignore usage differences. Reimbursement workflows mark payer at 100%, others 0% - log actual payments separately to avoid double-counting.

Sharing,Sharing, Updates,Updates,Updates, and Common Mistakes

Share via link for access control. Google Sheets supports multiple editors. Designate one updater or rotate to avoid disputes.

Weekly script: "Gather receipts, enter transactions, recalculate balances, text group summary." Monthly: Export PDF for records.

Common mistakes:

  • Forgetting to log cash reimbursements as 100%/0% splits (one person pays back fully).
  • Over-editing without version history (use File > Version history).
  • Ignoring split variations - equal works for dinners; usage-based (e.g., per mile driven) needs % columns.
  • No category filters, making summaries messy.

Backups prevent data loss. For active groups, agree on rules upfront like "update within 48 hours."

When to Use a Spreadsheet vs. an App

Spreadsheets suffice for small groups (under 10 people) with simple rules and no payment needs. They handle custom splits like income-based or nights-stayed without fees.

Use if:

  • Tracking roommates' utilities or family groceries.
  • Group travel with occasional reviews.
  • Clubs needing exportable records.

Consider apps for receipt scanning, auto-reminders, or larger groups. A receipt folder plus written rules works for one-off events like parties.

Stick to spreadsheets when payment apps blur tracking - reimburse via check or bank transfer after balances settle. No need for apps if a shared doc meets your workflow.

FAQ

How do I calculate net "who owes what" for a roommate group?
Sum each person's payments minus their shares (total / split count or custom %). Positive = owed to them.

What's a good split type column for uneven shares like travel?
Use % per person (e.g., "Alex 40%, others 20%") or flags (yes/no) with formulas dividing by participant count. Test for accuracy.

Can I use these formulas for family budgets or club dues?
Yes, adapt categories for recurring dues or budgets. Use QUERY for monthly summaries.

How often should we update the tracker?
After each expense or weekly batches. Review balances monthly.

What if someone disputes a balance?
Pull receipts, verify entries together. Add a notes column for agreements.

Are there free templates that include a "who owes what" column?
Search Google Sheets template gallery for "shared expenses" - customize with these columns and formulas.

Next, build your sheet with sample data from last month's expenses. Test formulas on two rows, then share for feedback.