As HQ Group expanded from cafés to a floating bar, multi-level venues, and a cocktail business, finance processes struggled to keep up: separate Xero files, manual Excel packs, inconsistent COAs, and time-consuming AP and month-end cycles. With Acterys integrated to Xero and Power BI, the team consolidated data into a governed SQL model, automated AP and month-end reporting, and delivered real-time, venue-level insight for leadership without spreadsheet chaos.
They were able to:
- Cut AP listing prep from 1–3 hours to a click for faster, reliable cash-flow reviews
- Accelerate month-end across multiple entities (P&L/BS/CF) with automated, refreshable packs
- Establish a single source of truth across venues, with live SQL feeding Power BI
- Reduce errors from duplicate invoices/intercompany variances and align the chart of accounts
- Unlock operational analytics (daily sales by F&B, deposit tracking, YoY performance)
- Support a custom fiscal calendar (4-4-5) for like-for-like period comparisons
- Build rolling forecasts off the same model; empower finance to self-serve in Power BI/SQL