- Qintar
- Free sheets
- Family gold register: every piece and who owns it
Family gold register: every piece and who owns it
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.
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
- The prices: The buying price per gram for each karat.
- The pieces: Each piece with its owner, karat and weight.
- The invoice: Type Yes or No.
- The value: The sheet works out the pure gold and the value.
- 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
| Owner | Piece | Karat | Weight (g) | Invoice? (type Yes or No) | Value at the buying price | Owner's total so far |
|---|---|---|---|---|---|---|
| Example: Mother | Bracelet | 21 | 18.500 | Yes | 113,964.63 | 113,964.63 |
| Example: Mother | Chain | 18 | 7.200 | No | 37,864.80 | 151,829.43 |
| Example: Daughter | Wedding band and guard ring | 21 | 8.000 | Yes | 49,282.00 | 49,282.00 |
| Example: Father | 10 g bar | 24 | 10.000 | Yes | 70,093.70 | 70,093.70 |
| Result | Value |
|---|---|
| Total weight (g) | 43.700 |
| Total pure gold (g) | 38.578 |
| Value at the buying price | 271,205.13 |
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).
- Value = weight × today's buying price per gram for that karat (without the making charge).
- Owner's total = the sum of the values of that owner's pieces, from the top of the register to this line.
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
- A family gold register: all the home's gold and its valueA step-by-step guide with a worked example.
- Family gold register: pieces and value per personThe same sheet 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.
More free sheets
- Gold savings goal: how much to put aside each monthI want to reach a set number of grams in a set time. How much should I save each month?
- Comparing gold bar prices between sellersBars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?
- What if it had been gold? Comparing in figuresThe amounts I saved in cash: had I bought gold with them at the time, what would they be worth today?