managing-consolidation-accounting
Structures consolidation procedures with intercompany elimination, minority interest, and foreign currency translation. Use when performing consolidations, eliminating intercompany transactions, or translating foreign subsidiaries.
Best use case
managing-consolidation-accounting is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Structures consolidation procedures with intercompany elimination, minority interest, and foreign currency translation. Use when performing consolidations, eliminating intercompany transactions, or translating foreign subsidiaries.
Teams using managing-consolidation-accounting should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/managing-consolidation-accounting/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How managing-consolidation-accounting Compares
| Feature / Agent | managing-consolidation-accounting | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Structures consolidation procedures with intercompany elimination, minority interest, and foreign currency translation. Use when performing consolidations, eliminating intercompany transactions, or translating foreign subsidiaries.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# Managing Consolidation Accounting ## When To Use - Consolidating financial statements of a parent entity with one or more subsidiaries - Eliminating intercompany transactions (sales, loans, dividends, management fees) - Computing and presenting noncontrolling (minority) interests - Translating foreign subsidiary financials into the parent's reporting currency - Preparing consolidation workpapers for period-end close or audit support - Evaluating whether a variable interest entity (VIE) or voting interest model applies ## Inputs To Gather - **Entity structure**: Legal org chart with ownership percentages, acquisition dates, and functional currencies for each subsidiary - **Trial balances**: Period-end trial balances for every entity in scope, mapped to the consolidated chart of accounts - **Intercompany activity log**: Detail of all intercompany receivables/payables, sales/purchases, loans, interest, dividends, and management fees with matching entity codes - **Acquisition records**: Purchase price allocation (PPA) schedules, goodwill calculations, fair-value adjustments, and any contingent consideration terms - **Foreign exchange rates**: Spot rates at balance sheet date, average rates for the income statement period, and historical rates for equity components [VERIFY — rate source policy per entity] - **Prior-period consolidation file**: Prior workpapers including opening elimination entries and cumulative translation adjustment (CTA) balances - **Minority interest schedules**: NCI share of net assets at acquisition and subsequent earnings allocations ## Workflow 1. **Confirm consolidation scope** - Determine which entities require full consolidation (>50% voting interest or VIE primary beneficiary), equity-method treatment (20–50%), or cost-method treatment - Identify any changes in scope from prior period (acquisitions, disposals, changes in ownership percentage) - [VERIFY] jurisdiction-specific thresholds or regulatory definitions of control (e.g., IFRS 10 vs. ASC 810) 2. **Standardize and map trial balances** - Reclassify each subsidiary's local-GAAP trial balance to the group chart of accounts - Adjust for any GAAP differences between subsidiary local reporting and parent reporting framework (IFRS vs. US GAAP) [VERIFY] - Reconcile intercompany balances across all entity pairs; investigate and resolve mismatches before elimination 3. **Translate foreign subsidiary financials** - Balance sheet accounts: translate at the closing spot rate - Income statement accounts: translate at the weighted-average rate for the period (or transaction-date rates if results are significantly seasonal) - Equity accounts: translate at historical rates from date of acquisition or capital contribution - Record the resulting foreign currency translation adjustment in other comprehensive income (CTA component) - For subsidiaries in hyperinflationary economies, apply remeasurement (temporal method) instead of translation [VERIFY — IAS 29 / ASC 830 criteria] 4. **Prepare elimination entries** - **Investment vs. equity**: Eliminate parent's investment account against subsidiary's equity at acquisition-date fair values; recognize goodwill or bargain purchase gain - **Intercompany balances**: Eliminate all reciprocal receivables/payables; confirm net-zero after elimination - **Intercompany revenue/expense**: Eliminate intercompany sales and corresponding cost of goods sold, service fees, interest income/expense, and management charges - **Intercompany profit in inventory**: Remove unrealized profit on inventory still on hand at period end (upstream and downstream) - **Intercompany profit in fixed assets**: Eliminate unrealized gain on intercompany asset transfers; adjust depreciation for fair-value write-up - **Intercompany dividends**: Eliminate dividends paid by subsidiary against dividend income recorded by parent 5. **Compute noncontrolling interest (NCI)** - Allocate NCI's share of subsidiary net assets at acquisition (full goodwill method vs. proportionate share method) [VERIFY — policy election under IFRS 3 vs. ASC 805] - Allocate NCI's share of post-acquisition earnings and OCI each period - Present NCI separately in consolidated equity and attribute consolidated net income between parent and NCI on the income statement - If subsidiary losses exceed NCI's carrying amount, determine whether NCI absorbs excess losses [VERIFY] 6. **Reconcile and validate consolidated totals** - Foot the consolidation workpaper: parent TB + subsidiary TBs + adjustments + eliminations = consolidated TB - Verify total assets equal total liabilities plus equity (including NCI) - Cross-check consolidated retained earnings roll-forward against prior period - Confirm CTA balance rolls forward correctly with current-period translation effects 7. **Document and report** - Prepare consolidation workpaper package with indexed elimination entries and supporting schedules - Draft management commentary on significant consolidation items: large eliminations, goodwill impairment indicators, CTA movements, changes in NCI - Flag any scope or judgment areas for audit committee or external auditor attention ## Output - **Consolidation workpaper**: Columnar spreadsheet showing each entity's trial balance, adjustment columns, elimination columns, and consolidated totals - **Elimination journal entries**: Numbered journal entries with descriptions, entity references, and supporting calculations - **NCI schedule**: Showing NCI balance at beginning of period, share of net income, share of OCI, dividends, and ending balance - **CTA roll-forward**: Opening CTA, current-period translation gain/loss by subsidiary, and closing CTA - **Management summary**: Narrative highlighting material consolidation adjustments, intercompany reconciliation exceptions, and period-over-period changes ## Quality Checks - All intercompany balances net to zero after elimination; any residual difference is investigated and explained - Goodwill and intangible amortization schedules tie to PPA and are current through reporting date - NCI income allocation percentages match legal ownership records - Foreign currency translation uses correct rate types (closing, average, historical) for each financial statement line - Consolidated retained earnings equal prior-period balance plus consolidated net income less dividends declared by the parent - Elimination entries are symmetric — every debit has a corresponding credit across the paired entities - [VERIFY] compliance with applicable reporting framework (ASC 810/IFRS 10 for consolidation, ASC 830/IAS 21 for translation, ASC 805/IFRS 3 for business combinations)