Find Customers Who Stopped Buying: Party-Wise Last Sale in Tally
Customers rarely announce they have left. A party-wise last sale view in Tally shows who has gone quiet, so sales can follow up before they are gone.
Customers rarely tell you they have stopped buying. They just do not order again, and by the time someone notices, they are buying elsewhere. A party-wise sales report in Tally that shows each customer's last sale date turns that silence into a list sales can act on. This guide covers how to build the list with standard reports, what to look for, and how to run the follow-up.
Why the last sale date matters
Total sales per customer tells you who matters most. The last sale date tells you who is drifting away. A customer who bought every week and has not bought for five weeks is a stronger signal than a large customer whose monthly order is two days late. Looking at both together is what makes the list useful.
Building the list with standard TallyPrime reports
Standard TallyPrime reports show each customer's transactions, but not a single side-by-side column of last sale dates. Common approaches:
- Customer ledgers: open each key customer's ledger (Alt+G, then the ledger name) and note the date of the last sales voucher. Fine for your top 20 customers, slow beyond that.
- Sales Register: filter the register by party for a recent period. If a regular customer has no entries, they have gone quiet.
- Export and sort: export sales vouchers for the year to Excel and use a pivot table to find the latest date per party.
For a business with hundreds of customers, a report that shows party-wise last sale directly saves this work every week. AndurilTech lists an add-on named Party-Wise Last Sales Report; read its product page for the columns it shows and the release it supports.
What to look for in the list
| Pattern | What it may mean |
|---|---|
| Regular buyer, no order for more than twice their usual gap | Price, service or stock issue, or a new supplier |
| Quiet customer with old unpaid bills | Cash-flow trouble; check before offering credit |
| Several customers in one area going quiet together | A competitor or a delivery problem in that area |
| Customer quiet after a complaint or return | Unresolved service issue |
Turn the list into follow-up
- Share it weekly with whoever owns each customer relationship.
- Check outstanding first. A customer who owes you money needs a different conversation; see our guide to bill-wise outstanding in TallyPrime.
- Call or message with something useful: a new product, a stock update, a reminder of terms.
- Record the reason each customer gives, and review the reasons monthly.
A short WhatsApp message often gets a reply when a call does not; our Tally WhatsApp integration covers sending messages and documents from Tally. And before extending fresh credit to a returning customer, check their limit, as covered in our guide to credit limits in TallyPrime.
Frequently asked questions
Does TallyPrime show the last sale date for every customer?
You can see each customer's transactions in their ledger or in the Sales Register, but listing every customer's last sale date side by side usually means checking parties one by one, exporting data, or using a dedicated report add-on.
How long without an order means a customer is inactive?
It depends on how often they normally buy. A customer who orders weekly is worth a call after three or four quiet weeks, while a quarterly buyer may need four months before it means anything.
What should I do with a list of inactive customers?
Share it with sales weekly, check outstanding and complaints before calling, and record the reason each customer gives. The reasons often point to a price, service or stock problem.