• Home
  • Latest
  • Fortune 500
  • Finance
  • Tech
  • Leadership
  • Lifestyle
  • Rankings
  • Multimedia
NewslettersCFO Daily

A startup CFO used ChatGPT to build an FP&A tool—here’s how it went

Sheryl Estrada
By
Sheryl Estrada
Sheryl Estrada
Senior Writer and author of CFO Daily
Down Arrow Button Icon
March 1, 2023, 6:51 AM ET
The text software ChatGPT. Man typing on a computer.
Frank Rumpenhorst—picture alliance/Getty Images

Good morning,

There’s been an ongoing debate over OpenAI’s ChatGPT, from its inaccuracies to some banks banning it to those who believe generative A.I. is part of the future of finance. One CFO set out to prove the value of the technology.  

“The amazing thing with these large language models like ChatGPT is they can take plain natural language queries and respond to them as a person would,” says Glenn Hopper, a startup CFO for more than 20 years at primarily private equity-backed companies, and a financial consultant. He’s also the author of Deep Finance.

I sat down with Hopper to discuss his project, “Application of ChatGPT to Build an FP&A Tool,” which resulted in 30 pages of documentation. “I consider myself a tech evangelist,” Hopper tells me. “I actually just registered the domain name Robo.CFO.AI.”

Glenn Hopper

Hopper says he understands the vital role that financial planning and analysis professionals play in the CFO organization. 

“I guess I had two purposes with it,” Hopper explains. “One was to show finance people, ‘Hey, we’ve all been clamoring for tools like this.’” Tech like ChatGPT not only can respond in natural language, but it could also write code, he says. “I think most FP&A people probably can write SQL (structured query language) queries at this point, and they have data science skills,” Hopper says. “But they’re not developers.”

The second purpose of the project was to create a “proof of concept,” so they could show the developers of their company and say, “‘Look, here’s what we could do, and these are the advantages if we could do it,” Hopper says. 

What was the process? “I took three years of financial statements from a fictional company and prompted ChatGPT to write code that would import those financial statements into database tables,” Hopper explains. In analyzing the data, he wanted to reflect on the process of “when you do the close, and you start comparing your performance to budget and your performance to the prior month or the year before,” for example. So, he created key metrics. 

“When I realized I wouldn’t be able to get ChatGPT to query the data directly, I had it write code that created a chatbot that let users ask questions in natural language about the data,” he says.

“The bot will respond to your queries as if you were talking to an analyst. You can get information from the tables without having to write SQL queries. You can just say, “Hey, what were our sales in June?’ And then it just spits out the response for that.”

“I wanted to show that this is a new tool we have in our arsenal,” says Hopper, a U.S. Navy veteran who earned a master’s degree at Harvard. “We can start building stuff like this.”

Building a case for finance tech

Exploring the capabilities of ChatGPT derived from the mindset Hopper had for most of his career—building a case for finance tech tools. 

 “My background has been in small and mid-size enterprises where we really don’t have much of a finance department at all.” Over the years, he’s relied on tech to help fill in the gaps.

“What I’ve done in the past, is go build something out as a proof of concept, and then hand it over to the development team when I do my report request, to show what the tool could do and how it would benefit the company,” Hopper says. 

Spending his career at private-equity-backed companies has taught him to act fast. Private equity portfolio company CFOs “don’t play wait and see,” according to recent McKinsey research. It’s typically just a five-to-seven-year period in which a PE CFO has to create and manage through a value creation plan, according to the research.

Hopper thinks generative A.I. and machine learning can be especially helpful for FP&A teams at small and mid-size companies. “FP&A teams in small companies are often overwhelmed by the number of reports that are required to effectively measure business performance,” Hopper says. “Tracking down the data required to compile these reports can be time consuming if the data is not readily accessible. And they usually don’t have access to nearly as much data as larger enterprises would so they can’t provide as much detail as would be available to larger companies.”

He continues, “If an A.I.-as-a-Service company came along that could consolidate (and anonymize) industry data from multiple companies, they could train algorithms on that larger dataset and make the algorithms available to their clients.”

We’re still in the early innings of generative A.I. as it pertains to finance, so I’m sure the debate will continue.


See you tomorrow.

Sheryl Estrada
sheryl.estrada@fortune.com

Sign up here to receive CFO Daily weekday mornings in your inbox.

Big deal

Accenture's recent cloud continuum report details the status of cloud migration across the world’s businesses. The findings are placed on a global survey of about 4,000 global business and IT leaders. Sixty-five percent of respondents saw up to 10% in cost savings, on average, from moving to the cloud. But some companies experienced obstacles to cloud adoption such as changing business and operating models (42%), security risk (42%), misalignment between IT and business (35%), legacy infrastructure (34%), and complying with regulations (32%). The findings also point to the benefits of investing in cloud technologies. "Those that are advancing their cloud engagements are leading—and even shaping—their industry transformations and pulling farther ahead of their competitors," according to the report.

Courtesy of Accenture

Going deeper

The Economist launched on Tuesday a new guide of economic terms called the "A to Z of economics." Economic terms, from “absolute advantage” to “zero-sum games" are explained in plain English. A useful guide to share with team members who may just be starting their finance careers. 

Leaderboard

Kevin Coveney was named CFO at Enveric Biosciences (Nasdaq: ENVB), a biotechnology company, effective March 13. Coveney brings more than 30 years of experience. He joins Enveric after serving as a fractional CFO to emerging life science and digital health companies, such as Progressive Therapeutics, Power of Patients, and VSI. Previously, Coveney was CFO of Memgen, Inc., and CFO of Q-State Biosciences. Before that, he was SVP of finance, HR, and IT at Vedanta Biosciences. Coveney has also held senior positions at several global accounting firms, including Grant Thornton, Marcum, Deloitte & Touche, BDO Seidman, and Ernst & Young.

Matt Malek was named CFO at Interactions, a provider of intelligent virtual assistant solutions that assimilate conversational artificial intelligence. Malek has 20 years of financial experience. Most recently, he served as COO and CFO at GenVault and DocuVault. Malek brings expertise in all aspects of business leadership—including strategy development and planning—to his new role. He will help deliver Interactions’ next phase of growth as the company "meets the rapidly rising demand for A.I.-powered customer experiences," according to the announcement.

Overheard

“In 58 years of Berkshire management, most of my capital-allocation decisions have been no better than so-so. In some cases, also, bad moves by me have been rescued by very large doses of luck.”

—Warren Buffett, CEO of Berkshire Hathaway, wrote in his annual letter to the shareholders. One of the most well-respected investors in the world, 92-year-old Buffett offered a bit of retrospective analysis, writing that his “satisfactory results” since 1965 are mostly due to a dozen or so great investments in companies like Coca-Cola and American Express, Fortune reported. 

This is the web version of CFO Daily, a newsletter on the trends and individuals shaping corporate finance. Sign up to get CFO Daily delivered free to your inbox.
About the Author
Sheryl Estrada
By Sheryl EstradaSenior Writer and author of CFO Daily
LinkedIn iconTwitter icon

Sheryl Estrada is a senior writer at Fortune, where she covers the corporate finance industry, Wall Street, and corporate leadership. She also authors CFO Daily.

See full bioRight Arrow Button Icon

Latest in Newsletters

Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025

Most Popular

Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Finance
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam
By Fortune Editors
October 20, 2025
Rankings
  • 100 Best Companies
  • Fortune 500
  • Global 500
  • Fortune 500 Europe
  • Most Powerful Women
  • Future 50
  • World’s Most Admired Companies
  • See All Rankings
Sections
  • Finance
  • Leadership
  • Success
  • Tech
  • Asia
  • Europe
  • Environment
  • Fortune Crypto
  • Health
  • Retail
  • Lifestyle
  • Politics
  • Newsletters
  • Magazine
  • Features
  • Commentary
  • Mpw
  • CEO Initiative
  • Conferences
  • Personal Finance
  • Education
Customer Support
  • Frequently Asked Questions
  • Customer Service Portal
  • Privacy Policy
  • Terms Of Use
  • Single Issues For Purchase
  • International Print
Commercial Services
  • Advertising
  • Fortune Brand Studio
  • Fortune Analytics
  • Fortune Conferences
  • Business Development
About Us
  • About Us
  • Editorial Calendar
  • Press Center
  • Work At Fortune
  • Diversity And Inclusion
  • Terms And Conditions
  • Site Map

© 2025 Fortune Media IP Limited. All Rights Reserved. Use of this site constitutes acceptance of our Terms of Use and Privacy Policy | CA Notice at Collection and Privacy Notice | Do Not Sell/Share My Personal Information
FORTUNE is a trademark of Fortune Media IP Limited, registered in the U.S. and other countries. FORTUNE may receive compensation for some links to products and services on this website. Offers may be subject to change without notice.


Latest in Newsletters

NewslettersMPW Daily
Your predictions for women, AI, and the workplace in 2026
By Emma HinchliffeDecember 24, 2025
4 days ago
Vanguard CIO Nitin Tandon.
NewslettersCIO Intelligence
How investment giant Vanguard’s CIO is placing big tech bets today to create the AI digital advisor of tomorrow
By John KellDecember 24, 2025
4 days ago
NewslettersCFO Daily
How AI is redefining finance leadership: ‘There has never been a more exciting time to be a CFO’
By Sheryl EstradaDecember 24, 2025
4 days ago
NewslettersCEO Daily
Expedia CEO Ariane Gorin on the fight to ensure AI doesn’t turn her brands into invisible pipes consumers never see
By Diane BradyDecember 24, 2025
4 days ago
NewslettersTerm Sheet
The AI startups founders and VCs say could be acquisition targets in 2026
By Allie GarfinkleDecember 24, 2025
4 days ago
Thierry Breton, former European Commissioner for the Internal Market, in Paris on June 13, 2025. (Photo: Thomas Samson/AFP/Getty Images)
NewslettersFortune Tech
U.S. denies visas for five Europeans, alleging American censorship
By Andrew NuscaDecember 24, 2025
4 days ago

Most Popular

placeholder alt text
Retail
Trump just declared December 26th a national holiday. What's open and closed?
By Dave SmithDecember 26, 2025
2 days ago
placeholder alt text
Success
As millions of Gen Zers face unemployment, CEOs of Amazon, Walmart, and McDonald's say opportunity is still there—if you have the right mindset
By Preston ForeDecember 26, 2025
2 days ago
placeholder alt text
Future of Work
Malcolm Gladwell tells young people if they want a STEM degree, 'don’t go to Harvard.' You may end up at the bottom of your class and drop out
By Sasha RogelbergDecember 27, 2025
1 day ago
placeholder alt text
Europe
Christmas 500 years ago was a drunken 6-week feast that may have been considerably better than the modern holiday, medieval historian says
By Bobbi Sutherland and The ConversationDecember 25, 2025
3 days ago
placeholder alt text
Success
Billionaire philanthropy's growing divide: Mark Zuckerberg stops funding immigration reform as MacKenzie Scott doubles down on DEI
By Ashley LutzDecember 22, 2025
6 days ago
placeholder alt text
Commentary
Why over 80% of America's top CEOs think Trump would be wrong not to pick Chris Waller for Fed chair
By Jeffrey Sonnenfeld and Steven TianDecember 27, 2025
23 hours ago