Points & Miles Redemption Tracker
Excel workbook (.xlsx) · Instructions included · No signup required
See the value of the travel you book with points and miles. Our free Excel tracker brings flights, hotel stays, travel portals, free night certificates, and companion tickets into one workbook.
Track your own redemptions or manage up to four players plus shared points—with a Summary that updates for the account you select.
One workbook for your household
Assign bookings to P1, P2, P3, P4, or Shared Points. View each account separately or choose All Accounts.
Value after fees
Added fees are deducted automatically from cash values. Eligible points bookings also show cents per point.
More than points bookings
Track travel portal redemptions, hotel free night certificates, and airline companion tickets alongside your award bookings.
Sample data shown. Download includes a blank tracker with protected formulas. Select any preview image to open a larger view in a new tab.
Your redemption value, in one summary
Enter your bookings on the Airline and Hotel sheets. The Summary brings the results together so you can see how your points, certificates, and companion benefits were used.
- Points used, net cash value, and cents per point for flights, hotels, and portals.
- Free night certificates and companion tickets, with their value after fees.
- Redemption value by transfer source and booking program.
- Cancelled bookings excluded from Summary totals.
Choose one player—or see all accounts
“Player” means the person whose points or benefit funded the booking. Use Shared Points for a shared account, and All Accounts for the combined view. You do not need a separate workbook for each person.
Track your airline bookings
Record flight details, the account holder, transfer source, points used, award type, cash value, and added fees. Use the same sheet for airline awards, points bookings through travel portals, and companion tickets. Cents per point calculates automatically for eligible points bookings.
Track hotel stays and free night certificates
Keep your hotel points bookings, portal redemptions, and free night certificates together. Enter the stay details, nights, account holder, points or certificates used, nightly cash rate, and fees. Total cash value and eligible cents-per-point calculations update automatically.
Instructions are included
The How to Use sheet explains player assignments, shared points, booking entries, transfers, fees, cancellations, and redemption values. Formula cells are locked to protect the integrity of the workbook.
Preview the How to Use sheet
Start by saving your own copy. Enter bookings in the designated input cells, then choose an account on the Summary sheet to review your results.
Download Your Points & Miles Redemption Tracker
Download the free Points & Miles Redemption Tracker and keep your household’s award bookings and redemption values in one place.
Blank Excel workbook with protected formulas and a How to Use sheet. Use a version of Excel that supports MAP and dynamic array formulas.
Redemption values depend on the cash prices you enter and are estimates of travel value, rather than cash earnings.
Keep Exploring
Evaluate your next redemption, find where to transfer your points, and see how travelers put their points to work.
Need Help Putting Your Points to Work?
Let’s talk about your next trip and how we can help you plan flights and hotel stays using cash, points, or a combination.
Book a Free 30-Minute Consultation