# End-of-day cash close for a gold shop | Free sheet

> Free Excel and PDF sheet to close a gold shop's cash drawer each day: count note by note, compare with the expected cash and see if it is over or short.

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

---

# End-of-day cash close for a gold shop

Free sheet for goldsmiths and shop owners · 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.

[Download PDF130 KB](https://qintar.app/en/sheets/shop-cash-close.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-cash-close.xlsx)

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. [Or try it online without downloading](https://qintar.app/en/tools/shop-cash-close.html).

![Preview of the first page of the "End-of-day cash close for a gold shop" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-cash-close.png)

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

## Example The calculation with numbers

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) | Count | Value |
| --- | --- | --- |
| 200 | 200 | 40,000.00 |
| 100 | 60 | 6,000.00 |
| 50 | 10 | 500.00 |
| 20 | 5 | 100.00 |
| 10 | 3 | 30.00 |
| 5 | 1 | 5.00 |
| 1 | 3 | 3.00 |
| 0.5 | 4 | 2.00 |

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

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

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

## Read more

- [How to close a gold shop's cash drawer every day](https://qintar.app/en/articles/cash-close-end-of-day.html)A step-by-step guide with a worked example.
- [Cash close calculator: count the drawer and compare](https://qintar.app/en/tools/shop-cash-close.html)The same sheet 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.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Credit sales book: what each customer owes](https://qintar.app/en/sheets/shop-credit-book.html)How much does each customer owe, how much have they paid, and what is left?
- [Scrap gold and refining: from scrap to pure gold](https://qintar.app/en/sheets/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?
- [Wholesaler account: weight, making charge and payments](https://qintar.app/en/sheets/shop-wholesaler-account.html)How many grams of pure gold and how many pounds of making charge do I owe the wholesaler?

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