If friends are sharing a Myrtle Beach rental, meals, gas, or activities, a plain Google Sheet can show both sides of the split: who paid and who owes. The useful setup isn't one giant balance cell. It keeps each bill, each person's share, and each reimbursement in separate rows.

A blank file at Google Sheets is enough for this workflow. You won't need a dedicated split-bill app just to make the math visible, but the sheet won't send money or fill in missing expenses. Agree on a simple rule first. A workable version is to add each cost within 48 hours, attach a receipt, and record reimbursements on a separate tab.

Use four tabs for the trip

Keep the structure boring. That makes disputes easier to check.

Tab What belongs there
Expenses One row for each bill, deposit, or shared purchase
Shares One row for each person who owes part of an expense
Summary Formula-driven totals for paid, owed, and remaining balances
Payments Actual reimbursements sent between group members

The separation matters. If you put reimbursements into the expense total, the trip cost gets overstated.

Build the Expenses tab first

Enter each cost once, even if six people share it. Then connect that expense to several rows in the Shares tab.

Use these columns in row 1:

Column What to enter
Expense ID A unique label such as MB-001
Date The date the charge happened
Description A clear name such as Beach house deposit
Category Rental, Flights/Transport, Gas, Groceries, Meals, Activities, Parking, or Misc
Amount The full charge in U.S. dollars
Paid By The person who covered the charge
Split Rule Equal, Percent, Custom, or Nights
People Count Number of participants for an equal split
Receipt A file link or short receipt note
Review Status Needs review or Confirmed
Notes Room, night, cancellation, or other context
Allocation Check Formula that compares shares with the full charge

Use a unique Expense ID every time. Names can repeat, but an ID should not.

For example, a $1,200 rental deposit could be MB-001, category Rental, paid by Alex, with Equal as the split rule and 6 as the people count. That is one Expenses row, not six.

Add one Shares row per person

The Shares tab turns a vague note such as "split among the group" into amounts that formulas can total.

Column What to enter
Expense ID The matching ID from Expenses
Person One participant's name
Share ($) That person's dollar responsibility
Percent Optional percentage, formatted as a percent
Basis/Notes Equal share, three nights, private room, or another reason

For an equal split, enter the Expense ID and each participant's name. In Shares!C2, use this formula for the dollar share:

=IFERROR(VLOOKUP(A2,Expenses!$A:$H,5,FALSE)/VLOOKUP(A2,Expenses!$A:$H,8,FALSE),"")

Copy it down. It finds the full amount in column E and divides it by the people count in column H.

For a percentage split, enter a value such as 40% in column D and use this instead:

=IFERROR(VLOOKUP(A2,Expenses!$A:$H,5,FALSE)*D2,"")

Custom dollar splits are different. Enter each agreed amount manually in column C, then explain the basis in column E. A person's amount might reflect extra nights, a private room, or an activity they did not join.

In Expenses!L2, add an allocation check:

=ROUND(SUMIF(Shares!$A:$A,A2,Shares!$C:$C)-E2,2)

A result of 0.00 means the Shares rows match the expense. A positive result means the shares exceed the bill. A negative result means part of the bill is still unassigned.

Set up the sheet in a few passes

  1. Open Google Sheets, create a blank spreadsheet, and name it something like Myrtle Beach Group Expenses.

  2. Add four tabs named Expenses, Shares, Summary, and Payments.

  3. Add the column headers above. Freeze row 1 from the View menu so the headers stay visible while you scroll.

  4. Format Date columns as dates and Amount or Share columns as currency.

  5. Select the Category column and use Data > Data validation to create a dropdown. Use the same approach for Split Rule and Review Status.

  6. Add every participant's name to the Summary tab before the trip begins. Consistent spelling matters because the balance formulas match names exactly.

  7. Test one equal split and one custom split before entering the real rental deposit.

This takes a little longer than making a single list. It saves cleanup later.

Track reimbursements separately

Create these columns in Payments:

Column What to enter
Date When the reimbursement was sent
From Person who sent the money
To Person who received it
Amount Actual payment amount
Note Transfer reference or expenses covered

If Alex sends Jordan $40, enter Alex under From and Jordan under To. Don't turn that $40 into a negative expense. The original bill should remain unchanged.

That record gives you an audit trail without tying the spreadsheet to a particular payment service. People can use their preferred transfer method, then log the completed payment here.

Use Summary formulas for who owes what

On Summary, list each person's name in column A. Add these headers in row 1:

Column Header
A Person
B Paid
C Owed
D Sent
E Received
F Remaining

Copy these formulas down from row 2:

Column Formula Meaning
B2 =SUMIF(Expenses!$F:$F,$A2,Expenses!$E:$E) Total paid by the person
C2 =SUMIF(Shares!$B:$B,$A2,Shares!$C:$C) Total share assigned to the person
D2 =SUMIF(Payments!$B:$B,$A2,Payments!$D:$D) Reimbursements the person sent
E2 =SUMIF(Payments!$C:$C,$A2,Payments!$D:$D) Reimbursements the person received
F2 =B2-C2+D2-E2 Position after recorded payments

A positive Remaining amount means the person should receive money. A negative amount means the person still owes money. Zero means the recorded expenses and payments balance.

Thing is, this shows net positions rather than an automatically optimized payment plan. The group still needs to agree who sends money to whom, then enter each transfer in Payments.

For category totals, list categories in another Summary area and use:

=SUMIFS(Expenses!$E:$E,Expenses!$D:$D,H2)

Here, H2 contains a category such as Meals.

A compact category report can use:

=QUERY(Expenses!A:E,"select D, sum(E) where D is not null group by D label sum(E) 'Total'",1)

To review larger charges in a separate area, use:

=FILTER(Expenses!A:L,Expenses!E:E>100)

Replace 100 with the threshold that makes sense for your group.

Choose the split rule before the bill arrives

Equal sharing is clear when everyone gets the same benefit. It becomes awkward when people stay different nights, skip an activity, or take separate rooms.

Split rule When it fits How to record it
Equal Everyone shares the cost in the same way Use Equal, enter the participant count, and add one Shares row per person
Percentage The group agrees on fixed contribution percentages Enter percentages in Shares and check that they total 100%
Custom dollar amount Room sizes, private purchases, or special arrangements differ Enter each dollar share manually and describe the basis
Nights or rooms A rental has staggered arrivals or different room use Calculate each person's agreed share and document nights or room type

With different arrival dates, one workable method is to divide fixed booking costs across the agreed group and assign the night-based portion by guest-nights. With staggered arrivals, private bedrooms, and a rental deposit paid months earlier, separating those pieces may feel fussy at first, but it is easier than arguing over one equal number on the last morning.

There is no universal fairness rule. Write the choice in Basis/Notes before anyone pays.

Share access without losing control

Use named invitations when the sheet contains personal names and balances. Give Editor access to the one or two people maintaining formulas, and use Commenter or Viewer access for everyone else who only needs to review the record.

Permission Practical use
Viewer Read-only access to totals and receipts
Commenter Review rows and leave questions without changing cells
Editor Add expenses, enter shares, and maintain formulas

Link sharing is convenient, but named access makes the group easier to manage. Keep a copy of the original structure, and use File > Version history if someone deletes a row or changes a formula by mistake.

Don't put bank login details, full card numbers, or other sensitive credentials in the file. The sheet needs expense facts, not account access.

Fix the mistakes that create most disputes

Mistake Better practice
Adding one full bill for every participant Add the bill once in Expenses and split it in Shares
Treating a reimbursement as a new expense Add it to Payments
Marking an expense as settled without recording the transfer Keep the expense and payment records separate
Leaving custom shares unexplained Add the reason in Basis/Notes
Forgetting cash purchases Log the expense, write Cash in Notes, and attach the receipt if available
Ignoring rounding Assign the leftover cent to one agreed share so totals match

Receipts help, but they don't replace a split rule. The group should be able to see why each person owes a particular amount.

Know when a spreadsheet is enough

A spreadsheet usually works well when the group can enter expenses manually, agree on the split rules, and let one person maintain the formulas. It is especially useful for rental deposits, groceries, gas, meals, and activities that need a shared record.

Consider a dedicated split-bill app when you need receipt scanning, automatic participant selection, or payment requests. Check its current features and fees before relying on it. To be honest, a plain sheet that everyone updates is more useful than a polished tool that leaves gaps in the record.

Three edge cases to plan for

Keeping every share in one cell. Text such as Alex 40%, Jamie 30% is readable but difficult to total reliably. Use one Shares row per person instead.

Cash expenses. Add them like any other cost. Note who paid and that the transaction was cash. If the receipt is missing, mark the row for group review rather than silently estimating.

Exact person-to-person transfers. The Summary tab shows who is ahead or behind, but it does not decide the payment sequence. Agree on simple reimbursements and record each completed transfer in Payments.

Create the file before the first deposit. Add one sample equal split and one custom split, make sure both Allocation Check cells show 0.00, then send the sheet to the group for review. After that, log each bill once and add reimbursements only to Payments.