Qintar logoQintar
  1. Qintar
  2. Guides
  3. How to close a gold shop's cash drawer every day

How to close a gold shop's cash drawer every day

Does the cash in the drawer match what should be there, or is there a gap?

Closing the cash drawer at the end of the day is the simplest habit that protects a shop. The idea is that the money in the drawer must equal what should be there: what you started with in the morning, plus what came in from sales, minus what went out to buy gold from customers and to pay expenses.

If you do it every day, any difference shows up on the day it happened and its cause is easy to find. If you wait until the end of the week, one difference mixes with others and you will not know where it came from.

Counting one denomination at a time cuts mistakes. Instead of counting the whole bundle at once, write down how many EGP 200 notes there are, then the EGP 100 notes, and so on. The sheet multiplies and adds.

The tolerance is a small amount you accept as a difference for loose change, and you decide it. If the difference is bigger, the sheet says the drawer is over or short and you start checking.

Why a gold shop's drawer needs its own check

A gold shop is not a normal till. The same drawer takes in the price of jewelry from customers and pays out the price of the gold the shop buys back from customers. On a busy day both sides are large, and a small slip on either side changes the total.

That is why the sheet keeps cash in and cash out on separate lines instead of a single net figure. When the drawer does not match, you can see straight away which side to check in the day book.

A worked example in plain words

In the example the drawer starts at EGP 20,000. During the day EGP 68,500 comes in, EGP 41,200 goes out to buy gold from customers, and EGP 650 is paid in cash expenses. So the drawer should hold EGP 46,650.

The count, one denomination at a time, comes to EGP 46,640: EGP 10 less than expected. The tolerance in the example is EGP 20, so the sheet reports "Matches". Had the gap been EGP 30, it would have said the drawer is short, and it would be time to open the day book.

The calculation

Example A worked example

Opening balance (example): 20,000.00 · Cash in today (example): 68,500.00 · Cash out: gold bought from customers (example): 41,200.00 · Expenses paid in cash (example): 650.00 · Accepted tolerance, EGP (example): 20.00

Denomination (EGP)CountValue
20020040,000.00
100606,000.00
5010500.00
205100.00
10330.00
515.00
133.00
0.542.00
ResultValue
Counted in the drawer46,640.00
Should be in the drawer46,650.00
Difference (counted − expected)−10.00
ResultMatches

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

Common causes of a difference

Terms used on this sheet

Drawer
The shop's cash till. In Egyptian shops people simply say the drawer (الدرج).
Day book
The daily record of every sale and purchase (اليومية). The totals for cash in and cash out come from it.
Tolerance
The small difference you are willing to accept, such as loose change. Anything bigger is reported as over or short.

Step by step with the sheet

  1. Opening balance: Type the amount the drawer started the day with.
  2. Cash in and cash out: From the shop's day book, type the total cash that came in from sales and the cash paid out to buy gold from customers.
  3. Expenses: Type the expenses paid in cash from the drawer today.
  4. The count: Count the cash one denomination at a time and type the count next to each one.
  5. The result: The sheet compares what you counted with what should be there and says matches, over or short.

The sheet is free: End-of-day cash close for a gold shop (Excel and PDF), or try it online with today's prices.

Frequently asked questions

Is the tolerance a fixed number?

No, you set it. The figure in the example is only an illustration, and you can set it to zero if you want the drawer to match to the last piastre.

What do I do if the drawer is short?

Go through the day book line by line: a sale or purchase recorded with the wrong amount, an expense nobody wrote down, or change given out. The sheet tells you the size of the gap; the reason is in the book.

Why does cash leave the drawer in a gold shop?

Besides selling, a gold shop buys gold from customers, and when it pays in cash the money comes out of the drawer. That is why the sheet has a separate line for cash out.

Can I use it with the shop's day book?

Yes. Take the cash in and cash out from the day summary of your day book, then count the drawer here.

Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling. Check tax matters with your accountant.

Live prices in the app. The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.