To find customers who stopped buying an item, compare two periods item by item: anyone who bought it last period and none of it this period has moved that item elsewhere, even if they still buy other things from you. Tally has no built-in list for this; Takkada's Vanished customers card shows it. The customer who drops one item is easy to miss, because their ledger stays active and their payments keep coming. A distributor usually notices only when the second and third items go the same way, and by then another supplier has the relationship. The worked example below compares September 2026 with August for a paint, hardware and sanitary distributor and finds four customers who dropped an item, worth ₹87,500 of August sales between them. It shows the Tally route step by step, what each call should sound like, and how to send a ready message from your own WhatsApp, one customer at a time.
Key Highlights
- The earliest sign of a customer leaving is one item gone quiet while the rest of their buying looks normal.
- In Tally the check is item by item: Movement Analysis for last period, again for this period, and a comparison by hand or in Excel.
- In the example, four customers dropped one item each, and the biggest, Patel Paints, had bought ₹36,600 of Wall Putty 20 kg in August.
In This Article
- What is the difference between an inactive customer and one who dropped an item?
- How to find customers who stopped ordering an item in Tally
- A worked example: four customers, four items
- What to say when you call
- On the phone: Vanished customers
- Frequently Asked Questions
What is the difference between an inactive customer and one who dropped an item?
An inactive customer has stopped buying from you altogether. A customer who dropped an item still buys, but one line has gone to someone else. The second is the earlier warning and the cheaper one to fix.
| Dropped one item | Inactive customer | |
|---|---|---|
| What the ledger shows | Bills as usual, one item missing | No bills for weeks |
| Payments | Normal | Often stop too |
| When you usually notice | Rarely, unless you check item by item | When the outstanding stops moving |
| What it takes to win back | One call about one item | A visit, often a discount |
Customer attrition analysis for a distributor is mostly the first column. By the time a shop is inactive, the decision was made months earlier, one item at a time.
How to find customers who stopped ordering an item in Tally
Tally has no report that lists customers who stopped buying a particular item. You can build the list one item at a time.
- Press Alt+G, type Stock Item Movement Analysis and pick the item.
- Press F2 and set last month. Note each customer on the outwards side and the quantity they took.
- Press F2 again and set this month. Note the customers again.
- Anyone on the first list and missing from the second has stopped buying that item.
- Repeat for your top items, or export both months with Alt+E and compare them in Excel.
For a business with 200 items and 150 customers, this is a monthly afternoon of work. Most owners do it for their top ten items, which is where the money is anyway. A customer's own buying, all items at once, is in Ledger Movement Analysis for that party.
A worked example: four customers, four items
The distributor compares September 2026 with August. Each of these customers bought the item in August and none of it in September.
| Customer | Item | August quantity | August value | Still buying other items? |
|---|---|---|---|---|
| Patel Paints | Wall Putty 20 kg | 60 Bag | ₹36,600 | Yes |
| Shree Ganesh Hardware | PVC Pipe 1 inch 6 m | 60 Pcs | ₹24,600 | Yes |
| Ravi Traders | Exterior Emulsion 20 L | 30 Tin | ₹17,050 | Yes |
| Mehta Sanitary | Ball Valve 1 inch | 50 Pcs | ₹9,250 | Yes |
| Total | ₹87,500 |
Every one of them is still an active customer. None would show on an inactive-customer list, and Ravi Traders bought more Wall Putty in September than anyone. Patel Paints is the one to call first: ₹36,600 a month on one item is over ₹4 lakh a year if it does not come back.
What to say when you call
Keep the call about one item and ask a question before you offer anything. Three openings that work:
- The plain check. "Patel ji, last month you took 60 bags of Wall Putty from us and this month none. Is stock still there, or did something go wrong with the last lot?"
- The rate question. "If someone has given you a better rate on putty, tell me the rate. I will check with my supplier before you place the next order."
- The stock question. "We had a short supply of glue in the middle of the month. If you went elsewhere for it, I understand. It is back in stock now."
Do not open with a discount. Half the time the reason is a missed delivery, a damaged bag or a salesman who stopped asking, and a discount gives away margin for a problem you could have fixed with one dispatch.
On the phone: Vanished customers
In Takkada, the Insights tab inside Sales by Item has a card called Vanished customers. It lists customers who bought an item last period and none of it this period, with what they spent. For the example, the card reads 4 customers bought an item in August and none of it this period. The cards are worked out from your Tally, as of the last sync, when you open the tab, for the period you pick.
Tap a row and choose Send from my WhatsApp. Your own WhatsApp opens with a ready message that names the customer, the item and your business, says they have not ordered it recently and asks whether they need it. You press send yourself. It works one customer at a time, and you can choose Call from the same row instead. The full list exports to Excel or PDF for a salesman's beat. The sales insights from Tally page shows the other seven cards, and the party-wise item-wise sales report for Tally page shows how to open any item to its customers at their average price. Owners and full-access team members see item-wise sales and profit; you choose who else sees reports.
With the MIS Insights add-on: Customers to call sorts every customer by days since their last bill into Billed, Not billed, Inactive and Lost, with the days you set (30, 40 and 50 to start). Its Drop off list shows customers who bought chosen items before and then stopped, Have not shows customers who never bought them, and But not shows customers who buy these items but not those. From any customer row you can call, WhatsApp, take an order or send a payment request, one customer at a time. Part of the MIS Insights add-on. Ask us to switch it on for your business.
For the customers who have stopped buying everything, our post on customer analytics from Tally covers buying frequency, and the cross-sell gap report covers items a customer has never bought from you. If the quiet customer also owes you money, read overdue customers nobody has chased before you call. Every report the app reads from your Tally is listed on the Tally reports on mobile page.
Frequently Asked Questions
Q: How do I find customers who stopped ordering from me?
A: Compare two periods item by item. Anyone who bought an item last period and none of it this period has moved that item, even if they still buy other things. In the example, four active customers dropped one item each, worth ₹87,500 of August sales.
Q: What is customer attrition analysis for a distributor?
A: It is the check for customers you are losing, and for a distributor it starts at the item level. A shop rarely leaves in one day. It moves one item, then another, so the useful report is the list of items each customer stopped buying, checked every month.
Q: Can Tally show inactive customers?
A: Tally has no report named inactive customers. You can read a party's last bill in its ledger or in Ledger Movement Analysis, and an item's buyers in Stock Item Movement Analysis for two periods. Comparing the two periods by hand gives the list.
Q: Can I message all of them at once?
A: No. In Takkada, Send from my WhatsApp opens your own WhatsApp with a ready message for one customer, and you press send. You can also call from the same row. A message about one item, from your own number, reads like a note from you, which is what it is.
Q: How often should I check?
A: Once a month, after the month's sales are in Tally, comparing it with the month before. In the running month, compare against the same days of last month so a half month is not read as a drop. Start with the customers whose August value on the item was the highest.
Takkada shows Sales by Item and its Insights cards, including Vanished customers, from your Tally books on the phone and the web app. Message us on WhatsApp to see who stopped buying on your own data.