Join me and 3 FP&A experts (Glenn Snyder, Chris Ortega, and Zach Rial) for a session on Budgeting Best Practice Tips. During this LinkedIn Live, you will have the opportunity to ask your Budgeting & Forecasting questions directly.
We will be discussing several important topics including:
Tips for making the process go smoothly
When to start planning for the budgeting cycle
When to use driver-based methods vs others for forecasting
The value of a budgeting post-mortem
How managing the budget varies by company size
Managing business relationships throughout the process
Budget season is around the corner, and many of you might be dreading it. I can remember some budget seasons that dragged on forever and were unpleasant experiences, and others that went well. I have learned that a lot of how well the budget goes depends on how well you planned ahead of time.
Below are 10 tips that will help you have a more successful budgeting process:
Complete a high-level straw case and understand scenarios/sensitivitiesbefore any meetings – Having an idea of what numbers should look like before starting makes the process go smoother. I have seen it done without, and it always takes longer
Management alignment upfront (targets, assumptions, timelines, everything!) – This is critical. I had a plan once where management would not give us any targets or assumptions, and it was painful, and in the end we just ended up cutting everything across the board to get to the numbers the business wanted, and nobody was happy
Develop a high-level and detailed calendar & checklist (do this way ahead of time) – A general calendar is not enough. The more detail you can provide the business and build buffers and checkpoints into the calendar, the smoother the process will go.
Book a kick-off meeting to align on targets, assumptions and the calendar – Communication is key, and it starts with a kick-off meeting. Make sure you give clear assumptions, expectations, and deadlines to the business. The clearer you are in the meeting, the smoother the process will go.
Frequent check-ins (leadership and bottom-up group). Daily if necessary – I had a planning season where corporate had a daily check-in that anyone could attend, and it made the process go much smoother. I recommend putting a daily in the calendar but making it optional. It makes everyone feel like they can ask for help whenever needed; even if it is hardly used, it makes things go smoother.
Highlight issues and gaps early (on all P&L lines with a solution mindset) – If I could add this one to the list twice, I would. If you see a gap in the numbers, do not wait until the end hoping it will go away; alert management early and discuss what to do about it. Not saying anything is how you end up with plugs and go-finds, which almost always cause you to miss the targets.
Scenario Management – Build scenarios & sensitivity capabilities into the process – Point estimates are not enough, so be prepared to work with ranges. Every situation has a range of possibilities; the more you understand them, the more you can be prepared for what might happen. Finally, building realistic scenarios with trigger points helps you plan for when life happens, and you need to adjust your plan.
Utilize technology and align on this early (planning tool, model) – Decide on what tools, technology, and templates you are going to use early. Do not wait until the end to build your templates in Excel and send them around via email. If you need a planning tool, start on that process long before budget season.
Start your presentations early (this will help you with the ‘story’ and reduce late nights) – This is something FP&A is bad at in general. Think about the story throughout the process and what you are going to say. Saving the deck until the last night usually results in errors. Remember the presentation is where you get sign-off, so the better prepared, the smoother that part will go.
Focus business involvement on key drivers – Keep the templates you give the business to complete simple. Fill out as much of the information yourself as you can. The more you can focus on aligning with the business on key drivers, the more engaged they will be vs. expecting them to provide a number for everything.
Business Partner's Corner
💡 Don't Sit on the Fence: Why Finance Must Make Recommendations
Early in my career as a Director of FP&A, I was given one of my first truly uncomfortable assignments: setting annual targets for each of our brands—and, by extension, the Brand Managers who would be held accountable for achieving them.
It was one of those decisions where no matter what targets I assigned, someone was going to be disappointed.
So, I did what many of us naturally do when we're uncomfortable.
I procrastinated.
When the time finally came, I found myself sitting on the fence, hoping my VP would make the difficult decisions for me. Looking back, I wasn't avoiding the work—I was avoiding the responsibility that came with making a recommendation.
Thankfully, I received some coaching that changed my perspective. I was reminded that Finance isn't just there to report the numbers—we're there to help the business make decisions.
I eventually assigned the targets.
Unfortunately, I made another mistake.
While I had made a recommendation, I hadn't clearly explained the rationale behind it. The result was exactly what you would expect: endless questions, debates, and revisions. Every target became a negotiation because people didn't understand the thinking behind the numbers.
That experience taught me an important lesson.
📈 The Turning Point
The following year, I approached the exercise completely differently.
Before recommending a single target, I did my homework:
📊 Reviewed historical growth rates
🚀 Assessed upcoming product innovations
📉 Evaluated changes in the competitive landscape
🔍 Considered business trends and market dynamics
🎯 Aligned every recommendation with our strategic plan
Instead of relying on intuition, I built a set of objective principles that would guide every recommendation.
When I presented the targets, something remarkable happened.
There was very little pushback.
The discussions were collaborative rather than confrontational because everyone could see the logic behind the recommendations. Even when people didn't completely agree with a target, they respected the process and appreciated that an impartial function like Finance had developed a thoughtful, principle-based recommendation.
That experience became a turning point in my career.
I stopped seeing myself as someone who simply analyzed data and started seeing myself as someone who could help shape better business decisions.
🤝 The Difference Between Analysis and Partnership
One pattern I've noticed over the years is that many finance professionals—myself included—are naturally analytical and often a little introverted. We spend countless hours ensuring our analysis is accurate, only to finish our presentations with:
"Here are the numbers."
…and then wait for someone else to decide what to do.
But that's not a business partnership.
Business partners don't just explain the options—they offer a perspective.
That doesn't mean being dogmatic or believing your answer is the only right one. A recommendation is simply your best thinking based on the information available. It's an invitation to have a productive discussion, not the final verdict.
⭐ A Simple Challenge
Before your next meeting, ask yourself one question:
"If the CEO turned to me and asked, 'What do you recommend?', would I have a clear answer?"
If the answer is no, your work probably isn't finished.
✅ Three Takeaways
📖 Do the homework. Strong recommendations are built on facts, trends, and business understanding—not opinions.
💬 Explain your rationale. A recommendation without context creates debate. A recommendation with clear principles builds trust.
🤝 Be willing to take a position. Finance creates the most value when we move beyond reporting the numbers and help the business make better decisions.
The most rewarding part of my journey wasn't learning how to build better financial models—it was learning to have the confidence to make thoughtful recommendations and engage in constructive dialogue.
That's when I stopped being seen as the person who counted the score...
...and started being viewed as a true business partner who helped improve it.
Analysis informs decisions.
Recommendations drive them.
And that's where Finance creates its greatest value.
Stay Out of Excel Hell
LOOKUP Methods
This Excel post will not be a lecture on why one lookup method is superior over another. Excel has lots of ways to do things, but I want to speak to 3 lookup methods that, if everyone learns, will cover almost every lookup situation outside of someone who is not using Microsoft 365. These methods are XLOOKUP, FILTER, and POWER QUERY. This week I want to cover XLOOKUP and FILTER, as they are my favorite functions, and in a future issue I will cover Power Query, which is my all-time favorite method. I like to think of it as XLOOKUP on steroids.
XLOOKUP – XLOOKUP is the formula Microsoft designed to replace VLOOKUP, and it is an easier formula with less chance of breaking. The syntax of the function is as follows:
lookup_value - This is the value you are searching for.
lookup_array - This is the array/range you are searching in to find the lookup value specified in the first step.
return_array - This is the array/range you are returning the value that corresponds to the value found in the lookup array/column.
[if_not_found] - This is an optional argument. If no match is found for the value you searched, it will return the text supplied.
[match_mode] - This is an optional argument and is used to specify the match type to use when searching for your value.
Options include:
0 - Exact Match, searches for an exact match, and this is the default if nothing is entered.
-1 - Exact Match, if no exact match is found, will return the next smaller item.
1 - Exact Match, If no match is found, will return the next larger item.
2 - Used for conducting a wildcard match where the characters *,?,and~ are used in a wildcard search.
[search_mode] - This is an optional argument and specifies what search mode to use:
1- Starts searching from the first item; this is the default if nothing is entered.
-1 - Performs a reverse search starting at the last item.
2 - Performs a binary search that relies on lookup_array being sorted in ascending order; if not sorted, invalid results will be returned.
-2 - Performs a binary search that relies on lookup_array being sorted in descending order. If not sorted, invalid results will be returned.
Note: [] = Optional input not required.
XLOOKUP Example
In the above example, we are looking up the bonus ratings in column C and returning the payout in column D using the table in columns F and G.
=XLOOKUP(C4:C8,F4:F9,G4:G9,"Not Found",0,1)
Lookup Value: (C4:C8) - The lookup value is C4:C8; this is the full range of bonus ratings. This function will spill the answer in cells D4:D8 for each lookup value.
Lookup Array: (F4:F9) -The lookup array is the column that contains the values that will match the lookup value; in this case, they are the bonus ratings in F4 to F9.
Return Array: (G4:G9) - This is the return array, this column contains the data we want returned if a match is found so for example if the bonus rating is a 5 we want to return 50,000 which is found in G4.
If Not Found: (“Not Found”) – This replaces the IFERROR function and returns whatever you enter here if no value to return is found. In this case, it is the word Not Found.
Match Mode (0) – Match mode tells Excel what kind of match you want to do and has 4 options outlined above. In this example, we are doing an exact match, so if no exact match is found, it will not return an answer.
Search Mode (1) – Search mode informs Excel how you want it to search your lookup data. Do you want to do it first to last or last to first? This can be helpful in situations where you might have duplicates, such as a product number, and you want the first or last record in the list.
FILTER – Many people do not think of the FILTER function as a LOOKUP function because it returns all records in a list, but it is one of my favorite lookups for that reason. The FILTER function returns all records that meet the match criteria. The Syntax of the function is as follows:
=Filter(array, include,[if_empty])
Array - This is your dataset, data array, or range that you want to filter
Include - This is where you supply your criteria to filter the dataset, array, or range. The criteria uses Boolean logic, and you will input a Boolean Array
[If_empty] - This is an optional argument to tell the function what to return in case nothing is found.
Note: [ ] = Optional input not required.
Boolean Logic: Uses AND/OR logic, which in Excel is entered with multiplication (*) for
AND logic and plus (+) for OR logic.
Example: if you wanted AND logic, you would do
Criteria 1 * Criteria 2
This would return an answer when both criteria are true.
If you wanted OR logic, you would do
Criteria 1 + Criteria 2
This would return an answer when either of the above criteria is true.
FILTER EXAMPLE
=FILTER(B11:G20,B11:B20=C2, “Not Found” )
Array: (B11:G20) - The array is the range you want to return records from that match your include criteria. In this example, we want to return all records associated with the data in cells B11 – G20, so we enter that as our range.
Include: (B11:B20 = C2) – The include criteria is where we tell the filter what criteria we want to include for our records. Here you can use Boolean Logic to have multiple criteria. The criteria can include both AND and OR logic, such as BMW and Sedan or Honda or Luxury, etc. In this example, we did a simple single criterion on the Manufacturer where it was equal to BMW.
If Empty: (“Not Found”) – This is where we tell Excel what we want it to return if it cannot find an answer. In this example, if no answer was found, it would return the word Not Found.
If you are still using VLOOKUP and it works for you, then continue using it, but if you are finding in certain situations it does not work well, or you get burned when your columns change, then consider switching to XLOOKUP or FILTER for your lookup needs.
Joke of the Day
Question: How does Santa’s accountant value his sleigh?
Answer: The Net Present Value
Brain Teaser Answer
Take one fruit from the box labeled “Apples and Oranges.”
Because every label is wrong, that box cannot contain a mix.
If you pull out an apple, that box must be Apples Only.
If you pull out an orange, that box must be Oranges Only.
Suppose you pull out an apple:
Label that box Apples Only.
The box labeled Oranges Only cannot contain oranges, and it cannot contain apples because that category is already assigned. Therefore, it must be Apples and Oranges.
The remaining box must be Oranges Only.
The same logic works in reverse if you pull out an orange.
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...