Excel / accounting ...
 

Excel / accounting guru's - who owes what?

12 Posts
11 Users
0 Reactions
93 Views
 Sui
Posts: 3092
Free Member
Topic starter
 

Picture the scene - big group holiday, lots of fun, drinking eating and paying for things (tabs/dinners) randomly depending on how drunk you are/ late to the table. Roll on a couple of months, we're now trying to figure out who owes what to who.

So most people know roughly what's been spent (the sickening site of cc bills), ranging from £1100 down to £400 - how on earth do you figure what goes to who? there's 7 people in total. I thought i could weight the difference after rounding everyone up to the highest number, but then my brain started to hurt..

im sure this should be simple, but i've gone blank, any ideas?

thanks

 
Posted : 13/09/2022 9:27 am
Posts: 10671
Full Member
 

Depends - are you just splitting the total or do you have the "I only had soup and a soft drink" type to deal with?

 
Posted : 13/09/2022 9:30 am
Posts: 108
Free Member
 

Don't bother trying to figure it out yourself, just use the Splitwise app to do it for you

 
Posted : 13/09/2022 9:37 am
Posts: 1294
Free Member
 

If you're going for an even split -

Add up total spend.
Divide by 7 to get what each person should have spent.
Get anyone who spent less to send you the difference (if they trust you).
Divide amongst the people who spent more.

If you're not doing an even split, good luck I guess.

 
Posted : 13/09/2022 9:42 am
Posts: 6851
Free Member
 

You can probably do the math(s) in Excel, but you could also use this: https://www.kittysplit.com/en/

Everyone puts in what they paid for and who benefited (E.g. if you only paid for a meal but only half the group attended, you can tell the website that. At the end it works out that if Person1 pays Person 4 £n and Person5 pays Person2 £m, everything is balanced. There are loads of apps that will do the same thing.

Makes more sense to do it at the time of paying for things so it's fresh in the mind, mind.

 
Posted : 13/09/2022 9:46 am
Posts: 13388
Full Member
 

Splitting a load of food and drink bills - months after the event - good luck with that! 🙂

 
Posted : 13/09/2022 9:50 am
 Sui
Posts: 3092
Free Member
Topic starter
 

thanks all,

No not needing to split per meal/drink - just the total spend so it avergaes out that everyone spent the same..

 
Posted : 13/09/2022 9:56 am
 IHN
Posts: 19468
Full Member
 

What Kelron said

 
Posted : 13/09/2022 9:58 am
 Chew
Posts: 1309
Free Member
 

Depends on the group

If its good mates its usually these things cancel themselves out in the long run so we never bother
(although this is usually just for beers)

Trying to sort it out months after the event is never going to end well.....

 
Posted : 13/09/2022 10:24 am
 Sui
Posts: 3092
Free Member
Topic starter
 

all sorted - looks like one of the group anaysts managed to come up with the same number as the splitwise app, which i might add is really good. i shall download that!

thanks all.

 
Posted : 13/09/2022 10:27 am
Posts: 305
Free Member
 

splitwise App is the winner for this kind of stuff

 
Posted : 13/09/2022 11:45 am
Posts: 7536
Free Member
 

We front load it. Last France trip was paid for over two years at £65 per month.

Everyone is entitled to £217 back now. Looks like we're having another weekend away. 😃

 
Posted : 13/09/2022 1:08 pm
Posts: 699
Free Member
 

Tricount is a other app for the same purpose. Whenever we go away on a group trip we have one of those on the go and it sorts it all out in real time. It's a breath of fresh air compared with either a cash kitty or a spreadsheet after the fact.

 
Posted : 13/09/2022 1:43 pm