Cash denomination calculator and daily cash tally
Updated · free, no login
Count your drawer by notes and coins: type how many ₹500, ₹200, ₹100, ₹50, ₹20 and ₹10 notes and coins you have and get the total and the amount in words. Then tally it: opening cash + cash sales + cash collected − expenses − cash taken out is what should be there; the calculator shows if you are short or excess, and checks UPI and card too.
FreeNo sign-up to useWhatsApp number to download filesWorks on your phone
1. Count the cash (notes and coins)
- Notes
- ₹4,500
- Coins
- ₹200
- Total cash counted
- ₹4,700
- Pieces
- 115
In words: Rupees Four Thousand Seven Hundred Only
2. Tally: should it be this much? (galla milao)
- Expected cash in drawer
- ₹4,700
- Cash counted
- ₹4,700
- Cash: Matches
- ₹0
3. UPI and card: did all of it reach you?
- UPI: Matches
- ₹0
- Card: Matches
- ₹0
- Total sales today
- ₹10,700
Know another shop owner who needs this? It is free.
How to use it
- Count the notes and coins. Type how many ₹500, ₹200, ₹100, ₹50, ₹20 and ₹10 notes and ₹20, ₹10, ₹5, ₹2 and ₹1 coins are in the drawer. The total and the amount in words update as you type.
- Enter the day's cash movements. Opening cash, cash sales from your bills, cash collected (udhaar, advances), and cash paid out for expenses, refunds or taken out by the owner or for the bank.
- Read the result. Expected cash is what should be in the drawer. The difference shows Matches, Excess or Short, with the amount.
- Check UPI and card. Enter UPI and card sales from your bills and what actually reached you (UPI app history, card machine settlement). Any gap shows up at once.
- Print or keep a sheet. Print the tally, or download the Excel sheet with live formulas to use every evening.
Daily cash tally formula
| Line | Example |
|---|---|
| + Opening cash (morning) | ₹2,000 |
| + Cash sales (from bills) | ₹4,500 |
| + Cash collected (udhaar, advance) | ₹500 |
| − Cash expenses, refunds | ₹300 |
| − Cash taken out (owner / bank) | ₹2,000 |
| = Expected cash in drawer | ₹4,700 |
| Counted cash − expected | 0 = matches; minus = short; plus = excess |
Keep the same opening cash (float) every morning, write every cash expense on a slip, and do the count before the owner takes cash home. More on this in UPI payment reconciliation for shops, daily cash book (dukan ka hisab) and signs of cashier theft and how to stop it. For a full cash book in Excel, see the free Excel templates.
Questions
How do I calculate cash denomination?
Multiply the number of pieces of each note or coin by its value and add them up: 4 × ₹500 + 3 × ₹200 + 12 × ₹100 = ₹2,000 + ₹600 + ₹1,200 = ₹3,800. The calculator does this for every note and coin and writes the total in words for your cash book.
How do I tally the cash drawer at the end of the day?
Expected cash = opening cash + cash sales + cash collected − cash expenses − cash refunds − cash taken out. Count the drawer and compare. If the counted cash is less, the drawer is short; if more, it is excess. Note the difference in your cash book the same day.
Why is my cash short at closing?
The usual causes are a UPI payment entered as cash on the bill, change given wrongly, an expense paid from the drawer without a slip, a refund not entered, or cash taken out for home without a note. Check those five before suspecting theft.
How do I match UPI payments with sales?
Total the UPI sales on your bills for the day and compare with the credits in your UPI app or bank statement for the same day. A gap usually means a bill marked UPI that was paid in cash (or the other way round), a payment that failed, or a customer who paid to another number.
Does this calculator include ₹2,000 notes?
No. ₹2,000 notes were withdrawn from circulation in 2023 and shops rarely hold them now; RBI still exchanges them at its issue offices. The calculator covers ₹500, ₹200, ₹100, ₹50, ₹20 and ₹10 notes and ₹20, ₹10, ₹5, ₹2 and ₹1 coins.
Can I download a cash tally sheet in Excel?
Yes. The free Excel sheet has the denomination count, the expected vs counted cash check and the UPI and card check with live formulas, and opens with today's figures from this page. It asks for your name and WhatsApp number once.
Is my data saved anywhere?
No. The count and tally stay in your browser and are gone when you close the page. Only the Excel download asks for a name and number.
Related
RichBills ye apne aap karta hai: 30 din free
RichBills records cash, UPI and card on every bill, so you stop adding up bills at night. On the bigger plans, Day close counts the drawer against the day's sales for you.
30 din free, phir ₹99/month pehle 3 mahine, phir ₹199/month ya ₹1,999/saal. See pricing
Related tools (free, no sign-up)
- Which billing software fits my shop?
- Diwali offer poster maker
- Barcode generator (PNG, SVG)
- Price tag maker
- Barcode label generator
- Free Excel templates for shops
- Udhaar reminder message
- GST invoice generator
- Bill formats by shop type
- GST invoice format & templates
- Profit margin calculator
- Profit & loss calculator
- Stock reorder calculator
- Blinkit payout calculator
- Discount & offer calculator
- GSTIN checker
- HSN code & GST rate finder
- GST calculator (add or reverse GST)
- Delivery challan format (Rule 55)
- Credit note format (GST)
- Quotation and estimate format
- Proforma invoice format
- GST late fee calculator (GSTR-3B, GSTR-1)
- Section 44AD presumptive income calculator
- Shop name generator
- Shop WhatsApp message generator
- Break-even calculator
- GST on rent calculator (RCM)
Har din ka billing, stock aur udhaar ek jagah: Start RichBills free trial 30 days free, no card. All free tools