| Date | Opening float | Cash sales | Paid out | To bank | Expected | Counted | Difference | Status |
|---|---|---|---|---|---|---|---|---|
| 1 Mar | 500.00 | 3,240.00 | 410.00 | 2,500.00 | 830.00 | 810.00 | -20.00 | Short |
Example row only. The file you download is empty and ready to use. Expected cash, difference and Balanced / Over / Short fill in by themselves.
- •One row per day or per shift, 31 rows on a page.
- •Type the float, cash sales, payouts and counted cash.
- •Print it blank if you prefer to fill it in by hand at the counter.
Works in Excel, Google Sheets and Numbers. No signup, no email.
Want this done for you every day, without a sheet? Ask for a quick demo for your shop on WhatsApp.
Ask for a demo on WhatsAppHow to use the daily cash closing sheet
Most shop owners already do a cash closing of some kind: a notebook page, the back of a receipt roll, a number sent on WhatsApp. The trouble is that those notes cannot be added up, compared or checked a month later. This sheet keeps the same habit but puts every day in one place, so a shortage on Tuesday is visible on Tuesday and a pattern across the month is visible too.
Each row is one day, or one shift if two people use the drawer. Enter the opening float, the cash sales for the day, the cash you paid out to suppliers or for expenses and refunds, and the cash you moved to the bank or the safe. The sheet works out the cash that should be in the drawer. Then enter what you counted, and it shows the difference and marks the day as Balanced, Over or Short.
Count only cash. Card, Apple Pay, bank transfer and delivery-app sales never reach the drawer, and adding them is the most common reason a sheet shows a shortage that is not real. Write payouts down when they happen, not at closing, because the small supplier payment made at eleven in the morning is the one everybody forgets.
At the end of the month the sheet totals cash sales, payouts, bank deposits and the net difference. If the difference is always on the same shift, you know where to look. If you would rather not type anything, print the sheet blank and fill it in by hand at the counter. And when you are ready to stop doing it yourself, Tallium AI records every sale and expense as it happens, so the expected cash is already calculated when you close.
Frequently asked questions
Stop juggling spreadsheets. Tallium AI runs invoicing, VAT & corporate tax, POS and inventory in one simple app.