After a weekend away with friends, the cabin went on one card, dinner on another and groceries on a third. Working out who owes whom at the end is where the headaches start. A small spreadsheet settles it in a few minutes, and it's easy to check.
1. Put every payment in one table
Start with a list of who paid for what. If you have receipts, add the photos to the receipt tool to get the date, store and total in a table, then add a Paid by column to the downloaded file.
As an example, four friends, Alex, Blake, Casey and Drew, share a weekend trip. The sheet is named Payments.
| No. | Date | Store | Total | Paid by |
|---|---|---|---|---|
| 1 | 9/5/2026 | Lakeside Cabins | 480.00 | Alex |
| 2 | 9/5/2026 | Harbor Grill | 256.00 | Blake |
| 3 | 9/5/2026 | Corner Market | 128.00 | Casey |
| 4 | 9/6/2026 | Taxi | 64.00 | Alex |
Anything without a receipt, like the taxi, can go in with "Add row". The trip cost 928.00 in total.
2. What each person paid and owes
Make a second sheet named Settle with one row per person.
| Person | Paid | Share | Balance |
|---|---|---|---|
| Alex | 544.00 | 232.00 | +312.00 |
| Blake | 256.00 | 232.00 | +24.00 |
| Casey | 128.00 | 232.00 | −104.00 |
| Drew | 0.00 | 232.00 | −232.00 |
- Paid (B2):
=SUMIF(Payments!E:E, A2, Payments!D:D) - Share (C2): the total divided by the number of people,
=SUM(Payments!D:D)/COUNTA($A$2:$A$5) - Balance (D2):
=B2-C2
A positive balance is money to receive and a negative balance is money to pay. The balances should add up to zero. If they don't, look for a misspelled name in the Paid by column.
3. Settle up with fewer transfers
Once you have the balances, pair people up. The simplest rule is to have whoever owes the most pay whoever is owed the most, and repeat.
- Drew owes 232.00 and Alex is owed 312.00. Drew sends Alex 232.00, and Alex is still owed 80.00.
- Casey owes 104.00. Casey sends Alex the remaining 80.00 and still owes 24.00.
- Casey sends Blake 24.00.
Three transfers and everyone is square, fewer than if everyone paid one person who then paid the others back.
4. Costs only some people shared
Not every cost is shared by everyone. If only three of the four had drinks at dinner, those three should split the bar tab. Add a participation column for each person in the payments table.
- Use columns F to I for Alex, Blake, Casey and Drew, and enter 1 if they shared that cost or 0 if not.
- In column J, count participants with
=SUM(F2:I2). In column K, work out the cost per participant with=D2/J2. - On the Settle sheet, Alex's share becomes
=SUMPRODUCT(Payments!K2:K20, Payments!F2:F20). Use column G for Blake, H for Casey and I for Drew.
The Paid and Balance formulas stay the same, so filling in the participation columns is all it takes to make the split fair.
5. Round before you send money
Dividing costs leaves amounts like 33.3333. Round transfers to the cent with =ROUND(D2, 2), or to whole units with =ROUND(D2, 0) if your group prefers. Agree up front that the person receiving the most absorbs the few cents left over.
Summary
Splitting shared costs comes down to one table of every payment, each person's balance of paid minus share, and settling the biggest balances first. Letting a tool turn the receipt photos into the table takes care of the slowest part.