Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Buying used gold from customers: a daily log

Buying used gold from customers: a daily log

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 KBDownload Excel61 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 "Buying used gold from customers: a daily log" sheet, with the table and the worked example

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

PieceKaratWeight (g)Price paid per gramPure gold (g)PaidPrice per gram of pure gold
Example: bangle2112.5006,100.0010.93876,250.006,971.43
Example: ring184.2005,180.003.15021,756.006,906.67
Example: chain218.1006,080.007.08749,248.006,948.57
Example: mixed scrap186.4005,150.004.80032,960.006,866.67
ResultValue
Total weight (g)31.200
Total pure gold (g)25.975
Total paid180,214.00
Average price you paid per gram of pure gold6,937.98
Today's price per gram of pure gold7,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

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

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.

More free sheets

All free sheets