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: How to Ensure the Budget moves the business forward
Published 3 months ago • 6 min read
Brain Teaser of the Week
See the solution at the end of the email
🧠 Brain Teaser:
A man shaves several times a day, but still has a beard. Who is he?
This Week's Sponsor
Inspirational Quote
“People don’t care how much you know until they know how much you care.”
— often attributed to Theodore Roosevelt
Message from our Sponsor
Finance teams shouldn't have to choose between familiar tools and modern automation.
FYIsoft connects the financial planning and reporting cycle with BudgetFYI for streamlined budgeting and forecasting, ReportFYI for automated financial reporting, and Telli™, a private AI financial analyst that turns reports into insights, visuals, and variance commentary.
Spend less time assembling the numbers and more time understanding what they mean.
People Plans x Financial Plans: A Conversation on HR & Finance Collaboration
When HR and finance are not aligned the job becomes a lot harder. You get conflicting assumptions, misaligned plans, and difficulty in meeting the business's growing headcount needs.I have experienced the struggles of misalignment between finance and HR and that is why I am excited to be hosting a conversation sponsored by Ramp with two experts on the topic.
JP Elliott, Founder, Future of HR
Katie Stephan, Director of GTM, Gong
We will cover where HR and FP&A naturally intersect, where the disconnects show up, and what stronger collaboration actually looks like in practice.
The Budget Isn't the Goal. Building a Better Business Is.
;I sat down with Zach Rial (AskElephant), Chris Ortega (Fresh FP&A), and co-host Glenn Snyder for a live conversation on budgeting and forecasting. The theme that quickly emerged is that the budget is just a product; the goal is to help the business achieve better results.
Some key quotes that really stuck out from the conversation, followed by a few practical takeaways.
Key Quotes:
"A budget is the direction of where you want to go, but things change so much in a business." Chris Ortega, who followed it up by saying that for most SMB’s formal budgeting is a waste of time, but planning is critical
"It's not a finance exercise. It's an organizational exercise." Glenn Snyder emphasizes the importance of involving the full business in the planning process.
"Be wrong more often." Zach Rial talking about how it is ok to be wrong. He said we are here to help the business, not build a perfect plan.
Practical takeaways
Start with conversations, not numbers: Chris does not open the budget cycle with a spreadsheet. He spends a day with the leadership team on four drivers: sales, marketing, operations, and people. What is working, what is not. The financial plan is the output of that conversation, not the starting point. Remember, the goal is to help the business achieve its targets, start with its needs in mind, not yours.
Ask your business partner what they wish the budget told them: Zach shares how he rebuilt an entire budget the number, what would you want to know automatically? This focus allowed him to deepen the relationship with the business and build something they would actually use.
Listen to what they want: Do not be afraid to let them give you a full Wishlist of everything you want. This exercise can be eye-opening when they see that granting the Wishlist will result in an unsustainable business model. Often, the conversation that follows is far more productive than a preemptive no.
Budget vacancy. Glenn Snyder shared some tactical advice on budget vacancy. If a department carries 100 positions but averages 95 filled, do not fund 100. Factor in how long roles actually sit open. Freeing up that expense in the plan may allow you to invest in other areas rather than having it go unused. Glenn has seen it free up $20-$30M in expenses in a budget.
Build trust throughout the year: Trust is built in the other eleven months. Budget season goes well when you have spent the year proving you use the budget to help people hit their goals, not to say no. If you have not built trust, it is hard to do it just during budget season
If you have not had a chance to watch the episode, go ahead and give it a listen below:
Challenging Conversations: How Finance Can Challenge Without Damaging Trust
One of my favourite books on communication is Crucial Conversations.
The authors describe a crucial conversation as one where three things are present:
The stakes are high. Opinions differ. Emotions run strong.
Sound familiar? 😁
Welcome to Finance!
Whether we’re discussing a forecast, challenging a spending decision, recommending a price increase or debating an investment, we have crucial conversations all the time.
Early in my career as a Finance Analyst and Manager, I didn’t always handle them well.
When someone in the business made what I thought was a poor financial decision, I would sometimes react emotionally. I thought I was doing my job by challenging the decision.
But there was a problem.
I ended up isolating myself. I was sometimes left out of important conversations because people didn’t necessarily want Finance in the room.
That’s the opposite of great business partnership.
Luckily, I received some great advice and mentorship that changed how I approached these conversations.
Start with trust ❤️
There’s a quote I now live by:
“People don’t care how much you know until they know how much you care.”
Before you earn the right to challenge someone, invest in the relationship.
☕ Grab a coffee or lunch. 👋 Ask about their weekend. 💬 Get to know them personally. 🎯 Ask about their business and what matters most to them.
Authentically care.
When trust exists, you can challenge someone in a way that builds the relationship rather than erodes it.
Here are three strategies that helped me:
1️⃣ Be hard on the problem, not the person
I remember challenging a recommendation from a Sales Director.
He became loud and emotional.
The younger version of me might have matched his emotion.
Instead, I stayed calm and focused on the issue. I shared my perspective in a way that demonstrated that I cared about him
AND the business.
You don’t need to win the argument. You need to help the team make the best decision.
2️⃣ Explain your rationale simply — and provide options
During a period when commodity costs spiked dramatically, I believed we needed to increase prices.
But instead of saying, “We have to take pricing,” I explained the financial reality in simple terms and engaged the team in the solution.
We discussed the alternatives, challenged each other’s thinking and ultimately landed on pricing together.
Same destination. Very different journey.
And significantly more buy-in.
3️⃣ Get curious before you get convincing
One of the biggest lessons I’ve learned in Finance is that we don’t always have the full picture.
Before challenging someone, ask questions:
❓ Help me understand what you’re seeing. ❓ What are we trying to accomplish?
❓ What might I be missing?
Sometimes you’ll uncover information that changes your recommendation.
Other times, the questions help the other person see the financial implications themselves.
Either way, curiosity creates dialogue. Certainty can create walls.
Great Finance professionals aren’t afraid of challenging conversations.
But they also understand that being right isn’t enough.
Build trust.
Challenge the problem.
Explain your rationale.
Stay curious.
That’s not a soft skill.
That’s great business partnership.
Stay Out of Excel Hell
Center Across Selection and Automatic Table Naming Coming To Excel
This is one post that has been 20+ years in the making. Two things that have always driven me and many Excel users crazy are:
That Merge and Center is the default on the home ribbon, not Center Across Selection
The fact that when you create an Excel Table, you cannot name it until later in the process
While good news, Microsoft has fixed both of these issues, and the fixes are in beta and will be making their way to general release soon.
As you can see in the above example, when I created a table the dialog box gave me the option to name the table. In this case, I had a little fun and named it Happy_Days to celebrate 😊
Adding this small change will hopefully improve tabe naming because nothing is worse than inheriting a file and going to the name manager dialog box and learning the person has 50 tables named table1, table2, table3, table….
The second change will make Excel users very happy, as many people say the only thing worse than using Merged Cells is hardcoding numbers in your financial model.
I am not that much of a purist, as I do use them from time to time, but they have been abused for years, and many people had no idea they could use Center Across Selection instead of merging cells because the option was hidden in the formatting menu.
While today that is no longer the case, look at the image below and notice that Center Across Selection is part of the home ribbon.
The reason this is a big deal is that merging cells often messes up analyzing data. To highlight the entire column, you have to unmerge cells. Merge cells should never be used where you store data. They have often caused people a lot of wasted time converting merged cells back to unmerged cells.
Center Across Selection should have always been the default, so it is exciting to see that Microsoft has added it to the menu. I just wish it showed up first on the list, not last.
Let me know what one change you are hoping Microsoft will make soon that will make you as happy as these two have made me.
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...