While TallyPrime doesn’t directly display stock age with the chosen valuation method in a single report, you can achieve this by combining information from the Stock Ageing Analysis and the Stock Summary reports.
Here’s a detailed approach:
Step 1: Generate the Stock Ageing Analysis Report in TallyPrime
- Go to the Gateway of Tally (Alt+F12) in TallyPrime.
- Navigate to Display > More Reports > Statements of Inventory > Stock Ageing Analysis.
Alternatively, you can use a keyboard shortcut:
- Press
Alt+G
(Go To) and type or select “Stock Ageing Analysis.”
Step 2: Define Age Slabs (Optional)
By default, the report might have pre-defined age slabs.
You can customize them by pressing F6
(Ageing Periods) and setting your preferred ranges (e.g., 0-30 days, 31-60 days, etc.).
Step 3: View Stock Age Breakdown
The report will display information like:
- Item Name: Name of the stock item.
- Date: Date of the report generation.
- Total Quantity: Total quantity of the stock item currently in hand.
- Age Slabs: User-defined categories representing different age ranges.
- Quantity (for each Age Slab): Breakdown of the total quantity according to the defined age ranges.
Step 4: Generate the Stock Summary Report (with Valuation Method)
- Go to the Gateway (Alt+F12) in TallyPrime.
- Navigate to Reports > Inventory Reports > Stock Summary.
Step 5: Configure the Stock Summary Report
- Press
Alt+F12
(Configure) to access report settings. - Under the “Valuation Method” section, choose the desired valuation method (e.g., Average Cost, FIFO, LIFO). This will calculate the total value of your stock based on the chosen method.
Step 6: Analyze Stock Age and Valuation (Example)
1. Scenario:
- You run a clothing store.
- You generated a Stock Ageing Analysis report with age slabs: 0-30 days, 31-60 days, and >60 days.
- You generated a Stock Summary report with the “Average Cost” valuation method.
2. Combining Information:
Compare the data from both reports for each stock item.
Here’s a simplified example:
Item Name | Age Slab (Stock Ageing) | Quantity (Stock Ageing) | Total Value (Stock Summary) |
---|---|---|---|
T-Shirt (M) | 0-30 Days | 40 | Rs. 8,000 |
T-Shirt (M) | 31-60 Days | 30 | Rs. 6,000 |
T-Shirt (M) | >60 Days | 20 | Rs. 4,000 |
3. Analysis:
- You can see the age distribution of T-Shirt (M) stock.
- By comparing the “Quantity” with the “Total Value” (based on Average Cost), you can estimate the average cost per unit within each age slab.
4. Limitations:
- This method requires combining information from two separate reports.
- It provides an estimate of average cost per age slab, not the exact cost of each item within that slab.
Additional Considerations:
- You can utilize more detailed Stock Summary reports (like Stock Summary by Batch) for a deeper analysis of valuation based on batch tracking.
- Regularly generate these reports to monitor stock age and adjust purchasing and sales strategies accordingly.
By effectively combining Stock Ageing Analysis and Stock Summary reports with your chosen valuation method, you gain a comprehensive understanding of both the age distribution and estimated valuation of your inventory, empowering you to make informed inventory management decisions.
Leave a Reply