Why stock can contain an internal profit
A manufacturer transfers goods to a distribution company that it consolidates. The manufacturer records a sale and the distributor records a purchase. At reporting date some goods may still sit in the distributor’s warehouse. From the group’s perspective those goods have simply moved between two locations. The margin included in their transfer price is still internal.
A consolidation accountant uses this calculator to estimate the adjustment on that unsold portion of one shipment. It can also help a controller reconcile a closing stock schedule or a student trace the difference between a legal entity’s ledger and the consolidated figures.
Gather the three inputs
Intragroup transfer revenue is the amount charged for the entire shipment. Take it from the internal invoice or agreed transfer schedule. Original group cost is the cost of that same lot to the group before the internal sale. This is a whole-shipment figure too. Use comparable currency and quantity bases and reconcile any credit notes first.
Share of shipment still held is the percentage remaining anywhere inside the consolidated group at the reporting date. If 40 of 100 identical units remain, enter 40. If cartons have different unit margins, count each homogeneous lot separately and add the resulting adjustments. A unit count is a reliable allocation only when it represents the margin embedded in the remaining goods.
Follow one shipment into the closing stock
Take an internal sale of 100,000, group cost of 75,000 and 40% still held. First subtract 75,000 from 100,000. The internal margin on the complete shipment is 25,000. Multiply that by 40/100 to find the unrealized profit to eliminate, 10,000.
The buyer carries the remaining units at 40% of 100,000, or 40,000 on the assumed transfer-price basis. Deduct the 10,000 internal profit and the group closing stock for this shipment becomes 30,000. You can independently check the amount by multiplying the original cost, 75,000, by 40%. These are two paths to the same reported inventory.
Read the two outputs correctly
Unrealized profit to eliminate is the profit adjustment on unsold goods. Group inventory after elimination is the remaining stock at original group cost under this model. The second number is specific to this shipment. The internal invoiced revenue and expense still need their own consolidation treatment; the 10,000 figure does not represent the entire sales elimination.
What happens when the stock moves?
With the same invoice and cost, suppose only 10% remains at year-end. That gives an adjustment of 2,500 and group stock of 7,500. If all goods have left the group for outside customers, enter zero. Both results become zero. If no units have been sold outside the group, enter 100. The entire internal margin of 25,000 is eliminated and the full 75,000 cost remains in inventory.
Moving goods onward to another consolidated warehouse does not itself make the margin external. When investigating an unexpected answer, first check that the percentage represents units retained across the group and that the cost has not already been reduced to the unsold portion.
Limits of this worksheet
The calculation assumes one shipment, uniform unit margins and comparable amounts. It does not allocate the effects to a noncontrolling interest, post tax adjustments, reverse an opening elimination or test whether inventory is impaired. A transfer below cost warrants a separate review of recoverability. Reconcile the estimated result to the actual accounting records and applicable reporting guidance before using it in a consolidation.
