Transforming Board Reporting for a Leading Healthcare Provider: Access Community Health

 

Running multiple Xero accounts and managing nationwide operations made reporting complex for Access Community Health’s finance team.

With Joiin’s Microsoft Excel Add-in, they now pull live data directly into their board packs, cutting hours of manual work and giving leadership instant, drill-down insights during meetings.

The Background

When Access, one of New Zealand’s largest community health and care providers, needed faster and more flexible board reporting from Xero, they turned to Joiin – and later, its Microsoft Excel Add-in.

With around 3,500 employees and multiple Xero organisations, Access manages several entities, including a major trading arm with 20 tracking categories. Their finance team needed to consolidate, analyse, and present data in a way that reflected the scale of their nationwide operations, without moving away from the accessibility and usability that Xero provides.

The challenge

As Access grew, so did the complexity of its reporting. The team had outgrown Xero’s native reporting tools but didn’t want to move away from the platform. They needed a solution that could extend Xero, not replace it.

Access faced growing challenges consolidating multiple Xero organisations and 20 tracking categories across regions. Rigid third-party tools limited drill-down capability, large data exports often crashed, and manual processes meant month-end reporting took hours longer than it should.

The solution

After trialling several tools, the Access finance team quickly moved over to Joiin.

Initially, the team used Joiin to build multi-entity, multi-period reports and export these to Excel to fit their standard board templates. Even in this first phase, they saved around two hours per month on manual work.

“In the end, saving two hours is gold. Our people found it easy to use, which made adoption fast.”

Warrick’s team saw the potential of Joiin’s new Excel Add-in and rebuilt their reporting packs around it. Instead of exporting, they now pull live data directly into existing Excel workbooks.

“We literally got an analyst to sign up and start using it. Joiin could get data out of Xero quicker than Xero itself. That blew my mind.”

“We kept our Excel format, gained speed and drill, and cut the grunt work. Now it just refreshes.”

 

“For us, Joiin’s Excel Add-in bridges the gap between automation and flexibility. It gives us the live data of an FP&A tool, but in Excel where we already work.”

Warrick Jackson, Executive Director – Strategy and Finance.

How Access Uses the Joiin Excel Add-in

  1. Live-linked board pack
    Each board pack combines Month, YTD, and full-year context on a single page. All figures update instantly when refreshed, allowing leadership to interrogate data live.
    “We’ve replaced copy-paste with direct links. The person who used to wrangle the spreadsheet doesn’t need to touch it now. We open, refresh and it works.” 
  2. Regional and sub-regional views
    Their largest entity uses 20 tracking categories. These are now mapped directly into Excel via Joiin links, enabling instant comparison between national, regional, and sub-regional performance. 
  3. One master sheet, 15 regional reports
    A single master workbook powers 15 automatically generated regional reports. With a little VBA, the team extracts individual reports from the master, ensuring consistent formats and faster distribution. 
  4. Reliable and cleaner data
    Trial balance and full-code extracts exposed naming inconsistencies across entities. Fixing them once means all links now work every time, improving data integrity and audit readiness. 
  5. “Set and forget” automation
    With periods pre-linked and refresh-on-open enabled, the pack now updates itself. Aside from an annual rollover, no manual rebuilds are needed.
    “It’s genuinely set and forgotten. Once a year we roll forward the periods, and it just runs. That’s the dream.”

Area

  • Report downloading
  • Report creation
  • Data integrity
  • Distribution
  • Board Prep
  • Adoption

Before Joiin

  • 2–3 hours of manual copy/paste
  • Another 3 hours building packs
  • Inconsistent naming
  • Manual emails, multiple versions
  • Static reports
  • Analyst-only

After Excel Add-in

  • Automated refresh
  • Automated set and forget
  • Fully standardised chart
  • 15 packs from one source
  • Live drill-down in meetings
  • Entire finance team confident using it

The benefits

  • Faster month-end: Hours saved every cycle through automation.
  • Live, linked data: Real-time updates with no manual exports.
  • Stronger consistency: One source of truth across 15 regional reports.
  • Familiar tools: Excel-based formulas, easy adoption.

The conclusion

Access Community Health’s story shows what Joiin’s Microsoft Excel Add-in does best – automating reporting while keeping the flexibility of Excel.

Live multi-entity data refreshes on demand, in a familiar environment that finance teams already know. The result: less manual work, faster decisions, and complete confidence in the numbers.

See Joiin in action

Watch our on-demand demo today

Ready to streamline your month-end processes?

Start your free trial today and discover how Joiin can help your business.