Lightweight contract management system built in Excel for small teams
SaferSkills independently audited ContractHub (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
A lightweight contract management system built in Excel (.xlsm) for small teams and startups. Tracks supplier contracts, SaaS subscriptions, and client agreements with a live dashboard, 90-day expiry alerts, and a rolling cash flow forecast.
ContractHub_template.xlsmAlways save as.xlsm— saving as.xlsxremoves the VBA macro.
Excel locale note: The template was built on German Excel which uses;as the formula separator. If you're on English Excel and see formula errors after opening, simply re-enter the affected formulas using,instead of;. All formulas are documented inskill/SKILL.md.
Open the Suppliers sheet and add a new row at the bottom. Fill in:
| Column | Field | Format |
|---|---|---|
| A | Counterparty | Text |
| B | Type | supplier / saas / lease / hr / other |
| C | Netto | Number only (no € sign) |
| D | Brutto | Number only (no € sign) |
| E | Frequency | Monthly / Quarterly / Semi-annual / Annual / One-time |
| F | StartDate | DD.MM.YYYY |
| G | EndDate | DD.MM.YYYY (leave blank if open-ended) |
| H | NoticeDays | Number of days (e.g. 90) |
| I | AutoRenewal | Yes or No |
| L | Status | Active / Review / Terminate / Expired |
| M | Notes | Free text |
Important: Columns J, K, N contain formulas — copy them from the row above, never type manually.
After adding a row: click Refresh Dashboard → Ctrl+S → confirm SharePoint check-in.
| Status | Meaning |
|---|---|
| Active | Running normally |
| Review | Needs attention |
| Terminate | Cancellation in progress |
| Expired | Ended — excluded from all calculations |
The Forecast sheet shows expected monthly costs per contract. Change the number in cell B1 to set how many months to display (e.g. 6, 12, 18).
The skill/SKILL.md file contains a Claude skill for ContractHub. Install it in a Claude Project to get an AI assistant that already knows the full architecture, every formula, and how to troubleshoot common errors.
To set up the Claude Project:
ContractHub Assistantskill/SKILL.md into the project instructionsContractHub/
├── ContractHub_template.xlsm ← template with dummy data
├── docs/
│ └── ContractHub_QuickStartGuide.docx ← user guide
└── skill/
└── SKILL.md ← Claude AI skillMIT — free to use and adapt.
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.