(Accounting) Increase stock in the stock take routine

Related topics

The following describes the accounting transactions the system creates when you increase the normal stock in the stock take routine.

Prerequisites when the cost type is Standard cost or Average purchase cost

Quantity in stock 100
Quantity counted 125
Cost price 100.00

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value 2500.00  
Cost price * (Qty counted – Stock on hand in Warehouse balance file)

100.00 * (125 – 100) = 2500.00

If the cost type is:

  • Standard cost, the cost price is retrieved from the Standard cost field in the Item file
  • Average purchase cost, the cost price is retrieved from the Average cost field in the Item file
912 Stock take difference, positive   2500.00 Tip: In Financials you should account the stock take differences on a separate account. If you account those differences on the same account as Cost for goods sold (800), it is more difficult to trace stock take differences.

Prerequisites when the cost type is FIFO

Quantity in stock 170
Quantity counted 245
Last purchase cost in the Item file 115.00

Assume the following FIFO transactions exist in the FIFO file:

Transaction date Price Qty received Qty delivered Remaining qty Stock value
15/10 113.80 25.00 25.00 0.00 0.00
31/10 113.80 75.00 75.00 0.00 0.00
6/11 114.75 200.00 30.00 170.00 19507.50

Created transactions

The following transactions are created:

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
901 Stock value 8625.00  
Cost price * (Qty counted – Stock on hand in Warehouse balance file)

Increase quantity: 245 – 170 = 75
Stock increase: 115.00 * 75 = 8625.00

The cost price is always retrieved from the Last purchase cost field in the Item file when the stock is increased in the stock take routine.

912 Stock take difference, positive   8625.00 Tip: In Financials you should account the stock take differences on a separate account. If you account those differences on the same account as Cost for goods sold (800), it is more difficult to trace stock take differences.

The following FIFO transactions exist in the FIFO file after the stock take on the 2nd December:

Transaction date Price Qty received Qty delivered Remaining qty Stock value
15/10 113.80 25.00 25.00 0.00 0.00
31/10 113.80 75.00 75.00 0.00 0.00
6/11 114.75 200.00 30.00 170.00 19507.50
2/12 115.00 75.00     8625.00

Related topics