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.

Expenses paid from the drawer
₹
₹
₹

Count the drawer before you close.

Example numbers are filled in so you can see the report. · Your entries stay in this browser only.

Get this report without typing it every night
DineOpen builds the daily report from every bill, split by cash, UPI, card and apps, and sends it to the owner on WhatsApp. 7-day free trial.
Start 7-day free trial →

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?

SectionWhat to write
Sales by payment modeCash, UPI, card, Swiggy, Zomato and credit (udhaar), with the total.
BillsNumber of bills, average bill, discounts and cancelled bills.
Cash drawerOpening cash, cash sales, expenses paid from the drawer, cash taken out, expected and counted cash.
ExpensesEach payment from the drawer with what it was for.
Sign-offWho prepared it, and any note for the owner.

How the cash check works

Expected cash = Opening cash + Cash sales − Paid from drawer − Cash taken out

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.

Explore DineOpen

Products
DineOpen POSDineOpen MenuDineOpen OrdersDineOpen LoyaltyDineOpen HotelDineOpen KitchenDineOpen AIDineOpen InventoryDineOpen TablesDineOpen BillingDineOpen Admin
POS by Industry
RestaurantsCafesCloud KitchensBars & PubsBakeriesHotelsFood TrucksQSRFine DiningSweet ShopsDhabasCateringIce Cream ParlorsJuice Bars
POS by Location
MumbaiDelhiBangalorePuneHyderabadChennaiKolkataAhmedabadJaipurUSAUKUAE
Popular Guides
Ice Cream Shop POS GuidePetpooja Review 2026Restaurant Billing App GuidePOS vs Billing SoftwareHow to Open Restaurant in IndiaRestaurant Technology Trends 2026Best Restaurant POS IndiaRestaurant POS Software India
हिंदी गाइड (Hindi Guides)
रेस्टोरेंट बिलिंग सॉफ्टवेयर गाइडरेस्टोरेंट कैसे खोलें 2026POS सिस्टम क्या है?फूड कॉस्ट कम करेंQR मेनू कैसे बनाएं (Free)
View Pricing →