Restaurant Daily Sales & Cash Register (Excel)
One row per day for the whole month. Type the day's takings under Cash, UPI, Card, Swiggy, Zomato and Other, the cash you paid out of the counter and the cash you banked. The register adds up the day, works out the average bill, tells you how much cash should be in the drawer, and shows the shortage or excess once you type the counted cash. The Month Summary splits sales by payment mode, estimates aggregator commission and the money still to arrive in the bank.
Free · no sign-up · opens in Microsoft Excel, Google Sheets, LibreOffice and WPS Office. Files contain no macros.
Preview
Real view of the file with its sample data (yellow cells are where you type).
| Date | Day | Bills | Opening cash | Cash | UPI | Card | Swiggy | Zomato | Other | Total sales | Average bill | Cash paid out | Cash deposited / handed over | Expected cash in drawer | Counted cash | Short (−) / Excess (+) |
| 01-11-2026 | Sun | 64 | ₹ 2,000 | ₹ 16,200 | ₹ 22,900 | ₹ 10,400 | ₹ 11,900 | ₹ 11,100 | ₹ 0 | ₹ 72,500 | ₹ 1,133 | ₹ 1,750 | ₹ 13,500 | ₹ 2,950 | ₹ 2,950 | 0 |
| 02-11-2026 | Mon | 38 | ₹ 2,950 | ₹ 8,200 | ₹ 12,600 | ₹ 5,100 | ₹ 6,800 | ₹ 6,250 | ₹ 0 | ₹ 38,950 | ₹ 1,025 | ₹ 900 | ₹ 6,000 | ₹ 4,250 | ₹ 4,250 | 0 |
| 03-11-2026 | Tue | 35 | ₹ 4,250 | ₹ 7,400 | ₹ 11,900 | ₹ 4,800 | ₹ 5,600 | ₹ 5,100 | ₹ 1,200 | ₹ 36,000 | ₹ 1,029 | ₹ 650 | ₹ 6,500 | ₹ 4,500 | ₹ 4,500 | 0 |
| 04-11-2026 | Wed | 40 | ₹ 4,500 | ₹ 9,100 | ₹ 13,850 | ₹ 5,900 | ₹ 6,900 | ₹ 6,400 | ₹ 0 | ₹ 42,150 | ₹ 1,054 | ₹ 1,200 | ₹ 7,500 | ₹ 4,900 | ₹ 4,920 | 20 |
| 05-11-2026 | Thu | 44 | ₹ 4,920 | ₹ 9,900 | ₹ 14,700 | ₹ 6,300 | ₹ 7,400 | ₹ 6,900 | ₹ 0 | ₹ 45,200 | ₹ 1,027 | ₹ 1,100 | ₹ 8,000 | ₹ 5,720 | ₹ 5,720 | 0 |
| 06-11-2026 | Fri | 62 | ₹ 5,720 | ₹ 15,600 | ₹ 21,400 | ₹ 9,800 | ₹ 11,200 | ₹ 10,400 | ₹ 0 | ₹ 68,400 | ₹ 1,103 | ₹ 2,300 | ₹ 12,000 | ₹ 7,020 | ₹ 6,970 | -50 |
What's inside
- Settings: restaurant name, month, opening cash float and a payment-mode table with an editable commission percent for Swiggy, Zomato, card or any other mode
- Daily Sales sheet: dates of the month fill in by themselves; number of bills, sales by six payment modes, total, average bill value
- Cash drawer check for every day: opening cash, cash paid out, cash deposited, expected cash, counted cash and short / excess (red when short)
- Month Summary: sales and share by payment mode, estimated commission plus GST on commission, net amount to be received, best day, average daily sales and total cash difference
- A bar chart of sales by payment mode for your monthly review
How to use it
- Open the Settings sheet. Type your restaurant name, the first day of the month (for example 01-11-2026) and the cash float you keep in the drawer at opening.
- In the payment-mode table, type the commission percent you pay on Swiggy and Zomato orders (and card charges if you want them counted). Leave Cash and UPI at 0.
- Every night, on the Daily Sales sheet, type the number of bills and the sales in each payment mode from your billing software or KOT book.
- Type cash paid out of the counter (vegetables, gas, staff advance) and cash you deposited in the bank or handed to the owner.
- Count the drawer and type the counted cash. Short / Excess shows the difference; investigate anything in red the same night.
- At month end, open the Month Summary for totals by mode and the commission estimate, then start a fresh copy for the next month.
Tips
- Use the sales figure after discount and before GST if you want the register to match your GST returns; use the figure including GST if you want it to match the money received. Pick one and stick to it.
- Aggregator payouts deduct commission, payment gateway fees, GST on those charges, TCS and TDS, and sometimes ad spend; the estimate here covers commission and GST on it only. Match each weekly payout with the statement from Swiggy or Zomato.
- Each day starts from the cash you counted the night before, so a shortage shows only on the day it happened instead of hiding in later days.
- Average bill value (sales ÷ bills) is one of the best numbers to watch: a combo or an add-on suggestion moves it more than a new dish.
Questions and answers
Where does each day's opening cash come from?
The first day uses the float on the Settings sheet. After that, each day starts with the cash you counted the night before; if you left the counted cell empty, it starts with the expected cash instead.
How is Swiggy or Zomato commission worked out?
Sales in that mode multiplied by the commission percent you typed, plus GST on the commission (18 percent by default, editable). Real payouts also deduct gateway fees, TCS, TDS and promotions, so treat this as an estimate.
Can I add another payment mode like Paytm or a food-court card?
Rename the "Other" mode on the Settings sheet; the column heading and the summary follow the new name.
Does it work for a cloud kitchen with no dine-in?
Yes. Leave Cash and Card empty if you do not use them; the Swiggy, Zomato and Other columns and the commission summary are what matter for a delivery-only kitchen.