• Home
  • News
  • Fortune 500
  • Tech
  • Finance
  • 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
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

NewslettersMPW Daily
Female exec moves to watch this week, from Binance to Supergoop
By Emma HinchliffeDecember 5, 2025
3 days ago
NewslettersCFO Daily
Gen Z fears AI will upend careers. Can leaders change the narrative?
By Sheryl EstradaDecember 5, 2025
3 days ago
NewslettersTerm Sheet
Four key questions about OpenAI vs Google—the high-stakes tech matchup of 2026
By Alexei OreskovicDecember 5, 2025
3 days ago
Facebook CEO Mark Zuckerberg adjusts an avatar of himself during a company event in New York City on Thursday, Oct. 28, 2021. (Photo: Michael Nagle/Bloomberg/Getty Images)
NewslettersFortune Tech
Meta may unwind metaverse initiatives with layoffs
By Andrew NuscaDecember 5, 2025
3 days ago
Shuntaro Furukawa, president of Nintendo Co., speaks during a news conference in Osaka, Japan, on Thursday, April 25, 2019. Nintendo gave a double dose of disappointment by posting earnings below analyst estimates and signaled that it would not introduce a highly anticipated new model of the Switch game console at a June trade show. Photographer: Buddhika Weerasinghe/Bloomberg via Getty Images
NewslettersCEO Daily
Nintendo’s 98% staff retention rate means the average employee has been there 15 years
By Nicholas GordonDecember 5, 2025
3 days ago
AIEye on AI
Companies are increasingly falling victim to AI impersonation scams. This startup just raised $28M to stop deepfakes in real time
By Sharon GoldmanDecember 4, 2025
4 days ago

Most Popular

placeholder alt text
Real Estate
The 'Great Housing Reset' is coming: Income growth will outpace home-price growth in 2026, Redfin forecasts
By Nino PaoliDecember 6, 2025
2 days ago
placeholder alt text
AI
Nvidia CEO says data centers take about 3 years to construct in the U.S., while in China 'they can build a hospital in a weekend'
By Nino PaoliDecember 6, 2025
2 days ago
placeholder alt text
Economy
The most likely solution to the U.S. debt crisis is severe austerity triggered by a fiscal calamity, former White House economic adviser says
By Jason MaDecember 6, 2025
1 day ago
placeholder alt text
Economy
JPMorgan CEO Jamie Dimon says Europe has a 'real problem’
By Katherine Chiglinsky and BloombergDecember 6, 2025
1 day ago
placeholder alt text
Big Tech
Mark Zuckerberg rebranded Facebook for the metaverse. Four years and $70 billion in losses later, he’s moving on
By Eva RoytburgDecember 5, 2025
3 days ago
placeholder alt text
Politics
Supreme Court to reconsider a 90-year-old unanimous ruling that limits presidential power on removing heads of independent agencies
By Mark Sherman and The Associated PressDecember 7, 2025
16 hours ago
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.