A salesman wise collection report is the receipts side of a field team's performance, showing for each rep what his parties owe today split by ageing bucket, what money came in from those parties during the period, and which of his accounts crossed their agreed terms this month. Most distributors have the selling half of this picture and not the collection half, and the reason is structural. A sale is tagged with a salesman when the order is booked, because the man is standing there. A receipt arrives on its own, as a cheque in the post or a UPI credit at eleven at night, and the office staffer entering it often has no idea whose party it came from. So a team ends up measured to the rupee on billing and measured on impression on recovery. This article covers why attribution is harder on the collection side, what the report must show to be usable, and why commission paid on billing produces a strong sales chart and a thin bank balance.
Key Highlights
- Sales attribution is automatic because the rep is present when the order is booked. Collection attribution has to be designed, because a receipt carries no salesman's name unless somebody routes it back through the party
- A collection board is actionable only if it carries three things together: outstanding split by ageing bucket, money collected in the period, and the parties that newly crossed terms this month
- Reading the team on an order basis and on an invoice basis produces different winners, and only an invoice creates a receivable you can collect against
- Commission paid on billing ends the salesman's job at the delivery. Commission linked to realisation makes the last mile his problem too
In This Article
- What a salesman wise collection report measures
- Why collection is harder to attribute than sales
- What the board must show to be actionable
- Order basis or invoice basis
- Commission on billing versus realisation
- The Monday conversation
- Reading it off your Tally data
- Frequently Asked Questions
What a Salesman Wise Collection Report Actually Measures
A salesman-wise sales report answers one question cleanly: how much did he sell. A collection report answers three, and they are only useful read together. What do his parties owe right now, broken into ageing buckets. How much money came in from those parties during the period. And which of his parties crossed their agreed credit terms this month, so somebody knows while the account is at 35 days rather than at 95.
The reason a distributor rarely has this view is that the first number is a stock and the second is a flow, and Tally holds them in separate places. Outstanding sits in the bills receivable and ageing views, keyed to the party. Receipts sit in the cash and bank books, keyed to the date. Neither is keyed to a salesman, so joining them by rep means two exports and an afternoon in Excel every month, which means it happens for two months after somebody complains and then stops.
So the owner keeps a running impression instead. Ramesh is good at recovery, Suresh is soft with his parties. That impression is often right, and never specific enough to act on.
Why Collection Is Harder to Attribute Than Sales
Two things make this harder than it looks, and neither is solved by trying harder.
A receipt does not carry a salesman's name unless somebody puts it there. The sales voucher gets its tag at entry, usually as a cost centre allocation, because the order came from a named person on a named route. The receipt has no such moment. Money lands from a party's current account, from the proprietor's personal UPI, or as a cheque that clears four days later, and the staffer allocating it is solving a different problem, which is which invoice it settles. Getting a rep onto that entry means the party master carries the rep, and the receipt inherits it from the party.
A party can be worked by more than one person over time. Routes get reassigned, a rep leaves, a big account moves to the owner's nephew. Now a party is billed by one man and collected by another. Attribute outstanding by whoever owns the party today and the new man inherits a bucket he did not build. Attribute by who billed it and the man who has left owns money nobody is chasing. Both rules are defensible, and a distributor who has never chosen between them is running a report where both are quietly in use at once.
The workable answer is to attribute the outstanding to the party's current owner and keep the billing attribution visible next to it, so a handover reads as a handover instead of as a collapse in one man's performance.
What the Board Has to Show to Be Actionable
A view showing only a total collected figure per salesman is a scoreboard, and a scoreboard does not tell anyone what to do on Tuesday. These are the columns that earn their place.
| Column | Why it earns its place |
|---|---|
| Total outstanding on his parties | The size of the book he carries, so his collection figure has a denominator |
| Split by ageing bucket | 0–30, 31–60, 61–90, 90+. The shape of the book matters more than the total |
| Collected during the period | The flow. What actually reached the bank from his accounts |
| Parties that crossed terms this month | New deterioration, caught in the month it happened |
| Oldest open bill, with the party name | The one line that ends an argument about whether things are under control |
The ageing split is the column owners underrate. Two salesmen can carry ₹18 lakh each and be in very different trouble, one with almost everything inside 30 days and the other with ₹7 lakh past 90. The ageing report already computes those buckets from your bills; the missing step is grouping them by rep rather than only by party, and reading each rep beside the party-wise outstanding statement for the accounts he has to visit.
The crossed-terms column turns the board from a review tool into an early warning. A party that slipped from 28 days to 34 days is a phone call. The same party at 95 days is a recovery problem with a lawyer attached.
Order Basis or Invoice Basis, and Who Looks Good
The same team, read two ways, produces two different rankings, and the choice quietly decides who gets praised.
An order-basis board credits a salesman when the order is booked. An invoice-basis board credits him when the invoice is raised. The two diverge wherever an order never became an invoice: stock was short, the party was over its limit, the dispatch went partial, the order was cancelled after the fact.
Order basis measures the rep's effort in the market and rewards the man who books heavily. Invoice basis measures what the business shipped and billed, which the warehouse and the credit desk influence as much as the salesman does. On the collection side the choice is less debatable, because only an invoice creates a receivable. Nobody can collect against an order.
Most distributors read effort on an order basis, read the money on an invoice basis, and look hard at any rep where the gap is wide. An order book that is not converting usually means he is booking against stock that does not exist, or his parties are hitting their credit limits and orders are being held. Neither shows up on a single-basis board.
Commission on Billing Versus Commission on Realisation
This is where the subject stops being a reporting question and becomes a money question.
If the incentive is paid on billing, the salesman's job is complete when the goods leave the godown. He has no economic reason to be uncomfortable about a party at 75 days, and a rational rep keeps pushing volume into a slow-paying account because the volume is what pays him. Run that for three years and you get exactly what it was designed to produce: a strong sales chart, a fat debtors figure, and a growing overdraft while everybody insists the business is doing well.
Linking the incentive to realisation changes the last mile, and the structures are simple. Pay on collected value rather than billed value. Or pay on billing but hold a portion until the bill is settled. Or claw back past a stated ageing threshold, so the rep carries a share of the cost of his own soft accounts.
Any of these needs a per-salesman collection number the team cannot dispute, which is the entire point of getting attribution right first. Once the number holds up, it also gives the owner a real handle on days sales outstanding, because DSO stops being a company-level statistic and becomes something four people are each individually responsible for.
The Monday Conversation When the Number Exists
The difference this makes is a short conversation.
Without the number, a Monday meeting sounds like collection thoda theek karo, sab log dhyan do. Everyone nods. Nothing changes, because nothing specific was asked of anyone.
With the number, the owner opens the board and says: your 90-plus moved from ₹4 lakh to ₹6.2 lakh in July, three of your parties crossed terms last month, and the oldest open bill on your route is 140 days. What is the plan on those three this week. The rep answers about three specific parties, the owner writes down what was promised, and the same board next Monday says whether it happened.
The number also does the confronting, which matters in a family-run business where the salesman has been with the firm eleven years and is somebody's cousin. The board states what is on his route, nobody has to accuse anybody of not working, and the talk moves straight to what to do.
Reading Collection Accountability Off Your Tally Data
Takkada reads your Tally data and puts the team boards on the phone, and the salesman-wise view can be read on an order basis or an invoice basis, so effort and billed reality sit side by side instead of an argument about which one the report used. The outstanding, the ageing buckets and the receipts all come from the same synced Tally books the office is working in.
Team access controls decide what each member sees. A salesman can be limited to his own parties, ledgers and screens, which is what makes it safe to put the board in the field team's hands at all. He sees his book, his ageing, and what is overdue on his route, and not what the other reps are carrying.
The reps also collect on the same phone. A payment link goes to the party, who sees each open bill with its due status and pays by UPI at 0% MDR, and the receipt writes back into Tally against those specific bills rather than sitting on account. That keeps the board honest, because only a receipt allocated bill by bill lets the ageing recompute correctly next month. Reps using the field order and collection tools produce attributed data as a by-product of the normal job.
Takkada is a Tally-integrated receivables and auto-reconciliation app for Indian distributors, with 0% MDR UPI collection and WhatsApp dispatch.
Frequently Asked Questions
Q: How do I track collection by salesman in Tally?
A: Tally has no salesman field on a receipt, so the attribution has to come through the party. Set each salesman as a cost centre or carry the rep on the party master, then read outstanding and receipts grouped by that rep. The discipline that makes it work is allocating every receipt bill by bill at entry, because an on-account receipt cannot be tied to a specific overdue invoice later.
Q: Should a salesman be judged on sales or on collection?
A: On both, read side by side. Sales alone rewards a rep for loading a slow-paying party, because the volume is what pays him. Collection alone punishes a man who has just inherited an old route. His billing read next to his ageing buckets and what he recovered in the period shows the whole job.
Q: What is the difference between an order basis and an invoice basis view?
A: An order basis credits the salesman when he books the order; an invoice basis credits him when the invoice is raised. They diverge on cancelled orders, partial dispatches, and orders held for stock or credit limits. Order basis measures market effort. Invoice basis is the right one for collection, because only an invoice creates a receivable.
Q: Salesman ke through bakaya kaise vasool kare?
A: Give each rep his own list rather than a company-wide statement. He needs to see only his parties, split by ageing, with this month's crossed-terms accounts marked, and a way to take the payment on the spot. A UPI payment link showing the retailer his own open bills closes an account in the shop instead of producing another promise for next week.
Q: Should I pay commission on billing or on collection?
A: Paying on billing ends the salesman's responsibility at the delivery, and over a few years that produces a strong sales chart with a weak bank balance. Most distributors move to paying on collected value, holding a portion until the bill is settled, or clawing back past a stated ageing threshold. Each of these needs a collection figure per rep that the team cannot dispute, so fix the attribution first.
Q: How do I attribute a party that changed salesmen mid-year?
A: Decide the rule once and apply it everywhere. The usual choice is to attribute outstanding to the rep who owns the party today, keeping the billing attribution visible alongside, so a route handover reads as a handover instead of as one man's numbers collapsing. Disputes come from having no stated rule, because then both conventions end up in use in different reports.
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.