Travel
Group Trip Budget Template: Plan Before, Track During, Settle After
A group trip budget template needs one row per cost and a few columns: shared or personal, how many people share it, what must be paid before the trip and by whom, and the amount per person. Plan with it in a spreadsheet. During the trip, log what people actually paid, and settle up once at the end. Below: the template filled in for five friends on a long summer weekend in Maine, how each line was estimated, and what happened when the trip stopped following the plan.
Five friends, one question
February, and the group chat is already planning July. Maya has found a house near Acadia National Park for a long weekend at the end of the month: Friday to Monday, three nights, five friends driving up from Boston. Owen has the car. Priya offers to do the shopping. Ben wants a whale watch, and Owen and Priya both get seasick.
Then Lucy asks the only question anyone cares about before booking: “So how much is this per person?”
The template
| Line | Type | People | Estimate | Prepaid | Paid by | Per person |
|---|---|---|---|---|---|---|
| House, 3 nights, all fees | Shared | 5 | 1,680 | 1,680 | Maya | 336 |
| Gas, 600 miles | Shared | 5 | 85 | 0 | Owen | 17 |
| Park vehicle pass | Shared | 5 | 35 | 0 | Owen | 7 |
| Groceries | Shared | 5 | 200 | 0 | Priya | 40 |
| Lobster dinner | Shared | 5 | 300 | 0 | Anyone | 60 |
| Buffer, 10% of shared | Shared | 5 | 230 | 0 | 46 | |
| Whale watch | Optional | 3 | 252 | 252 | Ben | 84 |
| Lunches and coffee | Personal | 1 | 75 | 0 | Each | 75 |
| Total, no whale watch | 581 | |||||
| Total, with whale watch | 665 |
Shared lines are split between everyone, optional ones only between the people who sign up. Personal lines tell each person what to set aside and never enter the split. Prepaid shows who carries the group’s money before the trip.
To reuse it, copy the table from “Line” down to the last total and paste it into cell A1 of an empty sheet in Google Sheets or Excel. Both usually keep the rows and columns of a table copied from a web page. Then swap the typed per-person numbers for formulas:
=D2/C2, copied down to G9. Buffer, D7: =0.1*SUM(D2:D6). Total without the whale watch, G10: =SUM(G2:G7)+G9. Total with it, G11: =G10+G8.How each line was estimated
The house. Budget the checkout total with fees and taxes, never the nightly price from the search page. Our $1,680, or $560 a night, is a round number we picked so the math divides cleanly. For scale, AirDNA put the average U.S. short-term rental at $317.55 a night in July 2026, as reported by Magicdoor.
Deposits and prepaid lines. One person books, because Airbnb won’t split one stay across several cards. Some listings offer Pay Part Now, Part Later: part is charged at booking, the rest automatically before check-in on a date shown at checkout. Agree in the chat when the others pay the booker back. Maya was fine waiting until after the trip. If your group pools money before leaving, read the shared trip fund guide first.
Gas. Miles divided by mpg, times the price per gallon. Enterprise puts Boston to Bar Harbor at about 295 miles, so call the round trip 600. Owen’s car does 30 mpg: 20 gallons. At $4.145, the EIA’s New England average for the week of November 2, 2026, that is $82.90, and $85 went into the plan. The road trip gas guide has a ready table.
The park. Acadia’s vehicle pass is $35 for seven days and covers everyone in the car. Small fees hide around it. In 2026 the drive up Cadillac Summit Road needed a $6 vehicle reservation from May 20 to October 25, and visitors living outside the U.S. paid $100 more each from age 16.
Groceries. The USDA’s moderate-cost food plan for September 2026 is $77.60 a week for a woman aged 19 to 50 and $91.90 for a man, with every meal cooked at home. That is roughly $11 to $13 a day. Five people, three days, $13 a day: $195. We wrote $200.
Activities and meals out. Use the operator’s own per-person price and count only the people who say yes. Bar Harbor Whale Watch Co. listed $84 per adult in November 2026, so three tickets make $252. The $60 lobster dinner and $25 a day for lunches are our guesses; mark guesses as guesses in your sheet too.
The buffer. 10% of the shared lines: $230, or $46 each. Something unplanned always turns up, from a parking meter to a rainy-day movie.
Where the spreadsheet breaks
The sheet is good at planning. Once the trip starts, it breaks in the same five places.
Late arrivals and early leavers. The per-person column assumes everyone stays the whole time. In July, Lucy’s shift moved and she drove up alone on Saturday morning. Now the house splits by nights, she is out of the gas, and two formulas in column G are wrong. Fixing that means a column per person.
People who skip things. The whale watch was planned as optional. The kayak tour somebody books on Saturday night was not.
One person paying for many. The plan says Maya books the house. It doesn’t show her card carrying $1,680 from February to July, or Ben’s carrying three whale-watch tickets. Who owes whom has no column.
Currencies. A trip across a border needs a rate column and someone to pick the rate. Agree on one rate before you go. SplitFast keeps one default currency per group, so log every amount converted at that rate.
Keeping it up to date. Nobody opens a shared spreadsheet at a gas station at six in the morning. Receipts go into pockets, and on Monday night someone rebuilds the weekend from three banking apps.
Track during the trip, in the group chat
The trip already has a Telegram group, and SplitFast lets you split expenses in Telegram right inside it. Add @SplitFastBot and members are recognized automatically: no registration, no separate app. Anyone who isn’t on Telegram can be added by name. The setup guide walks through the first expense.
Whoever pays logs it in the Mini App that day: the amount, who paid, who shares it. Here is the weekend as it was logged.
| Expense | Amount | Paid by | Split |
|---|---|---|---|
| House | 1,680.00 | Maya | Portions: nights, 3 each and Lucy 2 |
| Gas, two fill-ups | 91.20 | Owen | Equally, the four in his car |
| Park vehicle pass | 35.00 | Owen | Equally, all five |
| Groceries | 214.50 | Priya | Equally, all five |
| Lobster dinner | 327.50 | Lucy | Equally, all five |
| Whale watch, 3 tickets | 252.00 | Ben | Portions: Maya, Ben, Lucy 1; Owen, Priya 0 |
These trip amounts are illustrative. On the house, 14 person-nights make one night $120: Lucy pays $240, everyone else $360. On the whale watch, Owen and Priya get 0. More cases are in the guide to splitting a bill unequally, and the holiday house guide covers rooms, couples and kids.
Settle after: the plan against what happened
| Plan | Paid | Share | Balance | |
|---|---|---|---|---|
| Maya | 590.00 | 1,680.00 | 582.20 | +1,097.80 |
| Owen | 506.00 | 126.20 | 498.20 | −372.00 |
| Priya | 506.00 | 214.50 | 498.20 | −283.70 |
| Ben | 590.00 | 252.00 | 582.20 | −330.20 |
| Lucy | 590.00 | 327.50 | 439.40 | −111.90 |
Plan is each person’s shared and optional lines from the template, buffer included. The weekend cost $2,600.20 and everyone came in under plan, the four who stayed all weekend only because of the buffer. Owen and Priya planned $460 before it and ended at $498.20: Lucy’s missing night added $24 to each full-stay house share, the gas went four ways, and groceries and dinner ran a few dollars over.
Four transfers close the trip, all to Maya, who fronted the house: Owen sends $372.00, Ben $330.20, Priya $283.70 and Lucy $111.90. The app reduces the debts to the fewest transfers, and each one is marked as paid once the money arrives. The guide to settling group debts explains how.

SplitFast has no budgets, categories or bank connection. It records what was actually paid and who owes whom, so the plan stays in your sheet. After the trip, put the app’s totals next to it, as above, and next summer’s estimates get better.
Sources
- Acadia entrance fees and the non-resident fee: National Park Service, Acadia fees and passes
- Cadillac Summit Road vehicle reservations, 2026 season: Recreation.gov
- New England regular gasoline, week of November 2, 2026: EIA, Gasoline and Diesel Fuel Update, released November 3, 2026
- Boston to Bar Harbor distance: Enterprise, Boston to Maine road trip
- Grocery costs: USDA Food Plans, Cost of Food at Home, September 2026 (PDF, issued October 2026)
- Whale watch fare: Bar Harbor Whale Watch Co.
- U.S. short-term rental average daily rate, July 2026 (AirDNA data): Magicdoor, updated October 12, 2026
- Paying for a stay in parts, and one payment method per stay: Airbnb Help Center, splitting the cost across payments; Airbnb Help Center, multiple payment methods
All links checked November 5, 2026. Fees and fares change every season; check them the week you book.
Frequently asked questions
How do I make a group trip budget in Google Sheets?
Use seven columns: line, type (shared, optional or personal), people, estimate, prepaid, paid by and per person. The per-person cell is the estimate divided by the number of people, for example =D2/C2. Add a buffer row worth 10% of the shared lines and share the sheet in the group chat before anyone books.
How much buffer should a group trip budget have?
We use 10% of the shared lines. In our example it came to $46 a person, and it covered the $38.20 that each full-stay traveler went over once a friend arrived a night late and the gas was split four ways. Personal spending stays out of the buffer.
Who should pay the deposit on a group rental?
One person books, because Airbnb does not let you split the total of one stay across several payment methods. Agree in the chat when the others pay that person back: straight away, or together with everything else after the trip.
What if someone arrives late or skips an activity?
Split the house by nights: in our example four people stayed three nights and one stayed two, so a night cost $120 and the late arrival paid $240 instead of $360. Anyone who skipped an activity gets 0 portions on it and pays nothing for it.
Can SplitFast replace the budget spreadsheet?
No. SplitFast has no budgets, categories or bank connection. It records what each person actually paid inside your Telegram group and works out who owes whom. Plan in the spreadsheet, track and settle in the app, then compare the two.