TL;DR:
One sheet with four tabs (budget, bookings, itinerary, documents) replaces a dozen open browser tabs.
Record each booking once with its confirmation code, date, cost and cancellation deadline.
Use a SUM formula for the budget so it updates itself, and check it against your own limit.
You have twenty tabs open: two hotels, a train timetable, a restaurant, three map views and an article about the best coffee. Close the browser and it is all gone. The fix is not a better memory. It is one place where the decisions go, so tabs can be closed once their answer has been copied out.
When this is worth doing
Any trip with more than one booking, more than one person, or a budget. A day trip does not need a sheet. A weekend away with a hotel, transport and a couple of reservations does, because that is exactly where details get lost.
Before you start
Decide the dates and who is going. Everything else depends on these.
Set a total budget, even a rough one, and write it at the top.
Pick one tool you will open on your phone, such as a spreadsheet app or a shared document. Offline access is useful if you may have no signal.
Safety: Do not store passport numbers, card numbers or passwords in the sheet. Keep documents as files in a protected place, and in the sheet write only where they are. Check official government sources for entry rules, as they change.
Step by step
Make four tabs: Name them Budget, Bookings, Itinerary and Documents.
Fill in Bookings first: One row per booking: what, where, date, confirmation code, cost, and the last date you can cancel for free.
Build the Itinerary: One row per time slot, with a start time, what, where and the booking it depends on.
List Documents: Tickets, reservation emails, insurance details, and where each file lives. Note who holds each one.
Total the Budget: Add a column of planned costs and a total with a formula, then compare it with your limit.
Close tabs as you go: When a tab's answer is in the sheet, close it. If you want it again, paste the link in the row.
Worked example: a weekend trip plan in one sheet
Say two friends take a weekend trip, Friday evening to Sunday afternoon, with a total budget of 400 in their own currency. Here are the Bookings.
Item | Date | Cost | Confirmation | Cancel by |
|---|---|---|---|---|
Train there | Fri | 60 | Code on ticket email | Not refundable |
Hotel, 2 nights | Fri to Sun | 180 | Code in email | Thu |
Dinner reservation | Sat | 0 | Phone confirmation | Same day |
Museum tickets | Sat | 40 | QR in email | Fri |
Train back | Sun | 60 | Code on ticket email | Not refundable |
In the Budget tab, the planned costs sit in cells B2 to B6, and the total goes in B7.
=SUM(B2:B6)Check by hand: 60 + 180 + 0 + 40 + 60 = 340. Against a limit of 400, that leaves 60 for food and extras. Put that in B8 with =400-B7, which gives 60. Split it over the two days and you have a daily allowance for meals. If the hotel cost changes, the total and the leftover change with it.
Note that the dinner row is 0 because they pay at the restaurant. Put the expected cost in the extras budget instead, so the plan stays honest. Entering numbers as plain numbers, not "60 euros" with text, matters: SUM adds only numbers and skips text.
The itinerary tab
Time | What | Where | Depends on |
|---|---|---|---|
Fri 18:30 | Arrive, walk to hotel | Station to hotel | Train there |
Sat 10:00 | Museum | Old town | Museum tickets |
Sat 19:30 | Dinner | Near hotel | Dinner reservation |
Sun 15:00 | Train back | Station | Train back |
The last column is the useful one. If the museum is shut that day, you can see which tickets to change, instead of searching your email.
The documents tab
List each file by name and say where it lives and who has it on their phone: "Hotel confirmation, email from the hotel, both of us". If only one person holds the train tickets and that phone dies, the other cannot board. Share or print the critical ones before you leave, and keep a paper copy of anything you could not replace on the road.
Add a short row for insurance and for a contact to call if plans fall apart, such as the hotel desk. A phone number in the sheet is much faster to find than one buried in an old email.
Mistakes to avoid
Saving only a screenshot of a confirmation. Put the code and date in the sheet as text too.
Forgetting the cancellation deadline. It is the most expensive missing column.
Planning every hour. Leave at least one block empty each day.
Keeping the plan in one person's head. Share the sheet with everyone who is going.
Trusting opening hours from memory. Check them again close to the trip.
Doing it faster
Open the sheet before the trip and read it through once, so you notice gaps like a late arrival and an early check-in time. DuckyHelper can see your screen and read the rows back to you out loud while you pack, if that suits you. It is optional, and the sheet works fine without it.
Frequently asked questions
Do I need a spreadsheet?
No. A shared document with the same four headings works. A sheet is handy because it adds the costs for you.
How do I split costs between friends?
Add a Paid by column and a column for each person's share. For two people with an even split, the share is the total divided by 2, so 340 gives 170 each.
What should I do with the tabs I closed?
Paste the useful links into the row they belong to, so a closed tab is never lost.
Get started
