Qintar logoQintar
  1. Qintar
  2. Guides
  3. A family gold register: all the home's gold and its value

A family gold register: all the home's gold and its value

How many grams of gold does the family own, who holds them, and what are they worth?

In many homes the gold is spread out: a bracelet with the mother, the engagement jewelry with the daughter, a bar with the father. Nobody knows the total, or where the invoices are.

A simple register fixes that: one line per piece, with its owner, its weight and karat, and whether there is an invoice.

Once you type today's buying price, the sheet works out the approximate value of each piece and of each person's gold. That value leaves out the making charge, because the making charge does not come back when you sell.

The register is for keeping things in order only; it does not decide ownership. Update the prices from time to time so the values stay close to reality.

Why the value is lower than what was paid

When jewelry is bought in Egypt, the price is the gold at the selling price, plus a making charge per gram, plus 14% VAT on the making charge. When it is sold back, the shop pays the buying price for the gold alone.

So the register will usually show less than the family paid, especially for jewelry with a high making charge. That is not a loss on paper; it is what the gold itself is worth today.

The example in plain words

The mother owns an 18.5 g bracelet of 21K, worth EGP 113,964.63 at a buying price of EGP 6,160.25, and a 7.2 g chain of 18K, worth EGP 37,864.80 at EGP 5,259. Her total is EGP 151,829.43.

The daughter owns a 21K wedding band and guard ring weighing 8 g, worth EGP 49,282.00. The father owns a 10 g bar of 24K, worth EGP 70,093.70 at EGP 7,009.37.

Together the family holds 43.7 g of gold, or 38.578 g of pure gold, worth EGP 271,205.13 at today's buying prices. The register also shows that the chain has no invoice.

The calculation

Example A worked example

Buying price, 1 g of 24K (example): 7,009.37 · Buying price, 1 g of 21K (example): 6,160.25 · Buying price, 1 g of 18K (example): 5,259.00

OwnerPieceKaratWeight (g)Invoice? (type Yes or No)Value at the buying priceOwner's total so far
Example: MotherBracelet2118.500Yes113,964.63113,964.63
Example: MotherChain187.200No37,864.80151,829.43
Example: DaughterWedding band and guard ring218.000Yes49,282.0049,282.00
Example: Father10 g bar2410.000Yes70,093.7070,093.70
ResultValue
Total weight (g)43.700
Total pure gold (g)38.578
Value at the buying price271,205.13

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

Terms used on this sheet

Buying price
The price at which a shop buys gold from you. It is lower than the selling price, and it is what your pieces would fetch today.
Hallmark
The stamp on a piece that shows its karat (الدمغة). Together with the invoice, it makes a piece easier to sell.
Shabka
The gold jewelry an Egyptian groom gives his bride at the engagement (الشبكة). It is often the largest set of gold in a home.
Pure gold
The gold inside an alloy: weight × purity. 21K is 0.875 pure and 18K is 0.75 pure.

Step by step with the sheet

  1. The prices: The buying price per gram for each karat.
  2. The pieces: Each piece with its owner, karat and weight.
  3. The invoice: Type Yes or No.
  4. The value: The sheet works out the pure gold and the value.
  5. Per person: Each owner's total.

The sheet is free: Family gold register: every piece and who owns it (Excel and PDF), or try it online with today's prices.

Frequently asked questions

Why record whether there is an invoice?

The invoice and the hallmark make a difference on the day you sell. The register reminds you which pieces still need their invoice found.

Does the value include the making charge?

No. The value uses the buying price of the gold only, which is roughly what you would get if you sold.

Does this register decide who owns what?

No. It is for keeping things in order only, and it is not a legal document.

Why do 21K and 18K pieces have their own prices?

Egyptian shops quote a separate gram price for each karat, because each holds a different share of pure gold. The sheet values each piece at the price for its own karat.

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.