Stock Valuation Method

Stock Valuation Method Report in Tally 9.0

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: In the Stock Summary screen, select the New Column button on the button bar or press Alt+C. The screen appears as shown. Select First in First Out (FIFO) from the Stock Valuation Methods list.

The Stock Summary report with First in First Out (FIFO) column is displayed as shown:

Tally permits different valuation methods for different items, that is, it does not restrict you to one method of valuation only for all items.  The selection of an appropriate costing method is essential in order to select an appropriate stock valuation method.  This helps in knowing the value of the stock both on cost basis and sale basis, which shows the approximate profit margins lying in the inventory.

Activating Stock Valuation

1. From the Gateway of Tally -> Inventory Info ->Stock Item Creation Screen.
2. Press F12:Configure.  Advanced Entries for Inventory should be activated.
3. Return to the Stock Item screen.
4. Under behaviour, activate costing and market valuation methods by entering values in Units and Set Std Rates.

The different costing methods are:

• Average Cost
• At Zero Cost
• First In First Out (FIFO)
• Last Purchase Cost
• LIFO Annual (Last In First Out Annual)
• LIFO Perpetual (Last In First Out Perpetual)
• Monthly Avg. Cost
• Standard Cost

The different stock / market valuation methods are:

• At Zero Price
• Average Price
• Last Sale Price
• Standard Price

Average Cost / Price:

Tally recalculates the average value after each purchase or sale for the whole year.

At Zero Cost:

The stock is valued at zero cost.

FIFO (First In First Out):

Tally assumes the sale of the oldest goods first.

Last Purchase Cost / Sale Price:

The stock is valued at the latest price.

LIFO Annual (Last In First Out Annual):

Tally assumes the sale of the newest goods first taking into account the current financial year.

LIFO Perpetual (Last In First Out Perpetual):

As above, but the last purchase price continues from the previous financial year.

Monthly Avg. Cost:

Tally recalculates the average value after each purchase or sale for the whole month.

Standard Cost / Price:

A pre-determined value that you have entered earlier during the stock item creation.

Advanced Inventory features

Tally also provides the facilities for:

• Ignoring difference in stock due to physical counting. 
• Ignoring negative balances.
• Treating all sales as new manufacture.
• Treating all purchases as consumed.
• Treating all rejections inward as scrap. 
  • Depending on the requirement, select YES or NO.
• Ignore difference Due to physical counting.
  • You are allowed to record the physical stock as counted, by way of a physical stock voucher.  There is, usually, a difference between physical counted stock and that appearing in the records.  If you wish to ignore the difference and continue using the stock as per books, select yes.  It is, however, advisable not ignore the difference.
• Ignoring negative balances.
  • In case of negative balance for stock items in stock reports this option can be selected.  Select as required.  
• Treating all sales as new manufacture.  
  • This is one way to avoid negative balances in the stock records. if you wish to avoid the need to pass entries for manufacture or goods in and can be automatically done when goods are sold.
• Treating all purchases as consumed.
  • Issues are automatically raised for all goods purchased, if this is selected. you do not wish to keep track of issues for this item.
• Treating all rejections inward as scrap.  
  • If you do not want rejected goods coming in to be taken back into stock, select Yes.  Otherwise , rejected goods received, though recorded separately through a Rejection note, will be taken back into stock.