Yes, a Google Sheet can handle a bachelorette weekend without a separate split-bill app. Set it up with one expense row, clear attendee shares, a summary, and a separate settlement log.

Use the layout below for a vacation rental deposit, dinner, rideshare, rooftop tab, or optional activity. The key choice is not the formula. It is agreeing who benefited from each charge.

You can build this in a blank file. No add-on is required.

Choose the split rule before entering costs

Thing is, an equal split is not always a fair split. Decide the rule before anyone starts adding receipts.

Cost Rule to agree on How to record it
Vacation rental Split equally if everyone stays; use nights stayed or room size when the group agrees Mark only the people covered by the charge
Group meal Split equally when everyone shared the meal Use a custom amount when orders differ substantially
Drinks or rooftop tab Include only the people who participated if the group prefers Mark drinkers as included, then split among them
Rideshare Charge the riders who used that trip Leave non-riders out
Optional activity Charge only attendees Use an unequal split if contributions differ
Bride's gift or hosted cost Decide whether the bride contributes before entering it Include or exclude her consistently

The bride isn't automatically free. If the group is covering her dinner or activity, include her. If not, leave her out.

Write that decision in the Notes column. It prevents a quiet argument later.

Build the Expenses tab

Open Google Sheets, create a blank file, and name it Austin Bachelorette Expenses. Add three tabs: Expenses, Summary, and Settlements.

One row should represent one charge. Do not combine a dinner and a rideshare just because one person paid both.

  1. In row 1 of Expenses, add Date, Description, Category, Payer, Amount, and Split Type.

  2. Add one Included column for each participant. Use the person's name in the header, such as Bride Included, Sarah Included, or Maya Included.

  3. Add a matching Owed column for each participant. Keep the names in the same order as the Included columns.

  4. Finish the row with Allocated, Difference, Notes, and Receipt.

  5. Add dropdowns for Payer and Split Type. Use Equal and Unequal as the split choices.

  6. Enter 1 for an included participant and 0 for someone who is not part of that expense.

For example, a dinner row might look like this:

Date Description Category Payer Amount Split Type Included
June 15 Group dinner at Franklin Barbecue Meals Sarah $320 Equal All eight marked 1

Enter the final shared charge in Amount. That can include tax and tip when they apply to the group expense.

Use the same spelling for every name. Sarah and Sarah B. become two different people to a spreadsheet.

Add formulas for equal and uneven shares

Assume the eight Included columns run from G:N. Assume the matching Owed columns run from O:V.

Paste this formula into O2:

=IF($F2="Equal",IF(COUNTIF($G2:$N2,1)=0,0,IF(G2=1,$E2/COUNTIF($G2:$N2,1),0)),"")

Copy it across the Owed columns and down the sheet. The G2 reference shifts for each participant, while the full Included range stays fixed.

With eight included people and an amount of $320, each Owed cell returns $40. The formula also leaves nonparticipants at zero.

For an uneven split, change Split Type to Unequal. Replace the Owed formulas in that row with agreed amounts or percentage formulas such as =$E2*40% and =$E2*60%.

Now add these checks:

  • In W2, enter =SUM(O2:V2) for Allocated.
  • In X2, enter =ROUND(E2-W2,2) for Difference.

A correct row shows $0.00 in Difference. A nonzero result means someone was missed or rounding needs a small adjustment.

Format Amount, the Owed columns, Allocated, and Difference as currency. Keep the Included columns as whole numbers.

A compact layout works for very simple groups. Use Date, Description, Payer, Amount, Split Type, # People, and Per Person Share; when Amount is in column D and the count is in column F, enter =D2/F2 for the per-person amount. A participant cell can then use =IF(G2>0,G2,0) when G2 contains that calculated share. This version is quick for full-group meals, but the paired Included and Owed columns handle optional activities more cleanly.

See who paid, who owes, and who has settled

The Summary tab turns row-level charges into a useful answer.

Set up these headers in row 1:

Name, Total Paid, Total Owed, Balance, Received, Sent, Remaining, Status

Put each participant's name in column A. For the first person in row 2, use the formulas below:

Cell Formula Purpose
B2 =SUMIF(Expenses!$D:$D,$A2,Expenses!$E:$E) Adds expenses paid by that person
C2 =SUM(Expenses!$O:$O) Adds that person's Owed column
D2 =B2-C2 Shows paid minus owed
E2 =SUMIF(Settlements!$C:$C,$A2,Settlements!$D:$D) Adds money received
F2 =SUMIF(Settlements!$B:$B,$A2,Settlements!$D:$D) Adds money sent
G2 =D2+F2-E2 Shows the remaining balance
H2 =IF(G2>0,"Receives",IF(G2=0,"Settled","Pays")) Labels the result

For the next participant, change only the Owed column in C3. If Sarah's Owed column is P, use =SUM(Expenses!$P:$P). Continue the mapping across the participant columns.

A positive Balance means that person fronted more than their share. A negative value means they still owe the group.

Create the Settlements tab with these columns:

Date, From, To, Amount, Note

If Sarah sends the bride $40, record Sarah in From, Bride in To, and 40 in Amount. That payment reduces the remaining balances.

Do not enter a reimbursement as a new dinner or activity. It is a settlement, not another shared expense.

Share the sheet without losing control

A shared link is convenient, but it can be forwarded. Use specific email access when the names and amounts should stay within the group.

  1. Click Share in the upper-right corner.

  2. Under General access, choose Anyone with the link if the group needs a simple link. You can also add specific people instead. Shared Contacts' Google Sheets sharing guide shows this link-sharing route.

  3. Choose the permission level. Viewer can read, Commenter can add comments, and Editor can change the sheet. Tiller's permissions guide describes these roles.

  4. Give Editor access to the person maintaining formulas and rows. Use Commenter for people who need to flag an error without changing the table.

  5. Select the Owed, Allocated, Difference, and Summary formula ranges. Use Data, then Protect sheets and ranges, and limit who can edit those cells.

On a phone, open the three-dot menu and choose the sharing option. GeeksforGeeks' mobile instructions cover that route.

Put the rules in the Notes column or at the top of the Summary tab: one row per charge, use the payer's exact name, mark only attendees, and use Settlements for repayments.

Keep the Austin weekend record usable

Enter costs the day they happen. The longer everyone waits, the harder it becomes to remember who attended a spa appointment or which rideshare included whom.

Receipts are boring until someone questions a charge, so save them while the details are still obvious. Add a photo or file name in the Receipt column, and keep the actual receipt in a shared folder. Do not put card numbers or other sensitive payment details in the sheet.

A simple weekend rhythm works well:

  1. Before the trip, add participant names, split rules, and the three tabs.
  2. During the trip, add each charge and receipt after payment.
  3. After the last activity, check every Difference cell and review the Summary.
  4. Record reimbursements on Settlements, then mark the remaining balances as settled.

One person should own formula changes. Others can still add rows if the protected ranges are set carefully.

Common spreadsheet mistakes

Mistake Fix
A name is spelled differently in different rows Use a payer dropdown with the approved names
Someone is charged for an activity they skipped Mark only actual attendees in the Included columns
A reimbursement is counted as a new expense Record it on Settlements instead
The total allocated does not equal the charge Check the Difference column and adjust rounding
A formula gets overwritten on a phone Protect formula ranges and give most people Commenter access
A deposit or fee is forgotten Add it as its own row with a clear description
A shared link remains active after the trip Review access and remove people who no longer need it

When a spreadsheet is enough

To be honest, a spreadsheet is a good fit when the weekend has a manageable number of charges and one person can keep the file tidy.

Consider a payment or split-bill app if the group wants automated payment requests, receipt scanning, or reminders. Those are convenience features, not requirements for a simple trip record.

Keep the spreadsheet as the record even if people pay through another service. Tracking, requesting, paying, and documenting are separate jobs.

Test it before sharing

Enter a few temporary rows: one equal dinner, one activity for only some attendees, and one uneven split. Confirm that every Difference cell shows $0.00.

Then check one person's Total Paid by hand. Delete the test rows, protect the formula columns, and share the link with the group's rules attached.

Start with the dinner row. It will show whether the names, payer, attendee flags, and formulas are all working before the Austin weekend gets busy.