Case Study: Royal Horticultural Society achieves rapid, accurate self-service reporting and high ROI with PrecisionPoint

Royal Horticultural Society - Customer Case Study

The Royal Horticultural Society, a £65m charity with no government funding, struggled to produce reliable monthly board and budget reports across four companies, ten divisions and hundreds of cost centres. Extracting data from Microsoft Navision relied on slow cut-and-paste processes, IT-written VBA reports and error-prone spreadsheets, so the RHS needed a faster, auditable way to track restricted funds and spending — and engaged PrecisionPoint to help, using PrecisionPoint for Dynamics NAV along with PrecisionPoint Advanced Inventory and the XLPublisher Excel add-in.

PrecisionPoint implemented an out-of-the-box BI solution that integrates general ledger and sub-ledger data into a single transaction-level database and OLAP hypercube, enabling self-service reporting and rapid ad-hoc analysis. The RHS can now produce and amend board and budget-versus-actual reports in minutes, reconcile numbers confidently, reduce IT dependence, and free up finance time for deeper analysis; according to RHS finance, PrecisionPoint delivered meaningful BI with an ROI estimated to be less than the cost of an additional head.

Royal Horticultural Society

David Wilson

Finance Manager