Permit & Certificate Renewal Tracker: Never Miss a Compliance Deadline Again

The problem this kills

Every building runs on a stack of pieces of paper that expire: the elevator inspection certificate, the boiler and pressure-vessel report, the fire-alarm and sprinkler certification, the occupancy permit, the backflow-prevention test. Miss one and you're not just out of compliance — you can get a stop-work order, a failed insurance audit, a fine, or a shut-down elevator. The deadline doesn't care that it lived in a spreadsheet nobody opened since the last inspector visited.

Most facilities teams track this in a shared spreadsheet that goes stale, with reminders that live in one person's head. The expiry dates drift, the responsible owner changes jobs, the renewal PDF is buried in someone's email, and the first time anyone notices a certificate lapsed is when an inspector or auditor points at it. You don't need a six-figure compliance platform to fix this — and you don't need to be a developer.

What you'll build

A simple internal web tool. You import a list of permits and certificates — issuing authority, location, issue date, expiry date, responsible owner — and upload each certificate PDF to secure storage. The tool computes days-to-expiry for every certificate and shows a single expiring-soon board: a color-coded view of what's overdue, what's due in 30 days, 60 days, and 90 days. As each certificate crosses a threshold, it emails a tiered alert to the owner so the renewal starts in time, not in a panic. When a renewal is underway, your facilities manager reviews and approves the action and the new expiry date before anything is marked In-renewal or Renewed — so a fresh certificate date never goes on the record without a human sign-off. Everything lands on a compliance dashboard you can export to CSV for audits.

What's inside the Implementation Plan

The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — which certificate types you actually track, how your locations and buildings are named, where your renewal list lives today, who owns each renewal, your real alert lead times, and your messy edge cases — and then it tailors the data model, the alert tiers, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through the import, the PDF uploads, the days-to-expiry math, the tiered email alerts, the manager review-and-approve screen, and the dashboard plus CSV export — each step with a ready-to-copy prompt. There's also a fallback so you can build and run the whole thing today from a spreadsheet, with no integration to your existing system.

The governance it includes (this is the point)

This is real compliance tooling, so it ships with the controls a facilities team needs: login so only your team can use it, row-level security so you only ever see your own organization's certificates, a complete audit trail of who was alerted, who approved which renewal, and when, a hard human-approval gate so no certificate is marked In-renewal or Renewed and no new expiry date is recorded until your facilities manager signs off, and duplicate guards keyed on certificate type plus location so the same certificate can't be entered twice. An auditor asking "prove you knew this was expiring and acted on it" gets a clean answer.

Who it's for

Facilities managers, compliance coordinators, and building-operations leads who are personally on the hook when a certificate lapses. If you can describe which certificates your buildings need and who renews them, you can build this.

You've got this — start with the plan, paste the first prompt, answer the interview, and you'll see your expiring-soon board come to life the same afternoon.