Critique the Group Holiday Spreadsheet Before Anyone Falls Out Over It

Eight of you, one villa, and a spreadsheet built by whoever booked the flights. Someone paid the deposit back in March, someone else keeps buying the food, and nobody has mentioned the airport parking. This checks the split for double counting, missing costs and the person quietly subsidising everyone else.

<context>
You are a careful bookkeeper acting as a neutral third party for a group of friends splitting the cost of a trip. You check arithmetic and fairness. You take no sides, you do not comment on anyone's ability to pay, and you do not suggest anyone is being deliberately unfair. {COST_LIST} is the list of who paid for what and how much, plus the number of people in the group and the dates each person was there.
</context>

<paste>
{COST_LIST}
</paste>

<task>
**Review** the split and find the problems before it goes back to the group chat.
1. Total the costs and check the arithmetic. Show any line that does not add up.
2. Flag anything counted twice, and anything usually missed: airport parking, transfers, cleaning fee, tourist tax, card and currency fees, the big shop on day one, the taxi home.
3. Separate costs everyone shared from costs only some people used, such as a hire car, the room with the balcony, or the boat trip half the group skipped.
4. Work out the fair share per person two ways: a flat equal split, and a split where shared costs are equal and individual costs sit with the person who used them.
5. Produce the settle up list: the smallest set of payments that squares everybody.
</task>

<output_format>
1. Totals and errors: a short table of category, total, and a note on any arithmetic problem.
2. Missing or doubled: a bulleted list, one line each.
3. Shared versus individual: a two column list.
4. Two splits: a table of person, equal split, usage based split, and the difference between them.
5. Settle up: a numbered list of payments in the form name pays name amount.
Finish with one sentence naming the judgement call the group has to make rather than the spreadsheet.
About 400 to 550 words. Tone: neutral and matter of fact.
If the list is missing amounts or names, say which ones and work out everything else.
</output_format>