The stock ageing report in Tally Prime is Stock Ageing Analysis. Press Alt+G, type Stock Ageing Analysis and press Enter: Tally splits each item's stock into age slabs, under 45 days, 45 to 90, 90 to 180 and over 180 days by default, and F6 lets you set your own. Age is counted from the purchase date, or the manufacturing date if you switch the style with F9. Tally's help lists batch-wise details as a prerequisite, so the report is built for items kept in batches. For a distributor, the useful question behind the report is simple: how much money is sitting in stock that came in months ago, and what is it costing. The worked example below takes ₹11,80,000 of closing stock, finds ₹4,20,000 of it past 90 days, and prices that at the owner's own 12% a year: ₹4,200 a month. It also covers dead stock, which is a different test. Key paths are from TallyPrime's help, checked on 10 November 2026.
Key Highlights
- Stock Ageing Analysis opens from Alt+G; F6 changes the slabs and F9 switches between purchase date and manufacturing date.
- Ageing counts days since the stock came in, while dead stock counts days since it last sold; an item can be young and dead, or old and still moving.
- In the example, ₹4,20,000 is past 90 days, which at 12% a year costs ₹4,200 a month in interest alone.
In This Article
- How to get the stock ageing report in Tally Prime
- Why the report depends on batches
- What owners actually ask about old stock
- A worked example: ₹11,80,000 of stock by age
- Dead stock and over-buying on the phone
- What to do with stock past 90 days
- Frequently Asked Questions
How to get the stock ageing report in Tally Prime
- Press Alt+G (Go To), type Stock Ageing Analysis and press Enter.
- Tally shows each item's closing stock split into the default slabs: under 45 days, 45 to 90, 90 to 180 and over 180.
- Press F6 (Ageing Periods) and type your own From and To days, for example 0 to 30, 30 to 60, 60 to 90 and over 90.
- Press F9 (Ageing Style) to age stock by purchase date or by manufacturing date.
- Press F7 to show value or profit alongside the quantity, and F2 to set the date the ageing is worked out on.
Why the report depends on batches
Stock Ageing Analysis ages stock lot by lot, and a batch is how Tally knows which lot came in when. Tally's help lists batch-wise details as a prerequisite for the report. For items you do not keep in batches, check the report against Stock Summary before you rely on it: if the aged quantity is smaller than the closing stock, the difference is stock the report could not place in a slab.
If most of your items are not in batches, the item's last purchase and last sale dates are a simpler check. Stock Item Monthly Summary shows them month by month, as our post on the stock register in Tally Prime explains.
What owners actually ask about old stock
The ageing report answers "how long has this been here". The owner's next two questions are different.
| Question | What answers it |
|---|---|
| How long has this stock been in the godown? | Stock Ageing Analysis, by slab |
| What has not sold at all for two months? | Dead stock: days since the last sale |
| What did I keep buying while it was not selling? | Over-buying: bought against sold for the period |
| What is the old stock costing me? | Value past 90 days × your own interest rate |
A box of Hex Bolt M10 bought last week and never sold is young and dead. A tin of Exterior Emulsion 20 L bought five months ago that still sells every week is old and moving. The ageing report alone puts the emulsion in the worry pile.
A worked example: ₹11,80,000 of stock by age
A paint, hardware and sanitary distributor closes September 2026 with ₹11,80,000 of stock at cost. Ageing Analysis, with the default slabs, splits it like this. The owner's working capital costs 12% a year, which is 1% a month.
| Slab | Value | Share | Interest a month at 12% a year |
|---|---|---|---|
| Under 45 days | ₹5,10,000 | 43% | ₹5,100 |
| 45 to 90 days | ₹2,50,000 | 21% | ₹2,500 |
| 90 to 180 days | ₹2,80,000 | 24% | ₹2,800 |
| Over 180 days | ₹1,40,000 | 12% | ₹1,400 |
| Total | ₹11,80,000 | ₹11,800 |
The two older slabs together hold ₹4,20,000, and that money costs ₹4,200 every month before rent, damage or a price cut on the supplier's side. Over a year, the 90-day stock alone costs ₹50,400 to keep. Use your own rate: a business borrowing on a cash credit limit at 11% gets a smaller figure, and one using the family's money still gives up what that money would earn elsewhere.
Dead stock and over-buying on the phone
In Takkada, the Insights tab inside Purchases by Item has two cards for this. Dead stock lists items with no sale in 60 days or more, the biggest 25 by value, with the quantity, the value and the days since the last sale. In the example it might read ₹1,84,000 sitting in 25 items with no sale in 60+ days. Over-buying shows what you bought beyond what sold in the period, such as ₹46,000 bought beyond what sold on 3 items, with the weeks of stock left at this period's sales. The cards are worked out from your Tally, as of the last sync, when you open the tab, and each opens a full list for Excel or PDF. The sales insights from Tally page shows all eight cards, and the Tally reports on mobile page lists the rest of the reports.
With the MIS Insights add-on: Stock health shows your stock value by age, what will run short or is too much at your average selling speed, what has not sold for the number of days you pick, and batch expiry. It can show what holding stock costs as interest at your own rate a year, counted from the bill date or the due date. Tap an item for its godown ageing, last sale and purchase, three months of movement and the customers who stopped buying it. Part of the MIS Insights add-on. Ask us to switch it on for your business.
What to do with stock past 90 days
Start with the biggest rupee lines in the older slabs and decide one of four things for each.
- Return it. Many suppliers take back unopened stock within their terms. Ask before the season changes, while the batch is still current.
- Move it with a scheme. Offer it to the customers who bought it before. The ones who stopped buying it are the first names to call, as our post on customers who stopped buying an item shows.
- Bundle it. Put a slow item with a fast one at a small discount, for example Ball Valve 1 inch with PVC Pipe 1 inch 6 m.
- Stop buying it. Check the item's last three purchase orders. If you are still reordering it out of habit, the over-buying check is where it shows.
Our post on finding dead stock in Tally before year-end has the full year-end list method, and the fast-moving and slow-moving items post covers ranking items by how fast they sell. Receivables have an ageing report of their own, explained in our aging report in Tally guide.
Frequently Asked Questions
Q: How do I get the stock ageing report in Tally Prime?
A: Press Alt+G, type Stock Ageing Analysis and press Enter. Tally splits each item's stock into slabs of under 45, 45 to 90, 90 to 180 and over 180 days by default. Press F2 to change the date it is worked out on.
Q: Can I change the ageing slabs in Tally?
A: Yes. In Stock Ageing Analysis, press F6 (Ageing Periods) and type the From and To days for each slab. Many distributors use 0 to 30, 30 to 60, 60 to 90 and over 90 so that the 90-day line matches their credit terms.
Q: How do I check non moving stock in Tally Prime?
A: TallyPrime has no report named non-moving stock. Read the over-180 and 90-to-180 slabs in Stock Ageing Analysis, then check each item's last sale in its Stock Item Monthly Summary. In Takkada, the Dead stock card lists items with no sale in 60 days or more, the biggest 25 by value.
Q: What is the difference between stock ageing and dead stock?
A: Stock ageing counts days since the stock came in. Dead stock counts days since the item last sold. A new item that has not sold in 60 days is dead stock, and an old item that sells every week only looks bad on the ageing report.
Q: How much does old stock cost me?
A: Multiply the value past 90 days by your own interest rate. In the example, ₹4,20,000 at 12% a year is ₹50,400 a year, or ₹4,200 a month, before rent and damage. Use the rate you pay on your cash credit limit, or what the money would earn elsewhere.
Takkada shows the Dead stock and Over-buying cards, Sales by Item and Purchases by Item from your Tally books, on the phone and the web app. Message us on WhatsApp to see them on your own stock.