· Orqestra Team · 8 min read

Restaurant Daily Sales Report Template (End-of-Day Sheet)

A restaurant daily sales report template: what the end-of-day sheet should contain, close-out steps, a filled-in example day and how it ties to Clover reports.

A daily sales report template is a one-page end-of-day sheet with gross and net sales, sales by daypart and category, a tender breakdown, tips, discounts, comps and voids, covers, average ticket, labor hours and labor %, the cash drawer over or short, and a notes line. The closing manager fills it in from the POS close-out report and the drawer count, and it takes about 15 minutes once the routine is set.

The sheet below is available as the daily sales report template. This article lists what each line means, the close-out steps, one full day filled in, and which Clover reports each line comes from.

What the daily sales report should contain

The report answers four questions: how much did we sell, how did people pay, what did it cost in labor, and does the cash balance. Everything on the sheet serves one of those.

SectionLineDefinition
SalesGross salesItem sales before discounts and refunds, excluding tax and tips
SalesDiscounts and compsPromotions, manager comps, employee meals
SalesRefundsMoney returned on paid orders
SalesNet salesGross − discounts − comps − refunds
SalesVoidsItems removed before payment (not in gross; tracked separately)
SalesSales tax collectedTax on net sales
SalesTipsCard tips and declared cash tips
SalesAmount collectedNet sales + tax + tips
BreakdownBy daypartNet sales for breakfast, lunch, dinner, late night
BreakdownBy categoryNet sales for food, beverage, alcohol, retail
BreakdownBy tenderCash, card, online or prepaid, gift card, other
GuestsCoversGuests served
GuestsPaid ordersNumber of checks closed
GuestsAverage ticketNet sales ÷ paid orders
LaborLabor hoursHours clocked by all staff
LaborLabor costHours × rates, plus payroll taxes if you have them
LaborLabor %Labor cost ÷ net sales × 100
CashStarting bankCash in the drawer at open
CashExpected cashStarting bank + cash sales − cash refunds − paid outs − tips paid from drawer
CashCounted cashWhat was actually in the drawer
CashOver / shortCounted − expected
NotesNotesWeather, events, call-outs, 86'd items, anything unusual

Two formulas do most of the work:

  • Average ticket = Net sales ÷ Paid orders
  • Labor % = Labor cost ÷ Net sales × 100

Tenzo's guide to end-of-day reports argues for a short list too: it names revenue vs target, labor cost as a percentage of sales, and theoretical cost of goods as core items, with sales compared to a prior period and manager feedback alongside the numbers (Tenzo). The sheet above keeps that shape and adds the drawer reconciliation, because for a small restaurant the cash count is the part that catches the most problems.

Where the numbers come from on Clover

If you run Clover, most lines come straight from the dashboard reports.

  • Gross sales, refunds and net sales are on the Sales report. Clover describes it as showing "total sales across your business, including gross sales, refunds, and net sales," and it can be filtered by daypart (Breakfast, Lunch, Dinner, or custom dayparts you configure under business hours) (Clover Help).
  • Tender breakdown comes from the Tender and card types report, which shows "a breakdown of sales by payment method, such as cash, card, digital wallet, or gift card," plus sales by card brand (same page).
  • Discounts come from the Discounts report, and the Order types report splits in-store, online and delivery, which gives you the online share.
  • Average ticket, amount collected and the expected cash deposit are on the Sales Overview Trends report. Clover defines average ticket size there as net sales divided by paid orders, and the Cash Deposit section walks from cash sales, minus cash refunds, plus cash added, minus cash removed and cash back, to cash collected, then minus tips payout to the expected deposit (Clover Help). The same page recommends using the report "during your closeout process to reconcile totals."
  • Card settlement is separate from the sales report. Clover's closeout bundles the day's card transactions into a batch and submits them for settlement, with deposits typically funded within 1 to 3 business days; your account is set up for either auto-closeout or manual closeout, which is US only (Clover Help).

The guide to reading the Clover sales report covers the gross vs net definitions in more detail. Square and Toast each have their own end-of-day reports; the line names differ, but the same sheet works once you map them.

Close-out steps

  1. Make sure every open check is closed or transferred. An open table at close-out puts tonight's sales on tomorrow's report.
  2. Enter any paper-receipt tips before the batch closes. Clover keeps the day's batch open for adjustments such as adding tips from paper receipts until the closeout event, so on auto-closeout that means before the scheduled time.
  3. Run the closeout (manual) or confirm the auto-closeout time has passed, then print or email the closeout report.
  4. Open the Sales Overview for today and copy gross sales, discounts, refunds, net sales, paid orders, tax and tips onto the sheet.
  5. Open the tender report and copy cash, card, online or prepaid, and gift card totals. Check that the tenders add up to amount collected.
  6. Open the Sales report filtered by daypart and by category and copy those lines.
  7. Pull labor hours from the time clock. Multiply by rates or let the scheduling tool give you labor cost. Compute labor %.
  8. Count the drawer. Compute expected cash, record counted cash, and write the over or short.
  9. Write the notes line: anything that explains today's numbers to someone reading this in a month.
  10. Sign it, file it, and move the daily numbers into the weekly summary.

Steps 4 through 6 are the ones a sales analytics tool automates by reading the POS; the sales analytics feature in Orqestra builds the sales half of this sheet from Clover (Square and Toast in early access) so the closing manager only types labor, the drawer count and the notes.

Worked example: one Friday

A single-location full-service restaurant, about $107,000 a month in sales, open lunch and dinner, 8.25% sales tax. Friday, October 23, 2026.

LineAmount
Gross sales$4,420.00
Discounts and comps$128.00
Refunds$0.00
Net sales$4,292.00
Voids (pre-payment)$38.00
Sales tax collected$354.09
Tips (card + declared cash)$612.00
Amount collected$5,258.09
Lunch net sales$1,480.00
Dinner net sales$2,812.00
Food net sales$3,520.00
Beverage net sales$772.00
Cash$830.00
Card$3,690.09
Online (prepaid)$738.00
Covers290
Paid orders214
Average ticket$20.06
Labor hours94.0
Labor cost$1,335.00
Labor %31.1%
Starting bank$200.00
Cash sales$830.00
Cash tips paid out$118.00
Expected cash$912.00
Counted cash$907.00
Over / short−$5.00
NotesRain from 5 pm, patio closed, 2 online orders remade (voids), one server called out

The arithmetic:

  • Net sales = $4,420.00 − $128.00 − $0.00 = $4,292.00
  • Sales tax = $4,292.00 × 8.25% = $354.09
  • Amount collected = $4,292.00 + $354.09 + $612.00 = $5,258.09
  • Tender check: $830.00 + $3,690.09 + $738.00 = $5,258.09, which matches
  • Average ticket = $4,292.00 ÷ 214 = $20.06
  • Labor % = $1,335.00 ÷ $4,292.00 × 100 = 31.1%
  • Expected cash = $200.00 + $830.00 − $118.00 = $912.00
  • Over / short = $907.00 − $912.00 = −$5.00 (short)

Reading it: a soft Friday, with dinner down because of the rain and labor % above the 30% the owner targets. The $5 short is within the tolerance most operators set, but it goes on the sheet so a pattern shows up if it repeats. The two voids were remakes, not theft, and the note says so.

Dayparts are worth a second look over time. Lunch was 34% of the day here; if that share moves, the schedule should move with it. The sales by daypart guide covers how to set dayparts and read the split.

Common mistakes

  • Using gross instead of net for ratios. Labor % and average ticket are both on net sales. Gross makes both look better than they are.
  • Forgetting voids are not in gross. A voided item never became a sale. Track voids as a count and a dollar value on their own line, not as a deduction from gross.
  • Mixing tips into sales. Tips pass through to staff. They belong in amount collected and in the cash reconciliation, never in net sales.
  • Closing the batch before tips are adjusted. The open batch is the window for adding paper-receipt tips. Once it closes, adjusting a tip is no longer a one-tap fix.
  • Skipping the tender check. If cash + card + online does not equal amount collected, something was keyed wrong, and tomorrow is too late to find it.
  • Counting the drawer without a starting bank. Expected cash is meaningless if nobody wrote down what was in the drawer at open.
  • No notes. "Net sales $4,292" with no context is a number. "Net sales $4,292, rain, patio closed" is a lesson for next October.
  • Filing it and never reading it. The daily sheet exists to feed the weekly summary. Move the numbers over on Monday or the sheet is paperwork.