|
Hello Reader, It's 4pm on the last Friday of the month. You need to finish the revenue forecast by the end of the day. The only thing missing is the contract terms for the three new deals. And Kevin, the only person who knows where everything is, just went on vacation. I know this because I have lived this. At my last company, we had two people maintaining two separate contract trackers. When either of them was out, we were stuck. Month-end close got delayed. The board got angry. And we looked incompetent because we could not find basic data in our own contracts. Here’s what I don’t like. You are spending probably 15+ hours per month on this, doing it manually. And you are still finding errors, and making adjustments all the time it feels like. What if I told you AI can do this in 15 minutes? Extract every payment term, every milestone, every renewal date from your contracts automatically. So when Kevin's away, you do not care. Here's how... The Bible ProblemIn my last company, we had something called ‘The Bible’ The place where we stored contract details (you might have a different name for this). What was worse. Every department had their own version of ‘The Bible’, and it drove us all mad. We were all tracking the same contracts, but everybody had different fields, different update schedules, and different versions of the truth. Sales cared about commission. Legal cared about termination clauses. Finance cared about payment terms and milestone schedules. So everyone just created their own tracker. And nobody talked to each other about it. This was painful for me, especially, because I am a numbers guy, and I like to see everything in one place. And this is the crazy part: Within Finance alone, we had TWO separate Bibles. One person maintained the sales and margin analysis tracker. Another person maintained the payment terms and milestones tracker. Different people needed different views, but, instead of figuring out one system, we just created another Excel file. Double the manual work. Double the chance of errors. Now, think about what happens when you need to close the books. You're trying to validate deferred revenue, confirm billing schedules, and reconcile customer balances. But first, you need to track down which version of which Excel file has the right information. Then you need to hope it's actually up to date. Then you need to cross-reference it with the actual PDF because you don't trust fully the manual entry. This is called manual contract administration, and it doesn't work. It's inefficient. And it will be completely unnecessary in 2026. And this isn't just an internal finance problem. WorldCC research shows that typical contract value leakage is 8.6% of contract value. This is not a rounding error. This is real money you are losing because nobody can find the payment terms, milestone triggers, or penalty clauses when they actually need them. AI Contract IntelligenceHere's the better way: You teach AI to read your contracts once, and then it reads every contract forever. Plus, you have a lot of options:
By the way, Maxio have released a new AI update that uses MCP (Model Context Protocol - more on this later) to execute tasks, like generating revenue schedules, detecting churn risk, and producing charts for board decks. You can read about this here. Whatever option you choose, it works because: AI doesn't get tired, doesn't make typos, and doesn't go on vacation. You give it a contract PDF, and it pulls out exactly what you need based on the instructions you give it. Think of it like that junior team member we always talk about, except this one can process 50 contracts in the time it takes you to drink your coffee. But really important to understand here: This isn't about replacing humans. It's about eliminating the manual, repetitive parts so your team can focus on the analysis and decision-making. AI extracts the data, you validate it, and then you use it. And the best part? Once you set this up, it scales. Whether you have 10 contracts or 10,000, the process is the same. Your AI Contract Intelligence RoadmapOkay, so how do you actually build this? Let me break it down into four steps you can start with this week. Step 1: Audit Your Current ContractsFirst, you need to understand what you're dealing with. Get a sample of 10-20 contracts and list out every data point your team currently tracks. Payment terms, milestones, renewal dates, termination clauses, etc. Then ask yourself: Where does this data live right now? Excel? CRM? Email? Kevin's brain? Write it all down. This gives you your baseline and shows you exactly what needs to be extracted. Step 2: Define Your Contract SchemaNow decide what data points you actually need AI to extract. Don't just copy everything from your current tracker—there's probably a lot of rubbish data in there. Ask yourself: "What information directly impacts revenue recognition, cash forecasting, or customer analysis?" Create a simple table: Data Point | Where It Lives Today | Where It Should Live | Priority (High/Medium/Low). Step 2.5: Create a Single Source of Truth for the Whole Company (Optional)Here, you have an opportunity to showcase your business partnering skills. Find out what other departments need. Add their high-value data points to your schema. Really quick - Ask Sales, Legal, Operations etc: "What contract data do you track manually right now?" Add those fields to your extraction. By doing this, you become the contract data owner for the entire company. One database that Sales, Legal, Operations, and Finance all trust. You have no more conflicting versions of the truth. And when you present this to leadership? You are saving not just Finance 30 hours per month. You are saving the company 100+ hours across all departments. This is the business case that gets you budget and a seat at the strategic table. Step 3: Test with Your Preferred LLM (Right Now)Before you build anything fancy, validate that AI can actually extract what you need. Take one contract PDF, upload it to ChatGPT, Copilot, Gemini, or Claude, and use this prompt: "Extract the following data points from this contract: [your list]. Return the results in a table format with columns: Data Point, Value, Page Reference." Did it work? Great. Did it miss something? Refine your prompt and try again. Spend 30 minutes on this. If AI can do it in a chat interface, it can do it at scale. And here's the key trick: Once you've got it working consistently, ask the AI: "Analyze our conversation and give me the system prompt I need to create this output consistently every time." Save that prompt. You're going to need it. This is my best kept secret that still nobody is using yet ;) Step 4: Build It Into Your WorkflowYou've validated that AI can extract your contract data. This is good. Now you need to decide how to integrate this into your actual process. You've got two routes: Path A: The Fastest Setup (No IT Required)This is about creating a repeatable extraction process using AI tools you can set up yourself in 30 minutes. Step-by-Step Setup: Option 1: Custom GPT (ChatGPT Plus or Enterprise)
Option 2: Gemini Gem (Google Workspace)
Option 3: Copilot Agent (Microsoft 365 Users) If you use Microsoft 365, this is your fastest automated setup.
Option 4: Claude with Projects + MCP
A note on MCP:
“Model Context Protocol (MCP) is an open standard developed by Anthropic, the company behind Claude. While it may sound technical, but the core idea is simple: give AI agents a consistent way to connect with tools, services, and data — no matter where they live or how they’re built.” - Edwin Lisowski You don’t need to understand the complexities of MCP when using Google Drive, or any connector. You just need to know what you can connect. Full list of Claude connectors here. This week, in the masterclass I was giving to the AI Finance Club members, one of the fractional CFO’s participating explained how after one training session, he connected Claude to all of his 25 years history of deliverables. Via the Claude MCP, he is using this now to make (and these are his words) “A client deliverable that would take a week in just a few hours.” Quick video on Quickbooks & Claude Below for you as well here: The Workflow:
Time per contract: 15 minutes instead of 90 minutes Where data lives: Your existing Excel or Google Sheets tracker (no new systems required) Path B: The Industrialized Route (Full Automation, IT Partnership Required)This is where you eliminate manual uploads entirely with workflow automation. Step-by-Step Setup: Microsoft Stack (Power Automate + Azure Document Intelligence)
Google Stack (Apps Script + Document AI)
Alternative: Zapier, Make.com or n8n (Platform Agnostic)
The Automated Workflow:
Time per contract: Zero ongoing manual work (after IT setup) Setup time: 2-4 weeks with IT What you show IT: "Here's my ChatGPT test showing 95% accuracy. We process 50 contracts/month at 45 minutes each = 37.5 hours/month saved. This pays for itself immediately." What This Actually Looks Like in PracticeThe company Honeywell integrated their contract, financial, and customer data systems. And now, they're projecting up to $50 million in working capital unlocked just from reducing cycle times. That's not ‘AI hype’, that's cash flow improvement you can take to the board. PKF O'Connor Davies implemented AI for data extraction from PDFs and reported 30-40% time savings per person, per day. Think about what your team could do with an extra 3 hours every day. Here’re some more use cases.
The Bottom LineYou remember when everyone decided that they were going to go paperless with all documents? Now we need to get to the point where we are ‘humanless’ when it comes to recalling information like this. For sure, a human needs to validate - But they don't need to waste hours they could be using becoming better business partners asking “what contract is this most up to date, and where is it?” Because (and this is super important) contracts touch everything. Revenue recognition, cash forecasting, customer analysis, compliance. All of it starts with contract data. And if that data is stuck in PDFs or living in Kevin's Excel file, you are missing a big opportunity with your revenue process. AI Contract Intelligence fixes this.
Your MoveSo here's what I want you to do this week: Take 30 minutes and find five contracts. Upload them to AI and test the extraction. See if AI can pull the payment terms, milestone schedules, and renewal dates accurately. If it works, you have just validated that you can eliminate manual contract administration. Then decide: Do you want the quick win with an AI chatbot processing your files? Do you want to use a dedicated tool like Maxio, or are you ready to go full automation with IT? You do not need a team of data scientists to make this work. You just need to be willing to stop doing things the hard way. And remember. You didn't become a finance leader to search for PDF contracts. This is your chance to get that time back (for you and your team) and build a faster, more accurate revenue process. Best, Your AI Finance Expert, Nicolas P.S. - What did you think of this newsletter? Did you find this useful and practical? Hit reply, and let me know (I read all replies) P.P.S. - We already have 2,000 confirmed guests for the biggest AI finance event on Tuesday; the seats are limited, so hurry up! |
Join 270,000+ Professionals and receive the best insights about Finance & AI. More than 1 million people follow me on social media. Join us today and get 5 goodies from me!
Sponsored by Maxio Want to learn how to create a financial forecast in 30 mins using AI? Join me for a free masterclass on the 6th November where I will provide tactical advice on how you can save time (and make better decisions) using AI to create amazing financial forecasts. Spaces are limited, so make sure to register on the link below now so you do not miss it. Register for the FREE Masterclass Hello hello! Let me tell you about the worst headcount planning meeting I ever sat through. It...
Sponsored by Maxio A big problem I see in finance teams is too much time spent on analysis and not enough time taking action. But, Maxio, a billing and financial reporting solution, is helping finance pros use AI - not just to analyse what’s happened - but to tell them how to produce better (more accurate) results. Click the link below, and keep scrolling to see the use cases. The ones on revenue recognition, churn and board reporting are really cool. Learn How to Make AI Actionable Hello...
Hi Reader, If you’ve already registered, amazing, I can’t wait to show you what I've prepared for this historic event. If not, let me ask you this: What’s one hour of your time worth… …if it shows you how to automate your reports, build a financial model, create a financial analysis or cohort analysis, clean your data, and save dozens of hours over the next month? That is $1000+ already saved for just one hour, and if you know that, then you don't need to think further... Get your free ticket...