Imagine being able to turn 4 hours of tedious financial analysis into just a few short minutes, all while uncovering valuable insights you never knew were possible. For those in accounting and finance who often find themselves overwhelmed by spreadsheets and manual reports, this isn’t just a pipe dream—it’s becoming a reality today.
On a recent episode of my Earmark Podcast, I had a great conversation with Nicolas Boucher, who focuses on how artificial intelligence can be used in accounting and finance. We discussed how AI is no longer just a topic of theories and ideas; instead, it’s becoming a valuable tool that is changing the way people in finance do their jobs every day.
The Growing Adoption of AI in Accounting
The accounting field is undergoing a big change with the use of AI. Nicolas notes that in the past, only about 20% of accountants used this technology, but now that number has grown to around 50%. This increasing adoption indicates that more accountants are starting to embrace AI in their work.
“Every three to six months there is a new phase of adoption,” Nicolas explained to me. “Two years ago, almost nobody was using it… then six months after, you had 20-30% of people starting to use it for emails, but then the technologists started using it for financial analysis.”
This adoption happens in waves, with each new phase bringing more sophisticated applications. While early adopters began with simple tasks like drafting emails, many are now creating custom AI agents and analyzing complex financial data.
Practical Examples of AI in Financial Analysis
Cohort Analysis for SaaS Businesses
Nicolas demonstrated how a SaaS business cohort analysis—typically used to track customer retention rates over time—can be transformed from a 3-4 hour task into a minutes-long process.
By uploading a simple dataset with dates, customer IDs, products, and invoice amounts to ChatGPT with a brief prompt to “do a cohort analysis visually,” he produced a sophisticated heatmap visualization showing retention rates across different customer cohorts.
“If you never did it [manually], you will probably need one day because you will have so much trial and error,” Nicolas noted, highlighting the dramatic time savings.
Salary Distribution Analysis Using Box Plots
Perhaps even more valuable than time savings is AI’s ability to suggest visualization techniques that many finance professionals may never have considered. Nicolas shared a powerful example of ChatGPT suggesting using box plots for salary distribution analysis—a visualization method he hadn’t applied despite 15 years in finance.
“The first time I saw the output of the analysis of salaries… I was like, wow. This is actually the best way to show a distribution of salary. After 15 years of finance, I never used that,” Nicolas recalled.
The box plot clearly displayed salary ranges across departments, showing minimum, maximum, and outlier values in a way that averages alone could never reveal. This discovery was so impactful that Nicolas thought, “This is going to change all our lives.”
Automated Financial Reporting
Nicolas also demonstrated a tool called Concourse.io that connects directly with QuickBooks Online and NetSuite to automatically generate comprehensive financial reports.
The tool automatically generates a complete report with executive summaries, revenue analysis, cost analysis, and customizable sections—all with both narrative commentary and visualizations.
Overcoming Implementation Challenges
While AI’s potential for finance is clear, many accounting professionals have hesitated to adopt these tools due to four key concerns:
- Data confidentiality: Uploading sensitive financial information to third-party AI platforms
- Auditability: Verifying AI calculations and tracing how results were generated
- Processing limitations: Most AI tools cannot handle large financial datasets
- Scalability: The inefficiency of repeatedly prompting AI for the same analysis
Solutions for Data Security and Auditability
Nicolas demonstrated an ingenious workaround that addresses these concerns. After using ChatGPT to generate a visualization, he asks it to provide the underlying Python code that created the chart. He then copies this code to Google Colab, a free browser-based tool from Google that allows users to run Python code.
“Now it solves the confidentiality of data because you are not in ChatGPT, you are inside your Google environment,” Nicolas explained. “And for auditability, here I can see the source… It’s not random. It’s not like a black box. You can see all of it.”
For professionals who aren’t comfortable with code, Nicolas showed how to implement AI-suggested techniques directly in Excel. For example, after discovering box plots, he asked ChatGPT to provide step-by-step instructions for creating these visualizations in Excel using the “Box and Whiskers” chart option.
Ensuring Proper Data Protection
When selecting AI tools, Nicolas emphasized the importance of proper data security:
“Make sure your team is using it without fear of data security. These tools use the best standards in terms of data security. If you sign a contract with them, you can read the data security protocol and make sure you opt out for data training, which is normally standard.”
For those using ChatGPT, he recommends the Teams account, which has data protection built in, rather than the Pro account, which requires explicit opt-out of data training.
The Evolving Role of Finance Professionals
As artificial intelligence changes how we handle financial analysis, the work of finance professionals is also changing. Instead of taking away jobs, these new tools help professionals focus on more important tasks that add greater value.
“Instead of spending a week with five people building a report, it’s just going to be 30 minutes of work. Then you can reinvest that time analyzing which vendors are good or bad, and working with procurement to make some savings,” Nicolas explained.
This shift addresses a long-standing aspiration in finance. “We talk a lot about business partnering and adding value. But when people are behind their Excel files, they cannot do a lot of this,” Nicolas pointed out. AI tools free finance professionals from the technical burden of report creation, allowing them to focus on strategic interpretation.
The evolution comes at an opportune time for the profession, which faces staffing challenges. “You have less people coming into accounting jobs. You have many people retiring. The turnover is really high,” Nicolas noted.
Organizations that adopt AI tools not only improve efficiency but also enhance their appeal to potential employees by offering more meaningful work.
Getting Started with AI in Finance
When selecting AI tools, Nicolas advised focusing on integration with existing systems:
“If you are already embedded in Microsoft—you use Outlook, SharePoint, Power BI, Azure—it makes sense to go with Copilot,” he explained. Similarly, organizations using Google’s ecosystem should consider Gemini. For smaller organizations without specific ecosystem requirements, ChatGPT provides a flexible solution.
For those looking to develop AI skills, Nicolas recommends following experts on platforms like LinkedIn and YouTube. “It’s crazy to see how much people can learn and implement in just two hours of training,” he says.
He also created a community called the AI Finance Club, where finance professionals can stay current on AI developments. “Every week we provide the most important content in the form of guides, masterclasses, or video courses where experts teach the best ways to use AI for finance.”
From Spreadsheet Specialists to Strategic Advisors
This isn’t just about getting new tools; it’s about a complete shift in how financial experts provide value to their companies.
These technologies are not just about saving time; they actually improve the quality of analysis while keeping data safe and accurate. Incorporating AI doesn’t mean losing control or risking the quality of data.
The professionals who will do well in this new environment won’t necessarily be the ones who are great at coding or become technology experts. Instead, success will come to those who know how to use these tools wisely—making good decisions while letting AI take care of routine tasks in financial analysis.
This change opens up a real opportunity to fulfill the promise of being strategic partners in business, a goal finance professionals have talked about for years. When they are free from making basic reports, finance experts can focus on analyzing insights and providing the valuable guidance that truly drives business success.
Did you find this article helpful? Listen to my full conversation with Nicolas Boucher on the Earmark Podcast for more practical examples and step-by-step guidance on using AI for financial analysis. Plus, you can earn free CPE for listening to the episode or watching the video with the Earmark app.