Frequent flyer programs are designed to thank the customer for their continued loyalty. Keeping track of all points across multiple rewards programs unique to each airline can get confusing. Use this Frequent Flyer Rewards template to log all flights and point transactions for the most up to date rewards point balances. Let this template do all the point calculations for you, enabling you to spend less time doing arithmetic and more time reaping the rewards of flying.
Whether you’re a frequent flyer that travels often for work or you fly only twice a year for vacations, why not gain points for each flight? Get rewarded for the trips you’re planning on taking anyway. Once you accumulate enough points, you save money on your flights. The only downside is the amount of time it takes to organize all the point transactions and flights… or at least it used to. Quickly log your flights and your point balance for each airline is automatically calculated with this Frequent Flyer Rewards template. Let’s fly through this template, organized by table:
Customers are often loyal to specific airlines. Whether it is due to the perks they receive from the airline or simply because of the service, customers are much more likely to try to book their tickets with airlines they have taken in the past. Each airline has their own point based reward system that allows you to redeem points in exchange for flights. This table contains all airline information including your current point balance with the airline’s rewards system.
Name. The airline’s name.
Logo. The airline’s logo.
Based out of. The airport the airline is based out of linked to the
Home base city. The city the home airport is
Based out ofpulled from the
Rating. The airline’s rating on a scale of 1-5.
Rewards ID. The unique rewards ID associated with the airline. All points are typically tied to this account.
Point balance. The net point balance calculated based on the number of points redeemed and credited in the
Flights taken. A link to the
Flightstable to identify the various flights you’ve taken operated by the airline.
Flight count. The number of flights taken operated by the airline.
Airports with hubs. A field linked to the
Airportstable to identify the various airports that contain hubs for the airlines.
Airport hub count. The number of airport hubs contracted.
All airlines. Displays all airlines sorted in alphabetical order.
Highest point balance. Displays airlines that you currently have the highest calculated
Point balancesorted by highest balance to lowest
Most frequently used. Displays airlines that you have taken the most flights with sorted in alphabetical order.
Highest rated. Displays airlines that have a
Ratingof 4 or 5 on a scale of 1-5 sorted in alphabetical order.
Airlines gallery. Displays all airlines in the form of a gallery view sorted in alphabetical order.
New airline. Displays a form that can be used to add a new airline to the list.
Points gained or redeemed are usually applied to the account based on the flight. The more distance a flight covers, the higher the reward points typically awarded. Even if you take the same flight but on different days, this table treats each flight and date combo as its own entity, keeping track of your points independently. If you can’t remember which flight you redeemed your rewards points on, easily take a peek at this table.
Number and date. An automatic formula that creates a flight
Numberand flight date for a unique combination.
Number. The flight’s number.
Operated by. This field looks to the
Airlinestable to identify the airline that is operating the flight.
Date and time. The flight’s date and time of departure.
Source airport. The airport the flight is leaving from. This field is linked to the
Destination airport. The airport the flight is headed towards. This field is also linked to the
Point transaction status. This single select field denotes whether you have submitted a request to apply the flight points to your rewards account with the airline.
Points. The number of points rewarded or used for the flight.
Credited points. This field displays a green check mark if you were credited the points for the flight and a red x if you have not yet received points or if you redeemed points for the flight.
All flights. Displays all flights sorted in chronological order of
Date and time.
Current year. Displays all flights that have a
Date and timein the current year sorted by earliest to latest flight.
Redeemed points. Displays flights where rewards points were redeemed sorted by earliest flight date to latest flight date.
Credited points. Displays flights that had points credited sorted by earliest flight date to latest flight date.
By point transaction status. Displays all flights stacked by
Point transaction statusin the form of a kanban view.
New flight entry. Displays a form used to enter a new flight to the list.
It’s common for frequent flyers to use the airport name to describe their destination. Many travel booking platforms use the airport code to identify the source and destination airports. This table contains all airport information including the airport code and various flights taken into and out of this airport. Additionally, if you have a preferred airline, easily identify whether the airport you’re headed to contains your favorite airline’s hub!
Name. The airport name.
Code. The airport’s unique 3 letter code.
Photo. The airport’s photo.
Flights taken. This field is linked to the
Flightstable to identify the various flights you have taken form this airport.
Located in. This field is linked to the
Citiestable to identify which city the airport is located in.
Address. The airport’s address.
Airline hubs. This table looks to the
Airlinestable to highlight the airlines the airport serves as a hub for.
Hub count. The number of
Airline hubsassociated with the airport.
Flight count. The number of
Flights takenout of the airport.
All airports. Displays all airports sorted in alphabetical order.
Frequently used. Displays airports that have been used for more than one flight sorted in alphabetical order.
Airport gallery. Displays all airports in the form of a gallery view sorted in alphabetical order.
New airport. Displays a form that can be shared to add a new airport to the table.
This table identifies airports and airline hubs within the airports that reside in the city.
Name. The city’s name.
Airport name. This field looks to the
Airportstable to display airports located in the city.
Airline hubs. This field looks to the
Airportstable to identify the
Airline hubslocated at airports within the city.
All cities. Displays all cities sorted in alphabetical order.
New city. Displays a form used to enter a new city.