Video:

HQ Group Slashes Month-End Reporting from Days to Minutes Using Acterys

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

Discover more Acterys videos

Most Power BI deployments are a one-way street. Source systems flow in, teams view polished...

The biggest objection to new planning software is change management. Acterys sidesteps it. The writeback-enabled...

A standard Power BI matrix can’t change a single number. The Acterys Matrix can. It’s...

Sometimes the request is simple: let me add a comment to a Power BI report....

Here’s the question behind this one: what if the chart wasn’t the output, but the...

Your team is working off one shared budget version. One person wants to test their...