You find fast-moving and slow-moving items in Tally by ranking each stock item on how fast it moves, then reading that ranking next to quantity on hand. Fast moving slow moving items tally owners actually use come from the Inventory report on the phone: Velocity is the ranking of movement, Stock is what is sitting there, and the two tabs together tell you which SKU can go dry this week and which SKU is cash on a shelf. Velocity sits in Reports+. A Guwahati FMCG owner at 9:10 on Monday opens Velocity, sees 1-litre mustard oil at 24 bottles a day and a pickle jar at 2, then flips to Stock: 96 bottles of oil, 200 jars of pickle. The oil has 4 days of cover against a 7-day Kolkata truck. The pickle has 100 days. This article shows how to read those two tabs, how item-wise sales feeds the same idea, and which list you take into the purchase call.
Key Highlights
- Velocity ranks how fast each item moves; Stock shows quantity on hand; read them together so a fast mover with 96 bottles and a slow mover with 200 do not get the same purchase
- Item-wise sales is the same ranking from the sales side, quantity and value per SKU over a period, usable on the phone in the aisle
- Inventory and Stock Summary have no export; Velocity exports to PDF or Excel, which is the sheet for Monday's purchase call
In This Article
- How do I find fast moving slow moving items tally on the phone?
- Velocity next to Stock
- Item-wise sales as the other ranking
- What a fast mover needs on Monday
- What a slow mover is actually costing
- The sheet you take into the purchase call
- Frequently Asked Questions
How do I find fast moving slow moving items tally on the phone?
You find fast-moving and slow-moving items in Tally by sorting stock items on movement, then looking at what is still on the shelf. Movement without stock is a trivia ranking. Stock without movement is a pile.
On the phone, Inventory has two tabs. Velocity is how fast each item moves. Stock is what is there. Open Velocity at 9:10, read the top of the list, flip to Stock for those SKUs, write days of cover next to lead time. The top of Velocity is the set that can go dry. The bottom, with high Stock, is the set that is sitting.
In Tally Prime on the desktop, the same idea lives in Stock Summary and in item-wise or Movement Analysis reports under inventory: outward quantity for the period, sorted so the movers rise. The limitation is the machine. The ranking is needed in the godown, where the purchase call is made, and on the scooter, where the salesman is about to promise the last cases.
Fast and slow are relative to your book. In a 400-SKU Guwahati FMCG godown, 24 bottles a day is fast. 2 jars a day is slow. In an agri-input shop in season, the fast band is a different set every fortnight. The method is the same. Rank, then read stock.
This ranking is how stockout control for distributors picks which of 400 SKUs get a reorder point this week. You do not compute 400 formulas at 9 AM. You compute the ones Velocity just named.
Velocity next to Stock
Velocity without Stock will scare you about items that still have 90 days of cover. Stock without Velocity will make you reorder a pickle because the shelf looks empty in that corner.
Read them as a pair.
| Velocity | Stock | What it usually means | Monday move |
|---|---|---|---|
| High | Low | Fast mover about to go dry | Purchase, today, against lead time |
| High | High | Fast mover with cover | Watch; recompute cover Thursday |
| Low | High | Slow mover holding cash | Hold buying; scheme or return before year-end |
| Low | Low | Slow mover that is also thin | Leave it; do not fill a dead line |
Monday 9:10. Oil: high Velocity, 96 on Stock, 24 a day, 4 days of cover, 7-day truck. Purchase. Pickle: low Velocity, 200 on Stock, 2 a day, 100 days of cover. No purchase. Biscuit carton: high Velocity, 45 on Stock, 18 a day, 2.5 days, 12-day rains truck. Purchase, both godowns if godown-wise says so.
A company Stock total can lie. Oil at 96 with 96 in Tinsukia and 0 in Guwahati is a fast mover that is already dry at the counter that sells it. Godown-wise stock is the Stock cut per location. Velocity is still company movement unless you have been splitting sales by location in your head.
Past-date Stock is quantity-exact, rupees at current rate. For this ranking you want today's Stock and a recent Velocity period, 30 days for a steady line.
Item-wise sales as the other ranking
Item-wise sales is the sales-side version of the same sort: quantity and value per item over a period. Sort by quantity and the unit movers rise. Sort by value and the rupee movers rise. They are not always the same SKU. Cheap biscuits can win quantity. Oil can win rupees at ₹185 a bottle × 24 a day = ₹4,440 a day.
Use quantity when the question is cover and reorder. Use value when the question is which empty SKU hurts cash. Lost ₹4,440 a day of oil is a different emergency from a slow pickle at ₹40 a jar × 2 a day.
Item-wise sales on the phone is the ranking you can read in the aisle while deciding what to load. Velocity is the Inventory view of movement. They should agree on the top band. If they do not, the period is different, or a stockout last week killed billed quantity and the oil looks slower than demand was. That dip is the lost sales problem: invoices understate a dry SKU.
Party-wise sales tells you who feels a fast mover going to zero. The three retailers who lift 60% of the 200 ml will be in tomorrow. Ranking items without ranking parties is how you protect a SKU nobody actually asks for.
What a fast mover needs on Monday
A fast mover is an item whose Velocity (or item-wise quantity) puts it in the band that can go dry inside lead time.
For each of those, compute days of inventory cover: on-hand ÷ daily sales. Put it next to lead time from the notebook. If cover is at or below lead time, it goes on the purchase list. The reorder point gives the quantity: daily sales × lead time, plus buffer.
Oil: 96 on hand, 24 a day, cover 4, lead time 7, buffer 3 days = 72, reorder point 240, purchase 144 bottles, ₹26,640. Biscuit: 45 on hand, 18 a day, cover 2.5, lead time 12, purchase today, both locations if both are short.
Sales orders already in Tally subtract from free stock before you type the PO. Fifty bottles promised against 96 is 46 free, under two days of oil. Pending Orders, a paid add-on available on request, is that not-yet-invoiced list.
Do not reward a fast mover with a blind extra month of stock. That is how a festival spike becomes January dead stock. Buy to cover lead time plus buffer, then look again Thursday.
What a slow mover is actually costing
A slow mover with high Stock is working capital. 200 pickle jars at ₹40 is ₹8,000 that looks small until you have forty such SKUs. Forty × ₹8,000 is ₹3,20,000 sitting in a corner while the oil is dry.
Hold it, then scheme or return before year-end locks the valuation. That is the dead stock pass: Velocity near zero for 90 days, Stock still there, identify before March.
A slow mover with low Stock is usually a line you should not refill. Thin and slow is a SKU the market already voted against. Filling it because the hook looks empty is how dead stock is born.
Season can reclassify. A diya-oil tin that is slow in July is a fast mover in October. Last year's item-wise sales for that month is the ranking to use, not July Velocity. Mixing those two periods is how you either miss Puja or sit on tins until February.
The sheet you take into the purchase call
Monday 11 AM, purchase person, six suppliers on the phone.
Inventory and Stock Summary have no export. Velocity exports to PDF or Excel. That export is the ranking you can put on the table. Next to it, by hand or on a second screen: Stock quantity, cover, lead time, reorder gap.
Eleven items this Monday, including the oil at 4 days against 7, the biscuit at 2.5 against 12, and the 200 ml shampoo at 2 days against 8. Godown-wise for those eleven, so Guwahati oil is purchased and Tezpur oil is not. Sales orders subtracted. PO quantities typed.
The pickle is on the Velocity export too, at the bottom, with 200 on Stock. It is on the sheet so nobody "just adds a case" while they are ordering Kolkata. Slow movers get protected by being visible, not by being forgotten.
Thursday is a shorter look on the items that changed, ranking open, Stock beside it: a scheme, a festival lift, a large order on Wednesday.
The SKUs do not raise a hand when they cross from fast-and-covered to fast-and-dry. The owner opens Velocity, then Stock, and decides.
Frequently Asked Questions
Q: How do I find fast-moving and slow-moving items in Tally?
A: Rank stock items by movement, then read quantity on hand next to that rank. On the phone, Inventory Velocity is the movement ranking and Stock is the quantity. On the desktop, Stock Summary and item-wise sales sort the same way. Fast and slow only mean something when both numbers are in view.
Q: Where do fast moving slow moving items tally rankings live on the phone?
A: In the Inventory report. Velocity is how fast each item moves. Stock is what is there. Item-wise sales is the sales-side ranking by quantity or value. Read Velocity or item-wise sales first, then Stock, then godown-wise if you have more than one location.
Q: Can I export the fast-mover list?
A: Velocity exports to PDF or Excel. Inventory and Stock Summary have no export. If the purchase call needs a sheet, the Velocity export is the one that exists. Cover and lead time still get written beside it.
Q: Should I reorder every fast mover automatically?
A: No. Reorder the fast movers whose days of cover are at or below lead time. A fast mover with 40 days of cover is healthy. A slow mover with 100 days of cover is capital. The ranking names the candidates. Cover and lead time name the purchase.
Q: Why did a fast mover look slow after a stockout week?
A: Item-wise sales only counts what was billed. A dry week records as quiet demand. Use days the item was in stock for the average, and treat the dry days as lost sales evidence, not as a new slower rate.
Q: Do I need all 400 SKUs on the purchase sheet?
A: No. The top of Velocity, the ones whose cover is close to lead time, plus the slow-and-high-stock lines you must not refill by accident. A sheet of thirty movers beats a sheet of 400 empty columns.
Takkada is a Tally-integrated receivables and auto-reconciliation app for Indian distributors, with 0% MDR UPI collection and WhatsApp dispatch. Book a free demo.