Skip to main content
Back to cases
LegalWindows app

Contract Lifecycle Tracker

Central ledger for every contract. Auto reminders before expiry. Outstanding sends and counter-signatures surface instantly.

The problem

Legal teams track sends, counter-signatures, renewal dates, and terminations across many contracts. Information hides in email, chat, and spreadsheets. Things slip.

The solution approach

A local ledger. One card per contract: counterparty, type, amount, key dates, status. Auto-red flag 30 days before expiry; a dashboard surfaces anything stuck in "to send" or "awaiting counter-sign".

What you will end up with

  • Home shows contract cards filterable by status (Drafting / To send / Awaiting signature / Active / Expiring / Terminated).
  • Each card: counterparty, type, amount, signed date, expiry date, status.
  • Red 30 days before expiry, yellow at 60 days, green otherwise.
  • A "follow-up" view aggregates anything needing action — perfect for weekly review.
  • Bulk import from Excel. Export follow-ups to Excel.
  • Sensitive fields (amount, counterparties) have a visibility toggle to avoid accidental exposure during screen-sharing.

Ready-to-use prompt

You are a senior engineer experienced with Windows desktop apps. Build a local Windows tool for an in-house legal team. User is a non-developer.

[Goal]
Central ledger for all contracts. Track by status. Auto-remind before expiry. Nothing slips.

[Platform & Stack]
- Windows 10/11 desktop app
- Electron + React + TypeScript
- Local SQLite; offline; ship a Windows .exe installer

[Data Model]
Contract: id (auto), counterparty, type, amount, currency, signed date, effective date, expiry date, renewal cadence, owner, status, notes, attachment path (relative).

Statuses: Drafting, To send, Awaiting signature, Active, Expiring, Terminated.

[Core Features]
1. Home card list: filter by status; sort by expiry; left-edge status color band.
2. Create/edit form with clear required fields. Attachment field picks a local file; store relative path, do not copy.
3. Follow-up board: aggregates To-send, Awaiting-signature, and Expiring-within-30-days — weekly-review ready.
4. Rules (configurable): <=30 days red, <=60 days yellow, else green.
5. Excel import/export. Import headers: Counterparty / Type / Amount / Currency / Signed / Effective / Expiry / Status / Notes. Export follow-ups to Excel.
6. Privacy: toggle hide for sensitive fields (amount, counterparty) in list view. Nothing uploaded.
7. Search by id, counterparty, notes.

[Visual Style]
- Dashboard density with soft dividers.
- Muted status colors — no harsh reds.
- System fonts; bilingual toggle.
- Follows system dark mode.

[Robustness]
- Auto-recover DB from last backup.
- Friendly validation on required fields.
- Catch invalid date ranges with a gentle hint.

[Delivery]
1. Structure + wireframes for list, edit, follow-up board.
2. Phase 1: list + create. Phase 2: follow-up + auto-coloring. Phase 3: import/export + privacy toggle.
3. Package .exe; write a 500-word user guide.

Start with structure and wireframe.

After copying

1

Open Codex Desktop and create a new project

2

Paste the prompt and send

3

Wait for Codex to finish; tweak company names, column names, button text as needed