Getting started

What did the holiday cost? Working it out when friends paid you back

Work out the true cost of a group trip when you paid for others and they sent money back, using a simple gross, repaid and net table in pounds.

Editorial illustration for What did the holiday cost? Working it out when friends paid you back

When you pay for a group and friends send money back, your card statement overstates your trip. The true cost to you is what you paid minus what came back, and getting that right means treating the repayments as reimbursements, not as income. Here is how to build the figure, with a worked example in pounds.

Why does the statement show the wrong number?

Say you booked a villa for four and paid the whole bill. Your statement shows the full amount going out. Three weeks later, three friends send you their share by bank transfer, and those arrive as small credits on another day, sometimes in another account. If you total only the card, the trip looks expensive. If you count the transfers as normal income, your month looks richer than it was. Neither is right, so you need a third kind of row.

How do I build a gross, repaid and net table?

  1. List every trip payment you made, whoever it was for, as the Paid column.
  2. List every transfer from a friend that relates to the trip as the Paid back column on the same line as the item it covers.
  3. Subtract to get Your cost.
ItemYou paidPaid backYour cost
Villa for four£1,200.00£900.00£300.00
Petrol and parking£164.00£123.00£41.00
Group dinner£188.00£141.00£47.00
Your own spending£236.50£0.00£236.50
Totals£1,788.50£1,164.00£624.50

Each friend sent £300 for the villa, £41 for fuel and £47 for dinner, which is why three friends give 900, 123 and 141. The totals check: 1,788.50 minus 1,164.00 is 624.50. That £624.50 is what the trip cost you.

Where do I find the repayments?

Search your account statements for the names of the friends and for the weeks after the trip. Bank transfers carry a reference and the sender's name, though the amount is the only thing you should rely on. If someone settled in cash, you will find nothing on the statement, so add a manual line and note it. A repayment you forgot to count is the most common reason a trip looks dearer than it was.

How do I add the totals in a sheet?

Put Paid in column C and Paid back in column D, with Your cost in E as =C2-D2 filled down. For the trip total, =SUM($E$2:$E$20). If you keep one long list of transactions instead, add a Type column marked Paid or Repaid and use =SUMIFS($C$2:$C$300,$D$2:$D$300,"Paid")-SUMIFS($C$2:$C$300,$D$2:$D$300,"Repaid").

What if I owe someone else?

The same table works in reverse. If a friend paid the first night's hotel and you sent them your share, that transfer is a trip cost for you, even though it came from your account and not your card. Give it the same trip tag and include it in your total.

Does the same method work for a small weekend trip?

Yes, and it is quicker. A weekend away with two other people might have a rail booking, one shared meal paid by you and a few small rounds of drinks. List them, record what came back, and subtract. The point is not the size of the trip but the habit of looking at the net. Many people who feel a weekend was cheap are looking at their own spending only, and many who feel a trip was dear are looking at the gross before the repayments came in.

What to do with the answer

  • Divide £624.50 by the number of days to see your daily cost.
  • Keep the table as a template for the next group trip.
  • Next time, agree on who pays what before you go, so the repayments are a handful of clear rows rather than a month of small transfers.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports