# Gold Shop Daily Ledger: Sales, Purchases, Gold Flow

> Free daily ledger for gold shops, in Excel and PDF: every sale, purchase and exchange by karat and weight, with the day's pure-gold change and net cash.

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

---

Free sheet for gold shops · How many grams came in and went out today, and where your balance stands. · [العربية](https://qintar.app/sheets/shop-daily-ledger.html)

How many grams came in and went out today, and how much cash? This day book records every movement in a gold shop (a sale, a purchase from a customer, or an exchange of old gold for new) with its karat, weight, price per gram and amount. The day summary turns it into pure grams and cash for each karat, so you can check your stock and your drawer before you close.

[Download PDF159 KB](https://qintar.app/en/sheets/shop-daily-ledger.pdf)[Download Excel64 KB](https://qintar.app/en/sheets/shop-daily-ledger.xlsx)

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells; everything else is worked out for you.

![Preview of the first page of the "Gold Shop Daily Ledger: Sales, Purchases, Gold Flow" sheet, with its table and worked example](https://qintar.app/en/sheets/shop-daily-ledger.png)

## How to use it

1. **Write each movement:** On a new row type the date, time, type, karat, weight in (from the customer) or weight out (to the customer), price per gram, and the amount received or paid.
2. **Use the lists:** Pick the type (sale, bought from customer, exchange) and the karat from the list in the cell, so the totals add up correctly.
3. **Open the day summary:** Type the date you want in the yellow cell to see grams bought and sold, net pure grams and cash in and out for each karat.
4. **Close the day:** Compare the change in pure grams with a count of the drawer and the display case, and look into any difference before you close.

## Example a day with six movements

The movements of 3 Nov 2026 in the file's example. The price per gram and the amount received or paid are as in the file; for an exchange, the amount is the difference paid or received. The movements are examples.

| Time | Type | Karat | Weight in | Weight out | Price per gram | Received | Paid | Net pure (g) |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 10:05 | Sale | 21K |  | 10 | 6,180.25 | 62,942.50 |  | -8.75 |
| 10:40 | Bought from customer | 21K | 20 |  | 6,160.25 |  | 123,205.00 | 17.5 |
| 11:30 | Sale | 18K |  | 5 | 5,276.00 | 26,836.00 |  | -3.75 |
| 12:15 | Exchange | 21K | 15 | 14.2 | 6,180.25 |  | 3,025.40 | 0.7 |
| 14:00 | Sale | 24K |  | 5 | 7,032.37 | 35,731.85 |  | -4.995 |
| 16:20 | Bought from customer | 18K | 8 |  | 5,259.00 |  | 42,072.00 | 6 |

The day summary in the file: cash received EGP 125,510.35 and paid EGP 168,302.40, net EGP −42,792.05. Grams in 43 and out 34.2, and a stock change of 6.705 g of pure gold.

## Explained: The shop's day book in five minutes

A gold shop moves two things at once, gold and cash, and a day book keeps both honest. The idea is simple: one line for every movement, written when it happens, not reconstructed at night. A sale, a purchase from a customer and an exchange of old gold for new each get their own line.

Each line answers the same questions. Which karat? How much gold came into the shop, and how much went out? At what price per gram? How much money was received, and how much was paid? In a sale, gold goes out and money comes in. In a purchase from a customer, gold comes in and money goes out. In an exchange both weights appear, the old gold in and the new gold out, and the amount is the difference that changed hands.

At the end of the day, totals by karat are not enough on their own, because 21K and 18K hold different amounts of gold. So the summary turns every weight into pure grams: 24K × 0.999, 21K × 0.875 and 18K × 0.75. In minus out, in pure grams, is how much gold your stock really gained or lost today. Received minus paid is the change in your cash.

Then close the day with a few checks. In minus out for each karat is the stock movement. The book balance in pure gold is the opening balance plus that movement. The cash in the drawer should be the opening cash plus what was received, less what was paid. Every line should carry a price per gram and a type, and every exchange should show both weights.

If you also count the stock, compare it with the book balance. A small difference has an explanation you can still find today; tomorrow it is much harder. A few minutes at closing time is easier than a search at the end of the month.

### More on this topic

- How to know your pure gold balance at the end of the day
- Closing the day: six checks

## Questions people ask

**What counts as gold in and gold out?**

In is gold that came into the shop: bought from a customer, or the old gold in an exchange. Out is gold that left the shop: a sale, or the new gold in an exchange.

**Why work in pure grams?**

Because a gram of 21K holds less gold than a gram of 24K. Turning each weight into pure gold (× 0.999, 0.875 or 0.75) lets you add karats together and see the real change in your stock.

**Can I keep several days in one file?**

Yes. The ledger has room for 50 movements on any dates, and the day summary adds up only the date you type in its yellow cell.

## Related calculators and guides

- [Gold Price in Egypt Today](https://qintar.app/en/gold-price-today/)
- [The goldsmiths' dollar: why gold in Egypt differs](https://qintar.app/en/articles/goldsmith-dollar.html)

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 are 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. It is free, with no ads.

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

## More free sheets

- [Old-for-New Gold Exchange Quote for Customers](https://qintar.app/en/sheets/shop-exchange-quote.html)Hand the customer a clear, itemized exchange calculation.
- [Gold Stock Count and Manufacturing Loss](https://qintar.app/en/sheets/shop-stock-and-loss.html)Does your count match the book, and is workshop loss within your limit?
- [Gold Holdings Log](https://qintar.app/en/sheets/gold-holdings-log.html)How many grams you own, what they are worth today, and whether you are up or down.

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