Partnering with Lancia Consult, Nuzest, a global nutrition brand, integrated its sales, inventory, finance, and e-commerce systems into a single, governed platform, boosting reporting accuracy, reducing manual effort, and enabling faster, more confident decision-making.
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 Consult to replace the spreadsheet‑heavy process with a single, trusted platform for reporting and planning.
The Solution
The team at Lancia Consult:
- 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 Nuzest’s 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.
“Lancia Consult’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
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.
Ready to transform your business with unified insight?
Partner with Lancia Consult to break free from fragmented spreadsheets and unlock real-time, actionable intelligence across your operations. Empower your team to make faster, smarter decisions today.