Intercompany Transaction Automation (Auto Elimination)
What it does
This NetSuite customization automates intercompany transactions and eliminations across subsidiaries — removing the manual effort of recording, matching, and eliminating intercompany balances during consolidation. When a transaction occurs between two entities, the corresponding journal entries, intercompany payables, and receivables are generated automatically and tagged for elimination.
Finance and accounting teams benefit from a consistently clean consolidation package. Rather than spending close week chasing intercompany mismatches, the team arrives at period end with balanced books, validated eliminations, and a full audit trail of every intercompany movement — all managed within NetSuite OneWorld.
Common use cases
Intercompany automation covers the full spectrum of cross-entity transactions — from routine cost allocations to complex multi-currency settlements.
Intercompany Sales & Purchases
When one subsidiary sells goods or services to another, the corresponding purchase transaction is automatically created in the buying entity — eliminating manual journal duplication and ensuring both sides post in the same period.
Shared Services Cost Allocations
Automatically allocate corporate overhead — IT, HR, facilities — across operating subsidiaries using configured allocation keys. Journals are created and tagged for elimination so they flow cleanly through consolidation.
Multi-Currency Settlements
Handle intercompany transactions across entities operating in different currencies with automated exchange rate application and FX gain/loss posting, keeping both sides of the transaction in balance.
Intercompany Loan Management
Automate the creation and tracking of intercompany loan balances, accrued interest, and repayments across subsidiaries — with validation to ensure both sides of each loan remain in agreement throughout the period.
Consolidation Eliminations
At period close, elimination journal entries are generated automatically based on tagged intercompany balances — removing intercompany revenue, COGS, receivables, and payables without manual spreadsheet work.
Imbalance Detection & Alerts
Saved searches continuously validate that intercompany pairs are in balance. When a mismatch is detected — misposted period, missing transaction — an alert routes to the responsible controller before close begins.
How it's built
NetSuite OneWorld intercompany features are extended with SuiteScript automation and SuiteFlow workflows to handle creation, matching, and elimination without manual steps.
Transaction Trigger
A User Event Script fires when an intercompany-tagged transaction is saved. It identifies the counterparty entity, exchange rate, and intercompany accounts, then initiates the corresponding entry creation.
Counterpart Creation
A Map Reduce Script creates the mirrored journal or transaction in the counterpart subsidiary — applying intercompany account codes, dimensions, and elimination flags so the record is consolidation-ready from creation.
Validation & Matching
Saved searches continuously validate intercompany pairs. When a mismatch is detected, a SuiteFlow alert routes the discrepancy to the responsible controller before it reaches period close.
Auto Elimination
At period close, a Scheduled Script generates elimination journal entries for all tagged intercompany balances in the consolidation entity — removing IC revenue, COGS, receivables, and payables automatically.
Before → After
Before
- Intercompany transactions are recorded manually in each subsidiary, often leading to mismatched amounts, wrong periods, or missing entries.
- Month-end close involves significant manual effort reconciling intercompany balances across subsidiaries using spreadsheets.
- Eliminations are performed manually — a time-consuming, error-prone process that delays consolidated reporting.
- Imbalances are discovered late in the close process, requiring controller intervention and delayed sign-off.
- Audit preparation is painful because intercompany entries lack clear linkage to originating transactions and counterparts.
After
- Counterpart transactions are created automatically when the originating transaction saves — both sides post in the same period with the correct accounts.
- Intercompany balances are validated continuously; imbalances are flagged and routed for correction before close begins.
- Elimination journals are generated automatically at period end — eliminating a major manual step from the close checklist.
- The consolidation dashboard shows elimination status in real time, so the team knows close is clean before submitting financials.
- Every intercompany entry links to its originating transaction and counterpart, making audit preparation fast and straightforward.
Explore more capabilities on the NetSuite Solutions hub or read about our customization services.