Community Living Trust replaces spreadsheet chaos with real-time budgeting and quarterly forecasting.

Community Living Trust is a Hamilton-based not-for-profit dedicated to supporting people with intellectual disabilities across the Waikato, Bay of Plenty, and Midland regions of New Zealand. With nearly 400 employees serving close to 700 clients and an annual turnover of NZ$20 million, the organisation carries real weight — and real responsibility.

Across its eight services, budget data had to travel from spreadsheet to spreadsheet before it could be imported into the General Ledger — a chain of manual steps that introduced misplaced figures, imbalances, and delays at every link. Analysis could only begin once data reached the GL, which meant the finance team was always working retrospectively, with little room to get ahead of problems before they materialised in the numbers. For an organisation where staffing costs account for 75% of total expenses, that lag had a direct cost — every decision made on stale data was a decision made blind. Accuracy was not optional; it was what the mission required.

In 2012, Community Living Trust implemented IDU-Concept through BES IT Systems, replacing the spreadsheet chain with a single, centralised web-based platform linked directly to the General Ledger. Data no longer passed through human hands between systems — it lived in one place, accurate in real time, visible to anyone who needed it.

What made the difference was not only what the system could do, but who could use it. Managers across the Trust's eight services — including those with limited confidence around technology — found IDU-Concept straightforward and, quickly, something they relied on daily. They could drill down into transactional detail, enter commentary against budget items, access their budgets on mobile, and see exactly where their numbers stood without waiting on the finance team to reconcile a spreadsheet. That shift in ownership mattered. Budget management moved from a dependency on the finance team to something managers across all eight services could own directly.

The platform also gave the Trust its first meaningful visibility into staffing costs. By aligning funded hours with actual support hours, the finance team could identify potential overruns before they reached the General Ledger. That forward visibility changed the nature of the finance function — from reconciliation to anticipation. And for the first time, quarterly forecasting was possible — not as an aspiration, but as a routine.

The results were tangible across four areas. Spreadsheet chaos was eliminated, replaced by a centralised system with a direct, unbroken connection to the General Ledger. Real-time accuracy meant figures were visible to managers and finance staff the moment they were needed, with no manual reconciliation between files. Reporting was streamlined, reducing the administrative burden on the finance team and freeing capacity for analysis. And managers across all eight services gained drill-down access to transactional detail and could enter commentary at the budget-item level — tools that, for those who had previously found the process daunting, proved decisive. Quarterly forecasting, something the organisation had never been able to achieve with spreadsheets, became routine.

"Community Living Trust needed a smarter, more transparent way to manage complex budgets. IDU-Concept delivered real-time accuracy, empowered managers, and gave the organisation forecasting capabilities that transformed their financial planning." – Rob Jones, IDU New Zealand

"We were hooked from the start. IDU-Concept made budgeting less daunting, even for managers with limited computer confidence. It's accurate, intuitive, and gives us the ability to prepare quarterly forecasts — something we could never achieve with spreadsheets." – Sharon Muller, Accountant, Community Living Trust