If you’re taking a trip like ours, there’s going to be a lot to book. Flights, trains, hire cars, hotels, Airbnbs, insurance and visas, tickets to sports games and museums and cooking classes… When you have 4 months worth of bookings, you want to be able to keep tabs on things quickly and easily. You don’t need fancy accounting programs or booking-tracker apps; you literally just need a simple spreadsheet.
|FLIGHT DETAILS||BUDGET||ACTUAL COST & DATE PAID||BOOKED WITH||BOOKING
|01 Jan: MEL – LAX||$2400.00||$2285.00 paid via credit card 18.02.17||Qantas website 18.02.17||XXX88X||Saved email in RTW folder|
|02 Jan: LAX – YYC||$600.00||$629.00 paid via PayPal 24.02.17||American Airlines website 24.02.17||XX55XX|
|08 Jan: YYC – KTN||$800.00||$784.00 paid via credit card 02.03.17||Alaska Airlines website 02.03.17||XXXX98|
|BUDGET||ACTUAL COST & DATE PAID||BOOKED WITH||BOOKING NUMBER||NOTES|
|01 – 02 Jan: Los Angeles hotel||$150.00||USD$85.00 to be paid on arrival||Booking.com 05.03.17||ABCDEF||Double room, non-smoking|
|02 – 08 Jan: Calgary hotel||$800.00|
|08 – 12 Jan: Ketchikan hotel||$500|
|DETAILS||BUDGET||ACTUAL COST & DATE PAID||BOOKED WITH||BOOKING
|Canadian National Parks pass||$150.00|
|Ketchikan city tour||$50.00|
And that’s about it. The way I use this is:
1. I started by filling in the first column of the travel plans that needed to be booked.
2. I filled in the second column with the amount we budgeted for each item.
Once we actually started getting things booked in:
3. I filled in the third column with the actual amount we ended up spending and the date it was paid
4. The fourth column was who I booked with, be in via email, website, third party, whatever, and the date they confirmed the booking.
5. In column five, I just put the booking confirmation number.
6. And the last column is just any notes.