Daily Sales Report Format for Restaurant Managers (Free Template)

Essential daily sales report fields

Every restaurant manager should close the day with a 10-field report. Takes 15 minutes and prevents cash leakage, missed trends, and GST errors.

Use a Google Sheet template — no expensive software needed.

• 1. Date and day of week
• 2. Gross sales (before tax)
• 3. Net sales (after tax and discounts)
• 4. Payment split: cash / UPI / card / aggregator
• 5. Total covers (dine-in + delivery)
• 6. Average bill value
• 7. Voids and refunds (count + value)
• 8. Top 5 selling items
• 9. Cash drawer variance (expected vs actual)
• 10. Manager notes (events, complaints, staff issues)

Cash reconciliation every night

Count cash drawer at close. Compare to POS cash sales report. Variance under ₹100 is acceptable; above ₹500 needs investigation.

Common causes: unrecorded cash sales, wrong change given, staff pocketing. Daily reconciliation catches problems early.

• Count cash by denomination — use a count sheet
• Match to POS "cash sales" line — not total sales
• Log variance with explanation (or "unexplained")
• Investigate any variance above ₹500 same day
• Two-person count for accountability

Weekly and monthly roll-ups

Daily reports feed weekly summaries. Track: week-over-week sales trend, best/worst days, and payment mix shift (are more customers paying via UPI?).

Monthly: compare to same month last year, calculate food cost %, and labour cost %.

• Weekly: total sales, avg daily sales, best day, worst day
• Monthly: sales vs last month, vs same month last year
• Track payment mix trend — UPI growing means lower MDR costs
• Flag any day with sales 20%+ below average for investigation

Using sales data to improve operations

Daily reports reveal patterns: Tuesday lunch is slow (run a promotion), Saturday dinner exceeds capacity (add staff), biryani outsells everything (ensure stock).

Share daily top-sellers with kitchen so prep matches demand.

• Slow day promotion: Tuesday/Wednesday 15% off via QR menu banner
• Staff scheduling based on cover patterns from daily reports
• Prep quantities aligned to top-selling items
• Update DineCard menu badges ("Bestseller") based on data

Free template and digital integration

Download a free Google Sheet template or create one with the 10 fields above. Enter data nightly — 15 minutes well spent.

DineCard QR menu analytics (coming soon) will complement daily sales data with menu view patterns.

• Google Sheet: share with owner for remote visibility
• Enter data by 11 PM every night — non-negotiable habit
• Photo of cash count sheet attached to daily report
• Cross-reference with Swiggy/Zomato payout reports weekly

Frequently Asked Questions