Daily sales report: what a shop or small team should log each day

A daily sales report is the short record of what a shop, site or small team sold today. It exists for a reason that monthly reporting cannot serve: patterns at the level of days — weather, weekday, a promotion, a staff change — are invisible once figures are aggregated into months, and by the time a month closes nobody remembers what was different about the second Tuesday.

The discipline that makes it work is that it must take two minutes. A daily report that takes fifteen gets done for three weeks and then stops, and a partial series is worth much less than a complete one.

The five numbers worth logging

• Total sales for the day, net of tax, so the series is comparable to your accounts.
• Number of transactions, which is what separates a busy day from an expensive one.
• Average transaction value, calculated rather than typed — total divided by transactions.
• The split you actually manage: by channel, by category, or by till. One split only.
• Refunds and discounts given, because a strong day with heavy discounting is a different day.
• Anything unusual, in a few words: a promotion, a closure, weather, a local event, staff short. This column explains more of your variance than any of the numbers.
• Optionally, footfall or enquiries if you can capture them — it turns sales into a conversion rate, which is the number you can actually improve.

The notes column is the part people skip and the part that pays. A year of daily totals with no context tells you that some days were better; a year with three-word notes tells you which promotions worked, how much rain costs you, and what happens when your best person is off. Write the note at close, not later.

Making it a two-minute habit

1. One row per day, one sheet per year. Do not start a new file per month — the point is the long series.
2. Take the figures from one source, the same one every day, so the numbers are consistent even if imperfect.
3. Log at close, by whoever closes. Delegating to whoever is free means it happens irregularly.
4. Let formulas do average transaction value, week-to-date and month-to-date totals.
5. Add a weekday column, because comparing a Tuesday to a Tuesday is the comparison that means something.
6. Reconcile weekly against the till or bank, not daily. Daily reconciliation is where the two-minute habit becomes a twenty-minute chore.
7. Review weekly for a few minutes: same weekday last week, same week last year if you have it, and what the notes say.
8. Keep the year's sheet. The second year is where this becomes genuinely valuable.

What the series lets you see

After a few months, three things become visible that were guesses before. The shape of your week, which tells you where to put staff. The real effect of promotions, measured against the same weekday rather than against a feeling. And the size of your seasonality, which is what makes a cash-flow forecast credible instead of speculative. None of these can be reconstructed later from monthly totals — which is the whole argument for logging daily even when nothing seems to be happening.

Ettex Sheets suits the daily log: one row per day with formulas for average transaction value and running totals, conditional formatting to flag a day well below the same weekday's average, charts from any range for the weekly shape, pivots by weekday or by category, and cell comments if a figure needs explaining. Version history means a corrected day is traceable. The takings themselves are categorised in Ettex Books — a chart of accounts, categories and auto-categorisation rules, attachments on any entry — and if daily figures are submitted by staff rather than typed by the owner, Ettex Forms collects them timestamped in one inbox with export to CSV or XLS.

The boundary: Ettex does not connect to a till or payment terminal. There is no EPOS integration, no automatic import of daily takings, no footfall capture and no retail analytics. Someone types five numbers, or submits them through a form. For a single site that is the two-minute habit described above; multi-site retail wants a system that pulls the figures itself.

Why daily logs stop

• Too many fields, so it takes fifteen minutes instead of two.
• Reconciled daily rather than weekly, which turns a habit into an accounting task.
• No owner — logged by whoever is free, which means irregularly.
• A new file each month, so the series that gives the data its value never accumulates.
• Notes column left empty, discarding the explanation for most of the variance.
• Never reviewed, so nobody sees a reason to keep filling it in.
• Gross and net figures mixed between days, making the series incomparable to the accounts.

A daily sales report is five numbers and a short note, logged at close by the person who closes. Keep one row per day for a year and you will have answers you cannot get any other way.