Skip to content
Seeing who paid an expenses, and how much that person has to pay or receive at the end of the tripFilter the expenses based on a date rangeSee a group expense report as a pie chart and bar chart
If create 8th person, the formula number should be 8If create 9th person, the formula number should be 9etc..
Expense Tracker Manual
How the expense tracker works.
Trip Expense Tracking App
This expense tracker will keep track of expenses we incur on the trip. The tracker renders on your phone so that it feels like a mobile app, so download the Coda App for expense tracking on the go!
Key Features
Some of the key features in this trip expense tracking app include:
This embedded link can't be shown.
Expenses sample 1
This event paid by Roy with total amount $150, each person (Ben and May) should pay back to Roy $50 each. Because Roy also attended this event so Roy should collect $100 but not $150
Expenses sample 2
This event paid by David but he doesn't attend, so he should collect total $30 from attendee (Roy, Ben, Mary, Patrick) $7.5 each
Expenses Summary
You can see the total expenses at the bottom, it is very clear to know who should pay or collect, it is the same as "Traveler Summary" table but "Traveler Summary" can view-able in mobile. Also, "Traveler Summary" also list the actual spent in the trip
How to Rename and add a person
Rename
just rename "Traveler Summary" table manually
Add - Step 1
Add row (e.g. Louis) in "Traveler Summary" table
Add - Step 2
in Expenses table, create new column next to last person, rename (e.g. Louis), copy formula from left, change highlighted number
Add - Verification
Make sure the "Traveler Summary" is the same ordering as "Expenses" table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.