The Cross-Border Mess: India + US Operations

The Situation

US software company, $50M revenue. 150 US employees, 100 in an India development center.

Month-end close: 25 days. Intercompany balances: $400K variance every month. Auditors raising the same issues year after year.

CFO: "We've been trying to fix this for 3 years. We hire new people, they get frustrated, they leave."

What Most Would Do

Hire a consolidation specialist. Buy more software. Replace the India accountant.

The Unfolding Values Analysis

Root cause: a chart of accounts built in isolation 5 years ago.

When the India entity was set up:

• The India accountant designed the chart of accounts for Indian compliance (Schedule III format)
• The US team set up the GL based on US GAAP categories
• Mapping between the two? Never built. Done manually each month via spreadsheet.

What that meant in practice:

• 47 manual mapping entries every month
• Intercompany revenue / expense never reconciled to the penny
• Different fiscal year ends caused timing mismatches
• Multi-currency consolidation done in Excel, not the ERP

This is a Day 1 problem that compounded for 5 years.

The Decision Tree

Option A: Replace the chart of accounts globally. Comprehensive but a 6-9 month project, disrupts ongoing reporting.

Option B: Build a mapping layer. Quick but doesn't solve the underlying issue.

Option C: Phased approach (Recommended). Mapping layer first (2 months), then a unified chart of accounts (6 months), then ongoing optimization.

The Outcome

Months 1-2: Built an automated mapping layer.

• Close dropped from 25 days to 7 days
• Intercompany variance dropped from $400K to under $10K monthly

Months 3-8: Unified global chart of accounts.

• Single source of truth across both entities
• ERP-native consolidation
• Audit fees dropped 30% (less manual reconciliation work for auditors to verify)

Month 12 status:

• 8-day close
• Audit fee savings: 30%
• Intercompany variance: under $10K monthly
• India accountant retained (was never the problem)

Key Principles

1. Most cross-border consolidation problems are Day 1 architecture problems: built in isolation, paid for forever.
2. The local accountant isn't the problem. The system around them is.
3. Fix the architecture, not the symptoms. Better systems make average people excellent.