Universal Code Mapping for Custom Financial Templates

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

The complexity and cost of implementing Corporate Performance Management (CPM) solutions are hindered by the need for customized financial reports, budget models, and dashboards, which require extensive consulting time and expertise due to the lack of standardization in Chart of Accounts across different companies, making these solutions unaffordable for smaller organizations.

Innovation Solution

A computer program product that generates custom templates by importing user account data, mapping user-defined account identifiers to predetermined categories, and generating codes for each identifier, allowing for the automatic creation of financial reports, planning models, and dashboards, reducing the need for extensive customization and consulting time.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If CPM solutions are customized for each company's unique Chart of Accounts, then the solution adapts to specific organizational needs, but implementation time and cost increase significantly

Engineering Contradiction:

ImproveAdaptability to company-specific Chart of AccountsVSAvoidImplementation time

Core Design Contradiction:

Adaptability or versatilityVSLoss of time

Solution Approach 1:

The patent uses template copying where pre-built CPM templates are generated by mapping user account data to standardized category codes. Instead of customizing from scratch, the system copies and adapts standardized templates to fit each company's unique Chart of Accounts structure, dramatically reducing implementation time while maintaining adaptability.

Inventive Principle:

Principle #26Copying

Solution Approach 2:

The system changes parameters by mapping variable account identifiers to standardized category codes. The mapping process transforms company-specific account structures into a universal format by assigning category codes based on account names, descriptions, and hierarchical relationships, enabling standardized templates to work across different organizations.

Inventive Principle:

Principle #35Parameter changes

2Adaptability or versatility

If extensive customization is performed for each company's Chart of Accounts, then the CPM solution fits specific organizational requirements, but consulting costs and expertise requirements increase

Engineering Contradiction:

ImproveCustomization to organizational requirementsVSAvoidComplexity of implementation process

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system enables self-service by automatically generating customized CPM templates through the mapping process. Users provide their account data, and the system autonomously maps accounts to category codes and generates appropriate templates, reducing the need for expensive consultant intervention while maintaining high adaptability to organizational needs.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent creates a universal mapping framework that handles diverse Chart of Accounts structures through a single standardized process. The category code system and template generation mechanism serve multiple functions across different organizations, eliminating the need for separate customization approaches for each company.

Inventive Principle:

Principle #6Universality (Multi-functionality)

3Productivity

If standardized templates are used across different companies, then implementation speed increases, but adaptability to unique organizational structures decreases

Engineering Contradiction:

ImproveTemplate generation speedVSAvoidAdaptability to unique Chart of Accounts

Core Design Contradiction:

ProductivityVSAdaptability or versatility

Solution Approach 1:

The system applies local quality by allowing customization at the account mapping level while maintaining standardized template structures. Each company's unique account identifiers are mapped to appropriate category codes based on their specific characteristics, enabling standardized templates to adapt to local organizational requirements without sacrificing overall standardization benefits.

Inventive Principle:

Principle #3Local quality

Data Source

PatentUS11657218B2Custom template generation using universal code

Publication Date: 2023.05.23 SOLVER INC

AI summary

A method of generating a custom template includes importing user account data including a plurality of user-defined account identifiers, receiving a user input on a graphical user interface including a mapping of the plurality of user-defined account identifiers to predetermined categories and a selected ordering of two or more of the user-defined account identifiers that are mapped to the same one of the predetermined categories, for each of the user-defined account identifiers, generating a code defining the predetermined category to which the user-defined account identifier is mapped and an order ranking of the user-defined account identifier relative to any others of the user-defined account identifiers that are mapped to the same predetermined category, and generating one or more templates comprising a representation of at least a portion of the user account data organized according to the predetermined categories and order rankings defined by one or more of the codes.