TEPEDE - From 20-Day Consolidation to Real-Time Multi-Country Reporting
Case study of integrating 8 entities in 6 countries with 6 different ERP systems into unified analytical platform, transforming 20-day reporting process to real-time overview with €300-400k capital release.
Real-Time Consolidation: From 20-Day Excel Consolidation to Real-Time Multi-Country Reporting
8 entities • 6 countries • 6 different ERP systems • 3-4 month implementation
Industry: Trade | Solutions: Financial consolidation • Inventory management • Distribution and sales mix analysis • Profitability management
Challenge
TEPEDE, leader in visual communication in Central and Eastern Europe, managed complex operation across six countries. Eight entities, six different ERP systems (Pohoda, KORWIN, Kulcs Soft, custom databases). Financial consolidation required 20 days and over 100 hours monthly.
With group growth, the need for faster visibility and more efficient consolidation grew.
Based on our experience with financial processes and multi-country consolidation, we were recommended to TEPEDE owner.
We proposed balanced solution: keep existing ERP systems and create integrated analytical layer that provides real-time overview and simplifies consolidation.
Solution
Financial Consolidation
- Connection of all 6 ERP systems with automated data extraction multiple times daily
- Standardization of financial data into unified chart of accounts across entities
- Automation of multi-currency and multi-level reporting consolidation
Result: 20-day reporting process transformed to real-time view every day. Finance team transitioned from 90% time on data collection to 90% time on analysis.
Sales Intelligence
- Unification of sales data from all 8 entities into one data structure
- Standardization of product categories and customer hierarchies across countries
- Automated daily dashboards with drill-down (Group - Country - Channel - Client - SKU)
- Active redirection of sales intelligence to profitability drivers - profitability analysis by products, customers and countries
- Additional review of pricing strategy - active advisory in price adjustments with real-time margin monitoring for sustainable growth
Result: Continuous profitability growth despite market decline. While industry and local markets are falling, TEPEDE is growing in all countries of operation.
Inventory Optimization and Management
- Connection of central warehouse and 6 local warehouses
- Standardization of product master data with automated ABC classification
- Real-time monitoring with alerts for order needs and allocation recommendations
- Active turnover monitoring at individual item level
- Proactive tracking and recommendations for replenishment and clearance cycles
Result: Improved turnover and warehouse efficiency. Released approximately €300-400k cash from inefficient inventory.
Approach
Gradual implementation over 3-4 months: Discovery → Build → Pilot in Slovakia → Scaling to remaining countries
Without ERP replacement. Everything connected into one intelligence layer with simple access for employees in all countries.
Transformation
20 days reporting → real-time view every day | 100 hrs/month → 10 hrs/month | 3-week lag → daily updates
Finance team transitioned from 90% data collection to 90% analysis. Decisions based on current data, not month-old spreadsheets.
Infrastructure scales: adding new countries or entities doesn’t require system rebuild.
Real story: On Monday morning caught problem in Croatia. By Wednesday resolved.
Without replacing existing systems. Without enterprise budgets. Without year-long projects.
Have Similar Situation?
If you’re dealing with consolidation across countries or entities, let’s talk.
Contact: contact@onetribe.sk | onetribe.sk
Onetribe: Enterprise BI + Strategic CFO Advisory for European SMEs | Slovakia | CEE | UK
Expand your knowledge with our resources
Explore our comprehensive library of articles, guides, and tutorials to deepen your understanding of key concepts and stay up-to-date with the latest developments.