agentsclimarketplace

Corporate consolidation

Skill GAJETOso/financeskills/skills/corporate-consolidation

AI-powered skills for financial professionals. Comprehensive collection of finance, accounting, audit, and compliance skills for AI agents. IFRS/GAAP compliant with industry-specific applications.

Install
npx -y skills add GAJETOso/financeskills --skill corporate-consolidation

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • 6 stars6 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

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."

SKILL.md

2.9 KB, as published. Nobody here has run it

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

  1. Ownership Structure

    • Which entities are controlled (>50% ownership)?
    • Which entities use the Equity Method (20-50% ownership)?
    • Are there Non-Controlling Interests (NCI)?

  2. 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)?

  3. Currency Conversion

    • Do subsidiaries use a different functional currency?

Consolidation Framework

Priority Order

  1. Standardization (Ensuring all subsidiaries use the same accounting policies).
  2. Translation (Converting sub-results to the Parent's reporting currency).
  3. Aggregation (Adding line items together).
  4. Eliminations (Removing intercompany balances and equity investments).
  5. 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.py to self-test; import the functions instead of doing mental math.

References

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.

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.