Direct Answer
Intercompany ends up in Excel when reconciliation happens only at closing time instead of continuously throughout the period, when the elimination logic isn't aligned with the actual ownership structure, or when intercompany entries are created independently across multiple entities without a shared structure. The platform capability is there — the question is whether it's been configured so it's actually used.
Common Causes in Detail
1. No Reconciliation During the Year
Symptom: Intercompany differences only become visible at month-end close, not during the month.
What to check: Whether a billing/reconciliation layer exists that surfaces differences on an ongoing basis, or whether intercompany balances are only compared once a month.
Areas affected: Intercompany billing, close process.
2. Elimination for Partial Ownership Doesn't Apply Cleanly
Symptom: For subsidiaries that aren't wholly owned, the eliminated amounts don't match the actual ownership percentage.
What to check: Whether the ownership percentage is recorded correctly, with the right effective date, at the subsidiary level, and whether eliminations automatically follow that percentage.
Areas affected: Consolidation, ownership structure.
3. Intercompany Entries Are Created Locally, Without a Shared Structure
Symptom: Each entity books intercompany transactions according to its own logic; the corresponding entries in the partner entity don't always line up.
What to check: Whether a consistent intercompany account structure exists across all entities, or whether local variations have crept in.
Areas affected: Chart of accounts, intercompany billing.
4. Currency Differences Aren't Explained on an Ongoing Basis
Symptom: Intercompany balances between entities with different functional currencies drift slightly, and no one can say for sure whether it's timing, an exchange rate movement, or a genuine error.
What to check: Whether multi-currency translation is applied consistently to intercompany positions, and whether exchange rate differences are documented and traceable.
Areas affected: Multi-currency, consolidation.
5. Intercompany Service Charges (Allocations, Margin) Aren't Modeled
Symptom: Intra-group services — allocations, recharges, margin on intercompany deliveries — are calculated manually outside NetSuite and posted after the fact.
What to check: Whether these transactions run through a defined intercompany process, or whether they show up as an annual one-off exercise in Excel.
Areas affected: Intercompany billing, reporting.
The constraint is rarely the platform. The constraint is whether the intercompany architecture was ever deliberately designed — or whether it simply evolved by accident over the years.
Context: Intercompany as a Standalone Topic
Intercompany is closely related to consolidation, but it's a distinct topic in its own right — the billing and reconciliation between entities, not the roll-up into a consolidated group statement. For more detail, including an architecture diagram and FAQ, see the Intercompany section of the Consolidation page.
When an Architecture Review or Health Check Makes Sense
If intercompany differences regularly reach significant amounts, or if no one on the team can confidently explain the elimination logic for partially owned subsidiaries, a NetSuite System Health Check is the right first step. In one reference case, a redesigned billing structure brought the month-end intercompany balance down from €2–4 million to under €100,000 — almost entirely due to timing.