# Scrap gold and refining: from scrap to pure gold

> Free Excel and PDF sheet for scrap gold: turn 21K and 18K scrap into pure gold, then see what returns after refining loss and fees, at today's price.

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

---

Free sheet for goldsmiths and shop owners · How many grams of pure gold are in my scrap, and how much comes back after refining?

Scrap that builds up in a gold shop is worth the pure gold inside it, not its weight. This sheet turns every batch into grams of pure gold, then works out what comes back after the refinery takes its loss and its fee, and what that is worth at today's price.

[Download PDF135 KB](https://qintar.app/en/sheets/shop-scrap-refining.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-scrap-refining.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-scrap-refining.html).

![Preview of the first page of the "Scrap gold and refining: from scrap to pure gold" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-scrap-refining.png)

## How to use it

1. **Record the scrap:** One line per batch: a note, the karat and the weight.
2. **Lab purity:** If a lab tested the piece, type the purity per thousand; the sheet uses it instead of the karat.
3. **The refinery's terms:** Type the loss % and the fee per gram exactly as agreed with the refinery.
4. **The price:** Type today's buying price for 24K.
5. **The summary:** Pure gold, what comes back, the fee and the net value.

## Example The calculation with numbers

Refining loss % (example): 0.5% · Refining fee per gram of pure gold, EGP (example): 40.00 · Buying price, 1 g of 24K (example): 7,009.37

| Note | Karat | Weight (g) | Lab purity, per thousand (if tested) | Pure gold (g) |
| --- | --- | --- | --- | --- |
| Example: 21K jewelry scrap | 21 | 120.000 |  | 105.000 |
| Example: 18K scrap | 18 | 45.500 |  | 34.125 |
| Example: rings tested at the lab | 21 | 30.000 | 870 | 26.100 |

| Result | Value |
| --- | --- |
| Total scrap weight | 195.500 |
| Total pure gold | 165.225 |
| Pure gold after the refining loss | 164.399 |
| Equals 24K (g) | 164.563 |
| Refining fee | 6,609.00 |
| Value at the 24K buying price, minus the fee | 1,146,877.03 |

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), or weight × lab purity ÷ 1000.
- Returned = pure gold × (1 − loss %). In grams of 24K = returned ÷ 0.999.
- Value = grams of 24K × buying price − refining fee (pure gold × fee per gram).

## Terms used on this sheet

- **Scrap:** Broken or used gold (كسر): pieces bought back from customers, offcuts and damaged items. Its value is the pure gold it contains.
- **Refining:** Melting scrap and separating the pure gold. The refinery keeps a small loss and charges a fee, both agreed with you.
- **Lab purity:** A test result in parts per thousand: 870 means the piece is 87% gold.
- **Buying price:** The price at which a shop buys gold. It is lower than the selling price that customers pay.

## Read more

- [Scrap gold and refining: working out the pure gold](https://qintar.app/en/articles/gold-scrap-refining.html)A step-by-step guide with a worked example.
- [Scrap and refining calculator: how much pure gold?](https://qintar.app/en/tools/shop-scrap-refining.html)The same sheet online, with today's prices.

## Frequently asked questions

**Are the loss % and the fee official rates?**

No. They are the terms of the refinery you deal with, and you type them. The figures in the example are illustrations.

**Why does it divide by 0.999?**

In the calculation 24K is 99.9% pure, so to know how many grams of 24K your pure gold equals, you divide by 0.999.

**Is the lab purity more accurate than the karat?**

If the piece was tested at a lab, that figure is more accurate than the karat stamped on it, which is why the sheet uses it when you type it.

**What do 21K and 18K mean in pure gold?**

Karats count gold in 24ths: 21K is 21/24 = 87.5% gold, so 1 g of 21K holds 0.875 g of pure gold, and 18K holds 0.75 g. Qintar counts 24K as 0.999.

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

- [End-of-day cash close for a gold shop](https://qintar.app/en/sheets/shop-cash-close.html)Does the cash in the drawer match what should be there, or is there a gap?
- [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?
- [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/)
