The Modern Finance Playbook is a newsletter for today's finance professionals brought to you by Paul Barnhurst and Ron Monteiro.
Share
Modern Finance Playbook: The State of the Finance Tech Stack Report
Published about 2 months agoΒ β’Β 9 min read
This Week's Sponsor
Inspirational Quote
"If everyone is thinking alike, then somebody isn't thinking."
β George S. Patton
Brain Teaser of the Week
See the solution at the end of the email
π§ The Two Ropes
You're standing in a room with two ropes hanging from the ceiling.
Your challenge is to tie the two ropes together, but there's a problem. They're positioned just far enough apart that when you're holding one, you can't reach the other.
You have a pair of scissors in your pocket.
How can you tie the two ropes together?
Hint: Sometimes the solution requires challenging how we think an object should be used.
Message from our Sponsor
β
Thanks to this monthβs sponsor, Lineos.
Lineos reporting intelligence connects directly to your ERP and delivers structured data in Excel.
Your finance team is armed with self-service reporting, formulas refresh automatically, and every number traces to a source.
The State of the Finance Stack 2026: Live Findings
Join Rob Knoferowicz of CFO Shortlist and me as we share our findings from our 2026 survey about the finance tech stack. In this survey, we interviewed 176 finance leaders about FP&A tools, AI, BI, consolidation, and more. We will share our findings and what they mean for the finance tech stack going forward.
What 176 Finance Leaders Told Us About Their Stack
This summer, Rob Konferowicz of CFO Shortlist and I surveyed 176 finance leaders, mostly heads of FP&A and CFOs.
The headline is that 65% say AI is already changing their work. Only 14% have an AI agent in a live workflow.
Here's what that means if you work in FP&A:
Check what your tools already offer. When a finance team's existing tools had agentic features, 70% were piloting or live. Without it, the figure was 23%. Most teams turn agents on inside tools they already trust. If you are not sure if your tool includes agents, ask today and give them a try.
Fix the data first. We asked about the biggest pain in the finance stack. In 124 written answers, "data" came up 60 times, and "cost" came up only twice. An agent working on messy data just gives you wrong answers faster. If you have not committed to fixing your data, do so today. Data, not cost, is the biggest pain point, so be willing to spend when necessary to get your house in order.
Get hands-on before you form an opinion. Among teams running agents live, 96% say AI is already changing finance work. Among teams not using agents, only 52% say the same. Nearly all of the "too early to tell" answers came from teams that hadn't started. Pick one small task this month and do it with an AI agent from start to finish. The technology is there; adoption is lagging.
Claude is leading, even with Microsoft's Resources. 61% of respondents use Claude, compared with 38% for ChatGPT and 36% for Copilot. Copilot comes built into the Office tools most finance teams already use, and yet Claude still leads by a wide margin. The lead is widest where people pick their own tools. At companies under 50 people, 88% use Claude and 21% use Copilot.
Raise the bar in your next tool evaluation. One leader told us: "At this point, the comparison to any tool is now Claude Code. And with that comparison, nothing really stacks up." Teams already using agents now judge every tool against what an AI agent can do, not just against other vendors. In your next demo or renewal, ask the vendor to show you an agent running a workflow on your own data. Then ask what's shipping in the next 12 months.
One caveat for this entire report. The sample size is small, and it primarily self-selects from our community, so read it as directional.
The full 10-page report goes deeper, including how small companies compare with large enterprises and how satisfaction varies by ERP. It's free to download, and you don't need to fill out a form.
Red Teaming: The Power of Challenging Each Other to Make Better Decisions
Sometimes the most valuable contribution we can make as Finance professionals is to challenge a decision, even when everyone else seems to agree.
I learned this lesson the hard way.
Early in my leadership journey, I was a newly promoted Finance Director. Our team was making a significant decision to outsource a product.
My gut told me something wasn't right, but I remained silent. I assumed the team had completed all the necessary due diligence. Surely, they had considered the risks?
I was wrong.
The decision proved disastrous, and I subsequently spent countless hours developing "Path to Profitability" analyses to help us recover.
That experience taught me an important lesson: Silence isn't always support. Sometimes the best way to support your team is to challenge their thinking.
Thankfully, I've had many positive experiences since then where constructive challenge has led to better decisions.
Introducing Red Teaming
Originally used in the military, Red Teaming is a structured approach where individuals deliberately challenge a proposed strategy or decision to identify blind spots, weaknesses and potential risks.
The objective isn't to prove someone wrong. It's to make the plan stronger.
Think of it as constructive opposition, with everyone playing for the same team.
How Can Finance Apply Red Teaming?
Imagine your commercial team proposes launching a new product with projected revenue of $15 million.
Rather than simply validating the numbers, Finance facilitates a discussion:
What assumptions are we making about customer demand?
What if sales are 25% below expectations?
How might competitors respond?
What are we potentially overlooking?
What early warning indicators should we monitor?
But don't stop at identifying risks. Develop contingency plans!
For example, if sales fall below expectations for two consecutive months, perhaps we adjust production volumes, revisit pricing, or reduce promotional spending.
Another example might be a proposed manufacturing line closure to save $2 million. A healthy challenge could uncover potential capacity constraints during peak season, prompting the team to explore inventory buffers or phased implementation.
Now we're helping the business make more resilient decisions.
Building Trust Through Healthy Challenge
Red Teaming only works when people feel safe to speak up.
Otherwise, we risk creating another situation like the one I experienced early in my career.
Three simple principles can help:
Challenge the idea, not the person. Assume positive intent.
Be curious, not confrontational. Replace "That won't work" with "What would have to be true for this to succeed?"
Turn challenges into actions. Identify risks AND develop contingency plans together.
Your Challenge This Week
At your next forecast review, budget meeting or business case discussion, dedicate 10 minutes to Red Teaming.
Ask your team:
"If this plan fails six months from now, what will most likely have caused it, and what can we do today to prepare?"
Encourage everyone to contribute, especially those who might see things differently.
Remember, great Finance business partners don't simply validate the numbers. They help the business see around corners.
And one final lesson from my outsourcing experience:
Don't confuse agreement with alignment and never underestimate the value of respectfully speaking up.
Stay Out of Excel Hell
Storing More than One Value in a Cell in Excel
Last week, Microsoft announced the ability to store multiple values in a single cell in Excel. I wrote about it on LinkedIn, and Secret CFO said he thought it was a terrible idea. He even hinted it could be the death of Excel, so I ran a poll. 14% of voters agreed with him that it is terrible, that they hate it, and that it will kill Excel. 13% said they love it, and the majority said it changes nothing or is too early to tell.
β
The results will change over time as people become familiar with this change. Personally, I am excited for this development even if it is currently in Beta and will take a while to reach the general Excel user. I am not worried about it hurting Excel because you have to choose to enter multiple values; by default, Excel behaves the same as always.
However, for those who learn to use these features, it opens up a whole new world of possibilities. New ways to filter on data, build reports, get formulas to return multiple values and more.
The new functions/features include:
Lists β A cell can store multiple values while still treating each value as a separate item.
β
Previously, Excel treated multiple values in a cell as one text string (see column 4). Now Excel recognizes it as a structured list (see column 3), allowing filtering, counting, lookups, and calculations on the individual items.
An example of this is if I filter on Team Members (List), I see each individual value you listed and no longer see the text string unless I select to see the list the way Excel used to operate by choosing it from the Select field drop-down in Excel. See screenshots below:
You will notice that with the new lists, all values are individual, whereas in the old way, it all showed as a text string.
You can also perform math operations on a list. Assume I have the following list below:
β
Notice how I can sum all the values as if they were in individual cells because they are all part of a list.
This can be handy if you want to store all the invoice amounts for each customer in one cell, but then perform math operations on that one cell.
Flatten Function β The FLATTEN function converts nested arrays and lists into a single flat array. This means each value operates like a dynamic array: the function lives in one cell, and the results spill into adjacent cells. In the example below, 10, 50, 100, and 500 lived in one cell and spilled into 4 rows.
β
HAS Function β Used to check whether a list or array contains a specific value. When it finds a specific example, it returns TRUE.
For example, assume I wanted to check a list to see how many people listed the Cowboys as one of their favorite sports teams. As you can see, the example shows TRUE for every person who has the Dallas Cowboys listed as their favorite football team.
β
HASALL Function β Used to see if all conditions are true. If you asked whether the favorite teams were the Dallas Cowboys and Texas Rangers, it would return TRUE if both teams appeared in the list.
HASANY Function β Usedto see if any conditions are true.If you asked whether the favorite teams were the Dallas Cowboys and/or the Texas Rangers, it would return TRUE if either team appeared in the list.
Nested Arrays β The last new item I want to mention is a nested array. This allows you to store an array of data in a single cell. This could be multiple records that would normally be contained in several columns and rows. For example, if I wanted to store all my sports data above in a single cell, I could do so by referencing the table and wrapping the function in {}. It would look like this: ={tblFans[#All]}, and all data would then be stored in a single cell in Excel, allowing you to write functions against that array.
Let us look at an Example
One example of how these new features can help is in reporting. If you want to see the video that gave me this idea, you can go here:
,The video shows how to build a report that includes all the details behind each report line as a data card. In this example, I have a table with Revenue data. I have summarized it in the image below, and in the cell next to it, I used the FILTER function with {} to store all the details for each transaction in a single cell. Notice it shows a grid icon, and if I click on it, I can see a data card with all the details that make up the Laptop Pro X transactions for the month.
β
The examples I have shown only scratch the surface of what is possible with these lists and nested arrays. Over time, we will see more and more use cases being developed for these new features.
,As I mentioned, they are currently in Beta, so they are only available if you subscribe to the Insider channel. However, once they are made available in General Release, they will change the way many of us work with Excel.
Joke of the Day
Question: What is a spreadsheet's favorite dessert?
Answer: Pie Charts
Brain Teaser Answer
Answer:
Tie the scissors to the bottom of one rope and swing it like a pendulum.
Grab the other rope, wait for the swinging rope to come towards you, catch it, and tie them together.
The lesson: We often get stuck because we see things only for their intended purpose. A fresh perspective can change everything!
This Week's Sponsor Inspirational Quote βClear is Kind.β Brene Brown Brain Teaser of the Week See the solution at the end of the email Three people need to cross a river at night. They have one small boat that can carry a maximum of two people at a time. Alex can row across in 1 minute. Blake takes 2 minutes. Charlie takes 5 minutes. When two people cross together, they travel at the speed of the slower person. The boat cannot cross without someone rowing it back. What is the minimum time...
Inspirational Quote βThe most important thing in communication is hearing what isnβt said.β - Peter Drucker Brain Teaser of the Week See the solution at the end of the email Three Finance colleagues go out for lunch. The bill comes to $30, so each person contributes $10. The waiter realizes the bill should have been $25 and returns $5. The colleagues each take back $1, and they give the remaining $2 to the waiter as a tip. So each person has now paid $9, for a total of $27. The waiter has the...
Hey Reader, "Your analysis was brilliant, but your presentation lacked." I will never forget my boss's words; they taught me the value of the last mile of analytics. I gave a presentation to my CFO that was a disaster, and it was because I did a poor job of presenting the solid analysis I had done. The last mile of analytics is the key to influencing the business, and a few bad data visualizations can often undo the whole presentation. On Wednesday, November 18, I'm running a free live...