Split ski trip expenses by income only for the costs everyone genuinely shares. Work out each person's agreed income share, multiply that share by the shared total, and keep personal or usage-based charges on their own lines.
The math itself is quick. With a 60/40 ratio, a $2,000 lodging bill becomes $1,200 and $800, and you're done. Building the spreadsheet is the easy part too. The harder decision sits underneath: whether the cabin, lift tickets, groceries, and rental car actually benefit everyone the same way.
Decide which costs belong in the income split
An income ratio fits a shared cabin, a rental car the whole group uses, or a group booking where each person receives roughly the same benefit. It fits badly for an individual lesson, a private room, or equipment one person rents alone. Same benefit, shared cost. Different benefit, different method.
Define "shared" before anyone books. It's striking how much friction a small snack bought for one skier can cause when nobody agreed where it belongs, and how little a large cabin charge causes when everyone signed off in advance.
That conversation sounds fussy before the trip. It sounds a lot less fussy the day the deposit is due and everyone remembers the agreement differently.
Match the split to the expense
| Cost | Starting method | Change it when |
|---|---|---|
| Cabin or vacation rental | Income-based if people stay the same nights and use similar space | Someone stays fewer nights, takes a private room, or uses a premium room |
| Rental car, gas, and tolls | Split among riders or use the income ratio if everyone benefits similarly | Someone rides for fewer days or doesn't use the car |
| Lift tickets | Split by skier and days used | The group intentionally subsidizes a shared booking |
| Groceries and group meals | Split among diners or equally among people eating | Some people skip the meal or buy separate food |
| Gear, lessons, and activities | The person who uses the service pays | The group agrees to gift or subsidize it |
| Deposits and cancellation costs | Follow the rule agreed before booking | A refund, replacement guest, or nonrefundable charge changes the result |
Turns out, a mixed method is usually easier than forcing a single rule onto every line. Income split for the cabin, day count for lift tickets, gear stays personal.
An income ratio isn't a magic fairness score. It adjusts the contribution for earnings, and that's all it adjusts. It can't see nights stayed, room size, ski days, or what each person actually consumed.
Set the rules before money moves
Settle six things before a single deposit leaves anyone's account:
- Choose the income measure. Take-home income, annual or monthly, both work. Use one period and one definition for everybody. Mixing one person's monthly figure with another person's annual figure will quietly wreck every share.
- Collect figures privately. The organizer can receive exact amounts by private message or a form and share only the resulting percentages. Income bands are another option, though the shares come out approximate.
- List the expense categories. Mark each line income-based, equal, per-person, usage-based, or individual.
- Name the participants. A lift ticket for three skiers shouldn't include the friend who's staying at the cabin but not skiing.
- Choose a fallback. Anyone who'd rather not share income can fall back on an equal, per-person, nights-based, or fixed-contribution rule instead.
- Write the agreement down. Review it after a major booking and again before the trip starts.
A short message can head off a long argument later:
Our incomes differ, so I'd like to use agreed percentages for the cabin and shared transportation. Lift tickets will follow ski days, and personal gear stays personal. Is everyone comfortable with that?
A written note might say: Shares: Alex 40%, Jordan 30%, Sam 30%. Applies to the cabin and shared gas. Meals use diners; lessons and gear are individual.
Calculate each person's share
The core calculation is two lines:
Income share = person's agreed income / total agreed group income
Then apply it to the expense:
Amount due = expense total x income share
Say someone earns $100,000 in a group with $250,000 combined. That's a 40% share, which means $800 of a $2,000 shared expense. Two people at 43% and 57% would split a $500 rental deposit into $215 and $285. And a person who's 62% of the group's combined income covers $4,030 of a $6,500 income-based total, leaving $2,470 for the rest.
One habit matters more than the formulas: use the same denominator for every income-based expense. Round the allocations to cents at the end, and if the pieces miss the total by a penny, park the difference on one line so the shares add back up.
Build a Google Sheets tracker
Create three core tabs, People, Expenses, and Allocations, then add a Summary tab for balances and a Settlement tab for reimbursements.
On People, use Participant, Agreed income, and Income share as the main columns. Put =IFERROR(B2/SUM($B$2:$B$10),0) in C2, copy it down, and format the results as percentages. Keep the income basis consistent across every row.
Expenses is next: one row per actual charge. Useful columns are Expense ID, Date, Category, Description, Total, Paid by, Split rule, and Receipt link. Type each total exactly once.
The Allocations tab gets one row per participant included in an expense. Set up Expense ID, Person, Income share, Override share, Amount due, and Settled?.
In C2, look up the person's income share:
=IFERROR(VLOOKUP(B2,People!$A$2:$C$10,3,FALSE),0)
Leave Override share blank on an income-based line. Usage-based lines take a custom fraction instead, like 3/5 for someone using three of five shared nights, or 1/4 for one of four equal participants.
Then E2 calculates the amount due:
=IFERROR(VLOOKUP(A2,Expenses!$A$2:$E$100,5,FALSE)*IF(D2="",C2,D2),0)
Check each expense for one thing: the included shares should total 100%. A person who doesn't participate gets no allocation row at all.
The Summary tab answers the only question anyone asks at the end of a trip, which is who owes whom. If the name sits in A2, this pulls total allocated cost:
=SUMIF(Allocations!$B$2:$B$200,A2,Allocations!$E$2:$E$200)
And this pulls payments made on behalf of the group:
=SUMIF(Expenses!$F$2:$F$100,A2,Expenses!$E$2:$E$100)
Subtract the second figure from the first. Positive means the person still owes money. Negative means the group owes them, before settlements.
For a category total, use:
=QUERY(Expenses!A1:H100,"select C, sum(E) where C is not null group by C label sum(E) 'Total'",1)
Record reimbursements separately, with columns like Date, From, To, Amount, Status, and Note. Never enter a reimbursement as a new trip expense; that overstates the group total.
Protect the formula cells and limit editing to the organizer or treasurer. If exact incomes feel too sensitive for a shared file, do the income math in a separate private file and circulate only the resulting percentages or balances. A hidden tab isn't privacy; anyone with access can unhide it.
Reconcile the sheet during the trip
Update the record after each deposit, large booking, or major meal. On a longer trip, a weekly pass through it works well.
Before sending a payment request, run this check:
- Each real expense appears once.
- Every allocation row names the correct participants.
- Each expense's shares total 100%.
- The payer, receipt, and split rule are recorded.
- Reimbursements sit on the Settlement tab, not the Expenses tab.
Keep the check-in neutral so it doesn't feel personal. Something like: "I updated the cabin, gas, and Thursday dinner. Alex has paid $600, Jordan owes $140, and Sam has a $75 credit. Please check the receipts before Friday."
Once somebody has paid, don't quietly swap the method on them. If the group does agree to a new rule, write down when it takes effect and leave the settled lines alone.
Handle privacy and unequal circumstances carefully
Exact income can feel too personal for a friend group, and nobody should have to disclose a salary just to join a weekend trip. If the group balks, use approximate income bands, a fixed contribution cap, an equal split, or a usage-based method instead. A person can also pay a set amount toward the cabin while everyone handles personal and activity costs separately.
Income is a rough measure of ability to contribute at best. Debt, dependents, medical costs, savings goals, whatever else is going on in someone's life, none of it shows up in the percentage. To be honest, when a trip only has a few low-dollar shared expenses, equal or usage-based splitting is probably kinder and simpler anyway.
The rule should support the group. It shouldn't turn a weekend away into an audit.
Common questions
How do I calculate an income split for four people?
Add up the four agreed incomes. Divide each person's income by that total. Someone earning $100,000 in a group with a $250,000 total holds a 40% share.
Should lift tickets be income-based or per-person?
Per-person or per-ski-day, whenever people buy different tickets or ski different numbers of days. An income-based split makes sense only when the group deliberately wants to subsidize a shared ticket purchase.
What if someone can't or won't share their income?
Give them an equal, usage-based, nights-based, or fixed-contribution rule instead. Record that choice before booking so they aren't treated as an exception later.
What happens if someone skips a meal or activity?
Remove them from the eligible participants for that expense. In the sheet, that's an override share on the allocation row, plus whatever cancellation rule the group agreed to beforehand.
How often should we review the split?
After each major booking, at least weekly on a longer trip, and once more before final reimbursements.
Is a spreadsheet enough for a small group?
It usually is. A clear expense log, protected formulas, receipt links, and a separate settlement record are more useful than adding another tool for a trip this size.
Create the People, Expenses, Allocations, and Summary tabs before anyone books anything. Enter one sample $500 expense, confirm the allocated shares land exactly on the total, and send the one-paragraph rule to the group. Only after that should the deposit money move.