Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...

9. Stock Valuation in Tally.ERP9

As per accounting rules, the final results of a company's working depend on the valuation of inventory (stocks). As per norms, there are many concepts of evaluating the company's stock. Tally.ERP 9 goes one step ahead, by providing all the required stock valuation methods for you to choose from. In addition,  Tally.ERP 9 allows you to choose different valuation methods for different items.

9.1. Stock Valuation Method

The Stock Valuation / Costing Methods provided in Tally.ERP 9 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

In addition, Tally.ERP 9 provides the following Market Valuation Methods:

 

         At Zero Price

         Average price

         Last Sale Price

         Std. Price

  

Depending on the Market Valuation Method defined in the stock item master, Tally.ERP 9 displays the rate/ price automatically at the time of Invoice entry. The Market Valuation Method is set as Average  Price by default. The Average Price displays the average of all the sales prices given in the previous sales entries, as the selling rate/ price while the current sales entry is being made.

Let us now examine the result of the different stock valuation methods

 

9.2. Display Stock Summery

Setup :

        Go to Gateway of Tally > F12: Configure > Accts / Inventory Info.

          Set Allow Advanced Entries in Masters in Inventory Masters to Yes.

        Go to Gateway of Tally > Inventory Info. > Stock Item > Alter,

        Select HP - 27 Printer Cartridges, you will find that the details of Costing Method and Market Valuation Method under Behaviour

          Select Average Cost and Average price respectively

          Accept the master information.

 

 

Go to Gateway of Tally > Stock Summary,

 

        Select Printers Stock Group

        Press F2: Period and change the period from 1-07-2009 to 31-07-2009.

        Click Auto Column (Alt + N) button and select Stock Valuation Methods.

 

 

The closing balance of stock as per Default and FIFO stock valuation methods are shown below :
Stock Valuation in Tally.ERP9
Tally.ERP 9 displays the closing stock of 6 nos of HP - 27 Printer Cartridges  as per different stock valuation methods. Since there are 11 columns in the report the same is displayed in six screens as shown below:
Stock Valuation in Tally.ERP9
Stock Valuation in Tally.ERP9
Stock Valuation in Tally.ERP9

We have purchased a total of 15 nos for Rs. 12750. The average now is Rs. 12,750 / 15 = Rs. 850 with a closing balance of 6 nos x 850 = Rs. 5,100 (Average cost method of valuation)

You can decide which method of stock valuation is most appropriate for your business and accordingly define that in the item master. FIFO (First In First Out) and Average Cost are the most popular stock valuation methods used in today’s business.
 
 
Text
 
 
Company Information @ Tally.ERP9
 
Group & Ledger

Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES

Advanced Inventory / Stock
Meaning
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Tally.ERP9 Report
  1. Unit Objectives
  2. Modifying Reports (Options)
  3. Balance Sheet
  4. Profit & Loss Account
  5. Stock Summary
  6. Trial Balance
  7. Day Book
  8. Books of Accounts
  9. Statement of Accounts
  10. Inventory Books
  11. Statutory Reports
  12. List of Accounts ( Chart of Accounts)
  13. Exception Reports
  14. Printing Reports
Tally.ERP9 MIS and Other Reports
Statutory & Taxation
Utilities & Others @ Tally.ERP9
Credit Limits
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)
 
Disclaimer :

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website.

 
GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
     
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
 
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com