# Inventory Average Costing

<span class="ts10">Video training manual 2016 - </span>[Click Here](https://vimeo.com/357005469)

<span class="ts0">The system caters for</span>

<table border="1" id="bkmrk-1-average-costing-2-" style="border-collapse: collapse; width: 28.1481%;"><colgroup><col style="width: 13.195%;"></col><col style="width: 86.717%;"></col></colgroup><tbody><tr><td>1</td><td><span class="ts0">average costing</span></td></tr><tr><td>2</td><td><span class="ts0">latest costing methods</span></td></tr></tbody></table>

<span class="ts0">Average Costing</span>

<span class="ts0">Average costing is worked out by the number of stock items coming into the system with a value. </span>

<span class="ts0">This value is posted to the general ledger books to your stock ledger account and Creditors control account. </span>

<span class="ts0">When the next Goods Received Note with stock comes in, the value of the incoming stock and quantity is worked out. </span>

<span class="ts0">The existing stock quantity and value is multiplied to give you a value and the new value from the Goods Received Note is added together and then divided to give you the new average cost of the item.</span>

<span class="ts0">Looking at the table below the average cost of the item is worked out each time stock comes in based on quantity and value. </span>

<span class="ts0">If the user does not back date any GRV or revalue the stock, one can work out the average cost of the item in excel and in history sorting by audit date and time.</span>

<span class="ts0">If a stock value adjustment has been made, the system will work out from the last stock value adjustment</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3138).png)

<table border="1" id="bkmrk-total-line-value-%3D-q" style="border-collapse: collapse; width: 54.9383%; height: 118.4px;"><colgroup><col style="width: 29.2637%;"></col><col style="width: 70.6913%;"></col></colgroup><tbody><tr style="height: 29.6px;"><td style="height: 29.6px;"><span class="ts0">Total Line Value =</span></td><td style="height: 29.6px;"><span class="ts0">QTY x Unit Value</span></td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;"><span class="ts0">Total Value </span><span class="ts0">=</span></td><td style="height: 29.6px;"><span class="ts0">Previous Total Value + New Total Line Value</span></td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;"><span class="ts0">Total QTY </span><span class="ts0">=</span></td><td style="height: 29.6px;"><span class="ts0">Previous Total QTY + New Line QTY</span></td></tr><tr style="height: 29.6px;"><td style="height: 29.6px;"><span class="ts0">Ave Cost </span><span class="ts0">=</span></td><td style="height: 29.6px;"><span class="ts0">Total Value / Total QTY</span></td></tr></tbody></table>

##### <span class="ts0">Average Costing Test</span>

<span class="ts0">When working out the average unit cost</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3139).png)

<span class="ts0"> </span><span class="ts0">Checking the stock value</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3140).png)

<span class="ts0"> </span><span class="ts0">Inventory valuation report</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3141).png)

<span class="ts0"> </span><span class="ts0">Quantity on hand check</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3142).png)

<span class="ts0"> </span><span class="ts0">Inventory movement check</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3143).png)

<span class="ts0"> </span><span class="ts0"> </span><span class="ts0">Document related transactions check</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3144).png)

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3145).png)

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3146).png)

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3147).png)

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3148).png)

<span class="ts0"> </span><span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3149).png)

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3150).png)

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3151).png)

<span class="ts0"> </span><span class="ts0"> </span><span class="ts0">Item check</span>

<span class="ts0"> </span>![](https://hugeerp0.co.za/csp/webhelp/topics/images/image(3152).png)