Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Family gold register: every piece and who owns it

Family gold register: every piece and who owns it

Free sheet for individuals · How many grams of gold does the family own, who holds them, and what are they worth?

Gold in a family home is usually spread across several people, and often there is no paperwork. This sheet puts it all in one register: the piece, its owner, its weight, whether it has an invoice, and what it is worth at today's price.

Download PDF137 KBDownload Excel62 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 "Family gold register: every piece and who owns it" sheet, with the table and the worked example

How to use it

  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.

Example The calculation with numbers

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.

The calculation

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.

Read more

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.

More free sheets

All free sheets