- Qintar
- Free sheets
- Buying used gold from customers: a daily log
Buying used gold from customers: a daily log
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.
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.

How to use it
- Today's price: Today's buying price for one gram of 24K.
- The pieces: One line per piece, with its karat, weight and the price you paid.
- Pure gold: The sheet works out the pure gold in each piece.
- The average: The average price you paid per gram of pure gold.
- 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?A step-by-step guide with a worked example.
- Used gold calculator: the price you paid per pure gramThe 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.
More free sheets
- Selling on installments: payment, mark-up and balanceIf 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 nisabHow much is the shop's zakat this year?
- Break-even: how many grams to sell each month?How many grams must I sell each month to cover the shop's costs?