Part of the MeltOne Advisory group · Montreal · Paris · New York · Bogotá · Singapore

Careers Contact ENES
PLANNING

When should I stop planning in Excel?

The time comes when your team spends more time building the budget than analyzing it. Excel is flexible and everyone knows it. But when planning involves many departments, versions and scenarios, that flexibility becomes a risk.

By Sophie Michel · General Manager, MeltOne Latam4 min read

The risk is real: a review of 35 years of research, published in 2024 in Frontiers of Computer Science, found that 94% of spreadsheets used for business decisions contain errors.

Six signs Excel is no longer enough

  • There are several versions of the budget and nobody is sure which one is current.
  • Consolidating what departments send takes weeks.
  • Simulating a new scenario takes days, not minutes.
  • The model depends on one or two people who understand its formulas.
  • You don’t know who changed which number, or when.
  • The forecast is disconnected from actuals in the ERP.

If you recognize three or more, the cost of staying in Excel is already higher than the cost of switching.

What changes with a planning platform

An EPM platform brings assumptions, actuals and scenarios together in a single model. Each department enters its part in a workflow with approvals, and consolidation stops being a monthly project. On top of a well-organized model you can also add machine learning forecasts and variance analysis.

There are several solid options on the market, such as CCH Tagetik, Anaplan, Pigment or SAP Analytics Cloud. The best one depends on your complexity, your ERP and your team, not on what’s trending.

How to start without breaking the process

  1. Start with one area. Operating expenses or revenue, not the whole budget at once.
  2. Redesign before migrating. Copying the Excel model as-is into a platform also carries over its problems.
  3. Run one cycle in parallel. Compare results before switching off the old model.
  4. Choose with your real cases. An RFP based on your concrete scenarios avoids picking the flashiest demo.
  5. Train your team. So your people can adjust the model without depending on the consultant.

Excel doesn’t disappear: it stops being the system. It’s still useful for ad hoc analysis, while planning lives in a reliable place.

Sophie Michel

ABOUT THE AUTHOR

Sophie Michel

General Manager, MeltOne Latam

Leads the strategy and growth of MeltOne Latam, and works alongside finance and IT teams across the region on their data, planning and AI projects.

View LinkedIn profile

KEEP READING

More questions CFOs ask us

Back to home
AI

Is my ERP ready for AI agents?

What decides whether an agent works isn’t the technology, but your data and processes. Five questions to find out.

November 2026 · 4 min readRead

CLOSE

How many days should my close take?

The benchmark is 6 calendar days. What drags a close out, five levers to shorten it and what to measure.

November 2026 · 4 min readRead

PROCESSES

Where should I start optimizing my finance processes with AI?

Where AI adds value in finance today, how to pick the first use case and how to move from pilot to results.

November 2026 · 4 min readRead