Contracts database
| Property | Type | Notes |
|---|---|---|
| Contract | Title | Name |
| Counterparty | Relation or text | Link to Parties or Clients |
| Matter | Relation | Optional |
| Stage | Status | Request, Drafting, Negotiation, Signature, Active, Expired, Terminated |
| Owner | Person | Responsible lawyer |
| Start date | Date | |
| End or renewal date | Date | |
| Notice period (days) | Number | Taken from the contract |
| Auto-renews | Checkbox | |
| Document | Files or URL | Link to the signed copy |
Formulas
Calculate the last day to give notice and the countdown to it:
- Notice by: `dateAdd(prop("End or renewal date"), -prop("Notice period (days)"), "days")`
- Days to notice: `dateBetween(prop("Notice by"), now(), "days")`
A label for views:
- Renewal flag: `if(and(prop("Auto-renews"), prop("Days to notice") <= 90), "Decide now", "")`
Notice clauses can count days, business days or require particular delivery methods. The formula assumes calendar days; adjust the notice period or add a manual override date when the contract says otherwise.
Views and workflow
- 1
Pipeline
Board grouped by Stage for contracts in progress.
- 2
Renewals
Calendar or table on Notice by, sorted ascending, filtered to Active.
- 3
Decide now
Filter Renewal flag is Decide now.
- 4
By counterparty
Group by Counterparty for relationship review.
For approvals, add a Reviewer person property and an Approved checkbox, and filter the pipeline on unapproved items.
What this does not do
Notion does not read contracts, extract clauses, collect e-signatures or keep an approval audit trail. Pair it with your document and signature tools, store the final PDF link in the row, and use the database as the tracking layer.
Frequently asked questions
- Can Notion replace a CLM product?
- For small volumes of tracking, often yes. For clause extraction, workflow approvals and e-signature, a dedicated product is better.
- Does LawyerOS include a contracts database?
- No. It has Matters and Deadlines (and more in Pro). This guide adds a Contracts database using the same patterns.
- Will Notion remind me of renewals?
- Yes through date property reminders in your own Notion notifications, not by sending email on your behalf.
- Are the formulas legal advice?
- No. They are arithmetic on dates you enter. Check what the contract actually says.
About the author
Raghav Handa trained as a lawyer, then spent years building legal technology, from enterprise legal products to custom systems for law firms.
Keep reading
- Practice managementEngagement letter and fee agreement tracker in NotionTrack engagement letters and fee agreements in Notion so no matter starts unsigned: statuses, fee basis, signed dates, review reminders and a chase view.3 min read · 17 October 2026
- Practice managementA legal CRM in Notion: contacts, referrals and follow-upsBuild a simple legal CRM in Notion: contacts, organisations, referral sources, follow-up dates and relationship views, linked to clients and matters.3 min read · 17 October 2026
- Practice managementLegal case management in Notion: a complete setupSet up legal case management in Notion step by step: cases, contacts, deadlines, tasks, documents, time and notes, with a case page template and key views.3 min read · 17 October 2026