Stock Valuation in Excel Download

By | April 1, 2015
Stock Summary can be further configured to derive the following information.

1. Stock Flow: This can be viewed using the F12: Configure button on the Tally.ERP 9 screen. The flow of stock ranging from opening stock, goods inwards, goods outwards to the closing stock can be analyzed in terms of its quantity. It gives you an insight into the quantitative movement of each stock item. However, for reconciling the closing balance value, this report cannot be referred to, since the outward goods are valued at the sales price and not the cost price.


2. Profitability and Consumption: This can be viewed using the F7: Show Profit button on the screen. Stock Summary shows the profitability and consumption details for each stock item. This statement shows the quantity and value of the opening stock, inward goods, outward goods, closing stock and the value of consumption (using the

The Stock Summary report with stock valuation methods can be used to view the effects of different methods on the value of stock. Each stock item can be set up to have a different stock valuation method. In some instances, a particular method of valuation may be required, for example, to assess the replacement value or saleable value of stock. Tally.ERP 9 displays stocks in any or all the valuation methods dynamically and simultaneously, without any complicated procedure.

Suppose you want to use Last Purchase Cost method to assess the replacement value and the Last Sale Price method for realizable (saleable) value:

The Stock Summary report can be viewed based on the Godown Types in Tally.ERP 9, as follows:

Our Stock with us: This will display the stock after excluding your stock lying with third parties and the third party stock with you.

Our Stock with Third Party: This will display your stock lying with the third parties, such as, Job workers, consignment agents, bonded warehouse, etc.

Our Stock with Us and Third Party: This is the default Stock Summary report which will display the stock after including your stock lying with third parties, which is also considered for the final accounts.

Third Party Stock with us: This will display the third party stock lying with you.

Our Stock and Third Party Stock us: This will display the stock including the third party stock lying with you, after excluding your stock with the third parties.

All Types: This option displays the stock after including your stock lying with third parties and third parties stock lying with you.

CLICK HERE TO DWONLOAD Stock Valuation in Excel Download


Leave a Reply

Your email address will not be published. Required fields are marked *