From fragmented spreadsheets to unified insight at Nuzest
Empowering a global nutrition brand to connect sales, inventory, finance and e-commerce into one governed platform – boosting reporting accuracy, reducing manual effort, and enabling faster, more confident decision-making.
Service
Sector
“Lancia’s reporting solution and financial model transformed how we operate – streamlining management reporting, forecasting and planning. We now have clear visibility and can make faster, better decisions.” — Peter Greeff, CFO/COO, Nuzest Group
The Challenge
Nuzest’s financial and operational data sat across multiple systems (inventory, accounting, consolidation, web sales and analytics) with spreadsheets used to bridge the gaps.
Reporting was spread over several workbooks with limited metrics, manual consolidation and frequent exports, creating delays and risk of error. Key items such as lot expiry and stock value were tracked only in Excel, and web data remained isolated, so there was no unified view of performance or return on marketing spend.
The CFO engaged Lancia to replace the spreadsheet‑heavy process with a single, trusted platform for reporting and planning.
The Solution
- Built a governed data‑cube as a single source of truth, integrating inventory (Cin7 Core), accounting (Xero), consolidation (Joiin), web sales (Shopify) and web analytics (Google Analytics).
- Delivered an interactive, real‑time dashboard suite: Sales (by region, product, client, period), Inventory (lot expiry, stock location, value at risk), and Web Channel (e‑commerce and marketing performance).
- Added a Key Insights view to surface product concentration, SKU demand and regional trends for quick, data‑driven decisions.
- Developed an integrated forecasting and budgeting model with a single assumptions page driving volumes, costs, margins, working capital and funding terms.
- Automated financial statements (income, balance sheet, cash flow) with five‑year history and projections, plus monthly and year‑to‑date variance analysis.
- Created a company‑specific data agent (artificial‑intelligence powered) connected to the cube for plain‑English queries, mode‑switching (analysis, strategy, monthly report) and export‑ready outputs (PDF/PowerPoint).
The Impact
The unified platform gave leadership a clear line of sight from data to decision. Reporting accuracy improved, manual effort dropped, and the team shifted from backwards-looking compilation to forward‑leaning action. Nuzest gained a reusable model and dashboard foundation that supports future advanced analytics.
Results
- Identified opportunity for 20% stock reduction through shorter holding periods and product focus.
- Improved stock management, enabling stock‑outs and write‑offs to be targeted at below 1%.
- Reduced over‑budgeted promotional spend by 15% with clearer marketing return‑on‑investment insight.
- Freed 25% of the finance team's reporting time.
- Detected data anomalies that can improve measurement accuracy by >10%.
What Changed
- One governed source of truth across sales, inventory, financials and e‑commerce.
- Investor-grade visibility with interactive slicing by region, entity and period.
- Faster planning cycles with effortless re‑forecasts and consistent assumptions.
- Leaders making quicker, more confident decisions backed by shared definitions and timely insight.
