# Buying used gold from customers: a daily log

> Free Excel and PDF daily log for a gold shop buying used gold: pure gold in each piece, the price paid per pure gram, and the gap to today's price.

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

---

Free sheet for goldsmiths and shop owners · On average, what did I pay today for each gram of pure gold in the used gold I bought?

Every day a shop buys used gold from customers, in different karats and at different prices. This sheet turns it all into one figure: what you paid per gram of pure gold, and how far that is below or above today's price.

[Download PDF143 KB](https://qintar.app/en/sheets/shop-used-gold-buying.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/shop-used-gold-buying.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-used-gold-buying.html).

![Preview of the first page of the "Buying used gold from customers: a daily log" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-used-gold-buying.png)

## How to use it

1. **Today's price:** Today's buying price for one gram of 24K.
2. **The pieces:** One line per piece, with its karat, weight and the price you paid.
3. **Pure gold:** The sheet works out the pure gold in each piece.
4. **The average:** The average price you paid per gram of pure gold.
5. **The gap:** The difference between the pure gold at today's price and what you paid.

## Example The calculation with numbers

Buying price, 1 g of 24K today (example): 7,009.37

| Piece | Karat | Weight (g) | Price paid per gram | Pure gold (g) | Paid | Price per gram of pure gold |
| --- | --- | --- | --- | --- | --- | --- |
| Example: bangle | 21 | 12.500 | 6,100.00 | 10.938 | 76,250.00 | 6,971.43 |
| Example: ring | 18 | 4.200 | 5,180.00 | 3.150 | 21,756.00 | 6,906.67 |
| Example: chain | 21 | 8.100 | 6,080.00 | 7.087 | 49,248.00 | 6,948.57 |
| Example: mixed scrap | 18 | 6.400 | 5,150.00 | 4.800 | 32,960.00 | 6,866.67 |

| Result | Value |
| --- | --- |
| Total weight (g) | 31.200 |
| Total pure gold (g) | 25.975 |
| Total paid | 180,214.00 |
| Average price you paid per gram of pure gold | 6,937.98 |
| Today's price per gram of pure gold | 7,016.39 |
| Gap on all the gold bought (today's value − paid) | 2,036.64 |

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

## The calculation

- Pure gold = weight × karat purity (24K: 0.999, 21K: 0.875, 18K: 0.75).
- Paid = weight × price paid per gram.
- Price per gram of pure gold = paid ÷ pure gold. Today's pure-gold price = the 24K buying price ÷ 0.999.
- Gap = pure gold × today's pure-gold price − paid: your margin before refining or resale costs.

## Terms used on this sheet

- **Used gold:** Jewelry and pieces a shop buys back from customers (الكسر, literally "broken"). It is valued by the pure gold it holds.
- **Pure gold:** Weight × purity: 21K is 0.875 pure, 18K is 0.75 pure, and Qintar counts 24K as 0.999.
- **Buying price:** The price at which a shop buys gold, lower than the selling price it charges customers.
- **Bangle:** A rigid bracelet (غويشة), one of the most common pieces of Egyptian 21K jewelry.

## Read more

- [Buying used gold from customers: was the price right?](https://qintar.app/en/articles/buying-used-gold-from-customers.html)A step-by-step guide with a worked example.
- [Used gold calculator: the price you paid per pure gram](https://qintar.app/en/tools/shop-used-gold-buying.html)The same sheet online, with today's prices.

## Frequently asked questions

**Why work in pure gold?**

So that 21K and 18K pieces add up to one figure and can be compared with each other and with today's price.

**Is the gap my profit?**

No. It is the margin before the cost of refining, reworking or reselling, and before any loss. Your real profit shows once you sell or refine.

**What do I do with the scrap afterward?**

If you send it for refining, the scrap and refining sheet works out how much pure gold comes back after refining.

**Why do Egyptian shops buy back gold at all?**

In Egypt people sell old jewelry back to gold shops for cash, or trade it in for a new piece. So buying is a daily part of a shop's work, not an exception.

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

- [Selling on installments: payment, mark-up and balance](https://qintar.app/en/sheets/shop-installment-sales.html)If I sell on installments, what is the monthly payment, and how much will the customer pay in the end?
- [Zakat for a gold shop: the base and the nisab](https://qintar.app/en/sheets/shop-zakat.html)How much is the shop's zakat this year?
- [Break-even: how many grams to sell each month?](https://qintar.app/en/sheets/shop-break-even.html)How many grams must I sell each month to cover the shop's costs?

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