Ever tried sorting out a three-thousand-dollar pool cabana tab at two in the morning?
It's an absolute headache. Vegas bachelor parties run through cash relentlessly. You have hotel suites, dinners, club entries, and an endless stream of rideshares over four days. By Sunday, everyone's memory gets fuzzy. If you stall until the airport boarding gate to calculate totals, you are looking at weeks of awkward payment reminders.
A shared Google Sheet or Microsoft Excel file solves this. Put the numbers where everyone can check them. That way, nobody wonders who covered what.
Setting Up the Layout
Build your grid before anyone pays a flight or hotel deposit. Setting columns early makes quick typing from a phone painless later.
| Column | Header | What Goes Here |
|---|---|---|
| A | Date | Day the transaction took place |
| B | Description | Specific label like "Omnia Table" or "Airport Uber" |
| C | Category | Lodging, Food, Drinks, Transport, or Activity |
| D | Payer | Name of the person who put down their card |
| E | Total Amount | Final cost on the receipt |
| F to M | Name Checkboxes | One column per attendee to mark their share |
| N | Notes | Details on excluded items or split exceptions |
Thing is, Vegas hotel folios get messy fast. Front desks routinely authorize incidental holds between $100 and $150 per night on the primary card. Tell whoever booked the room to enter only real room rates and daily resort fees in column E. Authorization holds fall off after checkout. If someone records a pending hold, the entire group ledger breaks.
Automated Splitting Formulas
Do not do mental math while nursing a hangover. Spreadsheets handle the splits without friction.
To divide an individual charge strictly among the people who joined in, count the active checkboxes across the row. If your total expense sits in cell E2 and participant checkboxes span F2 through M2, paste this formula:
=IFERROR(E2/SUM(F2:M2),"")
In Google Sheets, a checked box evaluates as 1, while an unchecked box acts as 0. The formula calculates the cost per participant based purely on checked names. If no boxes are picked yet, the IFERROR function keeps the cell blank instead of throwing a divide-by-zero warning.
To track what one person fronted across the whole weekend, drop a SUMIF formula onto a summary tab:
=SUMIF($D$2:$D$50, "Dave", $E$2:$E$50)
This formula scans column D for Dave's name and adds up his payments from column E. You instantly know if Dave is carrying thousands of dollars while other people coast.
For an organized category summary without pivot tables, use the Google Sheets QUERY function:
=QUERY(A2:E50, "SELECT C, SUM(E) GROUP BY C LABEL SUM(E) 'Total'")
It groups every charge by category from column C and totals the dollars from column E. Clean, simple, and automated.
Capturing Receipts on the Fly
Paper receipts rarely survive a casino floor. Someone puts a steakhouse tab in their pocket, orders drinks at a lounge, and by morning the slip is sitting at the bottom of a trash can.
Turns out, the mobile Excel app can save you here. Open the Microsoft 365 app, tap Actions, and select Image to Table. Your phone camera scans the physical paper bill, parses the numbers into grid data, and drops them straight into the workbook. The details on how this scanner handles printed sheets are laid out by Microsoft Support. Photograph big restaurant bills right at dinner before the server walks off.
Protecting Formulas From Accidental Edits
Giving ten tired guys open editing rights to a shared spreadsheet is risky. Someone trying to type a taco tab on a small phone screen will eventually delete an entire summary column by accident, usually because they tapped the wrong cell while walking.
Lock your key cells early. In Google Sheets, highlight your formulas and summaries, right-click, and select Protect range. Restrict editing permissions so only you can alter calculations, while everyone else can still enter rows and tick checkboxes. You can review the exact setup steps in the official Google Sheets documentation.
Rules for Uneven Bills and the Groom Share
Vegas trips rarely split evenly across every ticket. Agree on clear boundaries before getting on the plane so no one argues over the sheet on the flight back:
- Groom expenses: leave the groom's checkbox empty for shared gifts like dinners or club passes. The formula automatically spreads his portion across everyone else.
- Different stay lengths: when an attendee flies in Saturday instead of Thursday, do not mark their box for earlier hotel nights.
- Alcohol splits: bottle service and cabana minimums climb fast. To be honest, asking a non-drinker to cover an expensive vodka setup is unreasonable. Log drink tabs on dedicated rows and leave sober friends unchecked.
Settling Up Balances
Settle balances right away. Once everyone unpacks back home, run through this closing routine:
- Audit the master list: match large charges against receipt photos stored in your shared folder.
- Check the folio: verify that the resort dropped incidental holds before you lock down lodging totals.
- Calculate net balances: take each person's total upfront spending and subtract what they owe. Positive numbers receive cash; negative numbers pay into the pool.
- Set a payment deadline: give everyone three days after landing to clear balances through their preferred peer-to-peer payment app.
Send a final screenshot of the balanced tab to the group chat, confirm incoming transfers, and archive the sheet.