I'm impressed by your awk sir!

I wanted to also mention that someone has built a handy web app for this kind of accounting that I use for similar trips at https://kittysplit.com/