Charles Leikauf shows fractional CFOs how to use ChatGPT to turn client PDFs, screenshots, and photos into populated Excel sheets in seconds. The AI extracts numbers, fixes formatting, normalizes dates, and strips identifying information, cutting out hours of manual data entry.
Chapters
If you're tired of spending your time manually going through Microsoft Excel, doing client analysis, and you're wondering, how can I offer fractional CFO services? Let me show you a whole bunch of different ways that you can use AI to do your work a hell of a lot faster and navigate some of the things that we absolutely hate. First thing is, you ever have clients that send you, say, a photo in WhatsApp or Slack or email or PDF financials, and you're like, oh my gosh, what am I even supposed to do to go through this? What, I'm going to type them all by hand? You can actually take that PDF, make sure you remove the client's name, screenshot it, put it into ChatGPT, and it'll spit back out in Microsoft Excel all the information that's there. And it puts the numbers automatically, it fixes the formatting issues, it fixes the dates. If you try and put 10/10, it immediately goes to October. It fixes all of that and removes the garbage text. And especially sometimes it's not really legible. So highly recommend that is you can take pictures and PDFs and turn them straight into Microsoft Excel.