I want to create an expense tracker for an event but not good with excel </3

I am putting together a decently sized event with 9 other people so 10 total. I want create an expense tracker that will mainly let me select 1, multiple, or all people that have paid for an expense. Ideally it should funnel into another sheet that when the event is over it will tally up exactly what each person is owed back when the event is over and it keeps track of who paid for what and who didnt pay for certain items. We want to make everyone whole again before splitting the profit evenly so no worries in needing to calculate certain percentages back. Essentially if 1 person pays for an expense out of pocket they should be made whole first before distributing actual net profit, we think its just easier to understand that way. That is the main gist, other small features I would want to add is like dates to go back and see who paid for what on which day to have a track of deadlines being on time or missed. Can anyone appoint me to some good videos/tutorials and let me know some tips or templates to make this happen?