The following article is available from the Microsoft Excel team blog, which provides useful articles and news about Excel and Excel Services from the Excel product group and occasional guest contributors.
Tracking Split Costs
Summary: Using a template, shows how to efficiently handle paying back multiple people while getting reimbursed for your travel costs at the same time.