Turning a Spreadsheet-Led Investment Process into a Connected Digital Platform

An established UK financial planning and wealth-management firm relied on spreadsheets and disconnected systems to support important parts of its investment-review process.

Although these processes had developed around genuine business needs, they required significant manual effort, made consistent oversight difficult and limited the organisation's ability to scale.

Irvine-David helped transform that environment into a connected digital platform covering portfolio analysis, investment research, model comparison, rebalancing, governance, reporting and client engagement.

The result is a more efficient and joined-up way of working that reduces manual handling, strengthens investment governance and gives both the business and its clients better access to trusted information.

The Client

Our client is an established UK financial planning and wealth-management firm responsible for helping individuals and families understand, manage and plan their financial futures.

The business combines financial planning expertise with an established investment process designed to ensure client portfolios remain appropriate, diversified and aligned with agreed investment strategies.

As the organisation continued to grow, it became increasingly important that the technology supporting those activities could grow with it.

The opportunity was not simply to replace a spreadsheet.

It was to create a digital foundation connecting investment data, portfolio reviews, internal workflows, management reporting and the client experience.

The Challenge

The client's existing investment-review process depended heavily on spreadsheets, manual data preparation and information moving between several systems.

These tools had supported the business successfully, but they also created a number of operational challenges.

Portfolio information had to be collected, checked and reformatted before analysis could begin.

Calculations and review steps depended on individual spreadsheets being maintained correctly.

Information moved between investment, planning and administration teams through a mixture of documents, emails and manual handovers.

Producing reliable management information required further consolidation and interpretation.

This made the overall process:

·        time-consuming;

·        difficult to oversee consistently;

·        vulnerable to avoidable data-entry and calculation errors;

·        dependent on knowledge held by individual team members;

·        harder to evidence and audit;

·        difficult to connect with wider business systems;

·        and increasingly challenging to scale.

The existing technology also created limitations beyond the investment team.

Senior leaders did not always have straightforward access to the reporting data needed to understand activity, trends and operational performance.

Clients had limited ability to engage digitally with their financial information or see an up-to-date picture of their portfolios.

The challenge was therefore broader than process automation.

It was to create a more connected operating model for investment management, internal decision-making and client service.

Moving Beyond Spreadsheets

Spreadsheets are extremely useful tools, particularly when a business process is still developing.

They allow teams to test ideas, create calculations and adapt quickly.

However, as a process becomes more important and more widely used, the limitations become increasingly visible.

Different versions can circulate.

Formula changes may be difficult to control.

Information may need to be copied between systems.

Approvals can take place outside the process itself.

It can also become difficult to understand exactly which data, assumptions and decisions produced a particular outcome.

For an investment-review process, those limitations are particularly important.

The business needed a platform capable of applying its investment methodology consistently while still allowing experienced people to exercise professional judgement.

That meant converting the logic embedded within spreadsheets into structured software.

Portfolio data, approved investments, model allocations, tolerances, recommendations, overrides and approvals all needed to become part of a controlled workflow rather than a collection of loosely connected files.

Creating a Structured Investment-Review Process

At the centre of the platform is a structured portfolio-review workflow.

Client, plan, valuation and holding data can be brought together from governed sources and presented in a consistent format.

Current portfolios can then be compared with approved model portfolios to identify differences in allocation, potential drift and areas requiring attention.

The platform supports the investment team through a defined process:

·        retrieving and validating client portfolio data;

·        aggregating holdings across plans and accounts;

·        comparing current allocations with approved models;

·        identifying data-quality issues and exceptions;

·        calculating potential rebalance actions;

·        allowing recommendations to be reviewed and adjusted;

·        recording the reasons for professional overrides;

·        approving the final instruction;

·        and generating a consistent implementation pack.

This transforms the review from a spreadsheet exercise into a repeatable business process.

Importantly, the platform does not remove professional judgement.

Automated calculations provide a reliable starting point, but authorised users remain responsible for reviewing the information, considering the client context and approving any resulting action.

The technology supports the decision.

It does not make the decision on behalf of the adviser or investment professional.

Strengthening Investment Governance

Efficiency was an important objective, but governance was equally significant.

A well-designed investment platform should not simply produce an answer. It should help explain how that answer was reached.

The system therefore records the information used during each review, including the portfolio snapshot, selected investment model, comparison methodology, identified exceptions, proposed trades and any manual adjustments.

Where somebody overrides a recommendation, the reason can be recorded as part of the workflow.

Approved instructions can then be turned into consistent evidence packs containing the relevant portfolio, model, benchmark and methodology information.

This creates a clearer history of:

·        what information was available;

·        which model and assumptions were selected;

·        what the system calculated;

·        where professional judgement was applied;

·        who approved the outcome;

·        and what was passed into the implementation process.

Auditability becomes part of the platform rather than an additional administrative exercise completed afterwards.

That gives operational teams better control while also creating stronger evidence for internal review and compliance oversight.

Bringing Investment Research into the Workflow

Portfolio analysis does not take place in isolation.

Investment teams also need access to reliable information about individual funds, approved investment lists, benchmarks, performance, costs, income characteristics and underlying exposure.

The platform therefore connects the review process with external investment data and research capabilities.

Users can search for investments, examine key information and compare funds without relying on a collection of disconnected websites, downloaded documents and manually maintained research files.

Depending on the available data, analysis can include:

·        historical performance;

·        asset allocation;

·        sector and geographic exposure;

·        equity style;

·        market capitalisation;

·        fixed-income characteristics;

·        charges and yield;

·        fund size;

·        concentration;

·        and underlying holdings.

Portfolio-level analysis can then combine information from multiple investments to provide a broader view of the client's overall exposure.

This helps the investment team understand not only whether a portfolio differs from its model, but also what sits beneath that difference.

The objective is not to replace investment expertise with data.

It is to make relevant, governed information easier to access at the point where decisions are being made.

Connecting with the Existing Microsoft Environment

The client had already invested in Microsoft 365, Power Platform and Dataverse.

Rather than creating another isolated application, the new platform was designed to work with that wider environment.

Dataverse acts as an important source of client, plan and operational information.

The investment platform can retrieve and structure that data for analysis while producing outputs that support the surrounding business processes.

This creates a more joined-up relationship between:

·        client and plan records;

·        portfolio information;

·        investment reviews;

·        operational actions;

·        generated documents;

·        internal reporting;

·        and client-facing services.

The solution uses bespoke Microsoft software where the process requires more sophisticated calculation, data handling or user interaction, while continuing to take advantage of the organisation's existing Microsoft and Power Platform investment.

This combination is important.

Low-code platforms are valuable for workflow, integration and operational applications.

Bespoke software is valuable where a business needs complex domain logic, highly controlled calculations or a tailored user experience.

The strongest solution often comes from using both appropriately rather than forcing every requirement into a single technology.

Improving Management Information

Disconnected operational processes frequently create disconnected reporting.

When information is spread across spreadsheets, documents and line-of-business systems, producing a reliable board-level view can require considerable manual effort.

The platform introduces a more structured data foundation for management reporting.

Portfolio, plan, investment and operational information can be captured in consistent formats and prepared for analysis through Power BI.

This gives the business a stronger basis for reporting on areas such as:

·        portfolio and asset-allocation trends;

·        investment-review activity;

·        assets moving through operational processes;

·        outstanding exceptions and data-quality issues;

·        client income and withdrawal patterns;

·        implementation activity;

·        and wider business performance.

Reporting no longer has to begin with somebody manually combining a series of spreadsheets.

Instead, the underlying platform creates governed data that can be reused across operational dashboards, management reporting and board-level analysis.

This provides better information while reducing the effort required to produce it.

Creating a Better Client Experience

The project also created an opportunity to improve how clients interact with the firm.

A client portal gives individuals secure access to a current view of their investments and wider financial position.

Rather than depending entirely on periodic documents or contacting the firm for routine information, clients can see relevant information in one place.

This can include:

·        current portfolio values;

·        investment performance;

·        asset allocation;

·        upcoming meetings and planning events;

·        outstanding actions;

·        recently shared documents;

·        financial plans and objectives;

·        and service requests.

The portal does not replace the relationship between the client and their adviser.

Instead, it supports that relationship by making information easier to access and giving clients a clearer view of what is happening.

It also creates a more modern and consistent digital experience.

The same underlying client and portfolio data can support advisers, investment professionals, operational teams, management reporting and the client portal without each audience relying on a separate version of the information.

Joining Up Internal Processes

One of the most significant benefits of the platform is the way it connects activities that were previously treated as separate tasks.

Portfolio data feeds the investment review.

The review produces recommendations.

Recommendations become approved instructions.

Instructions feed operational activity.

The resulting information supports reporting, documents and client communication.

This reduces repeated data entry and creates clearer handovers between teams.

It also gives users better visibility of where work sits within the process.

Instead of relying on email chains or individual spreadsheets to understand what requires attention, teams can work from shared queues, statuses, actions and exceptions.

That makes the process easier to manage as the organisation grows.

New team members can work within a defined system rather than having to learn a collection of undocumented spreadsheet conventions.

Experienced staff can spend less time preparing and reconciling information and more time applying their knowledge to decisions that require judgement.

Designing for Scale

The client's challenge was not only that the existing process was inefficient.

It was that inefficiency increased as the business grew.

A manual process that is manageable for a limited number of portfolios can become a significant operational constraint as client numbers, investment options and reporting expectations increase.

The new platform separates the business methodology from the limitations of individual spreadsheets.

Rules, models and approved investments can be maintained centrally.

Portfolio data can be processed consistently.

Reviews can follow the same governed workflow.

Reporting can be produced from structured data.

Client-facing services can draw from the same underlying platform.

This creates a much stronger basis for scale.

Growth no longer has to result in a corresponding increase in manual preparation, checking and administrative coordination.

The technology allows the organisation's existing expertise and investment process to be applied more consistently across a larger client base.

Building a Platform, Not a Point Solution

Although the original requirement centred on investment reviews, the wider opportunity was to create a platform capable of supporting several parts of the business.

The resulting technology now provides a foundation for:

·        adviser and investment-team workflows;

·        portfolio analysis and rebalancing;

·        investment research;

·        approved investment governance;

·        implementation instructions;

·        operational oversight;

·        document generation and access;

·        management and board reporting;

·        client self-service;

·        and future data and AI capabilities.

This is an important distinction.

A point solution addresses one immediate task.

A platform creates reusable data, services and workflows that allow the organisation to continue developing.

As new requirements emerge, they can be incorporated into the same architecture rather than creating another isolated process or spreadsheet.

That makes each subsequent development more valuable because it can build upon information and capabilities the business already has.

The Result

The new platform has transformed a fragmented, spreadsheet-led process into a more connected digital operating model.

It has delivered significant time savings by reducing manual data preparation, repeated entry and spreadsheet administration.

Structured calculations and validation reduce the opportunity for avoidable errors.

Clear workflows and audit records strengthen investment governance.

Better-quality data gives operational leaders and the board access to more useful reporting.

The client portal improves the customer experience by giving clients direct access to current portfolio information, documents, actions and planning activity.

Together, these capabilities provide the business with:

·        faster and more consistent portfolio reviews;

·        fewer manual calculations and handovers;

·        improved data quality;

·        clearer oversight of investment decisions;

·        stronger audit and compliance evidence;

·        better operational and board reporting;

·        a more joined-up experience across teams;

·        improved digital engagement with clients;

·        and a scalable foundation for future services.

The most important result is not any individual screen, calculation or integration.

It is that the organisation now has a technology platform designed around how its investment and financial-planning expertise creates value.

How Irvine-David Helped

Irvine-David worked with the client to understand the commercial and operational problems behind the existing process before designing the technology.

Our involvement combined technology strategy with hands-on delivery across software architecture, Microsoft development, Dataverse integration, investment-data services, workflow design, reporting, security and client experience.

We helped translate spreadsheet logic and working practices into structured domain rules, governed data and practical user journeys.

We also designed the platform to fit within the client's wider Microsoft environment rather than operating as another disconnected system.

This combination of business understanding, technical leadership and hands-on software delivery was central to the engagement.

The objective was not simply to digitise an existing spreadsheet.

It was to create a connected platform that improves today's processes while giving the business the foundation it needs to scale.