Travel and vehicles

A booked-trips calendar: dates, amounts paid and refund deadlines

A booked-trips calendar sheet lists every flight, train and hotel with amount paid, cancellation deadline and status, so no refundable booking lapses.

Editorial illustration for A booked-trips calendar: dates, amounts paid and refund deadlines

A booked-trips calendar is one sheet that lists every flight, train and hotel you have paid for, with the travel date, the amount, the date after which cancelling costs you money, and the current status. It stops you from losing money on a booking you forgot, and it shows how much of your cash is tied up in future travel. Here is the layout, the formulas and a small made-up example.

The columns

  1. A: Trip name.
  2. B: Item: flight, train, bus, hotel or other.
  3. C: Provider or property.
  4. D: Travel or check-in date.
  5. E: Amount paid.
  6. F: Free-cancellation deadline, date and time noted in the confirmation.
  7. G: Status: Booked, Changed, Cancelled, Refund pending, Refunded, Used.
  8. H: Notes, such as booking reference or conditions.

Read the confirmation for the deadline. Some deadlines are a date and others are a time, and some bookings have no free-cancellation period at all. Write what the booking says rather than guessing.

The formulas

  • Days to the deadline, in I2: =F2-TODAY()
  • Decide-now flag, in J2: =IF(AND($G2="Booked",$F2>=TODAY(),$F2-TODAY()<=3),"Decide now","")
  • Money tied up in future bookings: =SUMIFS($E$2:$E$200,$G$2:$G$200,"Booked",$D$2:$D$200,">="&TODAY())
  • Money tied up with a deadline still ahead: =SUMIFS($E$2:$E$200,$G$2:$G$200,"Booked",$F$2:$F$200,">="&TODAY())

Copy I2 and J2 down the column. Both formulas work in Excel and in Google Sheets. If F holds a date and time, I2 will show decimals, so format it as a number or wrap it in INT: =INT(F2)-TODAY().

A made-up example

ItemTravel datePaid in ₹Free cancellation untilStatus
Flight to Goa14 December6,8007 DecemberBooked
Hotel in Goa, 3 nights14 December10,50010 DecemberBooked
Train to Jaipur2 January1,450No refund after bookingBooked
Hotel in Jaipur2 January7,20028 DecemberBooked

The money tied up in these bookings is 6,800 plus 10,500 plus 1,450 plus 7,200, which is ₹25,950. The money still within a cancellation window, if today is 5 December, is the flight, both hotels but not the train, which has no free cancellation: 6,800 plus 10,500 plus 7,200, which is ₹24,500. That is the figure to keep an eye on.

How does the calendar help me save money?

Each time you open the sheet, sort by the deadline column. Anything that shows Decide now is a booking where a choice is still free. Confirm the trip is still on, or cancel. Without the sheet, the deadline passes quietly and you discover it only when you ask for a refund.

Which dates matter besides the deadline?

  • Cancellation deadlines for each hotel, which may differ even within one trip.
  • Dates a fare or voucher expires.
  • The day a refund should arrive, once you cancel.
  • Payment dates for a booking paid in instalments.

When a sheet stops being enough

If you want your payments to reconcile with your statements, SpendixAI can import them from your bank or card as PDF, CSV or Excel, and you review the rows before saving. The calendar is still the place for deadlines and status.

What about bookings made for other people?

If you booked a hotel or ticket for a parent, a friend or a colleague, add their name in the Notes column and mark who will pay you back. Money you are owed is part of the amount tied up, and you will want to see it. When they repay, change the note so the sheet stays honest.

How do I keep the sheet current?

Make the sheet a step in your booking routine. The moment a confirmation email arrives, add a row: it takes a minute and the details are fresh. When you cancel, change the status and add the refund follow-up, as you would in a refund tracker. A sheet that is two weeks out of date is worse than none, because it looks trustworthy.

Weekly review

  1. Open the sheet once a week, on the same day.
  2. Check every row marked Decide now.
  3. Update the status of anything changed or cancelled.
  4. Add the refund follow-up for cancelled bookings.
SPENDIXAI JOURNAL

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

Explore your reports