Why you shouldn’t build your own contract database
What it takes to build your own contract database
Scroll to see the work ↓
A contract database looks simple.
Like a house, most of the work is underneath.
First, find them. Start with SharePoint.
Then everyone’s inbox.
Then Docusign.
Then Salesforce.
Then people’s laptops.
Found them all? You’ll never know.
Then drag them all into one place.
Now open a spreadsheet.
Log every file. By hand.
Signed? Active? Sometimes you can’t tell.
Keep or remove? Decide for each one.
Row 14 of 1,164. Keep going.
Files with the same names are already in Contracts - MASTER.
Now organise them.
A folder for every counterparty.
Group amendments and SOWs with their agreement.
Work out which document wins.
Then rename every file.
SOW 3 says its terms override the MSA. Amendment 1 says nothing overrides the MSA.
One contract, three folders? You need labels.
Agree them with every team.
Then apply them the same way, every time.
Then read every page.
Find each value. Type it in.
Some dates aren’t in the contract.
Decide what each field means.
Spot a problem? Log it. Chase it.
612 contracts, 10 fields. 6,120 values to check.
Order Form
This Order Form is made on 7 August 2024 between:
(1) ACME SUPPLY LIMITED, a company registered in England and Wales (company number 09284711) (the “Supplier”); and
(2) NORTHSTAR RETAIL LIMITED (the “Customer”).
1. Term
1.1 This Order Form continues for an initial term of thirty-six (36) months.
1.2 It then renews for successive periods of twelve (12) months unless either party gives not less than ninety (90) days’ written notice.
2. Charges
2.1 The Customer shall pay annual charges of £8,400 exclusive of VAT.
2.2 The Charges shall increase each year by the Retail Price Index (RPI) plus 3%.
Schedule 1: Pricing
Price adjustment: CPI plus 3%, capped at 6%.
3. Service levels
4. Liability
5. Data protection
Hi Tom, clause 2.2 says RPI but the order schedule says CPI. Do you know which one we agreed?
Sent Sent 12 days ago · No reply · 22 more issues openWrite down every rule.
And every exception.
Add one contract type. Rewrite six rules.
Then build somewhere for it all to live.
And decide who can see what.
Contract database blueprint
Where do the amendments go?
function saveAgreement(doc) { db.insert('agreements', doc); } function saveAmendment(doc) { // TODO } Last changed 14 months ago by the contractor who built it Then it never stops.
New contracts arrive every week.
Someone asks for a new field.
The person who built it leaves.
New starters. New tools. New questions.
Every month. Every year.
Do you have the time?
Do you know how?
Do you have the tools?
“Can’t AI just do it?”
It needs the same answers.
And someone has to check its work.
Happy to help. First I need you to tell me:
- Which of the 3,412 files are contracts?
- Which documents belong together, and which one wins?
- How should each agreement be named?
- Which labels, and who agreed them?
- Which fields do you need, and what does each one mean?
- How should the dates be calculated?
- What should I do when a contract is unclear?
- Who should be able to see what?
- What happens when new contracts arrive?
Done. Here are your agreements:
Option one: do it yourself.
Option two: use AI.
Option three: buy a heavyweight CLM.
All three leave the work with you.
Or let Nomio do it.
Every file renamed and grouped.
Every data point captured and verified.
A new amendment? Grouped and captured.
All your contracts.
Organised, accurate, and searchable, without lifting a finger.
Your Acme agreement renews on 7 August 2027. It needs 30 days’ notice, so give notice by 8 July 2027.
Source: Acme Supply Agreement.pdf, clause 12.1
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓
✓ “Nomio takes away all the manual effort that my team were spending.”

“We just upload a contract, the team at Nomio do all the stuff they do to get it into the database”

“Our contracts were saved on a SharePoint, if they were even saved. It was chaotic and not at all organised. Nomio has given me so much of my time back to do more valuable things.”

“Our spreadsheet was an incomplete database, details of some contracts and nothing on others. Now we sign, upload to Nomio, and that’s it.”

“Now in Nomio, we have the MSA and underneath we have all the statements of work, the orders, the addendums. You just need to type the customer you’re looking for and it’s super easy to know what agreements we have with them.”

“I’ve spent personally, weeks going through our contract, pulling out all of those contract obligations and deliverables, and yet Nomio did it in seconds.”

“That relied on us actually calculating the date correctly. It also relied on us remembering to upload the contract and update the spreadsheet in order to set that reminder. So it only solved half the problem.”

“If somebody leaves and somebody says, oh, well, Terry did that contract, I can get into Terry’s emails, but I have no idea what his foldering system was.”

“I just felt like I was constantly wasting time and I was a PA rather than a lawyer, and I wanted to be spending my time being a lawyer.”

“With all the AI in the world, including a human in that process is the difference. Nomio has been transformational. We get, instead of two weeks, answers in seconds. It’s fantastic.”

“Any question that you might ask of the whole portfolio was an exercise. It was a project.”

“I know I am looking at the right version of a document, and I know the summary is accurate because it is not just an AI tool. There is the human element too.”

“There aren’t really other providers that I’ve come across that are pure repositories like Nomio is. Most of them are CLMs, where there’s a lot of different features wrapped up together, one of which is being a repository.”

“We aimed for the moon and we didn’t even land in the stars. We crash-landed a quarter way there with a CLM. Nomio solved the problem for us very neatly.”

“I just gave Nomio access to our supplier folder within SharePoint, and they then did everything for me”

“We didn’t have to rename anything, we didn’t have to filter anything out. All of that was done for us.”

“If we have, let’s say, something that’s missing from an agreement, the team will flag it. I haven’t come across a tool that has both AI and then has a human being back up.”

“This customer signed over the weekend, and I’ve gone to upload it to Nomio and I found it’s already there because of our Docusign integration.”

“You effectively have to do nothing as a client, and it’s all being done for you.”

