Intercompany Transaction Elimination System
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Managing intercompany transactions is challenging due to independent recording by legal entities, leading to difficulties in matching and eliminating transactions, especially during quarter or fiscal year closures, and existing Business Intelligence systems lack accurate consolidated data for real-time corporate-level information.
Innovation Solution
A financial computer system that generates an eliminating entry for intercompany transactions in real-time upon approval, ensuring timely and accurate financial information for the holding company by using an intercompany system that communicates between subsidiary general ledger systems to automatically create matching and eliminating entries.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If intercompany transactions are recorded independently by each legal entity, then each entity maintains autonomy in recording transactions, but matching and eliminating transactions becomes difficult and time-consuming
Solution Approach 1:
The system segments the intercompany transaction elimination process by creating unique identifiers and tracking each transaction separately across different legal entities. Each entity records transactions independently with segment-specific identifiers, allowing automated matching without manual intervention during consolidation.
Solution Approach 2:
The patent introduces an intermediary consolidation system that acts as a mediator between independent legal entities. This intermediary system receives transaction data from各 entities, automatically matches corresponding intercompany transactions using unique identifiers, and generates eliminating entries, thereby resolving the timing and matching difficulties without compromising entity autonomy.
2Quantity of substance
If consolidation is performed manually at month-end, then corporate-level financial information can be consolidated, but the process is complicated and delays real-time financial reporting
Solution Approach 1:
The patent replaces the manual mechanical consolidation process with an automated computer-based system. The system automatically retrieves transaction data from various legal entities, performs matching and elimination operations using algorithms, and generates consolidated financial statements without manual spreadsheet manipulation, thereby eliminating time delays and providing real-time corporate-level financial information.
Solution Approach 2:
The consolidation system operates continuously rather than periodically at month-end. The automated system processes transactions as they occur, maintaining continuous updated consolidated financial information, which eliminates the discontinuous nature of manual month-end consolidation and provides timely financial reporting.
3Speed
If Business Intelligence systems provide daily snapshots, then real-time corporate information is available, but the data is merely an estimate rather than accurate consolidated data
Solution Approach 1:
The system performs preliminary automated consolidation and elimination operations continuously in the background, so that accurate consolidated financial data is already prepared and available when needed for Business Intelligence reporting. This preliminary action ensures that daily snapshots reflect actual consolidated transactions rather than estimates, maintaining both speed and accuracy.
Data Source
AI summary
A financial computer system at a holding company receives an approval of an intercompany transaction between two related subsidiary entities. The system generates an eliminating entry for the intercompany transaction at the time and every time it receives an approval, thereby providing timely and accurate financial information for the holding company.