# 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? Free, in your browser.

Source: https://qintar.app/en/tools/shop-cash-close.html
Language: English
قنطار (Qintar)، qintar.app

---

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](https://qintar.app/en/sheets/shop-cash-close.html). It runs in your browser and saves no data.

## 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:

| Result | Value |
| --- | --- |
| Counted in the drawer | 46,640.00 |
| Should be in the drawer | 46,650.00 |
| Difference (counted − expected) | −10.00 |
| Result | Matches |

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

- Expected = opening balance + cash in − cash out − cash expenses.
- Counted = the sum of (denomination × count).
- Difference = counted − expected. If the difference is within the tolerance, the result is "Matches".

## 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](https://qintar.app/en/sheets/shop-cash-close.html). For a step-by-step explanation: [How to close a gold shop's cash drawer every day](https://qintar.app/en/articles/cash-close-end-of-day.html).

## 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

- [Credit book: each customer's balance after every entry](https://qintar.app/en/tools/shop-credit-book.html)How much does each customer owe, how much have they paid, and what is left?
- [Scrap and refining calculator: how much pure gold?](https://qintar.app/en/tools/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?
- [Wholesaler account: balance in pure gold and making charge](https://qintar.app/en/tools/shop-wholesaler-account.html)How many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- [Gold shop monthly profit calculator](https://qintar.app/en/tools/shop-monthly-profit.html)How much did the shop make this month after expenses?
- [Orders and deposits calculator: what each customer owes](https://qintar.app/en/tools/shop-orders-deposits.html)What does each order cost, how much has the customer paid, and what is still due?

[All calculators](https://qintar.app/en/tools/) · [All free sheets](https://qintar.app/en/sheets/)
