Compliance Calendar: Track Licences, Insurance and Certificates

Build one register listing every licence, insurance policy and certificate with its expiry date, owner, lead time and where the document is stored. Send automatic reminders timed to each lead time, usually starting 30 to 90 days out, and have AI read each new certificate to pull out the dates, so nothing depends on memory. A spreadsheet with calendar alerts covers most small firms.

The renewals that get missed are rarely the obvious ones like the main insurance policy. They are the ones that depend on other people: a contractor's insurance certificate, a staff member's first-aid qualification, an equipment inspection booked by a supplier, or a licence application that needs weeks of notice. Build the register around those, and the famous renewals come along for free.

Follow me on Instagram@sagnikteaches

A community hall and café with 31 things to renew

The illustrative example here is a community interest company that runs a café, rents out a community hall for classes and parties, and runs a weekly youth club. When its manager sat down to list everything that expires, she expected about ten items. The list reached 31. Before the register, renewals lived in three places: the insurance broker's emails, a wall planner, and the memories of two long-standing volunteers. The prompt for building a register was a near miss: the hall's fire alarm service turned out to be four months overdue, which is covered in detail further down.

Connect on LinkedInSagnik Bhattacharya

What belongs on the calendar

Group the items so nothing is overlooked. Which ones apply to you depends on your activities and where you operate, so treat this as a list of questions to check, not a list of legal duties.

Subscribe on YouTube@codingliquids

• Licences and permits: premises or event licences, alcohol or entertainment licences, music licences for playing recorded music, food business registration, signage or pavement permits, waste carrier registration.
• Insurance: public liability, employer's liability where required, buildings and contents, business interruption, trustees' or directors' liability, cyber cover, vehicle policies.
• Premises safety certificates: gas appliance safety checks, fixed electrical installation inspection, portable appliance testing, fire alarm and emergency lighting servicing, fire extinguisher servicing, lift or hoist inspections, legionella or water hygiene checks.
• People's certificates: first aid, food hygiene training, background checks for work with children or vulnerable adults, safeguarding training, driving licence checks.
• Other people's certificates: contractors' and hall hirers' insurance, suppliers' product safety or food safety documents, a caterer's hygiene rating.
• Digital and contracts: domain names, website security certificates, software subscriptions with notice periods, leases and service contracts with break dates.

Contracts overlap with a separate job, tracking renewal and notice dates in agreements you have signed; tracking contract renewals with AI covers that in depth, and the same register can hold both.

Use AI to find what you have forgotten

The hardest part of the first register is knowing what should be on it. An AI assistant is useful as a prompt for your memory, provided you treat its list as questions rather than answers. The hall's manager described the organisation's activities and asked for a checklist:

Our organisation runs: a cafe serving hot food, a hall hired out for classes and
children's parties (some hirers bring bouncy castles and caterers), a weekly youth club
for ages 11-16, and occasional evening events with a bar run by volunteers.
We operate in [JURISDICTION]. List the licences, insurance, inspections, certificates
and staff qualifications an organisation doing these things might need to track.
For each, say which activity triggers it and who usually issues or checks it.
Mark anything you are unsure applies in our jurisdiction as CHECK.

The illustrative reply ran to about 30 items. Most were already on her list, but four were not: a temporary event licence for evenings with a bar, which the volunteers had been assuming the premises licence covered; checks on the caterers' own food hygiene documents; an electrical safety check for hirers' bouncy castle blowers; and the lift in the hall, which had its own inspection that the building's owner arranged and nobody had seen a certificate for. The AI also listed two items that did not apply, including a licence for a type of entertainment the hall never runs. She checked each new item against the licensing office's published guidance, with the insurer and with the building's owner before adding it. That is the right order: AI widens the net, and people who know the rules decide what stays in it.

The register: one row per item

Use a spreadsheet, Microsoft Lists or Airtable. The columns matter more than the tool. An illustrative extract from the community hall's register:

Two columns do most of the work. Lead time is how long before expiry you must start, not a reminder setting; a licence that needs a 28-day public notice has a lead time of at least six weeks. Owner and deputy are people who can act, not job titles on an organisation chart. Add a "next action date" column that the sheet calculates as expiry minus lead time, and sort by it.

Let AI read certificates as they arrive

Most errors in a register come from typing dates in by hand. The easier route is to email or upload every new certificate to one place, and have an AI step read it. A chat assistant works for occasional documents; an automation with an AI step suits a steady flow, and AI document processing explains the options for scans and PDFs. The extraction prompt:

Read this certificate or policy document and return JSON with:
document_type, issued_to (exact name), issuer, reference_number,
issue_or_inspection_date, expiry_date, cover_or_scope (one line),
limit_or_sum_insured (if any), conditions_or_actions (anything the document says
must be done, e.g. remedial work), confidence.
Rules:
- Write dates as YYYY-MM-DD. If a date could be read two ways (04/05/2026), return
  both readings and set confidence to low.
- If no expiry date is printed but a validity period is ("valid for 12 months from
  inspection"), calculate it and say so in a note.
- If a value is not on the document, return null. Do not guess.

Illustrative output for the gas safety certificate:

{"document_type": "Gas appliance safety check record",
 "issued_to": "[previous hall committee name]",
 "issuer": "[engineer's company]", "reference_number": "GS-2291",
 "issue_or_inspection_date": "2025-11-03", "expiry_date": null,
 "note": "No expiry printed. If the check must be repeated every 12 months, next due 2026-11-03.",
 "conditions_or_actions": "Extractor fan in café kitchen flagged as 'at risk' - repair advised",
 "confidence": "medium"}

Three things in that output would have been missed by someone just copying a date into a spreadsheet. The certificate was issued to the old hall committee's name, not the community interest company that now runs the building, which could matter to an insurer. The document had no printed expiry, so the next due date depended on knowing the required interval. And it contained an action, the extractor fan repair, which went onto the register as its own item with a date. Check every extraction against the document before accepting it; the AI's job is to spot, not to sign off.

Reminder timing built around lead times

A single reminder a week before expiry is too late for most renewals. Base the schedule on the item type:

Three ways to send the reminders

1. Calendar events (simplest). For each item, a calendar event on the "next action date" with two alerts, in a shared calendar. Fine for up to about 15 items, poor at showing status.
2. Spreadsheet plus a daily automation. Zapier or Make runs every morning, finds rows where today matches a reminder point, and sends an email or team chat message to the owner with the item, the date and a link to the document folder. With Zapier, the daily read of the sheet and each message are tasks, which comes to well under 100 a month for a register this size; the Professional plan's 750 tasks is plenty, and Make's entry plan from about $9 a month is often cheaper. Adding AI steps to Zapier shows how to add the certificate reading to the same account.
3. A list tool with built-in automations. Microsoft Lists (with Power Automate) or Airtable can send reminders from date fields without a separate automation service, if you already use them.

The community hall used option 2 and pointed the reminders at a team chat channel as well as the owner, so that a missed email did not mean a missed renewal.

Escalate when nobody acts

Reminders fail quietly when the owner is busy, ill or on holiday. Add an escalation rule to the automation:

• At the last reminder point, if the status is not "Renewed", copy the deputy and the manager.
• On the expiry date, if still not renewed, set status to "Expired", message the whole management group, and trigger the stop rule for that item.
• Write the stop rule in the register itself. For the hall: no youth club session without a current background check for the lead; no bouncy castle booking without the hirer's insurance on file; no hot food service if the gas check has lapsed.

The stop rules are what make the calendar matter. A reminder that nobody acts on is just noise; a rule that stops the activity forces the renewal.

Chasing other people's certificates

Third-party documents are the most likely to lapse, because the other party has no reason to remember your deadline. The hall's original chase email, and the version AI helped rewrite:

Before: "Hi, can you send us your insurance please? Thanks."

After: "Hello, your booking for the hall on Saturday 14 November includes a bouncy castle, so we need a copy of your public liability insurance certificate covering that date before the booking can be confirmed. Please reply with the certificate by Friday 6 November. It needs to show your business name as on the booking, the policy dates, and the cover for inflatable equipment. Thank you."

The rewrite states the reason, the deadline, the consequence and exactly what the certificate must show, which cuts the replies that attach the wrong document. The automation sends it 30 days before the event, and again at 7 days if no certificate has arrived; when one does, the extraction step checks the name and dates match the booking. The same pattern suits any business collecting documents from customers; a grooming salon collecting vaccination records is a close cousin, covered in automating vaccination checks for a grooming salon.

An evidence folder you can find in a hurry

When an insurer, funder, licensing officer or inspector asks for a document, you want it in under a minute. Keep one compliance folder with a sub-folder per type, and name every file the same way: date, item, document type. For example: 2026-09-12_fire-alarm_service-certificate.pdf. Old certificates stay in an archive sub-folder rather than being overwritten, because you may be asked for the history. Link each register row to its folder.

The certificate that was filed but never entered

This is how the hall's near miss happened, and it is worth knowing because it is so ordinary. The fire alarm contractor serviced the system and left a paper certificate on the caretaker's desk. The caretaker filed it. Nobody wrote the next due date anywhere, because the contractor "always rings to book". Then the contractor changed its booking system and stopped ringing. Four months after the next service was due, a small fire in the café kitchen was put out with an extinguisher, nobody was hurt, and the insurer's first question for the minor claim was for the most recent fire alarm service record.

The fix was a rule: every certificate, paper or digital, gets photographed or forwarded to the compliance inbox the day it arrives, where the extraction step reads it and adds the next due date. A paper certificate in a drawer is now the one thing the process does not accept. If you are unsure how cover and evidence interact, what business insurance covers when AI makes mistakes is a useful companion read on reading policy conditions.

What a toy shop and a small charity add to the register

• A toy shop collects suppliers' product safety test reports and declarations for the toys it sells, and tracks public liability, the annual card payment security questionnaire from its payment provider, and its trademark renewal. The supplier documents are third-party certificates and get the same chase routine as the hall's hirers.
• A small charity adds governance dates: the annual return to its charity regulator, trustees' annual declarations, safeguarding training renewals for staff and volunteers, and funder reporting deadlines, which are not compliance in the legal sense but cost money when missed. Staff and volunteer training dates fit better in a training matrix feeding the register; building a staff training matrix with AI covers that.

The 15-minute monthly review

Automation handles the reminders; a short review catches what automation cannot. On the first working Monday of each month, the manager spends 15 minutes on four questions:

1. What is due in the next 90 days, and has each owner started?
2. Is anything "Expired" or overdue, and is its stop rule being followed?
3. Have any new activities started that need a licence, certificate or insurance change? (The hall's new Saturday market needed its own check.)
4. Did every automation run this month? A reminder log with no entries for a month is a warning sign.

For the community hall, setting up the register took about four hours, most of it finding documents and dates. AI read 26 existing certificates in about 30 minutes, with another 40 minutes of checking. The ongoing cost is a free or low-cost automation plan and the monthly 15 minutes, which is considerably less than the cost of one lapsed policy.

Compliance calendar questions

Should expiry dates live in a calendar or a spreadsheet?

In a spreadsheet or list, with the calendar fed from it. A calendar shows dates but not the owner, the lead time, the document location or whether the renewal is done. With fewer than about 15 items, calendar events with two alerts each can work, but once you have third-party certificates and staff qualifications, a register with a status column is far easier to review.

How do I check a contractor's insurance certificate is genuine?

Check that the insured name matches the business you are hiring, the dates cover the work, the type of cover suits the job, and the limit meets what you require. If anything looks odd, contact the insurer or broker named on the certificate directly, using contact details you find yourself rather than those printed on the document, and ask them to confirm the policy is live.

What if a renewal date passes while the owner is away?

That is why the register needs a named deputy for each item and an escalation rule. Reminders go to the owner first, then copy the deputy and a manager if nothing has changed a week before the due date. For anything where a lapse would stop you trading or leave you uninsured, set the first reminder far enough out to survive a two-week holiday.

Further reads

• Fleet Admin for Small Businesses: Automate Services, Checks and Fuel — The same reminder approach for vehicle services and checks.
• AI Software Contracts: Auto-Renewals, Price Rises, Notice Periods — Catch software auto-renewals and notice periods before they bite.
• How to Write a Health and Safety Policy With AI and What to Check — Put your safety policy review on the same calendar.
• How to Stop Zapier and Make Automations Breaking Silently — Make sure your reminder automation is still running.
• AI Document Extraction vs Traditional OCR: Which Should You Use? — Choose the right way to read dates from scanned documents.
• Business Continuity Planning With AI: A Template for Small Firms — Plan for the day something lapses anyway.
• Nine Everyday AI Uses for Electricians Beyond Estimating — Nine electrician-specific jobs AI handles, from explaining inspection findings to landlords to logging intermittent faults, each with a worked example.
• How to Draft Risk Assessments With AI and What a Human Must Check — Feed AI the real facts of the job, get a structured first draft of hazards and controls, then run the human checks that make it safe to sign and use.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Zapier and Make pricing and task-counting pages; general compliance-tracking practice. Which licences and certificates apply depends on your activities and jurisdiction, so none are stated as legal requirements.