Free ski trip budget template for Excel and Sheets
Free group ski trip budget for Excel or Google Sheets: lodging, lift passes, rental and meals, 100 expense rows and a worked example for six. No signup.
On this page
For a group ski trip, plan six budget lines: lodging, lift passes, equipment rental, transport, groceries and meals, and other costs. This free template compares your plan with actual spending, across 100 expense rows.
Download the free template (.xlsx)
No signup or email required. Open the file in Excel or import it into Google Sheets to edit it together. The example uses US dollars; the file does not convert currencies or calculate what each person owes.
Get started
- Open the file in Excel or import it into Google Sheets.
- In Budget, enter the number of people and edit the blue cells.
- In Expenses, clear the five examples without deleting the rows. Then enter your group’s purchases.
Track who paid, from the first booking.
One friend pays for the stay, another for dinner. Add those expenses in Spliz to see who owes whom. Keep this file for planning; it does not sync with the app.
Free expense tracking. Friends install the app, then join your group as guests without creating an account.
Two sheets, one view of the trip
Budget holds your planned costs for the six categories. The sheet calculates spending by category, the amount remaining and an average per person. A negative remainder means spending has exceeded the plan.
Expenses records the date, category, description, person who paid, amount and notes. There are 100 input rows, from row 7 to row 106. Keep the category names unchanged so the dropdown and summary continue to match.
What should a ski trip budget include?
- Fixed costs first: the chalet or condo, then getting to the resort.
- Lift passes and equipment rental next. These vary most from one person to another: some friends own their skis, some don’t ski at all.
- Groceries and meals at the resort, with or without lunch on the mountain.
- Room in Other for lockers, ski storage, pharmacy runs or parking.
Example: a $4,800 budget for six friends
These are the fictional figures included in the file. They are not estimates of real lodging or lift pass prices: replace them with your quotes and receipts.
| Category | Planned | Spent | Remaining |
|---|---|---|---|
| Accommodation | $1,800 | $1,800 | $0 |
| Lift passes | $1,320 | $1,320 | $0 |
| Equipment rental | $540 | $486 | $54 |
| Transport | $420 | $238 | $182 |
| Groceries and meals | $600 | $312 | $288 |
| Other | $120 | $0 | $120 |
| Total | $4,800 | $4,156 | $644 |
The $644 remaining is room in the budget, not money held in a shared account. Check meals and purchases still to come before treating it as spare money.
How to use it in Google Sheets
Open a spreadsheet in Google Sheets, then choose File → Import → Upload. Select the workbook and create a new spreadsheet. Both tabs come with the file. Google documents this in its guide to importing Excel files.
Share one working copy with the group. Before entering your own figures, check that the example shows $4,800 planned, $4,156 spent and $644 remaining. Then clear the five sample expenses without deleting their rows. Agree who logs each purchase.
Record a cost once
If Sam buys the group’s lift passes online for $1,320, record $1,320 once. Money a friend sends Sam afterwards is a repayment, not another trip expense. A pass refunded by the resort goes in as a negative amount under Lift passes.
Keep the chalet’s security deposit out of the total until an actual charge is confirmed. See how to handle a withheld security deposit.
Not everyone skis: the average is not everyone’s bill
The file’s average is for planning. It ignores the friend who doesn’t ski, the one who brings their own skis and the one who arrives a day late. Keep lift passes and rental separate: only the people who use them share them. For activities part of the group joins, see splitting costs by participant; for different arrival dates, use our vacation rental split calculator. Planning ideas are in our guide to a ski trip with friends.
Keep the budget here, track who owes whom in Spliz
In the file, Léa paid for the chalet ($1,800) and ski rental ($486), Sam for the lift passes ($1,320) and groceries ($312), and Nour for gas and tolls ($238). The total is $4,156. The $692.67 average does not tell you who needs a reimbursement.
Who pays whom in this example?
Assume the group also includes Yanis, Chloé and Malo. Malo doesn’t ski and travels by train on his own ticket. He shares the chalet and groceries, but not the lift passes, the rental or the car.
- Chalet and groceries for six: $2,112 ÷ 6 = $352 each.
- Lift passes for five: $1,320 ÷ 5 = $264.
- Rental for five: $486 ÷ 5 = $97.20.
- Gas and tolls for five: $238 ÷ 5 = $47.60.
Each skier owes $760.80; Malo owes $352.
| Person | Paid | Share | To receive or repay |
|---|---|---|---|
| Léa | $2,286 | $760.80 | Receives $1,525.20 |
| Sam | $1,632 | $760.80 | Receives $871.20 |
| Nour | $238 | $760.80 | Repays $522.80 |
| Yanis | $0 | $760.80 | Repays $760.80 |
| Chloé | $0 | $760.80 | Repays $760.80 |
| Malo | $0 | $352 | Repays $352 |
Malo sends Léa $352 and Yanis sends her $760.80. Chloé sends $412.40 to Léa and $348.40 to Sam. Nour sends Sam $522.80. Léa receives $1,525.20 and Sam $871.20. With an equal split, Malo would have paid $692.67 for slopes he never skied.
- Create a trip group in Spliz and invite your friends with its link.
- Add each expense with its payer and participants: everyone for the chalet, only the skiers for the lift passes.
- Check the balances, settle up by bank transfer, cash or another app, then record the repayments in Spliz.
Spliz is free for creating groups, adding expenses, splitting shares and viewing balances. Friends install the app and join the group as guests, without creating an account. Spliz does not move money: a repayment recorded in the app does not confirm a payment. The file does not sync with the app.
What if a total looks wrong?
Check that amounts are numbers, not text, and that the number of people is a whole number between 1 and 100. The Budget tab flags invalid inputs. An amount with a missing or unknown category appears under Uncategorized and still counts toward spending. Check that you have removed the sample expenses.
This is an editable planning file, with no macros, external data connections or payments. Keep a clean copy before changing its formulas. For a trip without skiing, use our group trip budget template.
Download the ski trip budget (.xlsx)
Sources and method
- Google Sheets: import an Excel workbook, instructions for importing both tabs.
- The example table reproduces the figures in the downloadable Spliz workbook. All people, prices and the repayment example are fictional.
Friends first. Enjoy the good times.
