{"product_id":"subscription-and-direct-debit-audit","title":"Subscription and Direct-Debit Audit","description":"\u003cp\u003eThis workbook holds personal and financial information about your household. Look after it: share it only with people who need it and keep the file somewhere protected. It has no columns for passwords, PINs, card numbers or bank account numbers, so please do not type them into Notes either.\u003c\/p\u003e\u003cp\u003eGeneral information only. It is not accounting, tax, legal or financial advice.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eThe problem.\u003c\/strong\u003e Subscriptions and direct debits pile up across email accounts, cards and apps. Renewal dates slip past, and nobody in the household has one clear view of what is paid each month or year, or who uses what.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat this does.\u003c\/strong\u003e You keep one list of subscriptions, one of cancellation requests and one of the people in your household. The workbook works out the yearly cost and monthly equivalent of each subscription from the amount and billing period you type, adds them up by category and by person, and shows which renewals fall inside the window you choose.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do with it\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee yearly cost and monthly equivalent for everything your household pays.\u003c\/li\u003e\n\u003cli\u003eSee cost by category and by person, as tables and a bar chart.\u003c\/li\u003e\n\u003cli\u003eSee renewals due soon, and renewal dates that have already passed.\u003c\/li\u003e\n\u003cli\u003eSee the yearly cost of the subscriptions you marked for review.\u003c\/li\u003e\n\u003cli\u003eKeep a cancellation log: the date you asked, what happened and an amount you type.\u003c\/li\u003e\n\u003cli\u003eChoose your household type (single, couple or family with children) to load suitable Category and Outcome lists, then edit them to suit you.\u003c\/li\u003e\n\u003cli\u003eKeep your records in a clear structure: a Data Dictionary explains every column, and three export sheets repeat your subscriptions, cancellation requests and people under plain field names.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003col\u003e\n\u003cli\u003eEnter your household name, choose your household type, and type your billing periods and renewal window on Settings.\u003c\/li\u003e\n\u003cli\u003eAdd the people in your household, then your subscriptions and cancellation requests.\u003c\/li\u003e\n\u003cli\u003eCheck the dashboard.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cstrong\u003eWho it is for.\u003c\/strong\u003e Individuals, couples and families who want one place to see what they pay for subscriptions and direct debits.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWho it is not for.\u003c\/strong\u003e Anyone who needs reminders or alerts. This is a spreadsheet: it does not send anything, does not connect to anything else, and makes no statement about whether a subscription is good value.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you need.\u003c\/strong\u003e Microsoft Excel 2016 or later. It was tested in Excel for Windows. No macros, no add-ins and no subscription.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGood to know\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e300 subscription rows, 200 cancellation rows and 50 people rows are ready, and you can add more by dragging the last row down.\u003c\/li\u003e\n\u003cli\u003eNothing is set for you. You type every billing period, number of payments per year, status word and window.\u003c\/li\u003e\n\u003cli\u003eThe next renewal is a date you type; the workbook does not work it out.\u003c\/li\u003e\n\u003cli\u003eNo reminders or alerts are sent. The workbook only marks dates on the sheet.\u003c\/li\u003e\n\u003cli\u003eThere are no fields for passwords, PINs, card numbers or bank account numbers.\u003c\/li\u003e\n\u003cli\u003eAn example copy with a made-up household shows every sheet working before you start.\u003c\/li\u003e\n\u003cli\u003eNothing is locked or password protected.\u003c\/li\u003e\n\u003cli\u003eUse this template to capture and improve your household data now. In future you can automate with AI.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"TeleWorld Online","offers":[{"title":"Default Title","offer_id":48859262779597,"sku":null,"price":11.95,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0652\/1031\/9053\/files\/01-cover_27ff4a68-8749-4bcc-a405-afe3a3b57ea1.png?v=1795095975","url":"https:\/\/www.teleworld.online\/sv-fi\/products\/subscription-and-direct-debit-audit","provider":"TeleWorld Online","version":"1.0","type":"link"}