I’ve built a contract management process from nothing at two different companies. The first time, I had no budget, no tools, and a boss who thought “contract management” meant “make sure we don’t get sued.” The second time, I had a small budget and the benefit of knowing all the mistakes I’d made the first time around.

Both processes worked. Neither was perfect. And the lessons from building them were almost identical, even though the tools were completely different.

If you’re staring at a pile of contracts with no process in place, this is the post for you. Not the theoretical version. The “here’s what I actually did on day one” version.

The First Time: No Budget, No Software

The company was a mid-size professional services firm, about 150 employees. They had contracts with clients, vendors, landlords, insurance providers, and a few subcontractors. When I asked where the contracts lived, I got the answer I’d eventually learn to expect: everywhere and nowhere. Some were in a shared drive. Some were in email. Some were in a filing cabinet that a former office manager had maintained until she retired. A few were just… missing. Nobody knew how many active contracts the company had. My best guess, after two weeks of digging, was somewhere around 200.

My budget for fixing this was zero dollars.

Here’s what I did.

Week 1: Find everything. I sent an email to every department head asking them to forward me any contracts they had or knew about. I got about 60% of them this way. The rest came from searching shared drives (every folder that had “contract,” “agreement,” or “legal” in the name), going through the filing cabinet, and checking the company’s DocuSign account, which had a backlog of signed documents that had never been filed anywhere.

Week 2: Build the spreadsheet. I created a Google Sheet with columns for: counterparty name, contract type (vendor, client, lease, etc.), effective date, expiration date, auto-renewal (yes/no), notice period, annual value, and internal owner. For every contract I’d collected, I opened it, found those data points, and entered them. This was the most tedious part of the entire process. Two full days of reading contracts and typing dates into cells. Boring. Necessary.

Week 3: Set up alerts. Google Sheets doesn’t have built-in reminder functionality, so I used a workaround. I set up Google Calendar events for every contract with an expiration or renewal date. Each event was set to alert me 90 days before the date. For auto-renewing contracts, I set the alert based on the notice deadline, not the renewal date itself. This is an important distinction. If a contract auto-renews on December 31 and requires 60 days’ notice, your alert needs to fire by late September, not late November.

Week 4: Build the habit. Every Monday morning, I spent 15 minutes reviewing the spreadsheet. What’s coming up in the next 90 days? Does anyone need to make a decision? Is there a contract I haven’t assigned an owner to? This was the part that actually made the system work. Not the spreadsheet. Not the calendar. The weekly habit of looking at the data and acting on it.

What it cost: $0 and about three weeks of part-time effort.

What it did: Within the first month, I caught two contracts that were about to auto-renew for services we’d stopped using. Combined savings: roughly $35,000. I also identified three contracts where we had no signed copy on file, just email confirmations. We got those formalized before they became a problem.

Where it fell short: The spreadsheet was fragile. It depended entirely on me updating it. There was no full-text search across the actual documents, so if I needed to find every contract with a specific clause, I had to open them one by one. The Google Calendar alerts worked but were clunky. And when I needed to share information with finance or leadership, I was copy-pasting from a spreadsheet into emails, which felt unprofessional and was prone to errors.

The spreadsheet system got us through about 18 months. It was, genuinely, better than nothing. But “better than nothing” is a low bar, and I knew I’d want something more sustainable the next time around.

The Second Time: Small Budget, Real Tool

The second company was a similar size but had more contracts, maybe 350, and a leadership team that was slightly more aware of the problem. They’d been burned by a missed renewal the previous year (a facilities contract that auto-renewed for $45,000) and were open to investing in a solution. Not a big investment. Not an enterprise platform. Just something that worked.

I chose ContractSafe. I’d looked at it during my spreadsheet era and liked that it was priced for companies like mine, not for Fortune 500 legal departments. The unlimited user model meant I didn’t have to play the “who gets a seat” game, and the implementation didn’t require a consultant or a six-month timeline.

Here’s what I did.

Day 1: Upload everything. I gathered contracts from the same kinds of places (shared drives, email, a filing cabinet, an orphaned DocuSign account) and uploaded the entire batch into ContractSafe. The platform’s OCR ran automatically on every PDF, including scanned paper documents, making them all full-text searchable. By the end of day one, I could type a vendor’s name or a clause phrase into the search bar and find every contract that mentioned it. That capability alone was worth the switch from a spreadsheet.

Days 2-3: Log the critical dates. Just like the spreadsheet, I went through each contract and logged expiration dates, renewal dates, and notice periods. This time, ContractSafe’s automated alerts handled the reminder system. I set 90, 60, and 30-day alerts for every contract. The alerts went to me and to the assigned contract owner. No more Google Calendar workarounds.

Day 4: Set up access. Because of the unlimited user model, I could give read-only access to finance, procurement, and the leadership team without worrying about per-seat costs. This was a bigger deal than I expected. Suddenly, when the CFO wanted to know the total value of our vendor contracts, she could look it up herself instead of asking me to pull numbers from a spreadsheet. When an auditor needed to see a specific agreement, I could point them to the repository instead of digging through folders.

Day 5 onward: Build the process around the tool. With the repository in place, I built the same Monday morning habit I’d had before, but now it was faster and more reliable. I could pull up a dashboard view of everything renewing in the next 90 days without scrolling through spreadsheet rows. I could see which contracts had owners assigned and which didn’t. Over the next few weeks, I added workflow elements: every new contract gets uploaded to ContractSafe on the day it’s signed. Every contract over $10,000 in annual value gets an owner. Every auto-renewing contract gets 90-day alerts.

What it cost: A few thousand dollars a year. Far less than the $45,000 renewal that had prompted the investment in the first place.

What it did: Everything the spreadsheet did, faster and more reliably, plus full-text search across all documents, automated alerts that didn’t depend on my Google Calendar, access for multiple stakeholders, and audit-ready reporting. In the first quarter, I identified over $70,000 in potential savings from contracts that were either unnecessary, overpriced, or due for renegotiation.

Where it fell short: No system is perfect. The tool handles the repository and the dates, but it doesn’t manage the human side. Getting sales to actually submit contracts instead of leaving them in email is still a people problem, not a software problem. I still have to chase people for information. The tool just makes sure I know what to chase and when.

What Both Experiences Taught Me

Looking back, the core lessons were the same regardless of the tools:

Start with the contracts, not the process. Both times, my first move was to find and collect every contract the company had. Not design a process. Not evaluate platforms. Not build a taxonomy. Find the contracts. Everything else is built on that foundation. If you don’t know what you have, no process in the world will help you manage it.

Dates are the highest-priority data. If you only track one thing, track when your contracts expire or renew. That single data point prevents the most expensive category of mistake: the contract that costs you money because nobody was watching the calendar. I’ve written about this in the auto-renewal trap and the most expensive mistake that costs $0 to prevent. Dates first. Everything else second.

Every contract needs an owner. Not a department. A person. Someone whose name is attached to that contract and who gets the alerts. This was true with the spreadsheet and it’s true with ContractSafe. Unowned contracts are unmanaged contracts.

The habit matters more than the tool. My spreadsheet system worked for 18 months because I checked it every Monday. A $100,000 CLM platform will fail if nobody logs in. The weekly review is the engine. The tool is just the dashboard.

Start ugly. Improve later. My first spreadsheet was not pretty. My first ContractSafe setup wasn’t fully optimized. Both were functional within a week, and both got better over time as I refined the process. Waiting for the perfect system means waiting while your contracts go unmanaged. Your contracts are a mess, and that’s okay. Start where you are.

Which Approach Is Right for You?

If you have fewer than 50 contracts and no budget, a spreadsheet and a calendar will get you started. I mean that sincerely. The spreadsheet era wasn’t a failure. It was the right tool for the constraints I had, and it prevented real losses.

If you have more than 50 contracts, or you need multiple people to access the information, or you want full-text search across your documents, or you’re tired of maintaining a spreadsheet by hand, a purpose-built tool is worth the investment. Not because spreadsheets are bad. Because they don’t scale, and they depend on one person keeping them updated.

Either way, the process is the same: find your contracts, log your dates, assign your owners, and build the habit of checking.

That’s it. That’s the whole process. I’ve done it twice. It works.


I’m Dave, and I write about contract management the way it actually works. No jargon, no sales pitch, just what I’ve learned from 15+ years of doing this job. New posts every Tuesday and Thursday.


Leave a Reply

Your email address will not be published. Required fields are marked *