The cleanest way to split a bachelorette bill is to assign each receipt item to the people who used it, then divide that item's amount by its marked participants. Shared costs can still be split evenly; personal drinks, add-ons, and optional activities do not have to be.

A $45 cocktail flight marked for three people becomes $15 per person. A $32 burger marked for one person stays with that diner. Simple rule, fewer late-night arguments.

Before anyone pays, agree on shared costs, the bride's agreed share, and any nonrefundable bookings. Put that rule in the group chat.

Pick a rule for each charge

One weekend can include a rental deposit, groceries, shared dinners, cocktails, taxis, and optional spa appointments. Choose the split rule per charge, not automatically per receipt.

Charge Practical starting rule Who gets marked
Shared meal or groceries Equal split Everyone who agreed to share
Personal meal or drink Usage-based split The person or people who ordered it
Optional activity Participant split Confirmed attendees
Limo or taxi Rider split People who rode
Lodging or a deposit Commitment split People committed to the booking
Bride's meal, ticket, or activity Group-agreed split Only the people who agreed to cover it

Equal splitting is fast. It works well for a rental deposit, decorations, or a group meal where portions are similar.

Usage-based splitting takes more marking but avoids making non-drinkers cover cocktails or making one person pay for an activity they skipped. Turns out, the rule matters more than the spreadsheet.

For example, send this before the trip:

Lodging is split among the people staying, shared food is split evenly, personal drinks are assigned by item, and the bride's agreed costs are split among the people covering them.

Set up a shared receipt sheet

Google Sheets or Excel is enough. Use one row for each receipt line, rather than one row for each person.

The layout below assumes six attendees in columns F through K.

Column What to enter
A Date
B Receipt item, such as Margarita round 1
C Amount for that row
D Person who paid
E Note, such as shared appetizer
F through K One attendee per column; enter 1 or 0
L Participant count
M Per-person share

Use real attendee names in row 1. Enter the amount as a number, then format it as currency if you want the sheet to display dollar signs.

In L2, enter =SUM(F2:K2). This counts the people marked for that item.

In M2, enter =IFERROR(C2/L2,""). This divides the item amount by the participant count and leaves the cell blank if nobody has been marked. Copy both formulas down the sheet.

At the bottom, create three summary rows labeled Owed, Paid, and Net. If those labels are in E101:E103, put this formula in F101:

=SUMPRODUCT($M$2:$M$100,F$2:F$100)

That calculates the amount owed by the person named in F1. Copy it across for the other attendee columns.

In F102, enter:

=SUMIF($D$2:$D$100,F$1,$C$2:$C$100)

This adds the receipt amounts paid by that person. Copy it across.

In F103, enter =F102-F101 and copy it across. A positive net means that person should receive money. A negative net means that person should send money.

Keep receipt photos in a shared folder and give most people view access. One or two designated editors can update the sheet, which helps prevent accidental formula changes.

Allocate tax, tip, and service charges

Those extra lines cause more friction than entrees. Treat them as charges that need an allocation rule, not as a reason to reset the whole receipt to an equal split.

For a proportional approach, total each person's relevant pre-fee items. Divide that person's subtotal by the group subtotal, then multiply by the printed tax, tip, or service-charge amount. If the allocated subtotals are $40 and $80 and the fee is $12, the shares are $4 and $8.

Tax rules differ by location, and some charges may apply only to certain items. Use the amount printed on the receipt; the spreadsheet is allocating that charge, not determining whether it is legally taxable.

If the group prefers speed, add tax and tip as separate rows and mark everyone included in that charge. Write the choice in the Notes column so nobody has to reconstruct it later.

Enter each receipt while details are fresh

  1. Capture the receipt. Photograph the full receipt immediately and record who paid. Include the date and venue in the file name if possible.

  2. Break out the lines. Enter items such as 2x Burger - $32 or Cocktail flight - $45 as separate rows when the receipt gives you enough detail. If a restaurant can provide separate checks, ask before ordering. Bon Appetit offers related restaurant bill-splitting guidance.

  3. Mark participation. Put 1 under every person who used or agreed to cover the item. Put 0 under everyone else. Every row needs at least one participant.

  4. Add fees and adjustments. Enter tax, tip, service charges, discounts, and refunds as separate rows when that makes the allocation clearer.

  5. Review nightly. During a multiday trip, spend five minutes checking new rows. Ask, "Any changes to the marks?" while the meal is still easy to remember.

  6. Settle from the Net row. The payer can post each person's net amount in the group chat. Keep the sheet and receipt photos until everyone confirms the balances are settled.

Keep fixed costs out of consumption math

Not every bachelorette expense is something people consume.

Lodging and deposits: Split these among the people who committed to the reservation, even if the cost isn't tied to a specific receipt item. Agree on the commitment rule before booking.

Transportation: Mark riders for taxis or rideshares. If the whole group used a booked limo, mark the whole group instead.

The bride's costs: There is no single rule that applies to every group. Put the bride's agreed costs on their own rows and mark only the people who agreed to cover them.

Cancellations: If someone skips a nonrefundable booking, follow the rule the group accepted when the booking was made. Note any exception in the sheet rather than quietly changing old rows.

Refunds: Record a refund as a negative row using the same participants when the credit applies to the original group. If the refund goes to someone else, explain that in Notes.

One person paying the whole receipt

That person does not automatically owe the full receipt. Their Paid total records what they advanced, while their Owed total includes only their own assigned share.

For example, if Jane pays a full dinner receipt, put Jane in column D for each row. The Net row then shows how much the rest of the group should reimburse her after subtracting Jane's share.

Catch errors before the trip ends

Problem Quick fix
A row has no 1 marks Pause and ask who used or agreed to cover the item
A payer is missing Add the payer before calculating reimbursements
A formula is blank Check that the amount is numeric and at least one person is marked
A receipt was entered twice Compare the photo, date, venue, and total
Someone changes their mind about an activity Apply the commitment rule and add a note
Tax or tip looks wrong Recheck the printed charge and the allocation method

To be honest, the biggest spreadsheet mistake is usually not the formula. Someone forgets to mark a participant, or two people enter the same receipt. A short review catches both.

Test the rules before the weekend

Send the group agreement before the first reservation:

Shared dinners and groceries are even. Personal drinks and optional activities are itemized. Lodging is split among committed guests. The bride's covered costs are separate.

Then create a blank sheet, add one sample receipt, mark three names, and confirm the per-person share and Net formulas. Fix the layout before real money changes hands.