LIV-EPI is one of Slovakia’s largest engineering design firms, specialising in energy and industrial projects and managing 20 or more designers across a complex project portfolio. Before the engagement, project forecasts were maintained across dozens of Excel spreadsheets updated manually each week, requiring reconciliation with the KROS Omega accounting system — a process that created a persistent time lag between actuals and the forward view, and consumed significant manual effort with no scalable path forward. Management needed decision-making visibility based on long-term outlook, not just historical results. Onetribe integrated KROS Omega directly with its platform, built complete financial reporting including P&L, balance sheet, and cash flow in real-time from accounting data, and developed a structured projection model that synchronises automatically with accounting records at the transaction level, reducing manual inputs to minimal scope. Cash flow projections and long-term financial outlook became available without manual maintenance. Results: weekly manual Excel forecast updates were replaced by automated real-time updates; manual reconciliation with accounting data was eliminated; management shifted from reactive reporting to proactive planning with long-term visibility; and adding a new project requires only model configuration, not a new set of spreadsheets.
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