11. Inventory Ageing Analysis in Tally.ERP9

A very important function of Working Capital Management is the monitoring of stocks. Money locked up in stocks can adversely affect the liquidity of a company. Every company strives or should strive to reduce stock levels to the optimum. Most businesses would prefer to dispose off older stocks as they might deteriorate with time, go out of fashion, or simply get forgotten.


Tally.ERP 9's Stock Ageing analysis enables you to know the age of stocks in hand according to when they were received and their purchase value.
11.1. View Inventory Ageing Reports

Go to Gateway of Tally > Display > Inventory Books > Ageing Analysis


       Select Medicines

       Press Enter and change the date to 3-3-2010

       Saridon with batch number ST-102 and expiry date is displayed

       Click on the button Expired Batches to view only those items which have expired (The button All Batches appears when the expired batches are on display)

       Press the button Hide Amounts, which toggles with Show Amounts to view the report with or without values

                    Set ageing style as By Expiry Date and the screen appears as shown below :

Inventory Ageing Analysis in Tally.ERP9

You will find that the Ageing Periods are displayed as <45 days, 45-90 days, 90-180 days and >180 days. These are the ageing period that Tally.ERP 9 displays by default. However, you change the ageing period by using F6: Ageing Periods.

Experiment by choosing different ageing styles and observe the changes in the report.

Practice Exercise

1. Select By Mfg. Date as Ageing Style and view the report as on 31-12-2009.
Company Information @ Tally.ERP9
Group & Ledger
Advanced Inventory / Stock
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
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 GST,TallyERP9 GST, 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.

Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...