Free Flight Details Planner: Flight Itinerary Sheet for Each Trip, a Yearly Flight Log with Miles and Costs, and a Frequent Flyer and Travel Program Tracker (PDF, Word, Excel)

What is on the flight details planner

Confirmation code

The six-character booking reference (also called a record locator or PNR) used to check in or change the booking.

Local times

Departure and arrival times are always in the local time of each airport; overnight flights arrive the next day.

Connections

The time between flights and whether you change terminal, pass through immigration or recheck bags.

Miles and cost per mile

Distance flown and ticket cost; Excel totals both and works out the average cost per mile.

Member no. (last 4)

Only the last four digits of loyalty numbers on paper; keep full numbers and passwords in a password manager or the airline app.

One page per trip

Copy each flight from the booking emails into the itinerary sheet, with local departure and arrival times, terminals and confirmation codes. Check it again a week before and the day before: airlines change schedules and gates more often than people expect. Note connection times and anything that makes them tight, like changing terminal or clearing immigration. Keep a copy in your bag and a photo on your phone. The full day-by-day trip, including hotels, belongs on the travel itinerary template.

A yearly flight log

A log of every flight is handy for expense claims, for travel budgets and for checking that points and miles were credited. Mark each flight as business or personal. Excel totals the miles, costs and points and works out the average cost per mile which helps compare fares next time. For trip costs beyond flights, use the trip expense tracker.

Keeping track of points

Most travelers belong to several airline, hotel and car programs and forget half of them. Points in some programs expire after a period without activity, so a once-a-year check of balances and expiry dates saves points you would otherwise lose. For security, write only the last four digits of member numbers on paper and keep logins in a password manager. Trusted traveler programs, such as Global Entry or TSA PreCheck in the US, need renewing every few years; add the dates here and to the travel document checklist.

Editing the files

The PDFs are fillable. In Excel, the flight log totals miles, cost and points automatically.

Questions

What details should a flight itinerary include?

Date, airline and flight number, departure and arrival airports and local times, terminal, seat, confirmation code and baggage allowance.

What is a confirmation code?

A six-character booking reference, also called a record locator or PNR, used to check in and manage the booking.

How long should a connection be?

It depends on the airport and whether you change terminals or pass immigration. Domestic connections are often an hour or more; international ones usually need longer.

Do airline miles expire?

Some programs expire points after a period without activity; others never expire. Check each program's rules.

How do I track my flights for a year?

Log each flight with date, route, purpose, miles and cost; the Excel log totals them.