Fronting three thousand dollars for an Airbnb in Lincoln Park and a six-hour sprinter van makes whoever holds the credit card nervous. Will everyone pay you back promptly without three weeks of uncomfortable text reminders? Most bachelor party budget blowups happen because groups do not agree on ground rules before booking. Chicago trips make this tricky with fixed van blocks, hefty restaurant tabs, boat charters on Lake Michigan, and late-night bar tabs. A shared Google Sheet gives everyone full visibility. Nobody feels shortchanged.
Agree on the Ground Rules Before Swiping a Card
First, decide how to handle the groom. The common tradition is that the rest of the crew covers his share of lodging, group dinners, and major activities. According to RipTrip's bachelor party cost advice, absorbing the groom's portion usually adds between $30 and $65 per person across a typical group. Be transparent about this upfront. Tell everyone the exact amount: "We are splitting the groom's van, boat ticket, and Airbnb share among the seven of us, which adds $55 each; he pays for his own flights and personal drinks." Clear math cuts out awkward side chatter.
Next, collect a deposit before reserving anything non-refundable. Ask every attendee for a 33% to 50% deposit before signing a rental lease or putting down a transport deposit, as suggested in Spark's guide on splitting costs without resentment. If someone cancels later, their deposit covers their share of fixed housing. The rest of the group will not scramble to cover the difference.
Thing is, not every expense belongs in an equal split. Fixed costs like an eight-hour van rental or a river cruise ticket work best when divided evenly across confirmed attendees. Meals and nightlife work differently. TakeControl's cost-splitting advice suggests creating a two-track plan: a core itinerary everyone shares, and optional outings billed only to those who join. When someone orders a $22 burger while another orders a $65 ribeye and three cocktails, splitting the dinner bill down the middle breeds resentment. Do not stick opt-out guests with huge restaurant checks.
Some groups look at income-based splits. You can review this concept in Beyond Money's analysis of household expense strategies or test it with Goodshare's calculator. While proportional splitting helps when incomes vary widely, it forces friends to reveal private salaries. That rarely works for a weekend trip among casual friends. Stick to equal splits for shared group items and individual payment for personal drinks.
Build the Google Sheet Expense Tracker
Keep the tracking sheet lightweight. You do not need twenty tabs or complicated macros. Set up one clean log tab and a simple summary tab.
When you book a rental van or reserve a table for ten people at a steakhouse, someone always offers to toss down a card, but then the bill arrives with tax and automatic 20% gratuity and suddenly that quick estimate everyone talked about in the group chat jumps by a couple hundred dollars. Logging each transaction immediately prevents that sticker shock.
| Column | Header | Purpose | Example |
|---|---|---|---|
| A | Date | When the payment happened | 2026-06-12 |
| B | Item | Description of the cost | Sprinter van 6-hour block |
| C | Category | Lodging, Transport, Food, Activities | Transport |
| D | Amount | Total paid including tax and tip | $650.00 |
| E | Paid By | Name of the person who paid | Mike |
| F | Split Type | All (equal), Subgroup, or Individual | All |
| G | Receipt Link | Link to photo in shared Drive | [Drive link] |
Use simple spreadsheet formulas to handle the math:
- To total what one person spent upfront, use
=SUMIF(E2:E50, "Mike", D2:D50). - To see total spending for any category, use
=SUMIFS(D2:D50, C2:C50, "Transport"), based on the structure in Relay's Google Sheets expense tracker. - To determine final balances, subtract what each person owes from the cash they already spent.
Lock your formulas before sharing the spreadsheet. Go to Data > Protect sheets and ranges to lock formula rows, as explained in Sheets Bootcamp's guide on protecting ranges. That prevents a tired friend from accidentally typing over your math. In the Share dialog, click the gear icon and uncheck the box allowing editors to change permissions, per the Sheets Bootcamp sharing guide. You stay in control of the file.
Chicago Weekend Expense Workflow
A weekend in Chicago presents specific line items. You have airport transit, neighborhood bar runs, and Cubs tickets. Transport needs careful planning. Editorial guides like Max's Luxury Rides ideas highlight booking sprinter vans in six to eight hour blocks for bar-hopping across neighborhoods like West Loop, River North, and Wrigleyville. Vans eliminate messy rideshare surges for ten people. Whoever books the van needs fast reimbursement.
Turns out, BYOB options in Chicago save massive amounts of money. Many neighborhood restaurants and private party boats allow outside drinks. Buy beer, seltzers, and ice in bulk on Friday afternoon. Put that grocery receipt on the sheet as a shared group expense.
Follow this schedule to keep payments clean:
- Collect housing deposits four to six weeks before the trip.
- Designate one primary card for big reservations so bookings stay organized.
- Snap receipt photos at the table and drop them straight into a shared Google Drive folder.
- Review the spreadsheet on Sunday morning before everyone heads to O'Hare or Midway.
- Settle all net balances within 72 hours of returning home.
How to Settle Balances Without Chasing People
Nobody wants to become the trip's accidental debt collector. When you calculate who owes what, focus on net transfers. If Dave paid $400 for groceries and his share of the weekend was $260, the group owes him $140. He should not pay anyone else. Do not make eight people send twenty micro-transfers back and forth. Instead, compute net balances so only two or three payments settle the entire weekend.
Settle within three days of getting home. Memory fades fast. After a week, someone forgets they agreed to split the boat charter. Settle while the weekend is fresh, backed by receipt photos.
Watch out for payment app classifications. If friends reimburse you through digital payment apps, confirm they mark the transfer as personal rather than commercial. Commercial tags can trigger confusing tax forms for simple reimbursements. Download a PDF copy of your finalized Google Sheet for your personal records.
Put Your Sheet Together
Put your sheet together before booking begins. Create a new Google Sheet today, plug in the column headers, and test the formulas with a sample row. Send the view link to the group chat so everyone knows the financial expectations well before landing in Chicago.