AI in Finance
Analysis: Finance Teams Are Using AI Inside Excel—Not Instead of It
New Vena data: 86% of finance teams use AI inside Excel, and those AI users are twice as likely to expect Excel reliance to grow. See all of the findings.
Finance teams are being asked to move faster than their fragmented data allows. Boards want more frequent forecasts, and business units want answers the same week they ask a question, if not the same day. And to top things off, AI has landed in the finance tech stack fast enough that most CFOs now carry a formal mandate to use it.
Against this backdrop, two forces are shaping financial planning and analysis (FP&A) heading into 2027. AI has moved from pilot projects into daily workflows at a pace faster than anybody could have predicted, and finance teams are pushing hard for a bigger role in setting strategy rather than just reporting on it.
The FP&A statistics below pull from Vena’s 2026 FP&A Impact Report, which surveyed 431 finance professionals, along with other key industry research from AFP, Gartner and more. Together, they paint a picture of the current state of FP&A careers, AI adoption and technology challenges.
Hiring patterns are a decent leading indicator for where a function is headed. Right now, employers are paying up for finance professionals who know their way around technology, not just the general ledger, and the roles being created inside FP&A teams tell the same story.
1. Financial managers, the category that covers controllers, finance directors and CFOs, earned a median wage of $166,570 in May 2025.4 (The U.S. Bureau of Labor Statistics folds chief financial officers into the broader “financial managers” category rather than tracking them separately.)
2. Employment of financial managers is projected to rise 10% between 2025 and 2035, with roughly 65,600 openings each year over the decade.4
3. Financial and investment analysts earned a median of $102,740 in May 2025.5
4. Financial analyst roles are projected to grow 7% through 2035, adding about 29,500 openings a year.5

5. Nearly nine in 10 finance and accounting leaders (87%) say they pay more for candidates with specialized skills in financial reporting, data analytics, financial modeling, and ERP software.6
6. Unemployment among accounting professionals sits between 1% and 2%, meaning which means most qualified candidates already have jobs.7
7. In a mid-2026 survey, 74% of finance and accounting hiring managers planned to increase permanent hiring in the second half of 2026, one of the highest rates of any specialization.8
8. The most common new roles being created inside FP&A teams are Financial Systems Manager and Enterprise Performance Management (EPM) Architect, at 40%, followed by FP&A Data Scientist and FP&A Analytics Manager, both at 32%.1
9. Generative AI is the single biggest missing skill in finance teams, named by 56% of senior finance leaders, while just 8% describe their organization as very well prepared to manage the AI trend.9
While technical hires appear to be in demand to support building the models and systems, someone still has to explain what the numbers mean to the broader business. And that requires both communication and reliable judgment.
As we uncovered in our 2026 FP&A Impact Report, finance teams believe they’re already strong strategic partners to the rest of the business. Their executives, by and large, don’t see it that way yet.
The distance between those two views of the role of FP&A was a consistent finding in both our research and external studies, and it’s held steady even as finance has taken on more responsibility across the business.
10. 61% of finance teams say their executive leadership views FP&A as either a transactional reporting function or a reliable advisor on financials.1
11. Only 31% say executives see FP&A as strategic business partners, and just 9% say executives view them as critical drivers of growth.1
12. Meanwhile, 67% of finance professionals rate their own influence on the rest of the business as high or very high.1
13. In an EY survey of more than 1,600 CFOs and senior finance leaders across 28 countries, six in 10 said Finance should be involved in value creation. Only 27% said their organizations view Finance as a key partner in it.16
14. According to Grant Thornton, 44% of CFOs think their CEO sees them as a strategic partner, but only 32% of CEOs say they do.17
15. Just 12% of finance teams rate their FP&A maturity as “leading,” while 73% place themselves in the middle as “developing” or “established.”1
16. Across all maturity levels, only 24% say that the primary role of their FP&A team is to drive business insights and influence decisions. Among teams that rate themselves “leading,” that figure doubles to 49%.1
17. Finance professionals now spend 21% of their time on work outside traditional finance, including strategy, technology implementation, HR, and operations.3
The perception problem may be more about what the rest of the business sees finance do, which is largely reporting. Freeing up FP&A’s capacity to spend more time on business partnering can help bridge the gap.
Finance teams have named the same obstacle for two years running, we learned in our 2026 FP&A Impact Report, and it’s not headcount or budget. It’s data itself.
The numbers are hard to get and hard to trust, scattered across systems that don’t talk to each other. Many of the challenges uncovered in this post trace back here, and it’s the most persistent of all FP&A challenges teams report.
18. 58% of finance professionals name data quality or availability as a current bottleneck in their FP&A function, the top-cited answer.1
19. 28% of finance professionals rank data quality as their single biggest technology challenge, and 73% place it in their top three.1
20. Even among teams that rate their own FP&A maturity as “leading,” 64% still name data quality as a top bottleneck.1
21. Only 42% of finance teams report fully integrated, real-time connectivity between their FP&A tools and source systems like their ERP, CRM, HRIS and BI systems. Slightly more than half (51%) describe that integration as moderate or limited.1
22. 61% of FP&A practitioners cite a lack of reliable data as a technology challenge, and 60% cite a lack of accessible data.12
23. More than a third of organizations (36%) cite data quality as simultaneously their biggest barrier to AI value and their biggest opportunity from it.13
24. 52% of finance teams report revenue forecast variances greater than 6% against actuals, and 11% see variances above 10%.1
25. Retail fares worst for revenue forecast variances, with 21% of retail respondents reporting variances of 10% or more, nearly double the all-industry rate.1
26. Only 34% of organizations fully integrate operational drivers such as unit sales, SKUs, headcount and marketing spend into their forecasting and scenario models.1
27. In a 2026 Vena survey of 624 U.S. finance and accounting professionals, 78% said their team had to restate or correct numbers in the past year after the month-end close was already marked complete.2
28. 92% of teams pulling data for the month-end close from 7 to 8 separate systems restated numbers, compared with 57% of teams working from just one to two systems.2
29. 48% of finance teams plan to invest in improving data integration across systems over the next 12 months, making it the single most-cited investment priority.1
30. Among teams pulling financial close data from seven to eight systems, 52% spend half or more of their close time manually consolidating data. For teams working from one or two systems, that figure is 19%.²
The real cost of this data fragmentation shows up downstream: by the time an error is spotted, those numbers may already have made their way into board decks and cash decisions.
Finance teams already know where the fix lives, and they’re funding it: improving integration between systems ranks above every other planned investment (cited by 48% of respondents in our 2026 FP&A Impact Report survey).

Within a year, AI adoption in finance jumped from something most teams were just beginning to read about to something most teams were actively running. Every major survey we’ve uncovered points in the same direction.
31. 86% of finance teams now use AI for at least some of their financial operations, up from roughly 57% a year earlier.1
32. 70% of companies have a C-level mandate in place to use AI within the finance organization. Among teams with "leading" FP&A maturity, that rises to 89%.1
33. 34% of finance teams say they've fully integrated AI agents across FP&A, and another 16% have extended that integration into multiple areas of the business.1
34. Over the next 24 months, 37% of finance professionals expect AI agents to handle at least half of their FP&A workflows with human oversight reserved for exceptions.1
35. Active AI use across the finance function has risen from 30% in 2024 to 75% in 2026, more than doubling in two years.13
36. As of early 2026, 93% of North American CFOs say their organizations now use AI across key operations. In a CFO Signals survey in early 2024, 66% were still experimenting with it or just reading about it.11
37. 19% of CFOs say they personally hold the greatest responsibility for AI governance at their company, ranking themselves ahead of the CEO, the board, and the chief risk officer.11
38. 44% of CFOs say their finance function uses AI for financial planning and budgeting, and 41% use it to analyze financial data.11
Whether finance teams adopt AI is no longer in question. Whether it pays off is a different story, because the research is mixed.
Some surveys show leaders meeting their ROI targets, and others show few are seeing high returns. The answer depends heavily on what’s happening underneath the AI layer.

39. 71% of senior finance leaders say AI is meeting or exceeding ROI expectations in their finance function.13
40. Only 7% of finance leaders report high ROI from AI in their finance function, despite growing adoption, according to a Gartner survey of more than 200 finance leaders.18
41. The greatest reported improvements gained from AI are in decision-making speed (71%), decision quality (70%), and forecast accuracy (64%), all judgment-heavy areas rather than transactional ones.13
42. Organizations that can produce AI audit evidence efficiently report a 33% reduction in errors, versus 6% for those that can't. Confidence in scaling AI shows a similar split, 42% against 14%.13
43. Fewer than half of organizations (42%) have built comprehensive assurance systems for AI-driven financial processes.13
44. Balancing pressure to deploy AI quickly against the need to manage risk is the top governance challenge for CFOs, cited by 59%.11
45. Nearly 60% of CFOs plan to increase AI investment in the finance function by 10% or more, though 47% currently allocate only 1–5% of their finance technology spend to it.14
Effective governance is the variable that separates the finance teams that are gaining returns from their AI investments from those that aren’t.
Teams that can confidently trace back how AI produced its output get measurably better results, and most teams can’t yet. For the wider picture beyond finance, Vena’s roundup of AI adoption statistics covers how other functions compare.
Even as automation and AI become more prevalent, FP&A teams still rely on one tried-and-true tool as much as ever: Excel.
46. 90% of finance teams rely on Excel alongside their primary planning platform for at least some models and reports, essentially flat against 89% the year before.1
47. Spreadsheets remain the most-used tool for budgeting and forecasting at 61%, ahead of dedicated FP&A SaaS platforms at 57%.1
48. As a company’s size grows, their reliance on Excel holds. 63% of companies with more than $1 billion in annual revenue still use spreadsheets as their primary budgeting and forecasting tool, and 24% call Excel their primary planning tool outright.1
49. 33% of finance teams rank their reliance on spreadsheets as their number one technology challenge, with 66% placing it in their top three.1
50. Spreadsheets remain the dominant tool for FP&A professionals, with 96% of respondents using them daily or weekly for planning.12
51. Advanced spreadsheet skills appear in 82% of FP&A manager job descriptions. EPM tool experience appears in just 31%.12
52. 86% of finance professionals now use at least one AI tool directly inside Excel, and 49% of those users run two or more at the same time.15
53. Finance professionals who use AI inside Excel are more than twice as likely as non-users to expect their Excel reliance to grow over the next year, 55% against 26%.15
54. Among finance teams that already own a dedicated corporate performance management (CPM) or financial planning platform, 92% still use Excel at least weekly outside that platform. Not one respondent said “never.”15
55. 86% of finance professionals rate a platform’s Excel compatibility as important or very important when evaluating CPM software.15
56. Seniority correlates with more spreadsheet use, not less. 64% of VP and C-suite finance leaders open Excel daily outside their planning platform, compared with 44% of managers.15
Those last two figures show that the people with the authority to replace Excel are the same people who open it every day, and they’re evaluating new software based on how well it works with the tool they already have.
Teams weighing their options can compare the AI tools finance teams are actually adopting against what their current stack delivers.
Even as planning technology has gotten more advanced over the past several years, budget cycles haven’t gotten faster. That’s the most uncomfortable finding in recent FP&A research, and it points to a process issue rather than software.
57. The average organization takes 8.7 weeks to produce a budget, unchanged from three years ago, despite widespread adoption of planning technology.3
58. Teams using structured scenario planning build budgets in 8.1 weeks on average, 12% faster than the 9.2 weeks it takes teams that don’t. Only 38% use structured scenario planning at all.3
59. Only 46% of finance professionals report effective horizontal alignment across operations, and just 47% use consistent variables in their planning.3
60. Half of North American CFOs (50%) named digital transformation of the finance function their top priority for 2026.10
61. 54% of finance teams complete their annual budget in one to three months, another 28% finish in two to four weeks, and 11% take longer than three months.1
62. Quarterly is the most common forecasting cadence, cited by 45% of finance teams, while only 6% have adopted a rolling or continuous approach.1
63. 41% of organizations use a fully collaborative top-down and bottom-up budgeting approach with shared accountability. Among companies above $1 billion in revenue, that rises to 60%.1
64. 43% of finance teams name limited collaboration with other business units as a bottleneck, the second-most cited obstacle after data quality.1
65. Asked to describe how they collaborate with the broader business, the largest share of finance teams (36%) said “regular meetings for forecast input.” Only 23% report joint ownership of financial targets with business units.1
66. During month-end close, the single most-cited challenge is chasing down information from other departments, named by 34% of finance professionals. Late or missing information from another department is also the second most common cause of restatements, at 27%.2
More meetings don’t always amount to better collaboration. Regular forecast-input calls are the most common form of collaboration finance teams have with the rest of the business (cited by 36% of them), but they don't automatically foster shared accountability or faster cycles.
“We no longer just own the numbers. We are responsible to help drive decision and execution velocity, from presenting analysis to recommending action,” says Vena CFO Melissa Howatson on the evolving role of Finance.
“But you can't change behavior without changing the system. Most systems today are built around cycles, roles and manual accountability.”
More is landing on FP&A’s desk these days, and AI is a big part of it. It now runs inside daily workflows, and leadership expects it to pay off. Finance wants a say in strategy, yet most executives still see the team as the people who produce the reports. Underneath it all is the same old problem.
Data quality is still the top bottleneck, cited by 58% of finance teams.¹ Teams that spend their week rebuilding numbers by hand can’t act as strategic partners or get returns from AI. They need governed data that reaches the right person at the right moment and is ready to use.
Vena’s FP&A platform brings governed, connected data and embedded AI directly into Excel and the Microsoft tools finance teams already use, so every part of the planning cycle can run on one trusted source, without giving up the spreadsheets you know and love. See why finance teams choose Vena.
Source list:
Get a data-driven look at where FP&A stands today and its next phase of evolution, based on insights from 400+ finance leaders.
Download Now