(Accounting) Receive goods without quality control, with landed costs and cost type Average purchase cost

Related topics

The following describes the accounting transactions that are created when you receive goods and the cost type is Average purchase cost. A landed cost for Insurance is applied which is 10% of the purchase price.

Prerequisites

Quantity received 100
Purchase price 10.00
Average cost in Item file 15.00
Landed cost (Insurance) 10%
Quantity in stock before reception 50 in warehouse 1
75 in warehouse 2

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
933 Goods received awaiting costs 1000.00  
Net purchase price * Received quantity

10 * 100 = 1000.00

This transaction increases (debits) the Goods received awaiting costs account using the net purchase price multiplied by the received quantity.

930 Reception from supplier   1000.00
Net purchase price * Received quantity

10 * 100 = 1000.00

This transaction is the purchase value that is normally accounted on a purchase account in DC1 Financials.

901 Stock value 1100.00  
(Net purchase value * Received quantity) + Landed cost value of insurance

(10 * 100) + 100 = 1100.00

This transaction increases (debits) the stock value, using the net purchase value multiplied by the received quantity, plus the landed cost value of the insurance.

933 Goods received awaiting costs   1000.00
Net purchase price * Received quantity

10 * 100 = 1000.00

This transaction decreases (credits) the Goods received awaiting costs account using the net purchase price multiplied by the received quantity.

932 Landed cost – Insurance   100.00
0.10 * 1000 = 100.00

This transaction increases (credits) the landed costs account for the insurance using the actual cost of the insurance.

Average cost price change
The next six transactions are created only if Cost per warehouse is not active, since the cost type is Average purchase cost and the average cost price has to be recalculated. As the new average cost price differs from the old average cost price, the system also has to re-value the whole stock. The system performs the following calculations:

New stock value
The system calculates the new stock value for the quantity on hand after the reception.
In this example the figures are:
Old stock value: 15.00 * (75 + 50) = 1875.00
Received stock value: 11.00 * 100 = 1100.00
New stock value: 1875.00 + 1100.00 = 2975.00

New average price
Then the system calculates the new average price for the quantity on hand after the reception by dividing the new stock value by the new quantity on hand.

In this example the figures are:
New stock value: 2975.00
New quantity on hand: 75 + 50 + 100 = 225
New average price: 2975.00/225 = 13.2222

Decrease of old stock
The stock value for the quantity on hand before the reception has decreased, since the new average price is less than the old average price. The system calculates the decrease of the stock value for the stock on hand before the reception.

Old stock value – (New average price * Old quantity on hand)

In this example the figures are:
Old stock value warehouse 1: 15.00 * 50 = 750.00
Old quantity on hand warehouse 1: 50
New average price: 13.2222
The decrease warehouse 1: 750.00 – (13.2222 * 50) = 88.89
Old stock value warehouse 2: 15.00 * 75 = 1125.00
Old quantity on hand warehouse 2: 75
New average price: – 13.2222
The decrease warehouse 2: 1125.00 – (13.2222 * 75) = 133.335
rounded to 133.34

Increase of moved stock
The stock value for the quantity received has increased, since the new average price is higher than the cost price for the received goods. The system also calculates this increase.

(New average price * Received quantity) – Stock value received goods

In this example the figures are:
New average price: 13.2222
Stock value received goods: (10 * 100) + (0.10 * 100) = 1100.00
The increase: (13.2222 * 100) – 1100.00 = 222.22

901 Stock value, average cost change for current stock   88.89 Decrease of the stock value for 50 pcs.
915 Average cost change 88.89    
901 Stock value, average cost change for current stock   133.34 Decrease of the stock value for 75 pcs.
915 Average cost change 133.34    
901 Stock value, average cost change 222.22   Increase of the stock value for 100 pcs.
915 Average cost change   222.22  

Related topics