Free Excel download - for field teams
Daily sales report format that shows where the day went
A daily sales report usually lists visits, orders and collection. This day close card adds the part that explains them: how the day was spent. Enter the numbers and it calculates strike rate, selling time, travel cost per visit and sales per selling hour, then checks that the minutes add up to the working day.
Excel workbook with a printable day card and a month log. No signup, no watermark.
Download
Day close card and month log
Day close card (Excel)
Three sheets: Settings (day length, rate per km, selling time target), Day card (one printable A4 page for the day) and Month log (one row a day with the same ratios and a month roll-up that also names your best day).
Best for: field sales reps and the managers who read their reports.
Download .xlsxTry it first
Close a day here, then take the sheet
Where the day went
- Travel 30%
- Waiting 7%
- With customers 39%
- Admin 11%
- Other 13%
The day is accounted for.
- Plan adherence
- 80%
- Strike rate (orders per visit)
- 38%
- Average order value
- Rs 14,167
- Selling time (share of day)
- 39%
- Travel and waiting (share of day)
- 37%
- Travel cost today
- Rs 384
- Travel cost per visit
- Rs 48
- Sales per selling hour
- Rs 12,143
The numbers above are a sample day. Replace them with yours. The workbook does the same arithmetic and keeps a row for every day of the month.
The numbers
Seven numbers the card calculates, and how to read them
Plan adherence
Visits done / visits plannedLow means customers were skipped. The useful question is which ones.
Strike rate
Orders / visits doneMany visits and few orders points at who is being visited, not at effort.
Average order value
Order value / ordersCompare a rep with their own last week, not with another territory.
Selling time
Minutes with customers / day lengthThe share of the day spent in front of buyers. Set your own target in Settings and watch the trend.
Travel and waiting
(Travel + waiting minutes) / day lengthWhen this is more than half the day, look at the route before the rep.
Travel cost per visit
Km x rate per km / visits doneFalls when visits are clustered by area.
Sales per selling hour
Order value / hours with customersSeparates a rep who sells well in little time from one who is busy for long.
Why reports go wrong
Three ways a daily sales report stops being useful
It reports results with no cause
A low order value on a day with six hours of travel is a routing problem. The same number on a day with six hours with customers is a selling problem. Only the time split tells them apart.
It is written by the person who reads it
When a manager fills the sheet from a phone call, it records the call. Keep the rep as the author and the manager as the reviewer.
It is compared across people, not across days
Territories differ. A rep's own trend over the month in the log says more than a league table of totals.
Beyond Excel
When the report writes itself
Kilometres, time at each customer and visit count already exist if the day is recorded on the phone. Zeba's field sales tracking and site visit management capture them, so the report starts from recorded numbers. The salesman tracking app page shows how kilometres are filtered, and the site visit report card covers what to write after each visit. Zeba does not take orders, so order value is still typed or imported from your sales tool.
Got questions?
Daily sales report: FAQs
What to include, who fills it in and how to read it.
- Visits planned and done, orders and their value, collection, kilometres, and how the day was spent. Numbers alone hide the cause. Adding where the day went (travel, waiting, with customers, admin) shows why a good plan still produced a weak day.
- This one calculates. Enter the day's numbers and it returns plan adherence, strike rate, average order value, selling time, travel cost per visit and sales per selling hour, with a check that the minutes add up to the working day.
- The rep, in the last ten minutes of the day. The manager reads the month log. If the manager types the numbers, the report becomes a record of what the manager heard, not of what happened.
- A rating is an opinion. Minutes can be compared across days and reps. If you do not track exact times, estimates in five minute steps are fine, and the check against day length stops them drifting.
- Yes. Day length, rate per km, and the selling time target are in the Settings sheet. Change them and every message on the day card and month log updates.
- Each rep keeps their own copy. For a team, collect the month log sheets and compare the ratios, not the totals. Teams beyond about ten people usually move to an app so nobody retypes the numbers.
More free tools
More free HR and payroll tools
Related to field teams, and the rest of the toolkit.
- Site visit report formatA one page report card with a promises ledger.
- Beat plan builderClasses, weekdays and how many reps the beat needs.
- Salary slip generatorPDF and Excel payslips with PF, ESI, PT and LOP.
- Attendance sheet format in ExcelMonthly register that calculates LOP and paid days.
- Offer letter formatOffer letter with a CTC annexure that adds up.
Stop retyping the day. Zeba records visits, time at each customer and kilometres on the phone, so the report starts from facts.