Corporate Consolidation
Consolidate a parent and its subsidiaries into one set of statements: standardize, translate, aggregate, eliminate intercompany balances, and allocate non-controlling interests.
- What
- Consolidate a parent and its subsidiaries into one set of statements: standardize, translate, aggregate, eliminate intercompany balances, and allocate non-controlling interests.
- Cost
- Free
- Needs
- Use "Corporate Consolidation" with your Muse.
- Install
- Copy the installer prompt below into your Muse — your agent does the rest.
⚠️ **Finance warning / Avertissement finance** : informational only, not investment advice. Consolidated statements are the group official reporting: a missed elimination double counts revenue and assets, a wrong non-controlling interest allocation misstates equity, there is a real risk of loss in any decision taken from misstated group figures, and no output here is a promise of return. Curated by Skill Harbor: the corporate consolidation skill of GAJETOso/financeskills. Use it to combine the financial results of a parent and its subsidiaries into a single set of statements under IFRS 10 or ASC 810, as if the group were one economic entity. The opening assessment maps the ownership structure first: which entities are controlled above 50 percent and consolidated, which sit in the 20 to 50 percent equity method band, and where non-controlling interests exist; then the intercompany landscape (sales, loans, management fees, and the unrealized profit sitting in inventory a subsidiary has not yet sold outside the group); then currency, where subsidiaries keep a different functional currency. The framework runs in a fixed priority order: standardization of accounting policies across subsidiaries, translation into the parent reporting currency, aggregation line by line, eliminations, and the non-controlling interest calculation. The technical steps eliminate intercompany receivables against payables on the balance sheet and intercompany sales against cost of sales in the income statement, eliminate the investment itself (debit the subsidiary equity accounts, credit the parent investment in subsidiary asset, with goodwill or a bargain purchase gain as the plug), and allocate the subsidiary net income and equity share to external owners. The deliverable is a consolidated financial package: a consolidation worksheet with parent, each subsidiary, eliminations and consolidated total columns, the consolidated profit or loss, balance sheet and cash flow statements, and a detailed intercompany log of every eliminated transaction kept for verification by the reviewers of the group accounts. From the GAJETOso/financeskills repository (MIT). Honest caveats: group statements are official filings, so have the worksheet, the eliminations and the non-controlling interest allocation checked by a qualified professional before any official use; the trial balances of every entity, the ownership percentages and the full intercompany transaction list are yours to supply and to verify, and the shipped calculate.py script should do the computations instead of mental arithmetic. Skill Harbor never reviews the code, review it yourself before use.
Version:
Install
Copy the install package below, then paste it into MuseThe install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
Use "Corporate Consolidation" with your Muse. Prerequisites: the trial balance of the parent and of every subsidiary on the same period and, as far as possible, the same accounting policies, the ownership percentages and acquisition dates, the complete list of intercompany balances and transactions, and the functional currencies with the translation rates where they differ. A spreadsheet tool or Python helps you keep the worksheet afterwards: this skill produces the consolidation structure and the eliminations, and every entity figure in it is yours to verify. No broker account and no credentials are involved. Informational only, not investment advice, and have the output checked by a qualified professional before any official use. 1. Open the skill: https://github.com/GAJETOso/financeskills/blob/main/skills/corporate-consolidation/SKILL.md and copy the full SKILL.md text. 2. Paste it into a chat with Muse and add: "Consolidate this group: map the ownership structure and the method for each entity, standardize the policies, translate the foreign subsidiaries, aggregate line by line, eliminate the intercompany balances and the investment against subsidiary equity with goodwill as the plug, eliminate the unrealized profit in inventory, allocate the non-controlling interests, and give me the worksheet, the consolidated statements and the intercompany log." 3. Tie the intercompany log to zero before you read the totals: any intercompany pair that does not eliminate cleanly is an error in an entity ledger, not a consolidation adjustment. Tip: collect the intercompany confirmations between entities before the close meeting; mismatched pairs found late are what turns a consolidation into an excavation. Safety: a skill is plain-text instructions; it runs nothing by itself. Analysis and documents only, no orders and no account access. Informational only, not investment advice.
Saved to your recent installs. Find it anytime on /connect.
Questions
How do I install a build?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the build up for you — no manual configuration.
Where does my money go?
Straight to the seller. Skill Harbor never processes payments: checkout happens on the seller’s own page, usually Stripe.
What does the ✓ next to a creator’s name mean?
It means we confirmed the identity of the person behind the listing. It says nothing about the code itself — always check a build before installing it.