Split event tickets with coworkers by creating a shared Google Sheet tracker with columns for ticket details, purchaser, shares owed, payments received, and status. Use equal or proportional splits based on group agreement, then request reimbursements via agreed payment apps after documenting receipts. This lightweight workflow helps U.S. coworkers in informal groups avoid disputes over concerts, sports events, or team outings.

Start with a group chat or email to confirm attendance and split method. The purchaser buys tickets and logs them immediately. Everyone reviews the sheet weekly, marks payments, and closes out post-event with a PDF export. For one-off events, a simple sheet often suffices without complex tools.

Agree on Split Rules Before Buying Tickets

Decide split rules upfront to prevent disagreements. Common options include equal split, where total cost divides by attendees; usage-based, like higher shares for VIP seats; or income-based, adjusting for salary differences.

For example, with 4 tickets at $100 each, an equal split means $100 per person. If one coworker wants a premium $150 ticket, usage-based could charge them the full upgrade cost plus an equal base share.

Sample agreement script: "We'll split equally unless someone opts for premium seats, in which case they cover the difference. Confirm your attendance and ticket type by Friday."

Document the agreement in an email thread or the first row of your tracker sheet. This creates a clear record. Tradeoffs: Equal splits are simplest but may feel unfair if incomes vary; usage-based matches costs to choices but adds math; income-based requires salary sharing, which not all coworkers want.

Set Up a Shared Ticket Tracker

Use a shared Google Sheet for tracking. Set it up with these recommended columns:

  • Event/Date
  • Ticket Type/Price
  • Purchaser
  • Attendees (list names)
  • Share per Person (formula: total price / count of attendees)
  • Amount Owed (per person)
  • Paid? (Yes/No dropdown)
  • Receipt Link
  • Notes/Status

Sharing notes: Give edit access to the purchaser or a designated treasurer; view-only for others. Enable version history under File > Version history to track changes.

Adapt formulas from the RelayFi Google Sheets expense tracker template:

  • Total owed by purchaser: =SUMIFS(F2:F100, C2:C100, "Your Name") (sums amounts where purchaser matches).
  • Unpaid rows: =FILTER(A2:H100, G2:G100="No") (shows only unpaid items).
  • Category summary: =QUERY(A2:H100, "SELECT B, SUM(E) GROUP BY B LABEL SUM(E) 'Total'") (totals by ticket type).

Common mistakes: Skipping permissions review, which risks accidental deletes; not using dropdowns for Paid? column, leading to typos; forgetting mobile-friendly formatting for quick checks.

For events with multiple purchases, add a summary tab with these formulas pulling data automatically.

Document Purchases and Receipts

Assign clear roles: The purchaser handles logging; the group reviews.

Stepwise workflow:

  1. Purchaser buys tickets and takes a photo or screenshot of the receipt/confirmation email within 24 hours.
  2. Upload the receipt to a shared folder (like Google Drive) and paste the link in the sheet.
  3. Enter row details: event info, price, attendees, calculated shares.
  4. Use conditional formatting for warnings, like =AND(E2>=D2*0.8, E2<=D2) from the RelayFi template to highlight shares hitting 80-100% of expected budget (adapt D2/E2 to your share columns; yellow fill).

Update cadence: Log purchases same day; group reviews every few days via shared link. This keeps records accurate and builds trust.

If multiple purchasers, use a shared folder named "Team Event Receipts - [Event Name]" with subfolders by purchaser.

Run Reimbursements and Track Payments

Once logged, calculate totals and request payments.

Stepwise workflow:

  1. Purchaser or treasurer shares the sheet link and highlights totals, e.g., "Sheet shows you owe $45 for your share."
  2. Send requests with this wording script: "Per our shared sheet [link], you owe $45 for 1 ticket toward the [event] on [date]. Can you send via Venmo to @group or Zelle to [number]? Reply here to confirm."
  3. Recipient pays and replies "Sent"; treasurer marks Paid? as "Yes" and adds payment date/method in Notes.
  4. Filter for balances: Use =FILTER formula above to list outstanding owes.
  5. Weekly check-ins: Treasurer pings the group chat with unpaid summary.

Incorporate components from Smartsheet's registration tracking template, like logging attendees and payments in one view, adapted to your sheet.

Review and Close Out the Event

Post-event, hold a quick review: Confirm all payments, archive receipts, and export the sheet as PDF via File > Download > PDF for records.

Cadence: Full review 1 week after event; treasurer emails the PDF to all.

Tradeoffs: Spreadsheets work well for one-off events like a single concert; for recurring team outings, consider templates with auto-summaries. Simple methods suffice when group size is small and trust is high.

Limitations: These workflows draw from general expense templates, not coworker-specific policies. Adapt for your group's dynamics. For disputes, consult HR or a professional; this is U.S.-focused informal guidance only.

FAQ

How do I calculate shares if not everyone attends?
Prorate based on confirmed attendees. Update the Attendees column and recalculate shares with =total price / COUNTA(attendees range). Notify no-shows they still owe if agreed upfront.

What's the simplest column setup for a 5-person ticket split?
Event, Total Cost, Attendees (5 names), Share (=Total/5), Owed By (name), Paid? (Yes/No). Add one formula row: =SUMIFS(Share column, Owed By column, "Name").

Should we use conditional formatting for unpaid balances?
Yes, for visibility. Use =G2="No" (G=Paid? column) with red fill, adapted from RelayFi templates.

How to handle cancellations or refunds?
Log as negative row: e.g., Ticket Type "Refund", Price "-$20", recalculate shares. Update all owed amounts.

Is a Google Sheet secure enough for coworker reimbursements?
For informal groups, yes with view-only links and no sensitive data like full account numbers. Use passwords if needed; enable 2FA on accounts.

When to switch from sheets to other tools?
If events recur monthly or group exceeds 10 people, consider templates like Smartsheet's event registration for built-in attendee logging.