Context
- One of Slovakia’s largest engineering design firms specializing in energy and industrial sectors
- 20+ designers managing complex project portfolios
- Contacted Onetribe based on reference from IFT
- Used KROS Omega ERP system with functional processes
- Maintained detailed but manual project forecasting in series of Excel spreadsheets
Challenge
- Need for automated financial outlook integrating actual accounting data with project forecasts
- Each project had unique characteristics including varying durations and different cost structures
- Required real-time profitability tracking across diverse project portfolio
- Decision-making needed to be based on long-term outlook not just historical results
- Manual updates across dozens of Excel files were time-consuming
- Time lag existed between actual results in accounting and plan updates
- Weekly forecast updates required manual reconciliation with accounting data
What Was Implemented
- Direct integration of KROS Omega ERP with Onetribe platform
- Complete financial reporting including income statement, balance sheet, and cash flow statement in real-time from accounting data
- Structured projection model synchronized between accounting and existing manual forecasts
- Automatic updates from accounting records at transaction level
- Reduction of manual inputs to minimal scope
- Detailed financial outlook and cash flow projections
- Long-term outlook built on actual data rather than estimates
- Integration enabling management to see both historical reporting and automated future outlook simultaneously
Outcomes
- Transition from weekly manual Excel forecast updates to automated real-time updates
- Manual reconciliation with accounting data eliminated
- Time lag between actuals and plan eliminated
- Automated forecast updates from accounting records at transaction level
- Reduction in manual work required for forecast maintenance
- Immediate visibility of cash flow projections
- Controlled growth enabled by long-term outlook capabilities
- System scalability achieved where adding new project requires only model configuration, not new Excel files
- Management shift from reactive reporting to proactive planning with long-term visibility