--- name: merged-entity-integration description: Manage financial integration of merged or acquired entities including system consolidation, chart of accounts mapping, process harmonization, synergy tracking, and integration milestone management. Use when planning post-merger integration, mapping financial systems, consolidating reporting, tracking synergy realization, harmonizing accounting policies, or managing integration milestones. Triggers on phrases like "merger integration", "PMI", "post-merger integration", "financial integration", "system consolidation", "synergy tracking", "COA mapping", "accounting policy harmonization", "integration roadmap", "day one readiness". --- # Merged Entity Financial Integration Plan and execute the financial integration of merged or acquired entities, from day-one readiness through full consolidation and synergy realization. ## Workflow ### 1. Integration Planning & Day-One Readiness ``` POST-MERGER INTEGRATION ROADMAP ═══════════════════════════════════════ PHASE 1: PRE-CLOSE (Weeks -12 to 0) ═══════════════════════════════════════ Financial due diligence findings: → Revenue: $45M ARR, growing 25% YoY → EBITDA margin: 18% (vs acquirer 24%) → Systems: Salesforce + Netsuite (acquirer: Salesforce + Oracle) → Accounting policies: 3 differences identified → Headcount: 250 employees → Open contracts: 12 key customer contracts, 8 vendor contracts Day-One Readiness Checklist: ═══════════════════════════════════════ □ BANKING → Wire authorization list established → Signers authorized on all accounts → Payment approval matrix defined → Cash management process documented □ PAYROLL → First payroll run tested (parallel test complete) → Benefit elections captured → Tax withholding configured for acquired entity jurisdictions → Payroll vendor selected (migrate to acquirer's system) □ ACCOUNTS PAYABLE → Vendor master data consolidated (deduplicated) → Approval workflows established → Payment terms documented → Open POs transferred □ ACCOUNTS RECEIVABLE → Customer master data consolidated → Billing process documented → Open invoices transferred → Collection process defined □ GENERAL LEDGER → COA mapping completed (acquired → acquirer) → Opening balance sheet prepared → Trial balance verified → Intercompany accounts established □ TAX → Tax elections filed (if applicable) → State nexus analysis complete → Sales tax registration for new jurisdictions → Transfer pricing documentation initiated □ REPORTING → Integrated financial statements format agreed → KPI dashboard design complete → Board reporting template updated □ SYSTEMS → CRM data migration plan → ERP integration plan (Netsuite → Oracle) → Access provisioning for acquired employees → Data retention and archival plan ``` ### 2. Chart of Accounts Mapping ``` CHART OF ACCOUNTS CROSS-WALK ═══════════════════════════════════════ Acquired Co (Netsuite) → Acquirer (Oracle) Notes ───────────────────────────┼───────────────────────────┼───────────── 4000 Sales Revenue → 41000 Product Revenue Main revenue 4100 Service Revenue → 42000 Service Revenue Professional services 4200 Subscription Revenue → 41100 SaaS Revenue Recurring revenue 5000 COGS — Materials → 51000 Cost of Revenue Hosting/infrastructure 5100 COGS — Labor → 51100 Direct Labor Fulfillment costs 5200 Shipping → 51200 Fulfillment Shipping/freight 6000 Salaries → 60100 Salaries & Wages Main salary account 6100 Bonuses → 60200 Bonus Expense Variable comp 6200 Benefits → 61100 Employee Benefits Health, 401k, etc. 6300 Software Licenses → 65100 Software & IT SaaS subscriptions 6400 Professional Fees → 63100 Professional Fees Legal, consulting 6500 Travel → 66100 Travel Expense Business travel 6600 Entertainment → 66200 Entertainment Client meals 6700 Rent → 64100 Rent Expense Office rent 6800 Depreciation → 68100 Depreciation Fixed asset depr 7000 Interest Income → 70100 Interest Income Cash interest 7100 Interest Expense → 71100 Interest Expense Debt interest POLICY DIFFERENCES IDENTIFIED: ═══════════════════════════════════════ 1. Revenue Recognition: → Acquired: Recognizes at invoicing (point in time) → Acquirer: Recognizes over service period (over time) → Resolution: Align to acquirer policy (ASC 606 compliant) → Impact: $800K timing difference in deferred revenue 2. Stock-Based Compensation: → Acquired: Fair value at grant date, straight-line vesting → Acquirer: Accelerated vesting method for certain plans → Resolution: New equity awards use acquirer policy; existing awards continue 3. Warranty Reserves: → Acquired: Historical rate of 2% of revenue → Acquirer: Product-specific rates (1-5%) → Resolution: Adopt acquirer methodology; adjust reserve 4. Capitalization Policy: → Acquired: Capitalizes software development >$5K → Acquirer: Capitalizes >$25K + meets specific criteria → Resolution: Adopt acquirer threshold going forward ``` ### 3. System Integration ``` FINANCIAL SYSTEMS INTEGRATION PLAN ═══════════════════════════════════════ CURRENT STATE: Acquirer: Oracle ERP (GL, AP, AR, FA) + Salesforce CRM + Workday HCM Acquired: NetSuite (GL, AP, AR) + Salesforce CRM + ADP Payroll TARGET STATE: Oracle ERP + Salesforce CRM + Workday HCM (single platform) MIGRATION TIMELINE: ═══════════════════════════════════════ System Migration Window Duration Risk Dependencies ───────────────────────────────────────────────────────────────────── Payroll (ADP → Week 2-3 post-close 2 weeks HIGH Employee comms → Workday) AP (NetSuite → Week 4-6 post-close 3 weeks MEDIUM Vendor comms Oracle) AR/Billing Week 6-8 post-close 3 weeks MEDIUM Customer comms (NetSuite → Oracle) GL/Closed Week 8-10 post-close 2 weeks MEDIUM Audit trail periods migration CRM (data merge) Week 2-12 ongoing 10 weeks LOW Deduplication HR (ADP → Workday) Week 4-8 post-close 5 weeks MEDIUM Employee impact RISK MITIGATION: → Run parallel systems for 1 month during transition → Maintain NetSuite access (read-only) for 12 months → Data validation checkpoints at each migration stage → Rollback plan for each system migration ``` ### 4. Synergy Tracking & Realization ``` SYNERGY TRACKING DASHBOARD ═══════════════════════════════════════ SYNERGY CATEGORIES AND TARGETS: ═══════════════════════════════════════ Category Target Annual Source Timeline Savings ($K) ─────────────────────────────────────────────────────────────────── COST SYNERGIES: Headcount reduction $1,500 Duplicate roles, 6-12 months (50 positions) optimization Facilities consolidation $400 Close acquired HQ, 3-6 months relocate to acquirer Technology stack $350 Consolidate SaaS 3-9 months subscriptions Procurement $250 Leverage combined 6-12 months purchasing power Shared services $200 Centralize finance, 6-12 months HR, IT ─────────────────────────────────────────────────────────── Total Cost Synergies: $2,700 REVENUE SYNERGIES: Cross-selling $2,000 Sell acquirer's 12-24 months products to acquired customer base Upselling $1,000 Expanded solution 6-18 months to acquired customers Channel expansion $500 Access to new 12-24 months distribution channels Pricing power $300 Reduced competition 6-12 months in combined markets ─────────────────────────────────────────────────────────── Total Revenue Synergies: $3,800 GRAND TOTAL SYNERGIES: $6,500K/year (annually recurring) SYNERGY REALIZATION TRACKING: ═══════════════════════════════════════ Synergy Item Target Q1 Actual Q2 Actual % Realized Owner ────────────────────────────────────────────────────────────────────────────── Headcount reduction $1,500 $200 $400 40% HR Director Facilities $400 $400 $400 100% Facilities Technology stack $350 $50 $100 43% CIO Procurement $250 $0 $50 20% Procurement Mgr Shared services $200 $0 $25 13% CFO Cross-selling $2,000 $150 $300 23% CRO Upselling $1,000 $80 $150 23% CRO Channel expansion $500 $0 $50 10% CRO Pricing power $300 $50 $75 42% CFO ────────────────────────────────────────────────────────────────────────────── TOTAL REALIZED (Q2): $1,450 22% INTEGRATION INVESTMENT: One-time integration costs: $2,500 (projected) Annual run-rate synergies: $6,500 Payback period: 4.6 months (after run-rate achieved) ROI (Year 2): 160% (synergies vs integration cost) ``` ### 5. Integrated Financial Reporting ``` INTEGRATED REPORTING FRAMEWORK ═══════════════════════════════════════ POST-MERGER REPORTING CALENDAR: ═══════════════════════════════════════ First 90 Days (Integration Period): → Weekly cash position report (combined) → Weekly synergy tracking update → Bi-weekly integration status report → Monthly combined P&L (pro forma) → Monthly integration investment tracker First 6 Months: → Monthly combined financial statements → Monthly variance analysis (actual vs plan) → Quarterly board reporting (integrated) → Quarterly synergy review → Annual audit planning (combined scope) Pro Forma Financial Statements: ═══════════════════════════════════════ Pro Forma Income Statement (LTM, $M): ═══════════════════════════════════════ Acquirer Acquired Adjustments Pro Forma Revenue $180.0 $45.0 $0.0 $225.0 COGS $65.0 $18.0 $0.0 $83.0 Gross Profit $115.0 $27.0 $0.0 $142.0 Operating Expenses R&D $30.0 $8.0 ($2.0) $36.0 S&M $45.0 $12.0 ($3.0) $50.0 G&A $25.0 $7.0 ($3.0) $29.0 Merger/Integration costs $0.0 $0.0 $5.0 $5.0 Total OpEx $100.0 $27.0 ($3.0) $120.0 Operating Income $15.0 $0.0 $3.0 $22.0 Operating Margin 8.3% 0.0% — 9.8% Interest Expense ($3.0) ($1.0) ($0.5) ($4.5) Pretax Income $12.0 ($1.0) $2.5 $13.5 Tax (21%) ($2.5) ($0.2) ($0.5) ($2.8) Net Income $9.5 ($0.8) $2.0 $10.7 ADJUSTMENTS EXPLANATION: → ($2.0) R&D: Eliminate duplicate research functions → ($3.0) S&M: Consolidate marketing campaigns → ($3.0) G&A: Eliminate duplicate corporate functions → $5.0 Merger costs: One-time integration expenses → ($0.5) Interest: New debt financing for acquisition KEY METRICS: Pro Forma Revenue: $225M (+25% vs acquirer standalone) Pro Forma EBITDA: $26.5M (+35% vs acquirer standalone) Pro Forma Operating Margin: 9.8% (vs acquirer 8.3%, acquired 0.0%) Revenue synergies: $3.8M (not included — separate tracking) ``` ## Edge Cases - **Reverse acquisition**: Acquirer is legal subsidiary; accounting acquirer is the acquired company - **Cross-border M&A**: FX considerations, transfer pricing, tax structure optimization - **Cultural differences**: Different business practices, approval processes, reporting expectations - **Regulatory approval delays**: Extended integration planning; maintain separate operations during waiting - **Failed integration triggers**: Deal break clauses; unwind integration activities if deal falls through ## Integration Points - **ERP systems**: Oracle, SAP, NetSuite (financial data consolidation) - **CRM**: Salesforce, HubSpot (customer data unification) - **HRIS**: Workday, ADP (employee data migration) - **Data migration tools**: Informatica, Talend, Fivetran - **Project management**: Jira, Asana, Smartsheet (integration tracking) - **Synergy tracking**: Custom dashboards, spreadsheet models ## Output ### Integration Status Report ``` MERGER INTEGRATION STATUS — Month 3 ═══════════════════════════════════════ OVERALL STATUS: ON TRACK (78% of milestones complete) FINANCIAL INTEGRATION: Day-one operations: COMPLETE ✓ COA mapping: COMPLETE ✓ GL integration: IN PROGRESS (70%) AP/AR migration: PLANNED (Week 4-8) System consolidation: IN PROGRESS (40%) SYNERGY REALIZATION: Cost synergies realized: $875K of $2,700K target (32%) Revenue synergies realized: $755K of $3,800K target (20%) Total realized: $1,630K of $6,500K (25%) Integration investment: $1,200K of $2,500K planned KEY RISKS: → System migration timeline at risk (2 weeks behind plan) → Key talent retention: 3 departures in first 60 days → Customer communication: 2 churned during transition (mitigated) NEXT MILESTONES: → Payroll migration complete by Week 4 → First fully integrated close by Month 4 → Technology consolidation 50% complete by Month 6 ```