Finance AI Skill
Merged Entity Integration
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 financia...
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 plan2. 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 forward3. 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 migration4. 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