Practical Applications of AI in Finance, Python and machine learning for FP&A
|
Hi Reader, Most finance teams don't have an AI problem. They have an integration problem. You can hand your team the best model on the market and it won't matter if that model is disconnected from your actual systems. You'll still be exporting CSVs, pasting numbers into a chat window, and manually re-uploading the "latest version" of a file three times a week. That's not an AI-ready stack — that's a chatbot with extra steps. An AI-ready finance stack is built in layers, from the ground up. Each layer depends on the one below it actually working. Skip a layer, and everything built on top of it inherits the gap. This newsletter walks through all five, in order, with what to actually do at each one — and where to go if you want to go deeper. Working through this alone? If you want a community of FP&A and finance people doing the same thing — swapping prompts, workflows, and what's actually working — join the AI Finance Club. Layer 0: Data — the coreBefore you touch a single AI tool, map out where your numbers actually live. For most finance teams, that means: your ERP, your general ledger, your CRM, your bank feeds, and — let's be honest — a folder of spreadsheets that nobody officially owns but everyone secretly depends on. The goal of this layer isn't to pick a tool. It's an audit. For each system, ask:
This is unglamorous work, and it's tempting to skip straight to "which AI tool should we buy." Don't. Every layer above this one is only as reliable as this audit is honest. Read more:
Layer 1: Connectors — the pipesThis is where "AI-assisted" turns into "AI-ready." If your AI tool only accepts file uploads, you're still doing the integration manually — the AI just helps you analyze the file after you've done the work of getting it there. A connector removes that step entirely, giving the AI tool direct, live access to a data source. In practice, this looks like:
The test for whether this layer is working: can someone ask a question and get an answer from current data, without anyone manually refreshing a file first? Read more:
Layer 2: OSS — One Source of TruthHere's the layer most AI rollouts quietly skip, and it's the one that determines whether the whole stack is trustworthy. If your AI tool is connected to five different systems that each define "revenue" slightly differently, you haven't solved your data problem — you've just given it a faster way to produce five different answers. Garbage in, garbage out still applies, and it applies faster with AI in the loop. Building a real single source of truth doesn't require a data warehouse on day one. It requires three things:
Start small. Pick one domain — revenue, headcount, whatever causes the most arguments in your monthly review — and get that one clean before expanding. Read more:
Layer 3: Playbooks & Context — the judgment layerThis is the layer most people building an "AI stack" don't know exists — and it's the difference between an AI tool that gives generic answers and one that reasons the way your team actually reasons. An AI model with access to clean data can tell you what the numbers are. It can't tell you why a 12% variance in Q3 marketing spend is fine but a 12% variance in COGS isn't unless someone tells it your team's actual judgment calls, definitions, and standard operating procedures. This layer includes:
In AI terms, this is sometimes called "context engineering" — deliberately curating what an AI tool sees, rather than assuming a bigger context window solves the problem on its own. More context isn't automatically better context. Read more:
Layer 4: AI — the apexThis is the layer everyone starts with, and it should be the layer you finish with. Claude, ChatGPT, Gemini, Copilot — the specific model matters less than what it's actually plugged into. A frontier model with no access to Layers 0 through 3 is still just a very articulate guess. The same model, sitting on top of clean data, live connectors, one source of truth, and your team's actual playbooks, is a genuinely different tool. Once the first four layers are in place, this layer is mostly about interface: where do people actually ask the questions? A chat panel embedded in your dashboard. An assistant inside your spreadsheet. A Slack bot pulling from live data. The point is to put the AI where the work already happens, not to create a new tab people have to remember to open. Read more:
The takeawayThe teams getting real value from AI in finance aren't the ones with the most tools. They're the ones with the fewest gaps between their tools. If you're starting from zero, don't start at Layer 4. Start at Layer 0 — go audit your actual data sources this week — and build up. Each layer you skip is a gap the one above it has to compensate for, and AI is not good at silently compensating for bad data. It's good at confidently reporting whatever you gave it. If you want a structured way to actually roll this out with your team, week by week: The Six-Week FP&A AI Adoption Plan — interactive guide. None of this has to be a solo project. If you'd rather build this alongside other FP&A and finance people doing the same work — sharing what's actually working, not just what sounds good in a demo — join the AI Finance Club. Thanks for reading and if you have any questions, let me know!! (and also congrats for reading the whole newsletter) This is an infographic I'll post next week on this btw, you get to see it first! Christian Martinez |
Practical Applications of AI in Finance, Python and machine learning for FP&A