Has anyone else noticed an issue with intercomany transfer pricing in OneWorld? If transfer price is not at cost, consolidated reports are inaccurate. How do people deal with this and determine the elimination entry required to correct?
Here is a scenario:
Parent Company
• Inventory item cost = $10/unit
• 10 units for a total cost of $100
Parent Company transfers 2 unit to Child Company with a transfer price @ $22.
This creates the following entries:
Fulfill (Parent)
Dr Inv in Transit $44
Cr. Inv Asset ($20)
Dr. Rev ($24)
Receipt
Cr. Inv in Transit ($44) (Parent)
Dr. Inv Asset $44 (Child)
Dr. InterCo $44 (Parent)
Cr. InterCo ($44) (Child)
This would give a total inventory value of:
Starting $100 (10 x $10)
Ship from Parent ($20) (2 x $10)
Receive to Child $44 (2 x $22)
Total Value $124
This would then require an elimination entry of:
Dr. Revenue $24
Cr. Inv Asset ($24)
and inventory value of:
Pre Elim Inv $124
Elim entry ($24)
Consolidated Inv $100 this is correct
Here is where the problem begins:
Child sells 1 unit for $75
Dr. Cash $75
Cr. Inv Asset ($22)
Cr. Revenue ($75)
Dr. COGS $22 (1 unit @ $22)
Now account balances are:
Inventory:
Parent $80 (8 @ $10)
Child $22 (1 @ 22)
Elim Entry (above) ($24)
Consolidated $76 BUT SHOULD BE $90
In addition, the consolidated income statement is off:
Revenue:
Parent $24
Child $75
Elimination ($24)
Total $75
COGS
Parent $0
Child $22
Total $22
Net Income $53
But it should really be:
Revenue $75 (Sale by Child)
COGS ($10) (1 unit at original cost of $10)
Net Income $65
The reason is because the Child is selling the Inventory Item and recording COGS at the transfer price, not the true price for Consolidation. There does not appear to be a way to track this valuation difference. It can get even more complicated if the Child also purchases the Inventory Item from a 3rd party, bringing in other value to the item.