Tools / Planning & Capacity
Free tool · Planning & Capacity

Daily Sales Report (DSR) Generator

The daily sales report is the least glamorous document in the restaurant and the one that catches the most problems: till shortages, discount abuse, the slow drift of average check. Enter the day's numbers by payment mode and the drawer counts, and this generator produces the full DSR, net sales, average check, expected-vs-actual cash with variance, ready to copy, sign and file.

Planning & Capacity — Daily Sales Report (DSR) Generator
In short

A restaurant DSR reconciles two things nightly: sales (cash + card + UPI + aggregator, minus discounts and comps = net sales) and the cash drawer (opening float + cash sales − petty expenses − deposits = expected cash, compared against the actual count). The variance line is the whole point.

Expected cash = opening float + cash sales − petty expenses − cash removed. Variance = actual counted − expected. A tallied drawer is within ₹100; anything beyond that gets a same-night explanation in writing.

Sales

Deductions

Cash drawer

Gross sales
₹0.00
Net sales
₹0.00
Expected cash in drawer
₹0.00
Cash variance
₹0.00

A variance beyond ₹100 either way deserves a same-night explanation, small shortages that go unexplained daily are how tills leak. File the signed sheet; a month of DSRs is your fastest fraud and trend detector.

How to use the Daily Sales Report (DSR) Generator

  1. Enter the day's sales by payment mode, plus discounts and comps.
  2. Enter the drawer numbers: opening float, petty expenses, deposits, actual count.
  3. Copy the assembled DSR, get it signed by the closer and verifier, and file it.

Frequently asked questions

Why split sales by payment mode every day?

Because each mode reconciles against a different source: cash against the drawer, cards against the settlement report, UPI against the QR provider, aggregators against their weekly payout. Mode-wise DSRs make every mismatch traceable to a single channel instead of a vague "sales look low".

What does a recurring small cash shortage usually mean?

Three usual suspects, in order of frequency: unrecorded petty expenses (someone paid the gas vendor from the till and forgot), billing voids handled sloppily, and skimming. Daily variance lines with signatures make all three visible within a week, which is precisely why some tills never get a DSR habit.

Who should sign the DSR?

Two people, always: whoever closed the till prepares and signs, and a manager or owner verifies and countersigns, ideally after independently recounting the cash. A self-verified DSR is a diary entry, not a control.

More Planning & Capacity tools

Want this run for you? Book a free auditExplore the platform →