A shared Google Sheets expense tracker is enough for many roommates, couples, trip groups, and small clubs. Use one row per expense, separate the payer from each person's share, and record settlements in a second tab.

That structure answers the basics: what was bought, who paid, what each person owes, and whether the row was settled. The sheet records those decisions; it doesn't send money or confirm that a transfer happened.

Start with a blank Google Sheets file and add the layout below. A spreadsheet can cover this without a dedicated paid expense app.

Build the workbook around four jobs

Name the first tab Expenses. It holds the original transaction log, so nobody has to reconstruct what happened later.

Use Summary for each person's total paid, assigned share, and net balance. Settlements records transfers after the expense is logged, while an optional Rules tab stores the group's split agreement.

Turns out, most groups don't need a complicated dashboard. Keep the raw rows intact and put calculations somewhere else.

Choose columns that separate paying from owing

Add one share column for each participant. Keep each person's name identical across the expense and summary tabs.

Column What to enter Example
Date Date the expense happened 2026-01-15
Description Plain-language purchase name Groceries
Category Optional grouping Household
Amount Total cost as a positive number $200
Paid by Person who covered the charge Jordan
Split type Rule used for this row Equal
Alex, Jordan, Sam, Taylor Dollar amount each person owes $50 each
Settled? No, Partial, or Yes No
Receipt or notes Receipt location, context, or agreement Shared folder link
Split check Formula that confirms the shares add up OK

The share columns represent responsibility, not payment. That distinction matters: Jordan can appear in Paid by and also have a $50 share.

Add more participant columns as needed. If someone did not participate in a custom expense, enter $0 rather than leaving the rule unclear.

Some groups prefer percentages instead of dollar shares. Require each row to total 100 percent. If one person covers a reimbursement, that person's coverage can be 100 percent and everyone else's 0 percent, but don't mix percentage entries with dollar amounts in the same columns.

Create the Google Sheets template

Set up the file in this order:

  1. Open a blank spreadsheet.
  2. Rename the first tab Expenses, then add Summary, Settlements, and, if useful, Rules.
  3. Add the headers shown above. Put participant names in the share-column headers.
  4. Format Date as a date and Amount as currency.
  5. Freeze the top row so the headers stay visible while you scroll.
  6. Add dropdowns for Split type and Settled? with consistent values such as Equal, Custom, Reimbursement, No, Partial, and Yes.
  7. Put receipt links or short notes in the same row as the expense.

Don't build formulas before deciding what the share columns mean. That small choice prevents many later corrections.

Add formulas for equal splits and balance totals

The share columns should add to Amount on every row.

Suppose Amount is column C, Split type is column E, and the four participant columns run from F through I. For an equal split among all four listed members, enter this in F2 and copy it across and down:

=IF($E2="Equal",$C2/COUNTA($F$1:$I$1),"")

Use manual dollar amounts for Custom and Reimbursement rows. An equal-split formula cannot know that one person skipped dinner or that a purchase belongs to only two roommates.

In L2, add a check that catches missing or excess shares:

=IF(ROUND(SUM($F2:$I2),2)=ROUND($C2,2),"OK","CHECK SPLIT")

Copy the check down the sheet. Fix any CHECK SPLIT result before marking the row settled.

On the Summary tab, create these columns: Person, Total paid, Total share, and Net. For Alex, the total paid formula in B2 can be:

=SUMIF(Expenses!$D$2:$D,A2,Expenses!$C$2:$C)

If Alex is in column F on the expense tab, use this for total share:

=SUM(Expenses!F2:F)

Then calculate net in D2:

=B2-C2

Copy the first formula and net formula down. Adjust the share-column reference for each person. A positive net means the group owes that person; a negative net means that person owes the group.

For a visual review flag, apply conditional formatting to the Amount column with a custom formula such as =AND($C2>100). Treat $100 as a review threshold, not a universal rule.

Test the math before sharing

Use the sample from the setup instructions to check every formula at once.

Date Description Amount Paid by Split type Alex Jordan Sam Taylor Split check
2026-01-15 Groceries $200 Jordan Equal $50 $50 $50 $50 OK

Jordan paid $200 and has a $50 share, so Jordan's net is +$150. Alex, Sam, and Taylor each show -$50.

If the totals differ, fix the formulas before inviting anyone. Small errors are easier to find in one test row.

For a reimbursement example, Sam pays an $80 utility bill for Alex and Jordan. Enter Reimbursement, put Sam at $0, Alex at $40, Jordan at $40, and Taylor at $0 if Taylor is not included. The split check should still say OK.

If Sam also shares the utility, assign Sam's own portion and divide only the remaining amount among the other people. Write that rule in the Rules tab.

Share with a narrow access list

Sharing controls matter because expense rows can include receipts, addresses, and personal notes.

Editor access fits people who add rows or maintain formulas. Give it sparingly.

Commenter access works for people who need to ask questions without changing the ledger.

Viewer access is enough for someone who only needs to review records.

Invite specific people by email when possible. An open link that allows anyone to edit makes accidental changes much more likely.

Review the setting that controls whether editors can change permissions or share the file. Use sheet or range protection for formula cells if group members tend to overwrite them.

Comments can flag a question, such as "Was this dinner personal or shared?" They aren't a settlement record. Put the actual transfer in Settlements.

A large editor list creates its own risk. Keep edit access limited to people entering or checking transactions, and give everyone else a viewing role.

Agree on the split rule first

Choose the rule before entering a month of expenses. Changing the rule halfway through makes old and new rows difficult to compare.

Split method Works well when What to decide
Equal Shared meals, common supplies, and routine bills Who counts as a participant
Per person Flights, gifts, tickets, or other individual costs Whether children or guests count
Usage-based Utilities, fuel, or supplies with different consumption How usage will be measured
Income-based Household contributions between partners or family members What income information is shared
Room-size-based Rent or household costs that reflect different rooms How room differences are valued
Nights stayed Lodging or trip costs with uneven attendance Which nights and deposits count
Reimbursement after proof One person fronts a purchase for others What receipt is required and when payment is due

Equal splitting is easy to explain. Usage-based or income-based rules can better match an agreement, but they need more information and more trust.

Write the rule in plain language. Include who participates, how rounding works, what happens with partial payments, and how corrections are documented.

Record reimbursements separately from expenses

Keep the original expense row even after everyone pays. Use the Settlements tab for Date | From | To | Amount | Method | Reference | Confirmed?.

For example, a $50 reimbursement might show Alex as the sender and Jordan as the recipient. The original grocery row still shows Jordan as the payer and each person's share.

Cash, a payment app, or a bank transfer can all be the method. The sheet should record what the group agreed happened, not pretend to verify the payment.

A simple message keeps the process moving: "I added the $50 team jersey purchase. Please check your share and confirm the receipt."

To be honest, a row marked Yes is only as reliable as the group's confirmation. If a payment is incomplete, use Partial and add the remaining amount to the notes.

Common mistakes to avoid

Receipts end up in random places, someone forgets which split rule applied, and a quick grocery run turns into a whole conversation. Build for that mess.

  • Treating Paid by as the person who owes the entire amount.
  • Using Equal when someone did not participate.
  • Typing over formulas in the share or summary columns.
  • Marking a row settled without recording the transfer separately.
  • Giving every group member edit access by default.
  • Changing the split rule without explaining which older rows it affects.
  • Leaving a custom split without a receipt or note.

Keep a downloaded copy when a trip, lease period, or event closes. The live sheet remains useful, but a dated record helps the group review what it agreed to at the time.

When a spreadsheet is enough

A spreadsheet usually fits a small group with occasional expenses and an agreed process. Use the table below to check whether your needs are starting to exceed a simple ledger.

Situation Spreadsheet approach Consider another tool when
Roommates with recurring bills Log each bill and settle on a regular schedule The group cannot keep up with manual entries
Short trip with shared costs Add one row per purchase and reconcile before leaving Receipts arrive in many formats and need frequent capture
Group that needs payment requests Record balances in the sheet and use a separate payment method Members need built-in requests or reminders
Formal financial records Keep receipts, rules, and dated exports together The records require accounting or professional review
Many people need access Give most people Viewer access and limit editors Everyone needs to enter data at the same time

Tracking, requesting, paying, exporting, and recordkeeping are separate jobs. A payment app may help with one of them, but it doesn't automatically replace a clear expense ledger.

Before moving to another tool, check its privacy controls, export options, and how your group will retain receipts. Sometimes the spreadsheet is still the simpler choice.

Questions that come up

How should I handle an uneven split?

Choose Custom, enter a dollar amount for each participant, and check that the row total equals Amount. Add a note explaining whether the difference came from usage, room size, nights stayed, or a personal item.

Should everyone be an editor?

No. Give editing access to people who enter or review rows, and use Commenter or Viewer access for everyone else.

Can a spreadsheet prove that someone paid?

No. It can document the group's record and the confirmation attached to a settlement, but it doesn't verify cash, app, or bank activity.

Can I use this without a paid expense app?

Yes, the layout relies on standard spreadsheet features rather than a dedicated expense service. Any separate receipt-storage or payment service may have its own terms or fees.

Create the Expenses and Summary tabs first. Add the $200 grocery test row, confirm the split check says OK, and invite one trusted editor before adding real shared costs.