Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Scrap gold and refining: from scrap to pure gold

Scrap gold and refining: from scrap to pure gold

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 KBDownload Excel60 KB

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.

Preview of the first page of the "Scrap gold and refining: from scrap to pure gold" sheet, with the table and the worked example

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

NoteKaratWeight (g)Lab purity, per thousand (if tested)Pure gold (g)
Example: 21K jewelry scrap21120.000105.000
Example: 18K scrap1845.50034.125
Example: rings tested at the lab2130.00087026.100
ResultValue
Total scrap weight195.500
Total pure gold165.225
Pure gold after the refining loss164.399
Equals 24K (g)164.563
Refining fee6,609.00
Value at the 24K buying price, minus the fee1,146,877.03

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

The calculation

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

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.

More free sheets

All free sheets