Party expense calculator
Parties have one awkward rule that spreadsheets handle badly: someone is not supposed to pay. Per-expense participants make it simple.
Short answer
Add every cost — venue, food, drink, decorations — and divide by the paying guests, excluding the guest of honour and anyone who contributed a matching amount in kind, such as bringing their own equivalent of drinks.
People
Expenses
Balances
- Alex$375.00
- Sarah$15.00
- Mike$165.00
- Emma$195.00
+ gets money back · − owes money
💸 Settle up
Only 3 payments needed.
- EmmaAlex$195.00
- MikeAlex$165.00
- SarahAlex$15.00
Who paid what
- Alex$600.00
- Sarah$180.00
- Mike$60.00
Saved on this device. No account needed.
How it works
- 1Add everyone, including the person being celebrated.
- 2Log each cost with whoever paid it.
- 3Untick the guest of honour on the expenses the group is covering for them.
- 4Settle after the event and share the list.
Party costs are rarely split evenly by headcount, because the birthday person, the groom or bride, or a guest who baked the cake instead of chipping in cash usually sits outside the normal split. The calculator handles this by letting you exclude specific people from specific expenses rather than forcing one flat per-head number.
In-kind contributions — someone bringing a case of beer instead of paying into the kitty — are easiest to treat as if that person 'paid' the cash value of what they brought, so it nets against their share automatically.
For bigger events like a hen do or festival weekend, separate big shared costs (venue, minibus) from optional extras (spa treatments, extra drinks) so people who skip the extras aren't charged for them.
Worked examples with real numbers
Birthday meal, guest of honour excluded
Six friends go for a birthday dinner for Nadia, the guest of honour, who pays nothing. The bill is 210 for food and 30 for drinks, split among the five paying guests. Marco pays the full bill upfront on his card.
| The bill | Amount |
|---|---|
| Food | 210.00 |
| Drinks | 30.00 |
| Total | 240.00 |
| Person | Paid | Fair share | Balance |
|---|---|---|---|
| Marco | 240.00 | 48.00 | +192.00 |
| Priya | 0.00 | 48.00 | −48.00 |
| Sam | 0.00 | 48.00 | −48.00 |
| Elle | 0.00 | 48.00 | −48.00 |
| Toby | 0.00 | 48.00 | −48.00 |
| Nadia | 0.00 | 0.00 | +0.00 |
- PriyaMarco48.00
- SamMarco48.00
- ElleMarco48.00
- TobyMarco48.00
240 total split across five paying guests is 48 each — Nadia has a share of zero and owes nothing, but still appears in the group so the total headcount is clear.
House party with an in-kind contribution
Eight people split a house party: venue decorations and snacks cost 140, plus 20 of ice and mixers, for a total of 160 split eight ways at 20 each. Jordan skips the cash contribution but brings the ice and mixers himself, which counts as his 20 share paid in kind.
| Costs and in-kind contributions | Amount |
|---|---|
| Decorations and snacksPaid by Aisha | 140.00 |
| Ice and mixersBrought by Jordan | 20.00 |
| Total | 160.00 |
| Person | Paid | Fair share | Balance |
|---|---|---|---|
| Aisha | 140.00 | 20.00 | +120.00 |
| Jordan | 20.00 | 20.00 | +0.00 |
| Ben | 0.00 | 20.00 | −20.00 |
| Cara | 0.00 | 20.00 | −20.00 |
| Dev | 0.00 | 20.00 | −20.00 |
| Elle | 0.00 | 20.00 | −20.00 |
| Fay | 0.00 | 20.00 | −20.00 |
| Gus | 0.00 | 20.00 | −20.00 |
- BenAisha20.00
- CaraAisha20.00
- DevAisha20.00
- ElleAisha20.00
- FayAisha20.00
- GusAisha20.00
Jordan's ice and mixers count as a 20 payment, matching his 20 share exactly, so he settles to zero and doesn't owe Aisha anything.
Per-guest cost with exclusions
1. Total party spend
sum of all costs (venue, food, drink, decorations)
2. Paying guest count
total guests minus anyone excluded (guest of honour, kids, no-shows)
3. Per-guest cost
total party spend ÷ paying guest count
4. In-kind credit
treat the value of items someone brought as an amount they 'paid'
5. Balance
(cash paid + in-kind value) − per-guest cost
Mistakes that cause arguments
Charging the guest of honour
Set their share to zero on every relevant expense rather than giving them a discount — a partial charge usually causes more awkwardness than none at all.
Valuing in-kind contributions vaguely
Agree a specific number for what someone brought (receipt if possible) before adding it as a payment, so it isn't disputed after the fact.
One flat split for optional extras
If some guests skip the taxi or the extra round, give that specific expense only to the people who used it instead of dividing it across everyone.
Practical tips
- Decide upfront who's excluded (guest of honour, plus-ones under a certain age) so nobody's surprised by their own share.
- Log in-kind contributions the moment they're agreed, with a value, rather than trying to reconstruct it later.
- Keep venue and food as one 'core' split and treat drinks or extras as separate line items for guests who opted in.
- Have one person collect and pay big supplier invoices (venue, catering) so the settlement only needs to flow toward them.
Questions
- How do we cover the guest of honour's share?
- Simply leave them off the participant list for those expenses; the cost redistributes across everyone else automatically.
- What about people who only came for part of it?
- Include them on the expenses that happened while they were there.
- Does it work for a stag or hen weekend?
- Yes — combine it with the trip calculator's approach for accommodation and travel.