Nav Level 1 - Customer Success

Each YMCA is its own operation, focusing on four key areas of work: accommodation; family work; health and well-being; and training and education. Finance’s role is to oversee the Association’s finances and run the budgets and forecasting for all of its activities—but with a complex web of spreadsheets and activities across multiple sites, the YMCA London South West struggled to assimilate budget information. Implementing Adaptive Insights gave it control over the budgeting process to create more strategic forecasts.

Challenges

  • Linked spreadsheet model used for financial planning

  • Fractured financial planning over multiple sites

  • Limited budgeting capability

Results

  • Integrated accounting and staffing data for holistic view of corporate performance

  • Increased control over financial planning process

  • Faster, more strategically efficient budgeting

About:
The YMCA is the oldest and largest youth charity in the world, set up by Sir George Williams in England in 1844. Across England and Wales, it is run as a federation with 120 local YMCAs working independently to support young people to belong, contribute, and thrive in their communities.
Location:
London, U.K.
Industry:
Nonprofit

Save time and manpower. Try Adaptive Insights free for 30 days.

Free Trial

Introduction

The YMCA is the oldest and largest youth charity in the world, set up by Sir George Williams in England in 1844. Across England and Wales, it is run as a federation with 120 local YMCAs working independently to support young people to belong, contribute, and thrive in their communities.

Workforce and capital planning fuel decision-making

The YMCA is the oldest and largest youth charity in the world. Run as a federation, each YMCA Association is its own operation, focusing on four key areas of work: accommodation; children, youth and family; health and well-being; and training and education. Finance’s role in YMCA London South West is to oversee the Association’s finances, from cash management to banking, and run the budgets and forecasting for all of its activities. 

“Our aim as a community charity is to meet people at their point of need, be that with temporary housing, working with children, or fitness courses. Finance makes sure the charity is properly run and accounted for, so those activities can reach as many people as possible,” explained Carrie Bowers, principal finance officer, YMCA London South West.

Before implementing Adaptive Insights, the branch struggled with using Excel spreadsheets to budget and to fine-tune forecasts. With activities taking place across a number of sites, one discrepancy or broken link in its Excel-based planning system would alter the entire budget, making it a very fragile and error-prone process.

Flexible, accurate workforce planning, budgeting, and reporting

The YMCA London South West identified Adaptive Planning as a solution that could give it a clearer view of its finances, without requiring a complete overhaul of its accounting practices and financial model. The ability to import data from existing accounting and HR payroll packages has created a single version of the organization’s budgeting data.

Changes are now reflected in real time and can be viewed and edited by personnel throughout the different sites. In addition, there are now no longer risks of glitches or version errors. This was especially valuable for the finance team in monitoring staffing, the YMCA’s largest and most important expenditure. Tracking payroll had been notoriously difficult, with management split across different sites, projects, and business areas. With all the data now rolled into one system, the YMCA is able to create hiring strategies aligned with operational plans, while giving finance and HR instant visibility into current and future employee expenses allocated across programs and locations.

Long-term capital planning and scenario modelling help fund mission 

With actuals data from accounting input each month aligned with planning data, the improved data integrity has increased forecasting accuracy and made it easier for the Association to implement long-term planning. Its five-year forecast factors in current long-term development projects involving hostels and starter accommodation housing developments to gain insights on the cash flow that will be available over the period. It has also allowed the finance department to run shorter-term cash-flow reporting more regularly, with new capabilities in slicing and dicing the data and in producing quality reports to the board.

“Adaptive Insights gives you complete control over the whole financial model and has helped us to be far quicker, more efficient, and more strategic in our planning and forecasting processes,” said Bowers. “You can configure the system yourself, easily adding a new staff member or cost center and also have control over who has access and when, which has assisted in deadlines being met.”

See Adaptive Planning software in action. Watch an online demo.

Watch a Demo