Financial Planning SaaS Platform

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.

Financial planning SaaS platform for advisers

Industry
Financial services, wealth coaching and financial planning
Organisation
Australian wealth advisory startup
Solution type
Custom SaaS platform, spreadsheet to software conversion
Core technology
Angular, .NET microservices, SQL Server, Microsoft Azure
Engagement
12+ months, ongoing development and support

Headline resultA fragile offline workbook replaced by a modular, production grade platform that matches the original model’s outputs

Overview

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 Problem

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.

  • No scalable productNo way to sell the methodology as a scalable digital product.
  • Risky changesTightly coupled formulas made every change risky.
  • No documentationNothing existed beyond the workbook itself.
  • Hidden errorsCalculation errors were quietly affecting client advice.

Our Solution

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.

  1. Complete questionnaire
  2. Choose a package
  3. Pay online
  4. Book coach sessions
  5. Follow the action plan

Financial planning SaaS platform for advisers and their clients

Key Features

  • Detailed financial questionnaire covering income, assets, debts and lifestyle costs
  • Wealth health score and goal likelihood scoring
  • Backend modelling of cash, property, shares, superannuation, vehicles and home contents
  • Liability modelling for mortgages, car loans, student debt and credit cards
  • AI generated 24 month strategy and action plan
  • Action tracking dashboard for clients and coaches
  • Branded PDF report generation
  • Package selection, online payment and coaching session booking
  • Administration portal for managing users, content and plans

Outcomes

  1. Multiple production releases delivered, each tested against the original workbook to confirm matching outputs
  2. A methodology that was locked in a spreadsheet is now a scalable, sellable digital product
  3. Calculation errors removed, improving the reliability of client advice
  4. Modular services make future features faster and safer to deliver
  5. The platform has supported the client in forming partnerships with larger organisations

Technology Stack

Frontend4 technologies
Angular

Angular

HTML

HTML

CSS

CSS

JavaScript

JavaScript

Backend5 technologies
C#

C#

.NET

.NET

REST APIs

REST APIs

Entity Framework

Entity Framework

Microservices

Microservices

Database1 technology
SQL Server

SQL Server

Cloud and DevOps4 technologies
Azure Web Apps

Azure Web Apps

Azure API Management

Azure API Management

Azure Blob Storage

Azure Blob Storage

Azure DevOps

Azure DevOps

Who This Solution Suits

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.

Have a Complex Model or Manual Process to Turn into Software?

Talk to the Microknot team about your project.

Book a Free Consultation

See Our Other Case Studies

Cloud Tax Refund Platform

A cloud based platform for a multi branch accounting firm, with real time reporting, a client portal and EFT refunds.

  • Accounting
  • Tax Services
  • Cloud Migration

Distribution Centre Labour Planning

A labour planning and cost control system for distribution centres, integrated with the warehouse management system.

  • Logistics
  • Retail
  • Workforce Planning

HubSpot and Genesys Cloud Integration

An Azure hosted integration between HubSpot CRM and Genesys Cloud with live caller lookup, call logging and AI transcription.

  • Contact Centres
  • Not for Profit
  • System Integration

AI Risk Flagging of NDIS Shift Notes

A platform that syncs Deputy shift notes and uses Azure OpenAI to flag NDIS participant risks for coordinators.

  • Disability Services
  • NDIS
  • AI Software