How BGSF Improved Budgeting and Forecasting with Dynamics 365 and Solver
From Excel-Based Budgeting to Structured Financial Planning: Budgeting and forecasting software for Dynamics 365 in practice
Download the case study PDF
Professional servicesCustomer story
- Customer
- BGSF
- Industry
- Professional services
- ERP
- Microsoft Dynamics 365 Finance and Operations
At a glance
With Solver in place, BGSF established a more structured approach to budgeting and forecasting.
The Situation
BGSF, a multi-division professional services organisation, had implemented Microsoft Dynamics 365 Finance and Operations (D365 F&O) as its core financial system.
While this provided a strong foundation for financial data, budgeting, forecasting, and reporting processes were still managed outside the system using Excel. These models included multiple driver-based calculations and required ongoing manual updates.
As the organisation grew, there was an increasing need to forecast more frequently and improve visibility into operational performance.
The existing approach worked, but it required significant coordination and effort to maintain consistency across teams.
What Was At Stake
As planning cycles became more frequent, the reliance on Excel-based budgeting introduced challenges:
- Time spent updating and managing multiple versions of spreadsheets
- Limited ability to align financial reporting with forecasting in a consistent way
- Increased effort required to maintain accuracy across departments
- Reduced visibility into performance between reporting cycles
The finance team needed a more structured approach that could support ongoing budgeting and forecasting without increasing complexity.
The Turning Point
BGSF began looking for budgeting and forecasting software for Dynamics 365 that could extend the capabilities of their ERP.
The focus was not on replacing existing systems, but on introducing a layer that could:
- Bring budgeting, forecasting, and reporting into one environment
- Reduce reliance on manually managed spreadsheets
- Support more frequent and consistent planning cycles
Solver was selected as the platform to provide this structure alongside Dynamics 365.
(This project was delivered by the Solver US team.)
What We Did
Solver was introduced as a structured environment for budgeting, forecasting, and financial reporting, using data from Dynamics 365.
The approach focused on:
Structuring Budgeting and Forecasting
Excel-based models were replaced with centralised budgeting templates, allowing departments to update their inputs in a consistent format.
Aligning Reporting and Planning
Financial reporting and forecasting were brought into the same environment, making it easier to compare actuals against budget and forecast.
Reducing Manual Coordination
Instead of managing shared spreadsheets, teams could access and update their budgets independently within Solver.
This allowed the finance team to maintain control over structure, while reducing the effort required to manage the process.
“Solver was the budgeting tool that we needed to help us improve our processes.”
The Result
With Solver in place, BGSF established a more structured approach to budgeting and forecasting.
- Budgeting became faster and more accurate across departments
- Financial reporting and planning were aligned in one system
- Teams could update budgets independently, improving consistency
- Comparisons between actuals and forecasts became easier to manage
Submitting budgets no longer required coordinating shared files. Instead, inputs could be updated directly, resulting in more up-to-date and reliable forecasts.
What They Can Do Now
With a structured approach in place, the finance team can now:
- Maintain accurate budgets without managing multiple spreadsheet versions
- Update forecasts more frequently with less effort
- Compare financial actuals and forecasts in a consistent way
- Support better visibility across departments and operations
- Spend more time reviewing performance rather than maintaining models
Why It Worked
This shift from Excel-based budgeting to structured financial planning was effective for three reasons:
Built Around Existing Systems
Solver extended Dynamics 365 rather than replacing it, allowing BGSF to build on their existing financial data.
Familiar but Structured
The solution retained the familiarity of Excel while introducing a controlled environment for budgeting and forecasting.
Designed for Ongoing Use
The focus was on supporting regular planning cycles, not just improving a single budgeting process.