A denomination count sheet is a single page with one row for every note and coin, a count beside each, an amount per row, and four summary lines at the bottom: opening cash, expected cash, counted cash and the difference. Fill it the same way every closing and a mistake has nowhere to hide. You can draw it on a ruled notebook page or build it in Excel or Google Sheets in five minutes.
What goes on the sheet?
Three columns for the rows: the denomination, the count, and the amount (which is the denomination multiplied by the count). Then the summary lines. A made-up filled sheet shows the idea.
| Denomination | Count | Amount |
|---|---|---|
| ₹500 notes | 12 | ₹6,000 |
| ₹200 notes | 9 | ₹1,800 |
| ₹100 notes | 31 | ₹3,100 |
| ₹50 notes | 24 | ₹1,200 |
| ₹20 notes | 30 | ₹600 |
| ₹10 notes | 45 | ₹450 |
| ₹10 coins | 14 | ₹140 |
| ₹5 coins | 20 | ₹100 |
| ₹2 coins | 25 | ₹50 |
| ₹1 coins | 30 | ₹30 |
| Counted cash | 240 pieces | ₹13,470 |
Add the amounts to check: 6,000 + 1,800 + 3,100 + 1,200 + 600 + 450 + 140 + 100 + 50 + 30 = ₹13,470.
What are the four summary lines?
- Opening cash: the float counted in the morning, say ₹2,000.
- Cash sales: the total of cash bills for the day, say ₹11,900.
- Cash paid out: money that left the drawer with a slip, say ₹250.
- Expected cash: opening plus cash sales minus cash paid out. Here that is 2,000 + 11,900 − 250 = ₹13,650.
Compare with the counted ₹13,470. The difference is counted minus expected, which is 13,470 − 13,650 = minus ₹180. Write the sign, and write the time of the count. A negative figure means the drawer is short; a positive figure means it is over.
How do I build it in a spreadsheet?
Put the denomination values in column A (500, 200, 100, 50, 20, 10, 10, 5, 2, 1), the counts in column B and the amount in column C. In C2 type the formula below and copy it down to C11.
- Amount per row in C2: =A2*B2
- Counted cash in C12: =SUM(C2:C11)
- Opening cash in C13, cash sales in C14 and cash paid out in C15, typed in by hand
- Expected cash in C16: =C13+C14-C15
- Difference in C17: =C12-C16
These formulas work the same in Excel and in Google Sheets. Lock the sheet layout and save one copy per day, so you keep a record.
How should I count so the sheet is trustworthy?
- Count in the same order every day, largest note first.
- Count a bundle twice if the difference is more than you expect. A miscounted bundle of ten ₹100 notes is a ₹1,000 error, and that is usually the answer.
- Count the coins by weighing or in small stacks of ten.
- Put a tick beside each denomination after counting, so no row is skipped.
- Keep damaged notes out of the count and list them on a separate line.
How often should I fill the sheet?
Fill it at every closing, at every handover between people, and whenever the owner takes cash out of the drawer. Add a small box in a corner for the weekday and the name of the person who counted. After a month you will have thirty sheets, and a pattern such as a ₹100 gap every Saturday becomes visible without any extra work. Keep the sheets in a file or in one spreadsheet tab per month, not in loose papers, so that a question about a particular day can be answered in a minute.
Where do I go after the sheet shows a difference?
The sheet tells you the size and sign of the gap, not the cause. Keep the sheets together and look at the last two weeks of differences in one list. A fixed repeating amount, a gap on busy days only, or a gap on one weekday each suggests a different investigation. If you log the shop's small cash spending in SpendixAI as manual expenses, the paid-out line on your sheet becomes easier to fill from a list.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


