Renewal Budget & Cost Forecast

The problem this kills

Renewal invoices show up when they show up. A certification lapses into its renewal window, an audit firm sends its annual quote, a software license auto-renews at a new price - and finance finds out when the bill lands. Nobody is hiding anything; the information just lives in a dozen places: a spreadsheet a compliance manager keeps, a calendar reminder, an email thread with a registrar, the memory of whoever owns each credential.

The result is a budget built on guesses. You either pad it heavily "to be safe" or you under-budget and spend the year explaining variances. Multi-year renewals make it worse - a three-year certificate paid once but "really" costs a third of that each year, and almost nobody spreads it correctly. Fee increases are an afterthought until they're a surprise.

This tool turns that scramble into a number finance can plan against: every renewal, every audit, every credential, laid out by month and by category, with the assumptions you couldn't confirm flagged out loud - and nothing reaches finance until a human has reviewed and approved it.

What you'll build

A small, private web app for your team:

• Import your licenses, certifications, audits, and credentials - with renewal dates and fees - from a CSV or Google Sheet, plus any expected fee changes.
• The agent builds a 12-month forecast: it places each renewal in the right month, spreads multi-year renewals correctly, rolls costs up by department and category, and flags every fee it had to assume rather than confirm.
• Compare to last year's actuals (if you provide them) so you can sanity-check the new number.
• A review screen where the compliance manager adjusts fees and timing, confirms the flagged assumptions, and sees the totals update.
• A human approval gate: nothing is "official" until the manager approves it.
• On approval, the app emails the forecast to finance via Resend and lets you export a clean CSV - both the month-by-month summary and the full line detail.

What's inside the Implementation Plan

• It starts by interviewing you about your business. Before it writes a single line of code, the plan has the AI agent ask you about your current renewal process, the spreadsheet or system your renewals live in, exactly how your data is named (item IDs, categories, departments), your typical and peak renewal months, your approval rules, and your messy edge cases. It reflects a short tailored spec back to you and waits for your thumbs-up. The tool you get fits your renewals - it is not a generic template.
• A clear definition of done so you know exactly what "finished" looks like.
• The exact stack, an architecture diagram in plain text, and a step-by-step build where every step ends with a ready-to-paste prompt for your AI coding agent.
• The forecasting logic spelled out: multi-year spreading, fee-assumption flags, duplicate guards, and a last-year-actuals comparison.
• A verification checklist and a no-integration fallback (CSV in, CSV out) so you can build the whole thing today even if you can't connect to your system of record yet.

The governance it includes (this is the point)

This isn't a spreadsheet with a nicer face. The plan builds in the controls finance and audit will ask about:

• Login so only your team can open the tool.
• Row-level security so each organization only ever sees its own renewals and forecast.
• A complete audit trail - who imported, who changed which fee, who approved, and when.
• A hard human-in-the-loop approval gate - the AI drafts the forecast, the compliance manager reviews and approves, and only then does it become the official budget input sent to finance.
• Duplicate guards keyed on item ID + renewal period, so the same renewal can't be counted twice.

Who it's for

Compliance managers and quality leads who own the renewals calendar, and the finance partners who have to turn it into a budget. If you've ever been surprised by a renewal invoice - or had to defend a budget variance you never saw coming - this one is for you.

You've got this. Paste the first prompt and let the interview tailor the tool to your renewals.