Financial Planning SaaS Platform Built From a Complex Spreadsheet Model
An 80+ sheet Excel workbook became a subscription platform with wealth scoring, AI action plans and coach bookings.

An 80+ sheet Excel workbook became a subscription platform with wealth scoring, AI action plans and coach bookings.

Headline resultA fragile offline workbook replaced by a modular, production grade platform that matches the original model’s outputs
An Australian wealth advisory business had built its entire methodology inside a single, very large Excel workbook. Using our SaaS development services, we turned that workbook into a subscription SaaS platform that combines online financial modelling with scheduled sessions alongside a licensed wealth coach. The platform scores a client’s financial health, models their future position and uses AI to produce a personalised two year action plan.
The business had a proven advisory method, but it lived in a spreadsheet that only a handful of people understood. The workbook contained more than 80 sheets, some with over a thousand rows, plus macros, and the file exceeded 25MB. It could not be offered to customers online, it was slow to update and it carried real risk every time someone changed a formula.
There was also no written specification. The spreadsheet itself was the only record of how calculations worked, and during analysis our team found several calculations that produced inconsistent results.
As part of our legacy system modernisation services, we reverse engineered the workbook sheet by sheet, documented every calculation and rebuilt the logic as a set of independent services. Breaking the dependencies apart gave the client a modular architecture where new products, rules or calculators can be added without disturbing the rest of the model. Calculation discrepancies were identified, confirmed with the client and corrected during the rebuild.
The customer journey is simple. A user completes an in depth financial questionnaire, selects a package, pays online and books sessions with a wealth coach. Behind the scenes, the platform models assets, liabilities and expenses, then uses AI to generate a 24 month action plan, with the first year broken into quarterly milestones that line up with coaching meetings.

Angular
HTML
CSS
JavaScript
C#
.NET
REST APIs
Entity Framework
Microservices
SQL Server
Azure Web Apps
Azure API Management
Azure Blob Storage
Azure DevOps
This approach suits financial planners, wealth coaches, accountants and fintech founders whose intellectual property sits inside complex spreadsheets. It is also relevant to any business that wants to turn an internal calculation model into a customer facing SaaS product.
Talk to the Microknot team about your project.