Paul BarnhurstFP&A Expert Empowering Finance Professionals to Excel Everday

AI fixes your messy chart of accounts.

16 Apr 2026 · 1 min

Watch on YouTube

0:32

In this brief talk, the speaker explains an AI tool they built to automatically map and organize a company's chart of accounts. The system handles about 90% of the mapping work, giving a solid foundation for downstream reporting and financial modeling while removing the need for manual VLOOKUP tables. The speaker also notes practical challenges, such as new accounts being added without notice, and discusses the need to find natural points in a CFO’s workflow where the AI can be integrated.

Chapters

One of the first AI tools I built into my application was a chart of accounts mapping and organizer. And as with most AI tools, it's not perfect, but it'll get you 90% of the way there. Like, all right, it did a pretty good job. Now I have this foundation for the company. I can go and do my reporting, do my modeling, everything else, and I'm not having to manage the VLOOKUP table. And inevitably somebody adds an account, didn't tell me, and oh crap, I've got to fix that. I've tried to find kind of like point areas in this sort of natural progression of a CFO engagement where I could start hooking things in.