Guides › Planning & Productivity

Never miss a renewal or deadline again

Keep one tracker of insurance, MOT, passports, subscriptions and contracts, with calendar reminders set well before each date.

Planning & ProductivityIntermediate40 minGoogle SheetsAI assistantGoogle CalendarGmail
Open the interactive guideBrowse all guides

When to use it

Set up once, update whenever something renews

Step by step

  1. Find your renewal dates

    Search your email for words like 'renewal', 'policy', 'subscription' and 'expires', and check documents such as your passport and driving licence.

  2. Turn them into a tidy list

    Paste the details (leaving out policy and account numbers) into your AI assistant.

    Prompt to copyOrganise these renewals and deadlines into a table: [paste details]. Columns: item, provider, renewal or expiry date, cost and how often it's paid, auto-renews (yes/no/unknown), how far ahead I should be reminded (e.g. 4 weeks for insurance to shop around, 10 weeks for a passport), and the action to take. Sort by date. Flag anything that looks like a duplicate or forgotten subscription.
  3. Save it in a spreadsheet

    Paste the table into Google Sheets or Excel and keep it somewhere safe and private.

  4. Add calendar reminders

    For each row, create a calendar event on the reminder date (yearly repeating where it makes sense) with the action in the description.

What you get

Car insurance | Brightway | 14 Jan | £412/yr | auto-renews | remind 16 Dec | compare quotes. MOT | - | 3 Mar | £54.85 | no | remind 10 Feb | book garage. Streaming | ViewBox | 22nd monthly | £10.99 | yes | flag: unused?

Tips

More Planning & Productivity guides