What Does an FP&A Consultant Do? A Practical Guide

“FP&A consultant” is one of those job descriptions that can mean almost anything.

Build a forecast.

Fix a model.

Help with the budget.

Prepare something for the board.

Figure out why margins are falling.

Untangle a reporting process that apparently requires three people, six spreadsheets and one person who absolutely cannot take vacation.

All technically FP&A.

I’ve worked in Finance long enough that when someone tells me they need “FP&A help,” my next question is usually:

What is making your life difficult right now?

That’s a much more useful place to start.

Because companies rarely wake up one morning thinking, You know what we need? More financial planning and analysis.

Usually something hurts.

The forecast isn’t reliable.

Leadership doesn’t have enough visibility.

The CFO is buried.

The board wants answers.

Cash needs attention.

The company has grown faster than Finance.

Or management has plenty of numbers and somehow still can’t answer a fairly simple question.

That’s where an FP&A consultant can become useful.

What Is an FP&A Consultant?

An FP&A consultant helps companies improve financial planning, forecasting, analysis and decision support without necessarily hiring another permanent full-time employee.

Depending on the company, that might mean building something new, fixing something that isn’t working, providing additional capacity or bringing experienced FP&A leadership into a specific problem.

The work can include:

• budgeting,
• financial forecasting,
• financial modeling,
• scenario planning,
• cash flow forecasting,
• management reporting,
• KPI development,
• variance analysis,
• board and executive reporting,
• finance transformation,
• business partnering,
• planning systems,
• and decision support.

That’s the official-looking list.

In practice, I think the job is simpler:

Figure out what Finance needs to help the business understand, then build a reliable way to answer it.

Sometimes that’s a model.

Sometimes it’s a process.

Sometimes it’s a meeting.

Sometimes it’s discovering that everyone has been using a different definition of gross margin for the last 18 months.

Consulting has glamorous moments.

When Does a Company Need an FP&A Consultant?

Not every company does.

I don’t believe in inventing finance work simply because Finance could theoretically do more.

But there are situations where outside FP&A support makes a lot of sense.

The CFO Is Doing Too Much

This is one I see often.

The CFO is thinking about capital allocation, strategy, the board, banking relationships, investors, acquisitions and leadership issues.

They are also rebuilding the revenue forecast at 10:30 at night.

That’s usually a clue.

Sometimes the company isn’t ready for another senior full-time FP&A hire.

But the CFO needs someone who can take a meaningful piece of the planning and analysis work and run with it.

Not another person who needs six months of explanation.

Someone who can look at the problem and start asking useful questions.

The Company Has Outgrown Its Finance Process

This happens gradually.

At $10 million, the spreadsheet worked.

At $20 million, it still mostly worked.

At $40 million, somebody added another workbook.

At $70 million, the planning process now includes twelve files, a heroic amount of copying and pasting, and one Friday every month that everyone in Finance quietly dreads.

Nothing necessarily broke overnight.

The business simply became more complicated while the finance process stayed roughly the same.

Eventually the gap becomes visible.

Forecasts take too long.

Reporting is inconsistent.

Planning becomes painful.

Nobody trusts quite the same numbers.

That’s often when I start looking at the FP&A operating model rather than immediately blaming Excel.

Excel has been accused of many crimes committed by process design.

An FP&A Consultant Can Build the Forecasting Process

Forecasting is probably one of the most common reasons companies need FP&A support.

Maybe there isn’t a formal forecast.

Maybe there is one but leadership doesn’t trust it.

Maybe Finance forecasts the P&L but not cash.

Maybe the forecast is really just the annual budget with increasingly desperate adjustments.

A consultant may help determine:

What should we forecast?

How often?

What are the business drivers?

Who owns the assumptions?

How does information get from the business into Finance?

How do we explain changes?

How do scenarios work?

What should leadership review?

I don’t think the goal is simply to create a better spreadsheet.

The goal is to create a forecasting process that gets smarter as the business changes.

A model without a process around it eventually becomes a very elaborate historical document.

An FP&A Consultant Can Build or Fix Financial Models

Sometimes the problem really is the model.

Maybe the company needs:

a revenue model,

a three-statement model,

a headcount model,

a scenario model,

a long-range plan,

a 13-week cash flow forecast,

or an operating model for a new business.

Other times, the model already exists.

That’s when things can get interesting.

I open it.

There are 26 tabs.

Three are hidden.

One says OLD.

Another says OLD2.

There are external links to someone’s desktop.

And the Instructions tab was last updated by a person who left the company in 2022.

Now we’re consulting.

The first question isn’t always:

How do we make this model better?

Sometimes it’s:

Should this model still exist?

That’s a surprisingly useful distinction.

An FP&A Consultant Can Help With Budgeting and Planning

Annual planning can consume enormous amounts of Finance’s time.

Templates go out.

Templates come back.

Finance sends them back again.

Someone changed the format.

Someone added a row.

Someone didn’t fill anything out because they thought the deadline was next Friday.

Eventually Finance consolidates everything and discovers the company has apparently hired 47 people nobody approved.

Good times.

An FP&A consultant can help design the planning process itself:

Who provides assumptions?

Which assumptions should be centralized?

What should departments own?

How should headcount work?

How should targets be set?

How much detail is useful?

How are scenarios incorporated?

What does leadership actually need to approve?

A good budgeting process shouldn’t require Finance to become a seasonal collection agency.

An FP&A Consultant Can Improve Management Reporting

Companies often have plenty of reporting.

That doesn’t mean they have useful reporting.

I’ve walked into finance environments where everyone is extremely busy producing reports and nobody can tell me which decisions those reports support.

That’s when I start asking dangerous questions.

Who reads this?

What do they do with it?

When was the last time someone asked for it?

What happens if we stop producing it?

Finance sometimes discovers it has been maintaining a report for three years because someone who no longer works there once requested it.

Corporate archaeology.

An FP&A consultant can help reduce reporting noise and focus management reporting on what leadership actually needs:

performance,

drivers,

risks,

opportunities,

cash,

resources,

and decisions.

I generally want fewer reports with better conversations around them.

Nobody has ever convinced me the path to better management is page 63.

An FP&A Consultant Can Help Explain What Changed

One of the most valuable things FP&A can do sounds almost embarrassingly simple:

Explain why the numbers changed.

Revenue missed.

Why?

Margins improved.

Why?

Payroll increased.

Why?

Cash declined.

Why?

Forecast changed.

Why?

Good variance analysis doesn’t merely describe the movement.

It connects the financial result to something happening in the business.

That’s important because leadership usually doesn’t need Finance to tell them revenue is $800,000 above forecast.

They can read.

They need to know whether the $800,000 tells us something important.

Did customers expand?

Did pricing improve?

Did something close early?

Did mix change?

Was the original forecast simply wrong?

Same green number.

Completely different management implications.

I’ve apparently reached the stage of my career where good news also requires an investigation.

My family would probably tell you this isn’t limited to Finance.

An FP&A Consultant Can Build Scenario Models

Companies tend to become very interested in scenarios when something becomes uncertain.

Which is most of the time.

What if revenue slows?

What if we hire faster?

What if pricing changes?

What if the acquisition closes?

What if the large customer leaves?

What if interest rates change?

What if we delay the investment?

FP&A can translate those questions into financial outcomes.

But I don’t think scenario planning is finished when the model calculates an answer.

I want to know:

What would management do?

If revenue falls 10%, does hiring change?

If cash falls below a threshold, does CapEx move?

If demand exceeds plan, where do we add capacity?

A scenario should eventually bump into a decision.

Otherwise Finance has just created several alternate universes for everyone to worry about.

I can do that without Excel.

An FP&A Consultant Can Help With Cash Visibility

Sometimes the P&L isn’t the urgent problem.

Cash is.

This is where short-term cash forecasting becomes especially valuable.

A 13-week cash flow forecast can help management understand expected collections, payroll, vendor payments, taxes, debt service and other cash movements on a weekly basis.

I’ve always liked cash forecasting because cash has very little patience for corporate storytelling.

A customer either paid or didn’t.

Payroll either clears or we have a considerably different meeting.

Cash tends to bring conversations back to reality quickly.

For businesses experiencing rapid growth, working-capital pressure, financing events or tighter liquidity, that visibility can materially change how management operates.

An FP&A Consultant Can Help Prepare for the Board

Board preparation has a special ability to reveal every weakness in a finance process at once.

Suddenly everyone wants the numbers.

And they need to tie.

And somebody would like a five-year view.

And why did gross margin change?

And can we show this by segment?

And where did that number on page 17 come from?

Board preparation isn’t just creating slides.

The useful work happens before PowerPoint.

What changed?

What matters?

Where are we off plan?

What assumptions have changed?

What risks should the board understand?

What decisions require discussion?

I’ve never believed the goal of a board deck is to prove Finance has access to charts.

The goal is to help leadership tell the financial story of the business clearly enough that intelligent people can ask better questions.

An FP&A Consultant Can Help Fix the Finance Function

Sometimes the request starts small.

“We need help with forecasting.”

Then you start looking around.

The close takes 18 days.

Actuals don’t tie to management reporting.

Sales and Finance have different revenue numbers.

Nobody owns headcount.

The forecast requires 40 hours of manual work.

There are reports nobody reads.

And Mike is holding the entire thing together with a workbook he built in 2019.

The forecast may not be the problem.

It’s just where the problem became visible.

This is why FP&A consulting sometimes turns into finance transformation.

You start examining:

processes,

roles,

data,

systems,

reporting,

planning calendars,

ownership,

and how information actually travels through the company.

I’m usually less interested in what the org chart says than what happens on Tuesday morning when someone needs an answer.

That’s where you find the real finance function.

FP&A Consultant vs. Fractional CFO

These roles can overlap, but I wouldn’t automatically treat them as the same thing.

A fractional CFO generally takes broader responsibility for financial leadership.

That can include strategy, capital, banking, investors, the board, risk, accounting oversight, M&A and overall finance leadership.

An FP&A consultant is usually narrower.

The focus is planning, forecasting, modeling, analysis, performance and decision support.

There are situations where a company needs both.

There are situations where the CFO is already excellent and simply needs more FP&A horsepower.

And there are situations where what management calls an FP&A problem is actually an Accounting problem wearing a forecast as a hat.

Part of the job is figuring out which one you’re dealing with.

FP&A Consultant vs. Full-Time FP&A Hire

A full-time hire makes sense when the company has enough recurring FP&A work to support the role and wants that capability permanently inside the organization.

Consulting makes more sense when:

the need is project-based,

the company needs experienced help quickly,

the function needs to be built before permanent hiring,

the CFO needs temporary capacity,

the business is going through a transition,

or specialized expertise is needed for a specific problem.

Sometimes I think the best consulting engagement ends with the consultant becoming less necessary.

Build the process.

Document it.

Train the team.

Make ownership clear.

Help hire if needed.

Then let the company run it.

I don’t think good consulting should require creating permanent dependence on the consultant.

That’s a strange definition of fixing something.

What Should You Look for in an FP&A Consultant?

Technical ability matters.

Obviously.

I want someone who understands financial statements, forecasting, modeling, budgeting and business drivers.

But I wouldn’t stop there.

I’d want to know:

Can they understand the business quickly?

Do they ask good questions?

Can they challenge an assumption without turning every meeting into a hostage negotiation?

Can they communicate with non-finance people?

Can they simplify?

Have they actually operated inside Finance?

Do they understand Accounting well enough to know when the FP&A problem begins upstream?

Can they distinguish important work from finance theater?

And maybe most importantly:

Do they know when not to build something?

Consultants are paid to do things.

That can create an unfortunate incentive to make things.

Models.

Reports.

Processes.

Decks.

Frameworks.

I’ve become increasingly impressed by people willing to say:

You don’t need this.

Sometimes the highest-value finance work is removing something.

What Does an FP&A Consulting Engagement Actually Look Like?

If I walked into a new engagement, I wouldn’t immediately start rebuilding the forecast.

I’d spend time understanding what is happening first.

Talk to the CFO.

Talk to Accounting.

Talk to operating leaders.

Look at the financials.

Look at the forecast.

Look at reporting.

Understand the planning calendar.

Trace important numbers back to their sources.

Figure out which processes everyone complains about.

Find the spreadsheet nobody wants me to touch.

There’s always one.

Then I’d start separating symptoms from causes.

Maybe forecast accuracy is poor because the model is weak.

Maybe the model is fine and Sales information arrives too late.

Maybe reporting is slow because Accounting closes slowly.

Maybe Finance is overwhelmed because it produces 30 recurring reports.

Maybe the company doesn’t need another analyst at all.

It needs three processes eliminated.

That’s why I don’t like diagnosing FP&A from an org chart.

The work tells you much more.

What Should an FP&A Consultant Leave Behind?

This is my favorite test of an engagement.

Something should be better after the consultant leaves.

Not just prettier.

Better.

Maybe leadership has a forecast it trusts.

Maybe the company can see cash 13 weeks ahead.

Maybe planning takes two weeks instead of six.

Maybe assumptions have owners.

Maybe reporting is automated.

Maybe the CFO has time back.

Maybe management understands what actually drives the business.

Maybe Finance stopped producing 14 reports nobody was reading.

Ideally, several of those things happen.

But I want the company to have a stronger capability.

Not just a folder full of deliverables.

The Best FP&A Consulting Work Usually Starts With a Mess

I don’t mean catastrophe.

Sometimes the mess is surprisingly polite.

The company is growing.

Revenue is good.

Everyone is busy.

Finance closes the books.

The board gets its deck.

Nothing is obviously on fire.

But the CFO knows something isn’t quite working.

The forecast takes too long.

Answers require too much manual work.

Nobody is completely sure which numbers to trust.

The business has become more sophisticated than the finance function supporting it.

Those are actually some of my favorite problems.

Because the answer usually isn’t one giant transformation.

It’s finding the handful of things creating friction and fixing them in the right order.

Maybe that’s the simplest explanation of what an FP&A consultant actually does.

We walk into a finance problem that has usually accumulated over several years, ask an unreasonable number of questions, and start pulling on threads.

Eventually you find the one that matters.

And hopefully, when you’re finished, Finance works a little better than it did before you arrived.

That’s the job.