Stock aging analysis helps businesses understand how long inventory has been sitting in stock. It categorizes stock items based on their age, enabling better inventory management. This guide explains how to enable and use stock aging analysis in Tally Prime with a real-world example.
Stock aging analysis categorizes inventory into age brackets (e.g., 0-30 days, 31-60 days, etc.), showing the duration items have been in stock. This helps identify slow-moving or obsolete stock.
Ensure stock aging analysis is enabled in Tally Prime.
Navigate to:
Set Enable Stock Aging Analysis to "Yes" and press Ctrl + A to save.
Ensure stock transactions are recorded with proper dates for accurate analysis.
A business deals in the following items:
No sales have occurred as of December 1, 2024. The stock aging analysis will categorize these items based on their purchase dates.
Follow these steps to view the Stock Aging Analysis report.
Navigate to:
Press F6 (Aging Method) to define age brackets such as:
The report will categorize stock items based on the defined aging periods.
Based on the example transactions, the Stock Aging Analysis report as of December 1, 2024, will look like this:
| Item | 0-30 Days | 31-60 Days | 61-90 Days | Total Quantity |
|---|---|---|---|---|
| Mobile Phones | 0 | 50 | 0 | 50 |
| Laptops | 30 | 0 | 0 | 30 |
Customize the Stock Aging Analysis report to meet your needs.
While viewing the report, press F12 to configure options such as:
Press Enter to apply the changes and view the updated report.
Stock Aging Analysis provides the following benefits:
To summarize:
Stock Aging Analysis in Tally Prime is a powerful tool for inventory management. It helps businesses make informed decisions regarding stock clearance and procurement. By using this feature, you can optimize inventory levels and improve overall efficiency.