Intercompany Revenue and Profit in Inventory Elimination

When one group entity sells goods to another, two things happen in the local books: the seller records revenue and margin, the buyer records inventory at the purchase price. In the consolidated statements, neither the sale nor the margin exists until the goods are sold to a third party.

Eliminating intercompany revenue and cost is the easy part. Eliminating the unrealized profit still sitting in the buyer's inventory is where most consolidation processes rely on spreadsheets. SAP S/4HANA for Group Reporting offers standard tasks for both. This article explains how they work and which design decisions matter.

Step 1: Eliminating Intercompany Revenue and Cost

The goal is simple: group revenue and cost of sales should include only transactions with third parties.

In SAP Group Reporting, this is handled by a reclassification method run in task 2011 (intercompany elimination of sales) in the Consolidation Monitor. In SAP's standard example:

• rule 010 eliminates revenue for the seller,

• rule 020 eliminates cost for the buyer,

• offsetting values post to a clearing FS item to keep each consolidation unit in balance,

• the eliminations post at posting level 20.

The prerequisite is partner information. Elimination relies on the partner consolidation unit on every intercompany posting. If the trading partner is missing on the sales or purchase side, the elimination will not find it.

Intercompany Matching and Reconciliation (ICMR) can be used upstream to match both sides and explain differences before elimination runs.

Step 2: Eliminating Profit in Inventory

Revenue elimination removes the sale, but not the margin embedded in the buyer's inventory. If the buyer still holds goods purchased from a sister company at period end, inventory is overstated from the group's view by the seller's margin – and so is group profit.

SAP Group Reporting provides a dedicated task for this: task 2015, intercompany elimination of profit in inventory.

What Data Is Needed

Two values per seller, buyer, and product (or material group):

• Inventory value: the buyer's intercompany inventory, collected in a statistical FS item (IPI_GV_M in SAP's standard content).

• Margin: the seller's intercompany margin rate, collected in a second statistical FS item (IPI_RATE).

Partner unit is mandatory for these FS items. The data can be uploaded through the Data Monitor's reported data upload or posted via group journal entries. Material number or material group can be used as the breakdown dimension.

How the Elimination Works

The reclassification method uses three sequences:

• Sequence 010 reduces the buyer's inventory by the unrealized profit.

• Sequence 020 reverses the net income effect of sequence 010 on the buyer.

• Sequence 030 eliminates the profit at the seller.

The result: the buyer's inventory is reduced to group cost, and the seller's net income is reduced by the unrealized margin.

Setup Prerequisites

The method needs task 2015 assigned to the reclassification method, a document type assigned to the version with its number range, the task in the task group, and the task group assigned to the version.

The Tax Dimension: US GAAP and IFRS Differ

Eliminating profit in inventory creates a temporary difference between the group carrying amount and the tax base. Here, US GAAP and IFRS diverge:

• US GAAP (ASC 740): For intra-entity inventory transfers, the seller's tax effects are deferred until the inventory is sold to a third party or otherwise recovered. The buyer does not recognize a deferred tax asset for the difference between the tax basis and the consolidated carrying amount. ASU 2016-16 removed this exception for other assets but retained it for inventory.

• IFRS (IAS 12): There is no such exception. Deferred taxes are recognized and measured at the buyer's tax rate.

For groups reporting under both frameworks, this means the profit-in-inventory elimination is the same, but the tax entries differ. Document types in Group Reporting can be set up to handle deferred tax – the configuration has to reflect each accounting principle separately.

Design Decisions That Matter

• Granularity of margin data. Per material, material group, or seller-buyer pair? More detail is more accurate but harder to maintain.

• Source of inventory data. Who provides the intercompany inventory at period end, and how is it validated?

• Timing. Profit in inventory changes every period as goods are sold on. The process must handle opening balances and movements consistently.

• Materiality. Not every intercompany flow needs the same precision. Define thresholds and document them for auditors.

• Controls. Under SOX, the inventory and margin data used for elimination are key inputs. They need ownership, review, and evidence.

Common Pitfalls

• Missing trading partner on intercompany sales or purchases.

• Margin rates maintained once and never updated.

• Intercompany inventory collected manually without reconciliation to local books.

• One tax treatment applied to both US GAAP and IFRS.

• Profit in inventory treated as a year-end topic, creating swings in quarterly results.

Related Articles

• Intercompany Leases: Elimination in SAP Group Reporting

• Multi-GAAP Consolidation: US GAAP and IFRS in One System

• The Universal Journal and RAR: One Source for Revenue Data

The Bottom Line

SAP Group Reporting covers intercompany revenue and profit-in-inventory elimination with standard tasks and reclassification methods. What makes the difference is the data feeding them: complete partner information, reliable intercompany inventory values, current margin rates, and a tax treatment that reflects the differences between ASC 740 and IAS 12. With those in place, profit-in-inventory elimination becomes a repeatable, auditable close step rather than a spreadsheet exercise – the kind of governed automation that Agentic Finance builds on.

Eliminating intercompany profit in SAP Group Reporting? Talk to our experts.