Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Family gold register: pieces and value per person

Family gold register: pieces and value per person

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. This calculator is the same as the "Family gold register: every piece and who owns it" sheet. It runs in your browser and saves no data.

Settings and prices

Loading today's prices…

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

OwnerPieceKaratWeight (g)Invoice? (type Yes or No)Pure gold (g)Value at the buying priceOwner's total so farDelete

Result

Who this calculator is for

This is the online version of the "Family gold register: every piece and who owns it" sheet, made for individuals. A register of all the gold in the home: who owns each piece, a description, the karat, the weight, whether there is an invoice, the pure gold, the value at today's buying price, and a running total for each person.

The question it answers: How many grams of gold does the family own, who holds them, and what are they worth?

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.

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

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total weight (g)43.700
Total pure gold (g)38.578
Value at the buying price271,205.13

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: A family gold register: all the home's gold and its value.

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.

Related calculators

All calculators · All free sheets