Book a demo

Restaurant day end report format, with a filled sample.

A day end report closes the day in one page: what you sold, how guests paid, how much cash should be in the drawer and what went out. Here is the format, a worked example that adds up, and a closing checklist for the counter.

What goes in a day end report

  1. Header: shop name, date, who closed the counter and the first and last bill numbers.
  2. Sales by channel: dine-in, counter or takeaway, and delivery or online, with discounts and GST.
  3. Payment modes: cash, UPI, card and credit sales. These must add up to the total billed.
  4. Cash tally: the cash that should be in the drawer, the cash you counted, and the difference.
  5. Expenses and payments made from the counter during the day.
  6. Bills: how many, the average bill, and any cancelled bills with the reason.
  7. Sign-off by whoever counted the cash.

Sample day end report

A café with dine-in, counter and online orders, closing on one day. All figures are in rupees and every section adds up.

1. Sales by channel

ChannelSales
Dine-in18,700
Counter / takeaway9,800
Delivery / online4,100
Gross sales32,600
Less discounts−600
Taxable value32,000
CGST 2.5%800
SGST 2.5%800
Total billed33,600

2. Payment modes

ModeAmount
Cash12,350
UPI15,250
Card4,800
Credit sales (to collect later)1,200
Total, must equal total billed33,600

3. Cash tally

ItemAmount
Opening cash (float)2,000
+ Cash sales12,350
+ Cash received from credit customers500
− Expenses paid in cash−1,450
− Supplier paid in cash (milk)−3,000
Expected cash in drawer10,400
Cash counted10,380
Difference (short)−20

4. Expenses paid from the counter

ExpenseAmount
Vegetables600
Delivery fuel600
Cleaning supplies250
Total1,450

5. Bills

Bill numbers4012 – 4223
Bills issued212
Average bill158
Cancelled bills2 (wrong table, duplicate)

GST here is 5% (CGST 2.5% + SGST 2.5%), the usual rate for a standalone restaurant or café in India. Check the rate that applies to your business with your accountant. GST rates on restaurant bills.

How to tally the cash

Use one formula every day:

Expected cash = opening cash + cash sales + cash collected from credit customers − cash paid out for expenses and suppliers

Count the drawer, write the counted amount next to the expected amount, and record the difference with a note. Small differences happen; a difference that keeps growing, or keeps going one way, needs looking into.

Closing checklist for the counter

  1. Settle every open table and order, so no running bill is left out of the day's sales.
  2. Enter every expense and supplier payment made from the drawer, with the receipt.
  3. Match UPI and card totals with the UPI app and the card machine's settlement slip.
  4. Count the cash and compare it with the expected cash.
  5. Write a reason for each cancelled bill and any cash difference.
  6. Keep tomorrow's float aside, and record the rest as deposited or handed over.
  7. Sign the report and keep it with the day's receipts.

Mistakes that make the day end not add up

  • UPI counted as cash because the bill was marked “cash” when the guest paid by UPI.
  • Credit sales left out, so payment modes come to less than the total billed.
  • The opening float mixed into sales, so cash looks higher than it was.
  • Expenses paid from the drawer but not entered, so the drawer looks short.
  • Cancelled bills with no reason, which hides mistakes and misuse alike.

How EntryPost makes the day end report

You don't fill this in by hand. When you close the day in EntryPost, you get sales by channel, cash in hand and expenses on one report. Each bill records how it was paid, whether cash, UPI, card or split across all three, and credit sales are tracked to the customer, so the payment modes add up to the total billed.

Each bill, purchase and expense also posts its own journal entry, so the day book, cash book and item-wise sales are ready behind the report, along with staff sales reports. It all runs on your counter PC, so the day closes even when the internet is down. How the accounting works.

Questions people ask

What should a restaurant day end report include?

Sales by channel with discounts and GST, totals by payment mode (cash, UPI, card and credit), a cash tally of expected against counted cash, expenses paid from the counter, the number of bills with any cancellations, and a sign-off.

How do I calculate expected cash at day end?

Opening cash, plus cash sales, plus cash collected from credit customers, minus cash paid out for expenses and suppliers. Compare it with the cash you count and record the difference.

What is the difference between a day end report and a day book?

The day book lists every transaction of the day, one by one. The day end report is the one-page summary of those transactions used to close the counter.

Should UPI payments be counted in cash in hand?

No. UPI goes to your bank account, so it is a separate payment mode. Only notes and coins in the drawer count as cash in hand.

See EntryPost running on your own menu.

We set it up on your counter PC, connect your printers and waiter phones, and train your staff on the first day. On site in Malappuram district, remotely anywhere else in India.

Objective IT Solutions objectivetec.in
+91 97454 47744 · WhatsApp