Sooner or later every Excel-based plan hits its limits: too many files, too many versions, too many links nobody understands any more. Then the question arises whether specialised planning software is the answer. The answer is often “yes” – but not for every company and not for every solution.
Warning signs: when Excel is no longer enough
- Budget planning takes longer than eight weeks, mainly because of consolidation and alignment.
- More than ten people plan in separate files.
- There are several legal entities that need to be consolidated.
- Scenarios and forecasts are hardly possible because every change takes days.
- There are errors that only show up late – broken links, overwritten formulas.
The categories at a glance
| Category | Description | Typical for |
|---|---|---|
| Structured Excel | Standardised templates, Power Query, central assumptions | Small companies, one entity |
| Excel-based planning tools | Excel as the interface, data in a central database | Mid-sized companies that want to keep Excel logic |
| Integrated financial planning and consolidation | Income statement, balance sheet and cash flow integrated, often with consolidation | Groups with several entities |
| CPM and xP&A platforms | Company-wide planning across finance, sales, HR and supply chain | Larger companies with complex models |
Well-known vendors in German-speaking countries include LucaNet, Jedox, Board, Corporate Planner, Prophix and Anaplan. The solutions differ widely in focus, usability and pricing. A serious comparison is only possible against your own requirements – and with a trial on your own data.
The most important selection criteria
- Integrated financial planning: are income statement, balance sheet and liquidity automatically connected?
- Data integration: how easily can actuals be loaded from accounting and ERP?
- Flexibility: can controlling adapt models itself, or does every change need a consultant?
- Usability for departments: can cost centre managers plan without training?
- Workflow and rights: approvals, comments, versions, access rights.
- Reporting: built-in reports or connection to Excel or Power BI?
- Operation: cloud or own server, data location, security.
- Total cost: licences, implementation, training and ongoing support over five years.
A proven selection process
- Gather requirements: with controlling, management, IT and two or three departments.
- Market overview: pre-select five to eight vendors based on must-have criteria.
- Scripted demos: shortlist three vendors.
- Proof of concept: two vendors build a slice with real data.
- References: talk to companies of similar size and industry.
- Decision: weighted scoring plus total cost comparison.
Common mistakes
- The software is supposed to rescue an unclear process. Clarify the process first, then choose the tool.
- Departments aren't involved and later don't use the system.
- Only licence costs compared, implementation costs underestimated.
- Too much at once: better to start with budget and forecast and extend later.
Conclusion
Planning software makes sense when the effort for consolidation and alignment eats up the benefit of planning. The selection should be based on your own processes, tested with real data and involve the departments – then the investment becomes a real time saver.
- BARC – financial planning software compared – independent analyst ratings and user reviews
- Lucanet – consolidation and financial planning
- Jedox – planning with an Excel-like interface
- Board – planning, analysis and reporting on one platform
- Corporate Planner – planning, reporting and consolidation for mid-sized companies
- Prophix – budgeting, forecasting and reporting
- Anaplan – enterprise-wide planning for larger organisations
This list is not exhaustive and is not a recommendation. We receive no commission.
Frequently asked questions
From what company size is planning software worth it?
There is no fixed threshold. What matters is the number of people planning, multiple legal entities and the effort for consolidation and scenarios.
What is the difference between CPM and BI?
CPM software (corporate performance management) supports planning, consolidation and forecasting. BI software like Power BI focuses mainly on analysing and visualising actual data.
How long does it take to implement planning software?
For a budget and forecast solution in a mid-sized company, three to six months are typical, depending on complexity and data integration.