Team
Salesman daily report: what it should show, with a simple format
The ten lines an owner needs from every salesman every evening, a format you can copy into a notebook or Excel, and how to check it in five minutes.
4 October 2026 · 6 min read
Short answer
A good daily report has ten lines: shops planned, shops visited, bills, sales, cash, UPI, credit given, old dues collected, and returns, and the stock left on the van. Build it from the day’s bills, not from memory at night. Then the owner can check it in five minutes.
Most salesman reports say one thing: “Sales today: ₹48,000.” That number cannot tell you if he visited his shops, how much of it was credit, or why he handed over ₹31,000 in cash. A report like that makes you ask more questions on the phone, which is exactly what a report is meant to stop.
The format
Copy this into a notebook, a printed sheet or one row of a spreadsheet. One report per salesman per day.
Salesman: ________ Date: ________ Beat: ________
- Shops planned: how many shops are on today’s beat.
- Shops visited: how many he actually went to, and the names of any he missed.
- Bills made: how many shops bought something.
- Total sales: the total of today’s bills.
- Cash collected: cash only.
- UPI collected: on its own line, never added to cash.
- Credit given today: the part of today’s bills not paid.
- Old dues collected: money taken for earlier bills, with the shop names.
- Returns and damage: what came back, from which shop, and why.
- Stock on the van at the end: what is left to unload.
What each line tells you
- Planned vs visited shows whether the beat was covered. Missed shops are where competitors walk in.
- Bills vs visited shows how many visits turned into orders. A visit without a bill is worth asking about, kindly.
- Cash and UPI are what he should hand over. Keeping them apart stops the most common mix-up at the end of the day.
- Credit given vs old dues collected shows whether the money shops owe you is growing or shrinking on his beat.
- Returns that keep coming from the same shop point to a stock, price or relationship problem.
How to read it in five minutes
- Visited less than planned? Ask which shops were missed, and why.
- Count the cash he hands over. It should equal the cash line, minus any expenses you agreed in advance.
- Credit given higher than dues collected, day after day? Look at that beat’s credit.
- Returns higher than usual? Ask what came back and from where.
If all four look normal, you are done. Save your questions for the days when something stands out. Our guide on salesman cash shortage covers what to do when the cash does not match.
Look at the week, not only the day
One bad day means very little. Once a week, put each salesman’s days side by side. Sales slowly falling, missed shops creeping up, or credit growing on one beat are the trends worth a conversation. Use the same report for every salesman, so the comparison is fair.
Make it easy to fill in honestly
A report that takes an hour to write at night will be guessed. The most accurate report is the one built from the bills and receipts he made during the day, shop by shop. That also protects an honest salesman: his numbers are on paper, not just his word. For checking work without making your team feel watched, see how to check your salesmen’s work.
How Mulberry Sales helps
Every bill records the shop and the time it was made on the salesman’s phone, so the report is built from what happened at each shop instead of being written up at night. His day starts and ends with a clock-in and clock-out (Starter plan and up). End Day shows the cash to hand over with UPI kept separate, plus the day’s profit at cost. Reports break sales down by salesman for any dates, so the weekly side-by-side view takes one click (Growth plan and up). See van sales software.
Questions people ask
What should a salesman's daily sales report include?
Shops planned and shops visited, number of bills, total sales, cash collected, UPI collected, credit given, old dues collected, returns and damage, and stock left on the van. Cash and UPI should always be separate lines.
How do I check a salesman's daily report quickly?
Check four things: did he visit the shops he was meant to, does the cash he hands over match the cash on the report, is credit given growing faster than old dues collected, and are returns unusually high. That takes about five minutes.
Should the report be written at night?
No. A report written from memory at night is a guess. It is far more accurate when it is built from the bills and receipts made during the day, at each shop.
Found this problem in your business?
Don't estimate it. Run one van on Mulberry Sales for 14 days with your own shops, products and salesman, and measure it. One price covers your whole business, not each salesman.
Read next
Team
How to check your salesmen's work without spying on them
Five numbers that show whether a salesman is really working his route, what they cannot tell you, and how to talk about them so good men stay.
Money
Salesman cash shortage: how to stop money going missing between the shop and the office
Why the cash a salesman hands over is often less than he collected, the honest mistakes and the other kind, and a daily routine that ties every rupee to a bill.