runbookify
← All plans
Facilities, Assets & IT Operations / IT Asset & License Tracking

SaaS Subscription Renewal & Spend Tracker: Never Auto-Renew a Dead Tool Again

Catalog every SaaS subscription with its owner, cost, billing cycle, and renewal date, compute the real cancel-by deadline, and alert the owner before auto-renewal — with the owner approving renew/cancel/renegotiate before any decision is recorded.

IntermediateA weekendBuilds onNext.jsSupabaseResend
What you'll build

A web tool where you import every SaaS subscription, the tool computes each renewal and cancel-by date, sends tiered alerts to the owner before auto-renewal, the owner approves a renew / renegotiate / cancel / downgrade decision, and the decision plus spend is recorded — with an annualized spend dashboard and CSV export.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.

Before you start

  • A Supabase account (free)
  • A Vercel account (free)
  • A Resend account (free)
  • A subscription list (CSV or Google Sheet)
  • Optional: contract / invoice PDFs
  • Claude Code or any AI coding agent

The problem this kills

Somewhere in your company, a tool nobody uses is about to auto-renew for another year. Nobody flagged it, because the renewal date lived in a vendor's billing system, the contract's 60-day notice window quietly closed last week, and the person who bought it left in March. The charge hits the card, finance shrugs, and you've just re-bought shelfware for the third year running.

SaaS sprawl is death by a thousand auto-renewals. Subscriptions are scattered across cards, departments, and inboxes; the real deadline isn't the renewal date but the cancel-by date hidden in the notice period; and no single person can see what you're actually spending per owner or per department. You don't need a six-figure SaaS-management platform to fix this, and you don't need to be a developer.

What you'll build

A simple internal web tool. You import your subscription list — vendor, product, cost, billing cycle, renewal date, notice period, owner, auto-renew flag — and optionally attach contract or invoice PDFs. The tool dedupes on vendor+product, computes each subscription's next renewal date and the cancel-by deadline (renewal date minus the notice period — the date that actually matters), and rolls up annualized spend by owner and department. It flags the dangerous combinations: auto-renew with no owner, big spend with a closing notice window, duplicates of the same tool bought twice.

As each cancel-by date approaches, the tool sends tiered alerts to the owner (early heads-up, then urgent, then last-call). The owner opens the renewal, reviews the cost and usage, and approves a decision — renew, renegotiate, cancel, or downgrade. Only then is the decision and its cancellation-by date recorded. A spend dashboard shows where the money goes, and you can export everything to CSV.

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 — how you track subscriptions today, where the list lives, exactly what your columns are named, how billing cycles and notice periods are written in your data, who the "owner" really is, your typical and peak subscription counts, and your messy edge cases (mid-term upgrades, multi-year deals, usage-based bills) — and then it tailors the data model, the date math, 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 renewal and cancel-by date math, the tiered alerts, the owner review-and-approve screen, the spend dashboard, and the CSV export — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no API to your billing systems.

The governance it includes (this is the point)

This is real money-on-the-line tooling, so it ships with the controls an ops and finance team needs: login so only your team can use it, row-level security so you only ever see your own organization's subscriptions, a complete audit trail of who decided what and when, a hard human-approval gate so no renewal decision or cancel-by date is recorded until the owner signs off, and duplicate guards keyed on vendor+product so the same tool can't be tracked — or silently re-bought — twice. Auto-renew subscriptions with no assigned owner are flagged loudly instead of slipping through.

Who it's for

IT and SaaS managers, finance and FP&A, procurement, and ops leaders fighting tool sprawl — anyone who has ever discovered a surprise renewal after the charge already hit. If you can describe how your company buys and renews software, you can build this.

You've got this — start with the plan, paste the first prompt, answer the interview, and you'll see your renewal calendar and spend rollup take shape the same afternoon.

Gated download

Enter your email — the plan downloads instantly and a copy lands in your inbox.

By submitting your email you'll also receive the weekly runbookify newsletter. You can unsubscribe at any time.