Business

A denomination count sheet for the shop counter

A one-page denomination count sheet for the shop counter: each note and coin with count and amount, plus opening, expected, counted and difference lines.

Editorial illustration for A denomination count sheet for the shop counter

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.

DenominationCountAmount
₹500 notes12₹6,000
₹200 notes9₹1,800
₹100 notes31₹3,100
₹50 notes24₹1,200
₹20 notes30₹600
₹10 notes45₹450
₹10 coins14₹140
₹5 coins20₹100
₹2 coins25₹50
₹1 coins30₹30
Counted cash240 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?

  1. Opening cash: the float counted in the morning, say ₹2,000.
  2. Cash sales: the total of cash bills for the day, say ₹11,900.
  3. Cash paid out: money that left the drawer with a slip, say ₹250.
  4. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports