The new Accounting-FP&A relationship in the age of agentic AI
The accountant's role is changing as agents take on more and more manual work. This changes not only how accountants work but also how FP&A and accountants should work together.
FP&A will benefit because accountants have more time to understand the business and the "why" behind the numbers. Accountants will also benefit from spending more time on strategic work.
AI is already changing how finance departments work together, and during the webinar we will discuss what this means for everyone, including:
How future-forward accountants are using AI
How to become the accounting partner FP&A wants
How to position your career for an AI-native finance organization
This week, for FP&A Guy Tips, I want to talk about building visuals. In the last week, we had three big AI announcements, and each one affects how we build visuals and dashboards.
Claude Dashboards – Claude just rolled out Claude Dashboards. From a simple prompt, Claude can write a SQL query to your data source, build a dashboard, and stay connected. Every dashboard you create saves in the artifacts tab, and it connects to all major data warehouse platforms and many of the apps you use. Get started with Claude Dashboards | Claude Help Center
Intelligent UI – ChatGPT is capable of mixing answer text with charts, buttons, forms, and diagrams, making it much more interactive. This means you could build a scenario that lets you change assumptions right in the chat window via a button and watch how it changes the outputs.
While these announcements are exciting and make building dashboards and reports much easier, they don't change the fact that if we don't understand good design principles, the dashboards and visuals we build will fail to influence the business. Below are 10 Data Visualization Principles to keep in mind when building visuals.
Know & Design For Your Audience
Know Your Data
Message-First Design
Keep it Simple, Avoid Information Overload
Ruthlessly Reduce Clutter
Use Color with Purpose & Restraint
Use Contrast Effectively
Label Directly & Clearly
Choose the Right Chart For the Right Purpose
Context is Important
These are the 10 principles I teach my students when teaching good design principles. Regardless of whether you or AI are building the charts and visuals, you need to make sure your audience receives the message loud and clear. If you are looking for data visualization training for your team, email me: Pbarnhurst@thefpadaguy.com​
Business Partner's Corner
Don’t Assume. Challenge the Target.
Many years ago, I was promoted to Finance Director of Supply Chain at a large consumer packaged goods company.
One of the first things I did was sit down with my team to review the budget. The year had just started, and the budget was already finalized.
Something immediately caught my attention.
Our cost savings target was significantly higher than the previous year.
We had experienced leaders around the table, and I made a critical mistake. I ASSUMED that the appropriate due diligence had been done and that solid execution plans were in place to deliver the savings.
Boy, was I wrong!
About three months into the year, I realized there was virtually no chance we would achieve our target. I started raising concerns with leadership, highlighting the risks in our plan.
Unfortunately, we ended up having a poor year. It was a tough lesson, but one that made me a much better Finance business partner.
Here are three lessons I took away from that experience.
1. Don’t assume. Ask questions.
Just because a target has been approved doesn’t mean there’s a credible plan to achieve it. As Finance professionals, we need to ask thoughtful questions and respectfully challenge assumptions.
Book time with your business partners to walk through the execution plans. What initiatives will deliver the savings? Who owns them? What milestones are in place? What could go wrong?
Remember, challenging a plan isn’t the same as challenging the people who created it.
2. Do your own due diligence.
Don’t assume that because experienced leaders have signed off on a target, everything has been thoroughly vetted.
Ask your boss to walk you through the detailed plans.
Understand the assumptions, dependencies, and risks before you commit to the numbers.
I learned that being new to a role was not an excuse for failing to ask the tough questions.
3. Signal risks early.
This was my biggest lesson.
When you see a risk, speak up. Don’t wait until the numbers confirm what your instincts are already telling you.
Early warning signals give leaders time to respond, whether that means reallocating resources, adjusting priorities or developing contingency plans.
Bad news rarely gets better with age.
That experience changed how I approached future roles. I became much more comfortable asking questions and challenging aggressive targets. I no longer saw it as being negative. I saw it as doing my job and providing a valuable service to the business.
Fast forward many years.
During the pandemic, the company I was working for had a phenomenal year. As we started building the following year’s budget, there was pressure to establish an equally aggressive target.
But this time, I challenged the thinking.
COVID had created extraordinary circumstances. Just because we experienced exceptional results during a once-in-a-generation event didn’t mean those results represented a sustainable step change in the business.
I encouraged the team to take a more realistic approach, recognizing that conditions would eventually normalize.
It was a very different experience from my early days as a Finance Director.
The bottom line?
Our role in Finance isn’t simply to validate the numbers or report on performance. It’s to help the business make better decisions.
Sometimes that means supporting an ambitious target. Other times, it means having the courage to challenge it.
The key is to be curious, objective, and constructive.
Great Finance business partners don’t just ask, “What’s the target?” They ask, “What’s the plan to achieve it?”
And most importantly, “What gives us confidence that the plan will work?”
A question for you: Have you ever inherited or been handed an aggressive target that you knew would be difficult to achieve?
How did you handle it?
Stay Out of Excel Hell
My 10 Favorite Excel Jokes
Here are 10 of my favorite Excel jokes in no particular order.
Question: What did the data analyst put in their hair? Answer: SUMPRODUCT
Question: What do you call a broken spreadsheet? Answer: The intern's problem
Question: What is the best cell to store your Excel error message in? Answer: Column: FU, Row: 2 (FU2)
Question: What happened to the bar chart when it worked out? Answer: It became a STACKED bar chart
Question: What is the most dangerous cell in Excel? Answer: C4
Question: What does every newborn spreadsheet need? Answer: Formula
Question: What is Excel's favorite dessert? Answer: A Pie Chart
Question: Why can’t spreadsheets drive cars? Answer: They crash too often
Question: What did the VLOOKUP say on its online dating profile? Answer: Seeking an Approximate match; it's TRUE!
Question: Why was the spreadsheet constipated? Answer: Because it could not budget it
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...