Use a Google Sheets template with columns for date, expense description, total amount, payer name, participant flags (1 or 0 per person), split type, individual shares, and running balances per person. Share the link with edit permissions for real-time updates among 8-15 groomsmen. This tracks Phoenix bachelor party costs such as flights to PHX airport, Airbnb deposits, rental car gas, bar tabs, steak dinners, and golf outings without needing payment apps.

For a group of 10-12 attendees, log expenses row by row, calculate shares automatically, and settle balances post-trip. Google Sheets supports real-time collaboration. Protect formula ranges to avoid errors.

Recommended Columns for Phoenix Bachelor Party Tracking

Core columns capture every expense clearly for group review. Start with these in row 1:

  • Date: When the expense occurred (e.g., MM/DD/YYYY format for sorting).
  • Expense Description: Details like "Uber from PHX airport" or "Group steakhouse bill at Durant's". Add receipt photo links here.
  • Total Amount: Full cost in USD (e.g., $450).
  • Payer Name: Who paid (e.g., "John Doe").
  • Participant Flags: One column per attendee (e.g., columns G-N for 8 people). Enter 1 if they participated, 0 if not. This enables usage-based splits.
  • Split Type: "Equal", "Unequal", or "Reimbursement".
  • Individual Share: Formula-calculated per person (example below).
  • Running Balance: Each person's net owed or credit, updated automatically.

Additional summary tabs: One for per-person totals, another for category summaries (e.g., travel, food, activities).

Participant flags handle uneven splits, such as non-drinkers skipping bar tabs.

Setup Steps to Build and Share the Spreadsheet

  1. Go to Google Sheets and create a new blank sheet. Name it "Phoenix Bachelor 2026 Expenses".

  2. Enter headers in row 1 as listed above. Add 10-15 participant flag columns for your group size.

  3. Input sample data: Row 2 - Date: 06/01/2026, Description: "Flights to PHX", Amount: $1200, Payer: "Mike", flags: 1 for all 10 participants, Split Type: "Equal".

  4. Add formulas (detailed next section).

  5. Protect key ranges: Select formula columns, right-click > Protect range. Allow only yourself or trusted planners to edit.

  6. Share: Click Share > Add emails or generate link. Set to "Editor" for active users (real-time edits visible instantly), "Viewer" for others who just check balances.

  7. Test: Have two people edit simultaneously to confirm live updates.

Set update cadence: Daily during the trip, weekly pre/post-event.

Formulas for Splitting and Summarizing Expenses

Use these examples, tested in recent Sheets versions. Copy-paste and adjust ranges. Treat as optional starting points and verify with your data.

For Individual Share (column P, assuming amount in C2, flags D2:K2): =IFERROR(C2/SUM(D2:K2),""). Divides total by participating count (sum of 1s). Adapted from KeyCuts blog.

For Per-Person Total Paid (summary tab, column C for "John", matching payers in main sheet column D): =SUMIF('Sheet1'!D:D,C$1,'Sheet1'!C:C). Sums amounts paid by each name. Adapted from KeyCuts.

For Per-Person Total Owed (next to paid): Use SUMIF on individual shares matching participant.

Category Summary (new tab, A1:D100 data): =QUERY(Sheet1!A:D,"SELECT C, SUM(D) GROUP BY C LABEL SUM(D) 'Total'"). Groups and totals by description keywords like "Travel". From Relay Financial blog.

High Expenses Filter (separate tab): =FILTER(Sheet1!A:D,Sheet1!C:C>100). Lists rows over $100 for review. From Relay Financial blog.

Running Balance per person (summary, e.g., for John): = [Total Paid] - [Total Owed]. Positive means they are owed money.

Logging Expenses and Handling Reimbursements

Follow this workflow for accuracy:

  1. Log Immediately: After each purchase (e.g., rental car gas), add a row. Snap receipt photo, upload to Google Drive, link in Description.

  2. Mark Splits: Equal - all 1s in flags. Unequal - adjust flags or add % in extra column. For non-participants, flag 0.

  3. Reimbursements: New row, Split Type: "Reimbursement", payer gets 100% flag, recipient 0% others. Per Expense Sorted blog workflow.

  4. Update Balances: Formulas refresh automatically. Review weekly or nightly via group chat link.

  5. Pre-Trip: Plan deposits (e.g., Airbnb). Post-Trip: Final sweep for loose ends like forgotten tips.

For Phoenix specifics: Note AZ sales tax in amounts; link vendor receipts for disputes.

Sharing Permissions and Common Mistakes

Google Sheets offers tiered access:

  • Editors: Full changes, real-time sync.
  • Viewers: Read-only, no edits.
  • Protected Ranges: Edit sheet but lock formulas/summaries.

Common mistakes:

  • Unprotected sheets: Accidental overwrites (fix: Protect ranges).
  • No currency consistency: PHX vendors charge USD; avoid multi-currency without conversion.
  • Forgetting backups: Download as Excel weekly (File > Download).
  • Over-editing: Too many editors cause chaos; limit to 2-3.

Spreadsheets work well for groups under $2,000 total, short trips. For payment requests, export balances and use apps separately.

FAQ

How do I handle uneven splits for non-drinkers at Phoenix bars?
Use participant flags: 1 for drinkers, 0 for others. Formula divides only among 1s.

What's the best way to share the sheet with out-of-town groomsmen?
Generate a shareable link set to "Editor" for planners, "Viewer" for check-ins. Real-time updates work on mobile.

Can I protect just the balance formulas from accidental changes?
Yes, select formula range > Protect range. Editors change data but not formulas.

How often should we review balances during a 3-day bachelor weekend?
Nightly group huddle or chat: Check summary tab for surprises.

When should we switch from spreadsheet to a split-bill app?
If over 15 people, needing auto-payments, or long-term tracking. Sheets suffice for one-off events.

Do I need to keep receipts for shared party expenses?
Yes, for disputes and records. Link photos in-sheet; store originals.

Next, build the sheet with samples, share the link pre-trip, and assign a balance checker. Export final PDF for records.