{"product_id":"travel-points-miles-tracker","title":"Travel Points and Miles Tracker Spreadsheet","description":"\u003cp\u003eThis travel points tracker keeps every loyalty program you belong to in one place, for anyone into travel hacking or simply tired of points expiring. Each program keeps a running balance, and every redemption is scored by what a point was really worth.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003ePick all programs or one, and the cards, charts and tables follow. Nothing is typed on it.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eEvery balance added up, with a mini chart by program\u003c\/li\u003e\n\u003cli\u003eWhat each program's balance is worth at the usual value you set\u003c\/li\u003e\n\u003cli\u003eEvery redemption ranked by cents a point, with a verdict\u003c\/li\u003e\n\u003cli\u003eWhere points went: earned, bonuses, transfers, redeemed and expired\u003c\/li\u003e\n\u003cli\u003ePoints earned in the last 12 months, and points in and out month by month\u003c\/li\u003e\n\u003cli\u003eValue by kind: airline, hotel, card and other programs as a ring\u003c\/li\u003e\n\u003cli\u003eThe next balances to expire, with those inside your warning in red\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eEvery balance, kept up to date\u003c\/h2\u003e\u003cp\u003eThe Programs tab holds one row per program, whether airline miles, hotel points or credit card points, with your starting balance, what a point is usually worth to you and how its points expire. Every earn, bonus, transfer and redemption goes on the Activity tab, and the balances follow.\u003c\/p\u003e\u003ch2\u003eWhat each point was worth\u003c\/h2\u003e\u003cp\u003eThe Redemptions tab works out cents a point on every redemption, sets it against the program's usual value and marks it Great, Fair or Poor. Your redemptions are ranked best value first, and every balance is valued in cash at your own value a point.\u003c\/p\u003e\u003ch2\u003eExpiry dates with a warning\u003c\/h2\u003e\u003cp\u003eExpiry is worked out from the last activity or from a fixed date, depending on the program, and you choose how many days of warning you want.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Programs, Activity, Redemptions and Dashboard.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook, filled with a worked example: 8 loyalty programs and 11 redemptions over 18 months\u003c\/li\u003e\n\u003cli\u003eThe same workbook, blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. They are for personal and business use on your own devices, so please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You get Excel workbooks for Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my airline or card accounts?\u003c\/h3\u003e\u003cp\u003eNo. You log each earn, bonus, transfer and redemption on the Activity tab, and the running balances follow from that.\u003c\/p\u003e\u003ch3\u003eHow does it value a redemption?\u003c\/h3\u003e\u003cp\u003eIt works out cents a point, compares it with the usual value you set for that program and marks it Great, Fair or Poor.\u003c\/p\u003e\u003ch3\u003eWill it warn me before points expire?\u003c\/h3\u003e\u003cp\u003eYes. Expiry comes from the last activity or a fixed date, and balances inside the warning period you choose show in red.\u003c\/p\u003e\u003ch3\u003eIs there an example to follow?\u003c\/h3\u003e\u003cp\u003eYes. The filled copy has 8 loyalty programs and 11 redemptions over 18 months, and a blank copy is included.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597875707998,"sku":"OPX-235","price":15.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/travel-points-miles-tracker-01.jpg?v=1790833270","url":"https:\/\/opxviashop.com\/products\/travel-points-miles-tracker","provider":"OPXVIA","version":"1.0","type":"link"}