A shareable trip report has three parts: a list of every shared expense with who paid it, each person's total paid, and a settle-up line saying who pays whom. Keep it in a sheet everyone can view, and close it within a few days of getting home, before memories blur.
What columns should the log have?
- Date and a short description, such as Day 2 lunch.
- Amount in rupees.
- Who paid, by name.
- Who shared it, if not everyone.
- Category: stay, travel, food, activities, other.
- Receipt or note, if it is large.
Agree the rules before the trip: is every expense split equally, or are some personal? Personal items stay out of the log.
A worked example with made-up numbers
Four friends, A, B, C and D, share a trip. Who paid for what:
| Person | Paid for | Amount in rupees |
|---|---|---|
| A | Stay | 16,000 |
| B | Cabs and fuel | 4,400 |
| C | Food | 9,600 |
| D | Activities | 6,000 |
| Total | All four friends | 36,000 |
An equal share is 36,000 divided by 4, which is ₹9,000 each. Now compare what each paid with the share:
- A paid 16,000, so is owed 7,000.
- B paid 4,400, so owes 4,600.
- C paid 9,600, so is owed 600.
- D paid 6,000, so owes 3,000.
Owed amounts total 7,000 plus 600, which is 7,600, and owing amounts total 4,600 plus 3,000, which is also 7,600. The sums match, which is your proof. The simplest settle-up is: B pays A ₹4,600; D pays A ₹2,400 and D pays C ₹600.
How do you calculate it in a sheet?
Put the paying person's name in column B and the amount in column C of the log. List the four names in a summary table, then use these for each name in, say, F2:
- Total paid: =SUMIFS($C$2:$C$200,$B$2:$B$200,F2)
- Equal share: =SUM($C$2:$C$200)/COUNTA($F$2:$F$5)
- Balance: =G2-H2, where G is total paid and H is the share; positive means the person is owed money
The balances must add up to zero. If they do not, an expense is missing a payer or has a typing error.
What if people shared some things unequally?
Add a column for the people sharing each expense, split that row's amount among only them, and add the shares up per person. It is more work, so use it only when it is worth the effort, for example when two people skipped an activity.
What if someone pays in cash or by UPI later?
Log it the moment it happens, with the payer's name, even if the amount is small. A forgotten chai round of ₹120 does not matter, but a forgotten ₹6,000 advance for a cab does. At the end of each day, one person reads the log aloud or posts a photo of it in the group chat, and anyone who spots a gap says so while it is fresh. Settling a mistake on day two is a minute's job; settling it a month later is an argument.
How do you share it safely?
- Share a view-only link or a PDF, not edit access.
- Remove personal details like account numbers.
- Keep receipts in a shared folder if anyone wants to check.
- Do not ask anyone to share banking logins to prove a payment; a UPI reference is enough.
Where does SpendixAI fit?
SpendixAI is not a bill-splitting app, so it will not work out who owes whom. It is useful for your own side of the trip: you can import statements, tag the trip spend with a category, and download a CSV from reports to feed the sheet above. The shared report itself stays in your spreadsheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


