Daily Sales Report Format
Fill in today’s sales and count the drawer. You get a clean report you can download as Excel, print as a PDF, or send to the owner on WhatsApp. Works for restaurants, cafés, bakeries and shops.
Sales by payment mode
Bills
Cash drawer
Cash in the drawer when you opened.
Bank deposit or handed to the owner.
Count the drawer before you close.
Example numbers are filled in so you can see the report. · Your entries stay in this browser only.
What goes in a daily sales report
This is the format most owners settle on after a few months. It fits on one page and answers the two questions that matter at night: how much did we sell, and is the cash right?
| Section | What to write |
|---|---|
| Sales by payment mode | Cash, UPI, card, Swiggy, Zomato and credit (udhaar), with the total. |
| Bills | Number of bills, average bill, discounts and cancelled bills. |
| Cash drawer | Opening cash, cash sales, expenses paid from the drawer, cash taken out, expected and counted cash. |
| Expenses | Each payment from the drawer with what it was for. |
| Sign-off | Who prepared it, and any note for the owner. |
How the cash check works
Count the drawer and compare it with the expected cash. A difference of a few rupees on a busy day is normal. A shortage that keeps coming back on the same shift is not, and that is usually the first thing an owner notices once the report is filled every night.
Keep UPI out of the drawer count. If staff note a UPI payment as cash by mistake, the drawer looks short even though the money is in your bank.
Questions owners ask
What should a daily sales report have?
At the least: the date, number of bills, total sales, and how that money came in (cash, UPI, card, Swiggy, Zomato and credit). Add discounts and cancelled bills, because that is where money quietly goes missing. Then the cash check: opening cash, cash sales, expenses paid from the drawer, cash taken out, and what is actually in the drawer at closing.
How do I check the cash at closing?
Expected cash = opening cash + cash sales − expenses paid from the drawer − cash taken out (for a bank deposit or handed to the owner). Count the drawer and compare. If the two match, the day is clean. Write down any difference, even ₹10, with a reason if you know it.
The cash is short. What should I check first?
Most small differences come from three things: a UPI payment entered as cash, change given wrongly at a busy time, or an expense paid from the drawer that nobody wrote down. If the drawer is short by a similar amount several days in a row, look at cancelled bills and discounts for that staff member’s shift.
Should Swiggy and Zomato orders go in the daily report?
Yes, but on their own lines. That money doesn’t come into your drawer or your UPI that day. The apps pay you every week, after taking commission, GST on commission and other charges. Keeping them separate lets you match each payout later and see how much of your business depends on the apps.
Can I send this report on WhatsApp?
Yes. Press "Copy for WhatsApp" and paste it in the owner or partner group, or use "Open WhatsApp" on your phone. The text is short, so it reads well on a phone screen.
Is Excel enough, or do I need billing software?
For one counter with a few dozen bills a day, a daily sheet in Excel works fine as long as someone fills it every night. Once you have staff billing, several payment modes and app orders, it gets slow and mistakes creep in. Billing software builds this report on its own from every bill, so the only thing left to do at night is count the cash.
Guides and tools
Updated November 2026 · Nothing you type here is sent to us. The report is made in your browser.