intercompany-eliminator
Automated intercompany transaction identification and elimination skill for consolidated reporting
What this skill does
# Intercompany Eliminator ## Overview The Intercompany Eliminator skill automates the identification and elimination of intercompany transactions for consolidated financial reporting. It ensures accurate elimination entries and handles complex multi-entity structures. ## Capabilities ### Intercompany Matching - Trading partner identification - Transaction type classification - Amount reconciliation - Timing difference handling - Currency conversion alignment - Threshold-based matching ### Elimination Entry Generation - Revenue/cost of goods sold elimination - Intercompany receivable/payable netting - Dividend elimination - Management fee elimination - Interest income/expense elimination - Service charge elimination ### Currency Translation - Functional currency determination - Translation method application - Temporal method calculations - Current rate method application - Cumulative translation adjustment - Remeasurement gain/loss ### Minority Interest Calculation - Noncontrolling interest identification - Profit/loss allocation - Comprehensive income allocation - Changes in ownership treatment - Step acquisition adjustments - Deconsolidation accounting ### Investment Elimination - Cost method elimination - Equity method elimination - Acquisition accounting - Goodwill calculation - Push-down accounting - Basis differences ### Unrealized Profit Elimination - Inventory profit elimination - Fixed asset profit elimination - Upstream vs. downstream - Minority interest impact - Tax effect consideration - Realization timing ## Usage ### Monthly Consolidation ``` Input: Subsidiary trial balances, intercompany activity reports Process: Match transactions, generate eliminations, calculate minority interest Output: Consolidated trial balance, elimination entries, reconciliation report ``` ### Intercompany Reconciliation ``` Input: Intercompany balance reports from all entities Process: Identify mismatches, investigate differences, propose adjustments Output: Reconciled balances, adjustment entries, exception report ``` ## Integration ### Used By Processes - Intercompany Accounting and Consolidation - Financial Statement Preparation - Month-End Close Process ### Tools and Libraries - ERP APIs (SAP, Oracle) - Consolidation software (HFM, OneStream) - Custom matching algorithms ## Best Practices 1. Establish intercompany policies and procedures 2. Implement real-time matching where possible 3. Set materiality thresholds for reconciliation 4. Create standard intercompany transaction templates 5. Build escalation procedures for unmatched items 6. Maintain entity relationship mapping
Related in Data & Analytics
clawarr-suite
IncludedComprehensive management for self-hosted media stacks (Sonarr, Radarr, Lidarr, Readarr, Prowlarr, Bazarr, Overseerr, Plex, Tautulli, SABnzbd, Recyclarr, Unpackerr, Notifiarr, Maintainerr, Kometa, FlareSolverr). Deep library exploration, analytics, dashboard generation, content management, request handling, subtitle management, indexer control, download monitoring, quality profile sync, library cleanup automation, notification routing, collection/overlay management, and media tracker integration (Trakt, Letterboxd, Simkl).
querying-soql
IncludedSOQL query generation, optimization, and analysis with 100-point scoring. Use this skill when the user needs SOQL/SOSL authoring or optimization: natural-language-to-query generation, relationship queries, aggregates, query-plan analysis, and performance or safety improvements for Salesforce queries. TRIGGER when: user writes, optimizes, or debugs SOQL/SOSL queries, touches .soql files, or asks about relationship queries, aggregates, or query performance. DO NOT TRIGGER when: bulk data operations (use handling-sf-data), Apex DML logic (use generating-apex), or report/dashboard queries.
app-store-optimization
IncludedApp Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.
habit-flow
IncludedAI-powered atomic habit tracker with natural language logging, streak tracking, smart reminders, and coaching. Use for creating habits, logging completions naturally ("I meditated today"), viewing progress, and getting personalized coaching.
app-store-optimization
IncludedApp Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.
visualizing-data
IncludedBuilds dashboards, reports, and data-driven interfaces requiring charts, graphs, or visual analytics. Provides systematic framework for selecting appropriate visualizations based on data characteristics and analytical purpose. Includes 24+ visualization types organized by purpose (trends, comparisons, distributions, relationships, flows, hierarchies, geospatial), accessibility patterns (WCAG 2.1 AA compliance), colorblind-safe palettes, and performance optimization strategies. Use when creating visualizations, choosing chart types, displaying data graphically, or designing data interfaces.