Contact Us
Three people closely collaborating over an iPad, laptop, and notebook.

Your finance team should not need to fix the same balances each month. Yet this can happen when two subsidiaries record the same deal in different ways. Wrong accounts and missed close tasks can also cause errors.

NetSuite OneWorld handles much of this work during month-end close. Still, the process needs correct records and clear accounting rules. This guide covers the main causes of elimination errors and how to fix them.

Key Takeaways

  • Missing "Eliminate Intercompany Transactions" flags can stop NetSuite from clearing internal balances.
  • NetSuite can mark eligible invoices and bills when you use the right accounts and subsidiaries.
  • NetSuite checks linked exchange-rate entries when clearing eligible A/R and A/P balances.
  • Run the Intercompany Reconciliation report before you finish your month-end close.
  • Old elimination errors need careful review when they affect several firms or past accounting periods.
Anchor Group Assessment
Contact Us

Is NetSuite right for you?

Six honest questions. We'll tell you straight - even if it's "not yet."

Question 1 / 6 Size
Your verdict
A strong fit

Understanding Intercompany Eliminations in NetSuite OneWorld

Companies with several subsidiaries often buy and sell goods within the same group. Each subsidiary must record its own sales and costs. But group financial reports should not count these deals as sales to outside buyers.

Intercompany elimination removes these internal sales, costs, and balances from group reports. This helps keep the company from showing too much revenue, costs, assets, or debt.

The Basics of Intercompany Transactions

Think of a case where Subsidiary A sells stock to Subsidiary B. The seller records revenue and accounts receivable. The buyer records stock or costs and accounts payable.

These entries are correct for each firm's own books. But the group has not made a sale to an outside buyer. The internal sale must therefore be removed from group reports.

NetSuite uses Automated Intercompany Management to find eligible deals and create entries that cancel them out. The system posts these entries to special elimination subsidiaries. This keeps group reports correct without changing the source records.

How NetSuite OneWorld Handles Consolidation

NetSuite runs intercompany elimination through its Period Close Checklist. The system finds eligible lines and creates the needed elimination journal entries. These entries keep internal amounts from affecting group results. Still, some balances may remain due to stock transfers, currency changes, or other accounting rules.

A balance that remains does not always mean something went wrong. Finance teams should check the source records first. They can then decide if the amount is valid or needs a fix.

image10.jpg

Common Causes of NetSuite Intercompany Elimination Problems

Most elimination problems start with wrong account settings, bad records, or missed close tasks. Even a small setup error can affect group reports and create more work.

Finding the root cause is key. If your team only fixes the final balance, the same issue may return next month.

Data Errors and Setup Problems

Accounts Not Flagged for Elimination

One common issue occurs when an intercompany account lacks the right elimination setting. NetSuite uses the "Eliminate Intercompany Transactions" checkbox to find accounts that need this process. If the box is not checked, related amounts may remain in group reports.

To check the setup, go to Lists > Accounting > Accounts. Review each account used for internal sales or other intercompany work. Open the account and check its type and elimination setting.

Each account type has its own rules. Some internal deals may need special intercompany accounts instead of standard business accounts.

Transaction Lines Not Marked to Eliminate

NetSuite handles elimination flags based on the type of deal and account setup. For eligible invoices and vendor bills, the system can mark lines for elimination. Advanced Intercompany Journal Entries can also use account settings to fill in these flags. Still, a wrong account or representing entity can stop the process from working.

A deal may look correct at first. Yet it may have a field that causes problems when NetSuite prepares group reports. Check the accounts, subsidiaries, and lines on each record. Do not assume that the account-level flag alone is enough.

Timing and Currency Problems

Timing Differences Between Subsidiaries

Suppose Subsidiary A records a sale in December. Subsidiary B does not record the matching bill until January. At December close, one firm shows a receivable without a matching payable. This creates a gap that may affect group reports.

The Intercompany Reconciliation report helps teams find deals that do not match. It can also help them check missing records and wrong dates.

NetSuite does not create missing source records during elimination. It only handles eligible entries that already exist in the right period.

Run the report before each month-end close. Work with both finance teams to fix missing entries and date gaps. Early fixes help keep old balances from carrying into future months.

Currency Revaluation Running Out of Sequence

Firms in different countries may use different base currencies. Changes in exchange rates can make their balances harder to match.

NetSuite follows a set order for accounting tasks during close. Currency revaluation must run before intercompany elimination. This helps ensure the balances reflect the right exchange-rate changes. Skipping this task or running it too late can affect the final reports.

NetSuite also checks linked exchange-rate entries when clearing eligible A/R and A/P balances. Some of these currency changes are recorded in the CTA-E account.

CTA-E stands for Cumulative Translation Adjustment - Elimination. It tracks certain currency changes linked to the elimination process.

What to Check Before Running Elimination

Before you start, make sure these tasks are complete:

  • Record all intercompany invoices, bills, and journals for the period.
  • Check that both firms use the right dates and amounts.
  • Review open deals and find missing or late entries.
  • Complete currency revaluation before running elimination.
  • Check exchange rates and related accounting entries.

Impact of Custom Scripts

Custom scripts and workflows can affect how NetSuite creates or changes intercompany records. For example, a script may choose the wrong account or subsidiary. It may also leave out a needed elimination flag.

These errors may go unnoticed during daily work. They often become clear only when finance teams prepare group reports.

Review scripts that create, change, or approve intercompany records. Focus on the fields and accounting rules they use. Test changes in a sandbox before moving them to your live system. This helps confirm that the fix works without causing new errors.

Anchor Group offers NetSuite Optimization services to help companies find setup issues and review custom processes. Our team can also help fix repeat accounting errors before they lead to larger problems.

Diagnosing Intercompany Elimination Issues

The first step is to find where the remaining balance came from. Do not rush to post a manual journal. Instead, use NetSuite reports to review the source deals. Start with group account balances. Then trace each unexpected amount back to its source record and elimination entry.

Using NetSuite's Reporting Tools

Intercompany Reconciliation Report

Go to Reports > Financial > Intercompany Reconciliation. This report helps you review internal deals and find amounts that do not match between subsidiaries. It can reveal missing entries, wrong amounts, and records that are not linked as expected.

Pay close attention to invoices and bills recorded in different periods. Also check for amounts that do not match. These gaps often mean the two firms did not record the same deal in the same way.

Run this report before each close. Give the finance teams enough time to review and fix open items. If the same issues keep appearing, review how staff enter records. Fixing the process is better than correcting each error on its own.

Consolidated Trial Balance

After elimination, go to Reports > Financial > Trial Balance. Choose the right parent subsidiary to view the group totals. Check accounts used for internal sales, receivables, payables, and other balances.

Eligible deals should no longer affect the group totals. Still, some amounts may remain due to valid accounting rules. For example, stock transfers may leave amounts in clearing accounts. Currency changes can also create gaps between firms.

Make a list of accounts with unexpected balances. Then check the source records before posting any fixes.

Finding Problems with Saved Searches

NetSuite Saved Searches can help find lines with missing elimination flags or wrong accounts. For example, a saved search can flag journal lines tied to intercompany accounts without the expected Eliminate setting.

This can save time when your team handles many deals across several subsidiaries.

You can also use SuiteQL to pull data from related NetSuite records. SuiteQL gives your team a closer look when standard reports do not show enough detail.

Tool What It Finds When to Use
Intercompany Reconciliation Report Internal deals that do not match Before financial close
Consolidated Trial Balance Group balances that remain After elimination
Saved Search Missing flags and wrong journal settings During error checks
SuiteQL Links between records When checking old data

Best Practices for Setting Up NetSuite OneWorld

A reliable elimination process starts with clear account rules and correct subsidiary links. Staff must also record internal deals in the same way.

Setting these rules during implementation can help prevent repeat errors. It also makes group reporting easier as the company grows.

Building a Clear Chart of Accounts

Use separate accounts for intercompany revenue, costs, receivables, and payables when needed. Keeping internal deals apart from outside sales makes it easier to find balances that need elimination.

Avoid mixing unrelated business deals with internal entries in accounts used for group adjustments. Use the same naming rules across subsidiaries. This helps finance teams find and check internal accounts.

For example, add an "IC -" prefix to intercompany account names. This makes them easier to spot in lists and reports.

Check new accounts before using them in the live system. Make sure the account type and elimination settings fit their purpose.

Setting Up Subsidiaries and Internal Accounts

Each parent subsidiary with child subsidiaries needs a suitable elimination subsidiary in the NetSuite hierarchy. The elimination subsidiary must use the same base currency and country as its direct parent. These settings help NetSuite keep the right structure for group reports.

Companies with several levels in their subsidiary hierarchy may need more than one elimination subsidiary. For example, a US parent may need its own elimination subsidiary. The global parent may need a separate one as well.

NetSuite also uses representing entities. These are customer and vendor records that show links between subsidiaries. The records help NetSuite find eligible internal deals and apply the right accounting rules.

The "Automatically Generate Representing Entities" setting can create these records when the needed setup is in place. Check the needed features and account rules before turning on this option.

If the system cannot create them, your team may need to add the records by hand.

Practical Fixes for Common Intercompany Elimination Glitches

The right fix depends on the cause, the affected period, and the firms involved. Errors in the current period are often easier to fix. The source records may still be open for edits.

Older issues usually need more review and approval before changes can be made.

Manual Corrections for Current Period Issues

Fixing Missing Eliminate Flags

Start by checking the type of deal and related records. For invoices and vendor bills, make sure the customer or vendor represents the right subsidiary. Then check the accounts used on the record.

For journal entries, review the Eliminate box on each line that should qualify.

If the period is still open, your team may be able to fix the source record. You can then repeat the needed close tasks.

Closed periods need more care. Changes to old records may affect financial reports that have already been issued. Do not post a manual journal just to force the balance to zero.

First, decide if the period should be reopened. If not, check whether an approved current-period entry is the right fix.

Fixing Amounts That Do Not Match

Start by comparing the original intercompany invoice with the matching vendor bill. Check the dates, items, amounts, currencies, and exchange rates used by both firms.

Follow your company's accounting rules to find which record is wrong. Once you find the error, fix the right source record. Then run the Intercompany Reconciliation report again. Make sure the related balances now match before moving on with period close.

Quick Checklist for Fixing Elimination Errors

Use this checklist when internal balances remain after elimination:

  • Find the account with the unexpected balance.
  • Trace the amount to its source invoice, bill, or journal entry.
  • Check the Eliminate flag on the relevant journal lines.
  • Confirm the accounts and representing entities for both firms.
  • Fix the source records using approved accounting rules.
  • Run the reports again to check the results.

Using Automation to Prevent Errors

NetSuite workflows and scripts can help catch bad records before financial close. For example, a custom rule can check journal lines that use special intercompany accounts. The rule can then alert users when a needed elimination setting is missing.

Advanced Intercompany Journal Entries already support automatic flags based on account settings. This means extra custom work may not always be needed.

Start by fixing the errors that cause the most work during close. Test any new rules before using them in the live system. Make sure each rule supports your current accounting process.

Effective NetSuite automation can reduce repeat checks and help finance teams close each month with more confidence.

Historical Cleanup Process

Old elimination errors can be hard to fix. This is most common when they span several periods or affect many firms.

Before changing old records, review a sample of the affected deals. This helps your team find the cause, measure the scope, and plan the needed approvals.

Phase 1: Review and Record

Start by listing open balances by account and subsidiary. Trace each amount to its source record. Check any related exchange-rate changes.

Review old journal entries for duplicate postings, wrong accounts, and entries that may have caused the remaining balances. Write down your findings before making changes. This gives your team a clear record of the review.

Do not reverse old journals without knowing why they were posted. An unneeded reversal can create new gaps and make the cleanup harder.

Phase 2: Correct Old Entries and Flags

Use the original records to find the balances that should have appeared after elimination. Check the accounting dates, exchange rates, and source amounts before making any fixes.

Each proposed change should have a clear reason and proper approval. For entries that affect several firms, check whether Advanced Intercompany Journal Entries provide the right accounting structure.

Keep records that support each change. This matters most for prior periods and data used during financial audits.

Phase 3: Revalue and Test

Complete the needed currency revaluation tasks before calculating consolidated exchange rates and running elimination. NetSuite can include linked revaluation entries when the source deals meet the needed rules.

Review the new elimination journals. Then compare the updated consolidated trial balance with the expected amounts.

Check any gaps that remain. Decide whether they are valid balances or errors that still need work.

Use the results from your first sample to plan the rest of the cleanup. Working in stages helps reduce the risk of new errors.

Using NetSuite Tools to Manage Internal Accounts

NetSuite offers reports and tools that help finance teams do more than fix single errors. By reviewing records across subsidiaries and periods, companies can find repeat issues. They can then improve the accounting steps that cause them.

A financial report may show an unexpected balance. But it may not explain why the same issue returns each month. NetSuite workbooks help finance teams review records over time. They can reveal trends that standard reports may miss.

Track intercompany sales by subsidiary and reporting period. Check how often each team enters late deals or uses the wrong accounts.

For example, one firm may keep entering vendor bills after month-end. Another may still use an old account without the right elimination setting.

Finding these patterns helps your team fix the source of the problem. This reduces the need for manual adjustments each month.

Using SuiteQL to Review Past Records

SuiteQL can show more detail when a problem involves several related NetSuite records. It lets users pull data about accounts, deals, and journal entries through queries. This helps finance teams review the records behind an unexpected balance.

For example, your team can find journal lines assigned to intercompany accounts without the expected Eliminate flag. SuiteQL can also help trace certain journal entries back to their source records. This makes it easier to see how a balance first appeared and why it remained.

The tool is useful when reviewing large amounts of data or errors that built up over several periods.

Why Your Business Needs Expert NetSuite Implementation

Many intercompany elimination problems begin during the first NetSuite setup. They may go unnoticed until the company starts preparing group financial reports.

Testing the accounting structure before go-live can catch these problems early. It also helps avoid costly cleanup work later.

Avoiding Common Setup Mistakes

Common setup mistakes include missing elimination subsidiaries, wrong account types, and incomplete elimination settings. These issues may not affect daily work. As a result, they can be hard to find before the first group financial close.

A successful NetSuite Implementation should include tests of real deals between subsidiaries. Create sample invoices and vendor bills. Check that both firms record the right amounts. Then run the elimination process.

Review the group balances to make sure eligible internal deals receive the right accounting treatment. This testing helps find setup errors before they affect live data or delay financial reports.

The Value of an Experienced Partner

Intercompany accounting becomes harder as companies add subsidiaries, currencies, and new reporting needs. An experienced NetSuite partner can help build clear account rules and find which deals need elimination.

The partner can also review close tasks, find setup problems, and explain the right order of accounting steps. The goal is a reliable group reporting process that your team can manage without repeated manual fixes.

VIDEO: NetSuite Optimization Explained: What It Actually Means & When You Need It

Keeping Your Intercompany Process on Track

Even a well-set-up NetSuite system can develop new elimination problems as the business changes. New subsidiaries, accounts, and scripts may create errors that did not exist during the first setup.

Regular checks help finance teams catch these issues before they affect group financial reports.

Regular Reviews and Account Checks

Review intercompany accounts each quarter. Check that their names, account types, and elimination settings are still right.

Include new accounts in the review. Make sure staff keep choosing the right records for internal deals.

The CTA-E balance should also be checked during each financial close. Large changes may reflect currency movements or deals that need more review.

Compare unexpected amounts with known exchange-rate changes. Trace unusual balances to their source entries before closing the period.

Monthly Checks to Prevent Repeat Errors

A monthly review can help prevent recurring elimination problems:

  • Check new intercompany accounts for missing or wrong elimination settings.
  • Match internal invoices and bills before financial close.
  • Review late deals and unmatched entries between subsidiaries.
  • Compare CTA-E balances with recent exchange-rate changes.
  • Check scripts that create or change intercompany records.
  • Record repeat issues and the steps taken to fix them.

Training Staff to Avoid Common Errors

Finance staff across all subsidiaries should know how to record internal deals. Training should cover which accounts to use and how to choose the right representing entities. It should also explain when journal lines need elimination flags.

Clear rules help reduce bad records and extra work during financial close. Keep shared accounting guides for dates, exchange rates, account selection, and each firm's duties.

NetSuite Training can help staff learn these rules and use them across the company. When staff know how to spot common entry errors, they can fix problems sooner. They do not need to wait until the month-end review.

Strong Fit for This Approach

  • Companies using NetSuite OneWorld to manage several subsidiaries.
  • Finance teams handling frequent internal sales, invoices, and journal entries.
  • Businesses facing repeat elimination balances during financial close.
  • Companies needing correct group reports for audits and financial reviews.

May Not Be the Best Fit

  • Companies without subsidiaries or intercompany transactions.
  • Businesses using separate systems for all group financial reporting.
  • Finance teams with stable processes and no repeat elimination issues.

How Anchor Group Helps with Intercompany Elimination

Anchor Group is an Oracle NetSuite Alliance Partner that helps companies manage NetSuite across several subsidiaries. Our NetSuite Consulting team works with businesses facing repeat group reporting problems, wrong account settings, and unreliable close tasks.

We start by reviewing your accounts, source records, and month-end close steps. This helps us find the root cause of the problem. Our team also checks custom scripts and workflows that may affect elimination.

For older issues, we help build a clear cleanup plan. The plan covers the affected periods and reporting needs. Our goal is to fix the source of the problem without creating new errors in your records.

We also help prevent repeat issues through better account settings, saved search alerts, and staff training.

If your finance team keeps posting the same adjustments each month, there may be a better way. Book a FREE 30-minute NetSuite fix to discuss the elimination problems affecting your business.

We can help decide whether you need a simple fix or a broader review of your accounting setup.

Our NetSuite Managed Services also provide ongoing help with account reviews, system changes, and repeat close issues.

The goal is simple: find errors sooner, reduce extra work, and help your finance team close each month with confidence.

image10.jpg

Frequently Asked Questions

What are intercompany eliminations and why do they matter in NetSuite OneWorld?

Intercompany eliminations remove eligible internal deals from group financial reports. This keeps the company from overstating its financial results. When one subsidiary sells goods to another, both record the deal in their books. But the group has not earned outside revenue. NetSuite OneWorld creates elimination entries during close, while finance teams check balances that remain.

What are the most common reasons for elimination errors in NetSuite?

Common errors include wrong account settings, missing flags, and records that do not match between subsidiaries. Timing gaps can also cause issues when related deals fall into different periods. Currency changes may create more differences. Finance teams should check source records, confirm account settings, and use the Intercompany Reconciliation report to find amounts that remain unresolved.

Can intercompany elimination be automated in NetSuite?

Yes, NetSuite can create elimination journal entries for eligible internal deals during financial close. It uses account settings and record details to find qualifying amounts. Advanced Intercompany Journal Entries can also fill in elimination flags based on account settings. Custom workflows can add more checks, but finance teams should still review the results to ensure correct accounting.

What tools help diagnose elimination problems?

The Intercompany Reconciliation report helps teams find deals that do not match between subsidiaries. A consolidated Trial Balance shows account balances that remain after elimination. Saved Searches can flag journal lines with missing settings or wrong accounts. SuiteQL shows more detail from related records. These tools help teams find the cause before they post manual accounting entries.

How long does it take to fix historical elimination problems?

Simple account setup errors may take only a few hours to review and fix. Older issues involving several subsidiaries, currencies, or closed periods often take longer. Finance teams may need to check source records, old journals, and exchange-rate changes. Starting with a small sample helps them estimate the work needed before making changes to past records.

Related Articles

2026 BigCommerce NetSuite Integration for Medical Device Manufacturers

BigCommerce NetSuite integration for medical device manufacturers is one of the most practical ways to support digital ordering when the build preserves UDI context, lot traceability, account approvals, returns, and exception logs. The best approach in 2026 is usually a connector-first architecture with custom rules for regulated inventory, customer eligibility, controlled documents, and recall-ready records.

Read the Article Three people standing before a whiteboard.

About NetSuite Ecommerce | Platform Options

SuiteCommerce Advanced is NetSuite’s flagship ecommerce solution, sitting flawlessly on top of NetSuite ERP. Previous to SuiteCommerce, companies had to integrate other ecommerce website hosting services (such as Shopify, Magneto, or WooCommerce) into their ERP using a custom integration or an integrator platform. In this scenario, NetSuite still offers a lot of value as a back-end ERP, especially due to its capable order management tools and its customizability as an organization evolves.

Read the Article Word cloud representing key concepts and terms related to SuiteCommerce Advanced.

Tagged with Financial Management, Troubleshooting