A group that needs custom split rules, not a simple running IOU, can keep the whole trail in Google Sheets. One file records all four pieces.
The bill, who paid it, each person's share, and the reimbursement that closes it belong in that same file. That distinction prevents many later arguments.
Want a free shared-expense template you can adjust for roommates, a family, or a trip?
Copy the five-tab layout below into a blank Google Sheet, then agree on the rule before the first bill lands. Start with real names and a test expense.
Fixing a vague balance later is harder. A spreadsheet works best when the group wants a transparent record of different shares, receipts, or recurring bills.
The shared sheet tracks decisions; it does not request or send payment by itself.
Copy this Google Sheets shared expense tracker layout
Name five tabs People, Expenses, Shares, Payments, and Balances, even if five tabs can sound a bit fussy at the start. Each tab has a single job.
Keep expense IDs unique, because the formulas rely on them.
People tab
| Column | Put in it | Example |
|---|---|---|
| A: Name | Each active participant once | Avery |
| B: Default share | A starting percentage for recurring costs | 50% |
| C: Notes | Room, guest, or household notes | Larger bedroom |
Spell every name the same way in every tab. A dropdown list is safer than typing names repeatedly.
Expenses tab
Log each bill on this tab once.
| Column | Put in it | Example |
|---|---|---|
| A: Expense ID | A unique label for the bill | EXP-001 |
| B: Date | Date paid or charged | 6/18/2026 |
| C: Description | What the group bought | Household groceries |
| D: Category | A useful reporting label | Groceries |
| E: Total | Full amount paid | $86.40 |
| F: Paid by | Person who actually paid | Avery |
| G: Split rule | Brief explanation of the method | Equal among 3 |
| H: Receipt link | Link to a shared receipt file, if available | Receipt folder file |
| I: Split total | Formula that checks all shares | =SUMIF(Shares!A:A,A2,Shares!C:C) |
| J: Notes | Exceptions or context | Casey was away |
Format column E as currency and column I as a percentage. A completed expense should show 100% in Split total.
Shares tab
Add one row for every person who owes part of an expense. If three people split a dinner, that dinner gets three rows.
| Column | Put in it | Example |
|---|---|---|
| A: Expense ID | Matching ID from Expenses | EXP-001 |
| B: Person | Person who owes a share | Avery |
| C: Share percent | That person's portion | 33.33% |
| D: Amount owed | Formula | =IF(A2="","",ROUND(VLOOKUP(A2,Expenses!A:E,5,FALSE)*C2,2)) |
For a $100 bill split three ways, use 33.33%, 33.33%, and 33.34%. That assigns the final penny instead of leaving the group one cent short.
Payments tab
Use this tab only after someone actually sends money.
| Column | Put in it | Example |
|---|---|---|
| A: Date | Date money changed hands | 6/20/2026 |
| B: From | Person who sent money | Blake |
| C: To | Person who received money | Avery |
| D: Amount | Amount sent | $28.80 |
| E: Method or reference | Optional record | Payment app note |
| F: Notes | Context | June grocery reimbursement |
Balances tab
Put a name from the People tab in column A, then copy the formulas down for each participant.
| Column | Formula or purpose |
|---|---|
| A: Person | Name from the People tab |
| B: Expenses paid | =SUMIF(Expenses!F:F,A2,Expenses!E:E) |
| C: Shares owed | =SUMIF(Shares!B:B,A2,Shares!D:D) |
| D: Net before payments | =ROUND(B2-C2,2) |
| E: Payments sent | =SUMIF(Payments!B:B,A2,Payments!D:D) |
| F: Payments received | =SUMIF(Payments!C:C,A2,Payments!D:D) |
| G: Current net | =ROUND(D2+E2-F2,2) |
| H: Status | =IF(G2=0,"Settled",IF(G2>0,"Receive","Pay")) |
A positive current net means that person should receive money. A negative amount means they should pay.
Create dropdowns for Expenses!F:F and Shares!B:B using the names in People!A2:A. Then protect the formula columns once you have tested them.
Skip a dashboard at the start. Clean balances matter more than charts.
Choose a fair split rule before the bill arrives
Roommates might split a fixed rent bill by room size and exclusive amenities, divide ordinary utilities evenly, and bill a guest-heavy weekend differently, which can feel a bit fussy at first but saves everyone from retroactive math after the bill arrives. Equal per person stays simple to audit.
An equal per person split works for shared groceries, a group gift, or a meal where everyone participated.
A room-based rent split can work when bedrooms differ in size, privacy, storage, parking, or amenities. Agree on the percentages before the lease term or payment cycle begins.
Usage-based sharing fits costs tied to actual consumption, such as a rental car used by only some travelers or a utility bill affected by an agreed special use, so define what counts as usage because guessing later rarely goes well.
Lodging often works better with nights-stayed sharing: divide the cost by occupied nights, then multiply by each person's nights rather than treating a two-night guest like a week-long guest.
Income-based sharing can be a voluntary choice for partners or families if you write down which expenses it covers, what income figure you will use, and when you will revisit the arrangement.
Some purchases should stay personal: a person's takeout order, personal subscription, or solo activity does not need a group formula.
Thing is, a fair-looking formula will not repair a rule nobody agreed to. Fair is a rule the group accepts, not one formula.
Add expenses with an audit trail
Enter one expense, then add its participant rows. Do not combine separate purchases just because the same person paid.
- Give the bill an expense ID, date, description, category, total, and payer in the Expenses tab.
- State the split rule in plain language, such as "all three roommates" or "lodging by nights stayed."
- Add one Shares row for every participant and enter percentages that total 100%.
- Add a receipt link or a short note while the purchase is still fresh.
- Check the Split total cell before anyone sends reimbursement.
If Avery buys $86.40 of groceries for three equal participants, record Avery as the payer and add three Shares rows. Each person owes $28.80.
Avery's own share still belongs in the sheet because Avery paid for it too.
One receipt can have two payers. Create separate expense records for the portions each person paid, give them different IDs, and attach the same receipt link to both rows.
Do not type "Multiple" in the Paid by column, because the balance formulas cannot tell who advanced what.
For a cancellation or refund, add a separate adjustment record and reference the original expense ID in Notes. Do not overwrite the original bill.
The history matters.
Keep reimbursements out of expense totals
An expense and a reimbursement are different events.
The Expenses tab records what the group bought. The Payments tab records how the group settled it.
Imagine Avery paid $240 for lodging, while Avery, Blake, and Casey each owe $100.
| Person | Expenses paid | Shares owed | Net before payments |
|---|---|---|---|
| Avery | $240 | $100 | $140 |
| Blake | $0 | $100 | -$100 |
| Casey | $0 | $100 | -$100 |
Blake can send Avery $100, and Casey can send Avery $40 plus settle the remaining $60 through another agreed arrangement only if the group has another amount owed elsewhere. In this single-bill example, Avery should receive $140 total, while Blake and Casey should each send $100, so the split itself needs another check: $240 divided three ways is $80 each.
That is exactly why the Shares tab is useful. The three Shares rows should be $80, $80, and $80 before anyone pays.
To be honest, entering a reimbursement as a negative grocery or lodging expense is one of the quickest ways to make category totals misleading. Record the payment separately.
If more than one person has a positive balance, make a short settlement plan in Notes. The Current net column shows each person's position, but it does not always dictate the only sensible payment path.
Set permissions and a receipt routine
Share edit access only with people who must enter or correct data. Everyone else can comment or view.
If all members need to add expenses, protect the formula columns and leave the entry fields open. Keep the description, total, payer, and receipt link near the left side of the sheet so phone updates are less clumsy.
Use a shared receipt folder if the group needs proof for deposits, travel reimbursements, or recurring household bills. A simple file name such as YYYY-MM-DD_store_amount is enough.
Blurry photos and missing dates create more work later.
A spreadsheet cannot override a lease, a written roommate agreement, or a rule governing a security deposit. Those obligations depend on the signed documents and, in many cases, state or local law.
Catch the mistakes that distort group balances
Small spreadsheet errors compound quickly.
Names drift when someone writes Alex in one tab and Alexander in another, and the formula treats them as separate people. Use the People tab dropdowns.
An expense that adds to 95% or 105% of the bill will quietly distort balances. Check for 100% before settling.
A payment is not a negative expense. Put it in Payments so spending categories still mean something.
Overwriting a bill after a refund, correction, or canceled booking removes the explanation. Add an adjustment row instead.
Wait until receipts, participants, and pending refunds are reviewed. Turns out, a five-minute check can prevent a week of back-and-forth.
Close out a month or a trip
Roommates can pick a recurring review day before rent or utilities are due, while a travel group should review the sheet once the last shared charge and refund have posted.
Filter Expenses by the relevant date range, confirm every Split total, review the Current net column, and record payments as they happen. Keep the file after everyone reaches zero.
It can answer a later question about a deposit, a shared purchase, or a forgotten reimbursement.
Use a plain reminder when the group needs one:
I logged [expense ID] for [description]. The split is [rule], and the sheet shows you should send [amount] to [name]. Please flag any receipt or participant issue before [date].
Open a blank Google Sheet, create the five tabs, and enter one recent shared expense together. Test the percentages before sharing the file with the group.