{"product_id":"subscription-tracker-recurring-payments","title":"Subscription Tracker Spreadsheet","description":"\u003cp\u003eThis subscription tracker lists the recurring bills and subscriptions in your household and converts each one to what it costs you a year. It is for anyone who suspects they are paying for more than they use and wants to catch renewals before they happen.\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\u003eA year on every row\u003c\/h2\u003e\u003cp\u003eA small monthly charge and a larger yearly one cannot be compared until one of them is converted. The file does it for you: weekly times 52, monthly times 12, quarterly times four. With an annual cost on every row, and a monthly figure from the same total, you can finally see where the money goes.\u003c\/p\u003e\u003ch2\u003eUsed lately, in three states\u003c\/h2\u003e\u003cp\u003eMark each subscription as used every week, sometimes or never. The never-used ones are totaled in money, and that money saving number often pays for the file in the first month.\u003c\/p\u003e\u003ch2\u003eRenewals and cancel-by dates\u003c\/h2\u003e\u003cp\u003eSubscriptions renewing in the next 14 days are counted. Each also has its own cancel-by date, because the deadline to cancel is not always the renewal date. That makes it a renewal tracker as well as a subscription list.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e120 subscriptions across eleven categories, so streaming and software totals stay separate\u003c\/li\u003e\n\u003cli\u003eWeekly, monthly, quarterly or yearly billing\u003c\/li\u003e\n\u003cli\u003eAn annual cost on every row, converted, and a monthly figure from the same total\u003c\/li\u003e\n\u003cli\u003eRenewing in 14 days, counted\u003c\/li\u003e\n\u003cli\u003eA cancel-by date of its own\u003c\/li\u003e\n\u003cli\u003eNever used, totaled in money\u003c\/li\u003e\n\u003cli\u003eA Bills tab alongside the subscriptions\u003c\/li\u003e\n\u003cli\u003eA Tasks tab for everything the main tab does not cover, and a dashboard reading all of it\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSix connected tabs and a filled example\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Subscriptions, Bills, Tasks and Dashboard. The example copy holds 24 subscriptions, with eleven renewing inside two weeks and a sizable yearly sum going on things marked never used. The blank copy is ready for your own household bills, and the Start Here tab walks you through setup in a few minutes.\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\u003eTwo Excel workbooks: the filled example and a blank one\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with 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 the moment payment clears, for personal and business use on your own devices. Please do not share or resell them. Questions? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. The Excel workbooks run on Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow does it compare monthly and yearly subscriptions?\u003c\/h3\u003e\u003cp\u003eIt converts every payment to an annual cost: weekly times 52, monthly times 12 and quarterly times four, then shows a monthly figure from the same total.\u003c\/p\u003e\u003ch3\u003eWill it remind me before something renews?\u003c\/h3\u003e\u003cp\u003eIt counts subscriptions renewing in the next 14 days on the dashboard, and each has its own cancel-by date. It does not send emails or notifications.\u003c\/p\u003e\u003ch3\u003eCan I see what I am wasting?\u003c\/h3\u003e\u003cp\u003eYes. Mark each subscription as used every week, sometimes or never, and the never-used ones are totaled in money.\u003c\/p\u003e\u003ch3\u003eDoes it connect to my bank?\u003c\/h3\u003e\u003cp\u003eNo. You type in your subscriptions yourself. The file has no add-ins, no macros and nothing to connect.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597870235742,"sku":"OPX-180","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/subscription-tracker-recurring-payments-01.jpg?v=1790832954","url":"https:\/\/opxviashop.com\/products\/subscription-tracker-recurring-payments","provider":"OPXVIA","version":"1.0","type":"link"}