Free Hotel Booking Tracker: Hotel Reservation Log with Cancellation Deadlines, a Hotel Comparison Worksheet with True Total Cost, and a Hotel Stay Checklist (PDF, Word, Excel)

What is on the page

Rate per night (incl. tax)

The nightly price including taxes, so the total reflects what you will actually pay.

Free cancellation deadline

The last date and time you can cancel without a charge. Put a reminder in your phone a day earlier.

Resort and city fees

Extra nightly charges added by some hotels or cities, often paid at the hotel and not shown in the headline price.

True total

Room plus taxes, fees, parking, breakfast and other extras for the whole stay, worked out in Excel.

Deposit hold

An amount the hotel blocks on your card for incidentals, released some days after check-out.

Tracking hotel reservations

Booking refundable rooms early locks in a price and keeps options open, but only if you track them. Write each booking down as soon as you make it, with the confirmation number and the exact cancellation deadline which is often a specific time in the hotel's local time zone. If you book a backup, mark which one you will cancel and when. The tracker also shows the total hotel cost against your travel budget. For a full trip, add flights from the flight details planner.

Comparing the true cost

The headline rate is only part of the price. Add taxes, resort or destination fees, parking, breakfast and anything else you'll pay for, then compare the totals. A slightly dearer room with breakfast, free parking and free cancellation is often the better deal. Location matters too: a cheaper hotel far from where you'll spend your days costs money and time in transport. For a rental apartment or house, see the vacation rental checklist.

Check-in and check-out

At check-in, confirm the rate, the deposit hold and any fees so there are no surprises later. In the room, find the fire exits and check that the door locks; photograph and report anything broken so you aren't charged for it. At check-out, read the bill line by line; minibar and restaurant charges are often wrong. Ask for an emailed receipt if the stay goes on an expense claim.

Editing the files

The PDFs are fillable. In Excel, the tracker totals nights and costs, and the comparison works out the true total and cost per night for each hotel.

Questions

How do I keep track of hotel bookings?

List each booking with dates, nights, rate, total, confirmation number, cancellation deadline and payment status.

What are resort fees?

Mandatory daily charges some hotels add for amenities, often not included in the advertised room rate.

How do I compare hotel prices fairly?

Compare the total cost of the stay including taxes, fees, parking and breakfast, not just the nightly rate.

What should I check at hotel check-out?

Review the bill for wrong charges, empty the safe and room, get a receipt and check the deposit hold is released.

When is the free cancellation deadline?

It is set by each booking, often a day or several days before arrival at a specific local time. Check the confirmation.