Bachelorette Party Cost Splitter

A bachelorette weekend runs on two kinds of money, and mixing them up is how friendships get weird. The house, the matching outfits and the boat are everyone’s. Your own train fare is yours. This splitter keeps the two apart — then turns what’s left into the shortest possible list of who pays whom.

Log the shared costs and who actually fronted each one. The sheet divides them by the attendee count YOU set: in the sample, $1,620 of shared costs across 6 attendees is $270 each. Personal costs — own travel, own extra drinks — are listed so the party grand total ($2,165) is honest, but they are never split and never owed.

Then the settle-up. In the sample, Maya fronted $1,020 (the house and the boat) and is owed $750 back. Jess owes $174, Sofia $36, Emma and Chloe $270 each — and Priya, who paid exactly her share up front, is Square, in writing. Every debt routes to the organizer who fronted the big bills: four payments settle the whole weekend, no chains of friend-to-friend transfers, and the balance check at the bottom must read $0.00.

What it does for you:
– Splits shared costs equally across YOUR attendee count — per-person share on every line
– Keeps personal costs personal: counted in the total, never in the settle-up
– Computes each person’s balance: overpaid, still owes, or square — with the amount
– Routes every debt to the organizer in one payment per person (4 payments settle the sample)
– Balance check proves the whole sheet nets to $0.00 before anyone pays anyone
– Adds a planning expense log, zero-based monthly budget, dashboard and 12-month summary

What’s inside (.xlsx, works in Excel AND Google Sheets):
– Start Here — setup steps, attendee count and party date settings
– Party Costs — 5 shared costs with paid-by and per-person shares, 6 personal costs, headline totals
– Settle-Up Summary — per-person balances and statuses, who-pays-whom list, $0.00 balance check
– Expense Log, Monthly Budget, Dashboard, Monthly Summary

Instant download. Type only in the yellow cells — formula cells are locked (password: sheetdaily, disclosed on the Start Here tab so you can unlock if you ever need to). Sample party is pre-filled so you can see exactly how it works; clear the yellow cells and type your own. Planning tool only — and not a ruling on who should pay for a bachelorette; that conversation belongs to the group, before anything is booked.