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 .xlsx

Try 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 planned

    Low means customers were skipped. The useful question is which ones.

  • Strike rate

    Orders / visits done

    Many visits and few orders points at who is being visited, not at effort.

  • Average order value

    Order value / orders

    Compare a rep with their own last week, not with another territory.

  • Selling time

    Minutes with customers / day length

    The 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 length

    When this is more than half the day, look at the route before the rep.

  • Travel cost per visit

    Km x rate per km / visits done

    Falls when visits are clustered by area.

  • Sales per selling hour

    Order value / hours with customers

    Separates 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.

Stop retyping the day. Zeba records visits, time at each customer and kilometres on the phone, so the report starts from facts.