How to eliminate intercompany transactions in consolidation: Examples, challenges with manual tools and 5 easy steps to follow

Spreadsheet-based eliminations create higher reporting risk

Intercompany eliminations are one of the most error-prone parts of consolidation, especially when handled in spreadsheets. Disconnected financial data, broken formulas, and manual updates make it difficult to match transactions accurately and keep reporting consistent across entities.

As group structures grow, even small errors can flow into consolidated reports, delay month-end close, and create audit risk for finance teams.

In this guide, we break down how intercompany eliminations work in practice, with real examples and a clear step-by-step process. We also show why spreadsheets break at scale and how modern financial systems like iplicit help automate eliminations and improve reporting accuracy.

Why listen to us?

iplicit is built for organisations managing and handling multi-entity reporting, consolidation, and audit complexity. We work closely with organisations handling intercompany eliminations at scale, helping them reduce manual effort and improve reporting accuracy. Teams like Dawn Capital have achieved 50% faster reporting, while du Boulay cut month-end close from three weeks to under one week, thanks to the power of our cloud accounting software.

From this experience, we’ve seen where eliminations break down and how to manage them more efficiently as organisations grow.

What are intercompany transactions?

Intercompany transactions are financial exchanges between two or more legal entities within the same corporate group. This can include a parent company and a subsidiary, or two sister companies under common ownership.

These transactions show up in everyday activity. Think intercompany sales and purchases or loans and interest. Other examples include cost allocations, management fees, royalties, asset transfers, dividends, and balances between entities.

For each transaction, both sides record their side of the transaction independently. For example, one entity records income while the other records a matching expense. The same pattern applies across loans, fees, and balances between entities.

At group level, however, these linked transactions must be identified and eliminated so the consolidated financial statements reflect a single economic entity.

What happens when you don’t eliminate intercompany transactions in consolidation

Intercompany transactions don’t create any income or value for the group. They only move activity between entities.

If they remain in the numbers, group accounting becomes misleading and consolidation becomes harder to trust. For CFOs, intercompany elimination is what keeps financial consolidation accurate and group reporting reliable.

Here’s what happens when it’s skipped:

• Overstated group revenue: Internal sales inflate revenue when they remain in consolidation. Removing them ensures reports reflect actual external performance across the group.
• Loss of true cost visibility: Internal charges can overstate expenses across entities. Removing them gives CFOs and accounting teams a clearer view of what it actually costs to run the business.
• Unreliable balance sheet values: Intercompany loans, receivables, and payables can overstate a group’s assets and liabilities. Elimination keeps the balance sheet aligned with the group’s true position.
• Inaccurate group reporting: Consolidation is meant to present a unified view of one economic unit. Leaving intercompany activity in breaks that view and blurs what’s actually happening across the group.
• Increased audit risk: Unmatched intercompany balances create risk during review. A clear elimination process supports stronger audit trails and easier validation.
• Distorted CFO decision-making: CFOs need numbers they can trust. Correct eliminations give a clearer view of performance, risk, and financial position across the group.
• Complex consolidation processes: Internal activity should not remain in consolidated results. Removing it gives finance teams cleaner numbers and a more reliable close.

Common examples of intercompany eliminations

Intercompany eliminations come down to one simple idea. Group reports should only show transactions with external parties. So finance teams remove internal sales, balances, charges, and any unrealised profit still within the group.

Here are six of the most common intercompany eliminations you’ll see in practice.

1. Intercompany sales and purchases

This is usually the first place eliminations show up. An intercompany sale happens when one entity in the same company group sells goods or services to another entity in that group.

To understand better, let’s assume there are two entities (Entity A and Entity B) that belong to the same group company. If Entity A sells goods to Entity B for £50,000, Entity A will record a £50,000 increase in revenue while Entity B records the £50,000 as a purchase.

At entity level, both entries are correct. But from a group perspective, nothing was actually sold to a customer. Thus, the transaction needs to be reversed on both sides during consolidation.

This can be done manually using an elimination journal or more effectively by using accounting software to automatically match and cancel both entries.

Either way, it has to go. If it stays in the consolidated accounts, the revenue and costs end up overstated. And the group reports activity that never really happened outside the business.

2. Internal loans and balances

Intercompany loans work in a similar way to sales and purchases.

Let’s break it down. Entity A, the parent company, lends £200,000 to its subsidiary, Entity B, maybe to support operations or cover short-term needs. At entity level, Entity A records a receivable, while Entity B records a payable.

But what does that mean at group level?

Nothing has changed. The business hasn’t borrowed from an external party. It’s just moved cash internally.

So during consolidation, the transactions cancel each other out. This means the £200,000 receivable and payable must be removed.

If they stay in, the balance sheet ends up overstating both assets and liabilities, making the group look like it owns more and owes more than it actually does.

3. Intercompany interest removal

Intercompany interest can be easy to miss, especially in multi-company organisations.

This is because it feels legitimate. Interest is expected when there’s a loan. And when those loans run over several years, the charges start to blend in. So if one entity charges another £12,000 in annual interest over a 10-year period, it might get attention in the early stages. After a while, though, it ends up sitting in the P&L like any other line item.

This means unless you’re actively looking for it, it doesn’t immediately stand out as internal. But it is, and it shouldn’t be left in.

If it isn’t removed, the interest silently inflates group performance. No new money is coming into the group and there’s also no real expense leaving it. The business is just charging itself, making it look like income on one side and costs on the other.

Over time, it becomes harder to get a clear view of what the group is actually earning and spending.

4. Elimination of cost recharge and management fees

Cost allocations and management fees happen when one entity in the same company group charges another entity in that group for shared costs or internal services. This often includes finance, HR, IT, payroll, rent, or group leadership costs. One entity records income or a recharge. The other records an expense.

As an example, let’s assume there are two entities. Say one of them provides finance and IT support to the other and charges £30,000. This transaction will show up as management fee income on one side and an expense on the other.

On the surface, everything looks fine. But once you step back and look at it from a group perspective, nothing new has actually happened. Both entities sit within the same group, so the charge is entirely internal. No real income has been earned, and no external cost has been incurred.

As a result, you’re reporting activity that only exists within the group. If this isn’t handled properly, it starts to blur how costs are actually distributed across the business. It becomes harder to see what each part of the group is truly consuming versus what’s simply being moved around internally.

5. Unrealised profit in inventory

Unrealised profit in inventory happens when one entity in the same company group sells stock to another entity in that group at a markup, and that stock has not yet been sold to an outside customer. The selling entity records a profit in its own accounts, but the group has not yet earned that profit externally.

For example, Entity A sells inventory to Entity B for £40,000. Both entities belong to the same company group. The inventory originally cost Entity A £30,000. Entity A therefore records an internal profit of £10,000. If Entity B still holds that inventory at the reporting date, the group has not yet made a profit from an outside sale.

During consolidation, that £10,000 profit must be eliminated. Inventory must also be reduced by £10,000 so it is shown at the group’s original cost of £30,000, not the internal transfer price of £40,000.

6. Artificial dividend income

Our last example is intercompany dividends. This happens when one entity within the organisation pays a dividend to another entity in the same structure. It’s also one of those items that can easily slip through without raising much concern.

When that dividend comes from within the organisation, it’s really just a movement of cash. The money was already there, it’s simply been transferred from one entity to another and recorded differently on each side.

That’s why it needs to be treated carefully. If it isn’t removed, it starts to look like the business has generated income, when in reality, nothing new has come in. Eliminating it keeps the financial statements focused on actual performance, not internal distributions.

The problem with manual intercompany eliminations

In many finance teams, intercompany eliminations are still done manually. Teams extract data, match transactions manually, and post adjustments, usually with the help of spreadsheets, offline journals, or basic finance systems.

Manual intercompany eliminations can work, especially for smaller businesses. But as the group grows, the cracks start to show. Some of the most common issues that come up are:

• Increased risk of reporting errors: With manual entries and spreadsheet formulas, it doesn’t take much for small mistakes to slip into consolidation. These errors are often difficult to catch early and usually end up flowing through to group reports.
• Slower close and reporting cycles: Spreadsheet-driven workflows add friction at every stage of consolidation. Matching, adjustments, and reviews take longer, which delays month-end close and group reporting timelines.
• Weak intercompany matching across entities: Data that is split among multiple databases and files can lead to poor intercompany matching. These inconsistencies between entities often require more time and effort to find and reconcile.
• Limited audit trail and control: Manual processes make it harder to track who made changes, when they were made, and why. This weakens control over approvals, reviews, and adjustments during audits.
• Version conflicts and inconsistent reporting: Having multiple versions of a spreadsheet makes it difficult to know which numbers are actually correct. When teams are unsure which version to rely on, this results in inconsistencies across reports, periods, and even between stakeholders.

Why spreadsheets break at scale

Spreadsheets aren’t designed for group-level consolidation. While they may work well for teams only managing a handful of entities, they’re not built for the volume and complexity that come with larger group structures.

Here’s why that is:

• Fragmented data across entities: As the group grows, data starts living across more files and systems. Spreadsheets can’t pull this together reliably. This results in teams spending more time stitching data than actually working with it.
• Poor visibility: Without a live view of group performance, teams have to rely on repeated exports. This slows down decision-making and reviews during the month-end close.
• Weaker control: Without a structured environment, reviews and approvals become harder to enforce consistently.
• Disconnected systems: Spreadsheets sit in between systems rather than connecting them. That creates gaps where data has to be re-entered, checked, and validated manually.
• Limited scalability: As the group structure grows, spreadsheet-led consolidation becomes harder to manage accurately across entities.

How intercompany eliminations work in practice

Intercompany eliminations follow a clear process. Here’s how it usually plays out in practice:

Step 1: Identify intercompany transactions early

Start by identifying transactions between entities in the same company group. This includes sales, loans, interest, cost allocations, and internal balances. If these are not identified clearly and early enough, they will be harder to eliminate later and hinder decision-making.

Step 2: Bring both sides into one view

Each transaction sits in two different entities. Instead of working across separate files, both sides should be brought into a single view where they can be assessed together. This makes it easier to see whether they match in value and timing.

Step 3: Reconcile differences

All intercompany entries should match in value and timing. When they don’t, the differences need to be investigated before consolidation can take place.

Differences usually happen due to timing, missing entries, or incomplete records. To get both sides aligned, accounting teams must review the data, identify any gaps, and adjust the entries before moving to elimination.

Step 4: Prepare and post elimination entries at group level

Once transactions are matched and aligned, the next step is to remove their impact from the group accounts. This means preparing elimination entries that strip out internal revenue, costs, balances, and any unrealised profit still sitting within the group.

Elimination entries are recorded during consolidation, not in the standalone books of each entity. This ensures each entity keeps its own records intact, while the group view reflects only external activity.

Step 5: Review consolidated results

After posting eliminations, the group numbers should be reviewed as a whole. This can be done internally or as part of a formal review process.

Ideally, internal transactions should no longer appear, and the results should reflect only external activity. However, if anything looks off, it should be flagged and traced back before finalising the numbers.

How financial software simplifies intercompany eliminations

Using modern financial software helps to reduce the manual work behind intercompany eliminations. Here are a few ways it does that:

• Centralised data across entities: With financial software, teams can manage all their consolidation needs in one place. This gives them a clearer group-wide view and unifies their reporting processes. iplicit in particular brings multi-entity consolidation, reporting, and approvals into one system, reducing reliance on separate files and duplicated work.
• Automated intercompany transactions: Financial software lets teams identify and track intercompany transactions as they happen, rather than being pulled together later. This helps reduce missed entries and keeps internal activity visible throughout the close.
• Real-time reporting across entities: One of the main issues with manual eliminations is the reliance on exports and delayed updates. With dedicated finance software like iplicit, built around real-time reporting, teams can review group performance as the close progresses and avoid delays during month-end.
• Built-in workflows and approvals: Finance software often features built-in workflows and approvals. These features give teams more control over how reporting and review processes are managed as consolidation becomes more complex.
• Audit-ready controls: Financial software provides clear audit trails and user permissions, so teams can track changes and maintain oversight across consolidation activity. This strengthens validation and makes audit preparation more straightforward.
• Multi-entity reporting at scale: Unlike spreadsheets, financial software is built to handle growing complexity without adding manual overhead as your group expands. iplicit’s cloud-based setup makes it easier to scale while maintaining visibility and control across entities.

How iplicit handles intercompany eliminations

When you record an intercompany transaction, iplicit can automate matching and help ensure both sides stay aligned. All things stay in-sync in real time, so you’re not fixing mismatches or rebuilding numbers at month-end.

With iplicit, everything sits in one system. Thus, eliminations happen within your normal workflow instead of as a separate process.

You’re also working from a single, live view of the group, with full visibility as the close progresses. This setup is what’s helped teams like Dawn Capital achieve 50% faster reporting, and du Boulay cut month-end close from three weeks to under one week.

Key features to look for in a modern solution

Not all accounting software can handle intercompany eliminations well. Many teams outgrow entry-level tools like Xero or Sage 50 as group structures become more complex. Conversely, enterprise systems like NetSuite or Intacct often feel over-engineered for mid-market organisations.

Below are a few things to consider when trying to pick the right solution.

1. Multi-entity consolidation

Intercompany eliminations sit inside a wider group reporting process. If your chosen tool doesn’t fully support reporting across multiple entities, the elimination process will still depend on manual work. Look for solutions that consolidate data across the group without rebuilding reports each period.

2. Real-time reporting

Finance teams need to review what is happening across the group while the close is still in progress. Look for a system with real-time reporting and analytics so you’re not waiting on manual updates.

This will give you immediate visibility into balances, transactions, and reporting positions. It also makes it easier to spot issues early and review group numbers faster.

3. Automated workflows and approvals

Automated workflows should be built into your chosen tool. This gives your team clearer control over the elimination process across entities and reduces reliance on manual steps.

iplicit, for instance, offers robust automation and workflows that remove much of the manual effort. Teams can also build custom workflows and complete group eliminations in real time without manual intervention.

4. Audit trails and user permissions

Intercompany eliminations require clear validation and traceability. Audit trails and permissions help teams track changes, maintain oversight, and respond to audit or review requirements more easily.

5. Connected integrations

Intercompany eliminations are harder when finance data is split across disconnected tools. A modern solution should connect with the systems finance teams already use, so data does not need to be exported, re-entered, or manually aligned before consolidation. Stronger integrations reduce duplication and improve visibility across the group.

6. Scalability for growing organisations

Once companies move beyond early growth stages, entry-level and legacy systems become harder to manage and limit accurate consolidation. Thus, when picking tools, choose a platform that adds new entities without IT projects, goes live in weeks, and is intuitive enough for finance teams to manage without specialist support.

When it’s time to move beyond spreadsheets

These are some common signs it’s time to move on:

• Consolidation takes too long
• Intercompany balances require repeated checking
• Reporting depends on manual exports from multiple systems
• Limited scalability
• Finance data spread across multiple, disconnected tools
• Growth through new entities or acquisitions has made the finance structure harder to manage with spreadsheets.

If you’re starting to recognise these patterns, it might be time to start looking at finance software. Just keep our considerations in mind so you can choose a system that gives you better visibility and more reliable reporting across the group.

How iplicit helps finance teams manage intercompany eliminations

Intercompany eliminations get harder to manage as the group grows. More entities, more data, and tighter reporting timelines all put pressure on a process that’s already difficult to control in spreadsheets.

iplicit gives finance teams a more structured way to handle this. With multi-entity consolidation, automation, real-time reporting, and audit-ready controls, you’re not chasing data across files or second-guessing numbers during month-end.

If your current process is slowing things down or making reporting harder to trust, book a demo today to see how iplicit manages and automates intercompany eliminations in real time. No manual journals, no spreadsheet reconciliation, everything audit-ready from day one.

Sources and review information

Sources: iplicit's own published case studies for Dawn Capital and du Boulay, and iplicit product documentation. Figures for both customers are drawn from iplicit's published case study material.

This guide was last reviewed on 24 September 2026.