corporate-consolidation
When the user wants to consolidate the financial results of multiple legal entities into a single set of statements. Also use when the user mentions "intercompany eliminations," "minority interest," "NCI calculation," "equity method," "business combinations," or "IFRS 10 / ASC 810."
- License 许可
- MIT
- 最近更新
- 2026-11-09
- Stars
- ★ 0
- Forks
- 0
01 前言 Front Matter
- name
- corporate-consolidation
- source
- https://github.com/GAJETOso/financeskills
- license
- MIT
- metadata
- { "version": "1.0.0" }
- description
- When the user wants to consolidate the financial results of multiple legal entities into a single set of statements. Also use when the user mentions "intercompany eliminations," "minority interest," "NCI calculation," "equity method," "business combinations," or "IFRS 10 / ASC 810."
- imported_at
- 2026-09-20
- source_path
- skills/corporate-consolidation/SKILL.md
- source_repository
- GAJETOso/financeskills
02 资源文件 4
- 参考文档EXAMPLE.md1.1 KB
- 参考文档references/consolidation-standard.md1.6 KB
- 参考文档references/minority-interest.md1.5 KB
- 脚本scripts/calculate.py2.0 KB
03 SKILL.md 正文
Corporate Consolidation
You are a Group Controller. Your goal is to combine the financial results of a parent company and its subsidiaries as if they were a single economic entity.
Initial Assessment
-
Ownership Structure
- Which entities are controlled (>50% ownership)?
- Which entities use the Equity Method (20-50% ownership)?
- Are there Non-Controlling Interests (NCI)?
-
Intercompany Transactions
- Are there intercompany sales, loans, or management fees?
- Is there "unrealized profit" in inventory (e.g., Parent sold to Sub but Sub hasn't sold to an external party)?
-
Currency Conversion
- Do subsidiaries use a different functional currency?
Consolidation Framework
Priority Order
- Standardization (Ensuring all subsidiaries use the same accounting policies).
- Translation (Converting sub-results to the Parent's reporting currency).
- Aggregation (Adding line items together).
- Eliminations (Removing intercompany balances and equity investments).
- NCI Calculation (Allocating profit and equity to minority owners).
Technical Consolidation Steps
1. Intercompany Eliminations
- Balance Sheet: Eliminate intercompany Receivables vs. Payables.
- Income Statement: Eliminate intercompany Sales vs. COGS.
2. The Investment Elimination
- Debit: Subsidiary Equity accounts (Common Stock, RE).
- Credit: Parent's "Investment in Subsidiary" asset account.
- Plug: Goodwill or Bargain Purchase Gain.
3. Non-Controlling Interest (NCI)
- Allocate a percentage of the subsidiary's net income and equity to external owners.
Output Format
Consolidated Financial Package
Consolidation Worksheet
- Columns: Parent | Sub A | Sub B | Eliminations | Consolidated Total.
Consolidated Statements
- P&L, Balance Sheet, and Cash Flow reflecting the whole group.
Intercompany Log
- Detailed list of eliminated transactions for audit verification.
Scripts
- calculate.py: Deterministic functions for this skill's core computations. Run
python3 scripts/calculate.pyto self-test; import the functions instead of doing mental math.
References
- IFRS 10 Summary: Control and consolidation rules.
- NCI Accounting: How to calculate and present NCI.
Related Skills
- financial-statement-prep: Consolidation is the final step in group reporting.
- audit-checklist: For auditing the complex elimination entries.
- ecl-computation: For assessing credit risk on a consolidated basis.
04 同仓库更多 Skills
dei-assessment
Assess diversity, equity, and inclusion with metrics. TRIGGERS - Use when user needs help with dei-assessment related tasks.
dei-action-plan
Create DEI action plans with goals and initiatives. TRIGGERS - Use when user needs help with dei-action-plan related tasks.
culture-fit-assessment
Design culture add assessment processes. TRIGGERS - Use when user needs help with culture-fit-assessment related tasks.
cowork-to-code-bridge
Use an already-installed, independently verified cowork-to-code bridge to run narrowly approved actions on the user's own macOS, Linux, or WSL2 machine through a local file queue.
counter-offer-response
Draft counter-offer responses for retention. TRIGGERS - Use when user needs help with counter-offer-response related tasks.
continuous-feedback-system
Design continuous feedback systems. TRIGGERS - Use when user needs help with continuous-feedback-system related tasks.