How to budget a team offsite without a spreadsheet

Ask a team lead what the offsite will cost and you will usually get a round number with a lot of confidence behind it. Ten thousand. Fifteen. The number is not wrong so much as unexamined, and it tends to fall apart the week the flights go on sale.

A better budget is not harder to make. It is built from four figures you already know, and it is set before anything is booked rather than reconciled after.

The four figures

• Headcount and home airports. Not just how many people, but where they fly from. Nineteen people from one city and nineteen from eleven are different trips.
• Nights. Count the nights, not the days. A Monday-to-Friday offsite is four nights for most people and five for the ones flying in from the West Coast on Sunday.
• The city's rates. A fair hotel rate and a per diem for the destination. Santa Fe in October is not Santa Fe in March, and neither is Chicago.
• The shared costs. The work room, the group dinner, the shuttle from the airport. These are the lines people forget and the ones that sink a budget.

Build it per person, then add the room

Start with one traveler. A round-trip fare from their airport, the nights times the hotel rate, the days times the per diem. Do that for each home airport, not each person, and multiply. You now have the travel half of the budget, and it is honest about the fact that the designer in Boise costs more to fly than the one in Denver.

Then add the shared costs as their own lines. Keep them separate from the per-person figure, because they do not scale with headcount the same way: a work room for twelve costs about what a work room for nineteen costs.

Finally, add a cushion, and say out loud what it is for. We suggest six to eight percent, which covers a fare that moves before everyone confirms and one extra night for someone whose connection falls apart.

Set the ceiling before the first booking

The budget only works if it exists before money moves. In Pioneer that means the ceiling goes in the first message: "nineteen people, Santa Fe, Oct 6 to 10, under $12,000." Every fare and room is then checked against what is left, not against what was planned.

A budget you set after booking is a report. A budget you set before booking is a decision.

The difference shows up the moment someone asks to stay through the weekend. With a live ceiling, you can see that two extra nights push the trip $212 over, and decide in the thread. Without one, you find out in November.

Keep the per diem out of the argument

The fastest way to make an offsite feel stingy is to argue about lunch. Give each traveler the city's per diem for each day, on the trip's card, and stop thinking about it. People spend less than you expect when the allowance is clear, and finance stops reading every coffee receipt.

Close it the week it ends

The last step is the one most teams skip: closing the budget while everyone still remembers the trip. Match every charge to its receipt, note what came in over or under and why, and write one line for next time. "Shuttle should have been two vans, not three." That line is worth more than the spreadsheet.

Next year's offsite will start from this year's real number instead of a round one, which is the whole point.