A daily sales report, or DSR, is the single most useful document a field sales team produces, and the one most often skipped. The format below works for FMCG and distribution reps, B2B sales teams and anyone who visits customers in person.
The columns a DSR needs
Keep it to what a manager will actually filter on. Every extra column is one more thing a rep has to type at 9 PM.
| Column | Why it matters | Example |
|---|---|---|
| Date | Lets you compare days and spot gaps. | 29-09-2026 |
| Sales rep | Who made the visit. Essential once you have more than two people. | Ganesh Pawar |
| Route / area | Shows whether beats are being covered. | Route 4 |
| Customer | The shop, dealer or company visited. Use the same spelling every time. | Shiv Traders |
| Visit type | New, repeat, follow-up or collection only. | Repeat |
| Outcome | Order, no order, not available. The column managers look at first. | Order |
| Products and quantity | What was ordered and how much. | Atta 10kg × 24 |
| Order value | Adds up to daily and monthly sales. | ₹12,500 |
| Collection and payment mode | Cash in hand versus credit outstanding. | ₹12,500 · UPI |
| Next step and date | Turns the report into a follow-up list. | Deliver Thursday |
A filled-in example
Here is one rep's afternoon as it should appear in the sheet: one row per visit, even the visit that went nowhere.
| Customer | Outcome | Qty | Order | Collected | Next step |
|---|---|---|---|---|---|
| Shiv Traders | Order | 24 | ₹12,500 | ₹12,500 UPI | Deliver Thursday |
| Om Distributors | Order | 12 | ₹5,400 | ₹0 (credit) | Collect on 2 Oct |
| Bharat Agencies | Not available | 0 | ₹0 | ₹0 | Call owner first |
The "not available" row matters as much as the orders. Without it you cannot tell a rep who visited ten shops and sold at three from one who visited three.
Five rules that keep a DSR useful
- One row per visit, not per day. Summaries hide the detail you will want in a month.
- Fixed choices where possible. "Order / No order / Not available" can be filtered; free text cannot. The template uses dropdowns for this.
- Same customer spelling every time. "Shiv Traders", "Shiv Trader" and "Shiv Tdrs" are three customers to a pivot table.
- Record collections separately from orders. An order on credit and cash received are different things for your cash flow.
- Always a next step. A visit with no next step is a visit that gets forgotten.
The real problem: getting it filled in
Most DSR formats are fine. The problem is that a rep who has been on the road since 9 AM does not want to type fourteen columns on a phone at night, so the report arrives late, arrives as a paragraph in a WhatsApp group, or does not arrive at all.
The fix is to capture each visit when it happens, in the fewest possible taps. That is what vBol does: the rep sends a short WhatsApp voice note as they walk out of the shop, in Marathi, Hindi, Tamil or whatever language they speak:
vBol reads it back for a one-tap confirmation and writes the row, with customer, quantity, payment and GPS location, into your Google Sheet or Excel file. At 7 PM you get one WhatsApp message listing what was filed and who sent nothing today. It is free for 30 days, then ₹199 per user per month.
Prefer to stay on a spreadsheet? Download the free template on this page. It has the columns above, dropdowns for visit type, outcome and payment mode, and example rows you can overwrite.
Frequently asked questions
What is a DSR in sales?
DSR stands for daily sales report: one row per customer visit or call, sent by each salesperson at the end of the day, recording who they met, what was ordered, how much was collected and what happens next.
What should a daily sales report include?
At minimum the date, salesperson, customer, visit outcome, order quantity and value, payment collected, and the next step with a date. Add route, visit type and payment mode if you manage collections or beats.
Should a DSR be one row per visit or one row per day?
One row per visit. A single summary row per day hides which customers were visited and makes it impossible to filter by customer, product or outcome later.
How do I get sales reps to send the DSR every day?
Make it faster than not doing it. Reps skip reports that take ten minutes of typing at night. A two-line voice note after each visit, confirmed with one tap, gets sent; a spreadsheet form usually does not. A daily list of who did not report also helps.