Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Cash close calculator: count the drawer and compare

Cash close calculator: count the drawer and compare

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

At the end of the day there is one question: is the cash in the drawer what should be there? In a gold shop the drawer moves money both ways: customers pay for jewelry, and the shop pays out when it buys gold from customers. This sheet has you count one denomination at a time, works out the expected cash from the opening balance, the cash in and the cash out, and shows the difference. This calculator is the same as the "End-of-day cash close for a gold shop" sheet. It runs in your browser and saves no data.

Settings and prices

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

Denomination (EGP)CountValueDelete

Result

Who this calculator is for

This is the online version of the "End-of-day cash close for a gold shop" sheet, made for goldsmiths and shop owners. A sheet that counts the cash in the drawer one denomination at a time, works out what should be there from the opening balance, the cash in and the cash out, and tells you whether it matches, and by how much it is over or short.

The question it answers: Does the cash in the drawer match what should be there, or is there a gap?

How to use it

  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.

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

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Counted in the drawer46,640.00
Should be in the drawer46,650.00
Difference (counted − expected)−10.00
ResultMatches

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

The calculation

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: How to close a gold shop's cash drawer every day.

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.

Related calculators

All calculators · All free sheets