Rules Engine for Client Document Requirement Matrices

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing systems for cross-selling financial products are largely manual, lacking visibility into client documents and requiring significant operational effort, with salespersons unable to efficiently identify which assets can be onboarded with minimal additional documentation.

Innovation Solution

A rules engine that ingests and applies rules to determine document requirements by converting spreadsheet formats into JSON, using handler functions to generate matrices indicating which products clients can purchase and what documents are needed, thereby automating the onboarding process and reducing manual effort.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If manual processes are used for cross-selling financial products, then salespersons can identify client documents and product requirements, but significant operational effort is required and visibility into client documents is lacking

Engineering Contradiction:
Improveease of identifying document requirementsVSAvoidoperational effort
Core Design Contradiction:
Ease of operationVSProductivity

Solution Approach 1:

The rules engine automatically evaluates trigger conditions and generates document requirement matrices without human intervention. The system self-services by ingesting rules, converting formats, applying evaluation logic, and producing results that guide salespersons, eliminating manual document requirement analysis

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

Manual mechanical processes of reviewing client documents and determining product eligibility are replaced by an automated computational system. The rules engine uses algorithmic evaluation of trigger conditions against client data to substitute the manual operational workflow

Inventive Principle:
Principle #28Mechanics substitution (Replace mechanical system)

2Adaptability or versatility

If rules are stored in multiple spreadsheet formats, then flexibility in rule storage is maintained, but format conversion and processing complexity increases

Engineering Contradiction:
Improveflexibility in rule storageVSAvoidformat conversion complexity
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

A format conversion intermediary layer is introduced between the diverse spreadsheet input formats and the rules engine processing. This intermediary automatically converts various spreadsheet formats into a standardized internal format, shielding the core engine from format complexity while maintaining input flexibility

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The rules engine is designed with universal format handling capability, accepting multiple spreadsheet formats through a unified interface. The system performs multiple functions: format detection, conversion, validation, and processing, all through a single versatile component

Inventive Principle:
Principle #6Universality (Multi-functionality)

3Productivity

If automated rules evaluation is implemented, then operational overhead is reduced and efficiency improves, but system complexity increases

Engineering Contradiction:
Improveefficiency of cross-selling processesVSAvoidsystem complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The automated evaluation system is segmented into distinct modular components: rule ingestion module, format conversion module, trigger condition evaluation module, and result generation module. Each module handles a specific aspect of the process, making the overall complex system manageable through functional segmentation

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS20260057441A1Method and system for implementing a rules engine
Publication Date: 2026.02.26 ROYAL BANK OF CANADA
  • US20260057441A1 patent drawing
  • US20260057441A1 patent drawing
  • US20260057441A1 patent drawing

AI summary

Methods, systems, and techniques for applying a rules engine. Rules corresponding to trigger conditions to be evaluated in respect of a client, and client data pertaining to the client, are obtained. The rules are applied by the rules engine so as to evaluate trigger conditions in respect of at least one product and in respect of at least one document requirement that requires the client to provide a particular document or class of document prior to purchasing the at least one product. The result of applying the rules is a matrix that summarizes, for each of the at least one product, which of the at least one document is required for the client to purchase the product.