Trip Expenses Spreadsheet

What is in the travel expenses spreadsheet template

Three sheets, nothing hidden. You only ever type into the white cells: names, dates, categories, descriptions, amounts, and a 1 for each traveler who shares a row.

• Expenses. One row per cost: date, category, description, amount, who paid, then a tick box column for each of up to 10 travelers. Put a 1 under everyone who was in on that cost. Two columns calculate themselves: Split among counts the 1s on the row, and Share per person divides the amount by that count. The header row is frozen and the file ships with 40 blank rows plus 5 filled-in sample rows you can overwrite.
• People. One row per traveler, with three calculated columns: Paid adds up everything that traveler paid for, Share adds up their slice of every row they were in on, and Net is paid minus share. A positive net means the group owes them. Below it sits the Settle with the organizer table, which turns those balances into one payment per traveler.
• Summary. Two small tables that build themselves from the Expenses sheet: spending by day for the first five days of the trip, and spending by category across Transport, Lodging, Food, Activities and Other. This is the group trip expense tracker part, and it is where you see the day the trip ran hot.

Amounts and dates are already formatted for your region, so the file you download shows dollars and MM/DD/YYYY dates without you changing a setting.

How the group trip expense tracker calculates each share

Four plain functions do all of it, and you can read every one of them in the formula bar. Nothing is hard-coded, nothing is a pasted value, and there are no macros to enable.

Per expense

Split among = SUM(of the tick box columns on that row) and Share per person = IF(count > 0, amount / count, 0). Because the share is the amount divided by the count, the shares on a row always add back up to the amount, whether four people shared it or two.

Per traveler

Paid = SUMIF(Paid by column, this traveler's name, Amount column). Share = SUMPRODUCT(Share per person column, this traveler's tick box column), which picks up the row share only where their cell holds a 1. Net = Paid - Share. Add every net together and the result is zero, which is the check printed next to the totals row.

Day and category totals

The Summary sheet is two SUMIF tables: one matches the date column, the other matches the category column, both adding the amount column. Change a category on an expense row and both tables move with it.

Settling up

The first traveler in the People sheet is the organizer, which is usually whoever booked the trip. Everyone else either sends the organizer the size of their negative net or receives the size of their positive net, so a group of five settles in four payments. A who pays whom plan that pairs debtors with creditors directly needs to compare every balance against every other balance, which is not something a spreadsheet formula does cleanly. For that version, use the who owes who calculator or the group trip calculator.

Worked example: four travelers over five days

These are the sample rows the download ships with, so you can open the file and follow along.

Trip expenses spreadsheet, or a tracker everyone can see

A spreadsheet is the right tool when one person keeps the record, the trip is over or nearly over, and you want a file you own that nobody needs an account to open. It gets awkward mid-trip, because the file lives on one phone: every new taxi means finding it, typing the row, and re-sending it to four people who each have a slightly different copy.

If you only need one answer right now, the browser tools skip the download: group trip calculator for travel costs, who owes who calculator for any group tab, split bill calculator for a single check, and split rent calculator for a monthly rent. For everyday shared costs at home rather than a trip, the matching file is the shared expenses spreadsheet.