# Family gold register: every piece and who owns it

> Free Excel and PDF register of a family's gold: each piece, its owner, karat, weight and invoice, the pure gold, today's value and each person's total.

Source: https://qintar.app/en/sheets/family-gold-register.html
Language: English
قنطار (Qintar)، qintar.app

---

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 KB](https://qintar.app/en/sheets/family-gold-register.pdf)[Download Excel62 KB](https://qintar.app/en/sheets/family-gold-register.xlsx)

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](https://qintar.app/en/tools/family-gold-register.html).

![Preview of the first page of the "Family gold register: every piece and who owns it" sheet, with the table and the worked example](https://qintar.app/en/sheets/family-gold-register.png)

## 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

| 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 value](https://qintar.app/en/articles/family-gold-register.html)A step-by-step guide with a worked example.
- [Family gold register: pieces and value per person](https://qintar.app/en/tools/family-gold-register.html)The 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.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Gold savings goal: how much to put aside each month](https://qintar.app/en/sheets/gold-goal-planner.html)I want to reach a set number of grams in a set time. How much should I save each month?
- [Comparing gold bar prices between sellers](https://qintar.app/en/sheets/bar-prices-compare.html)Bars 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 figures](https://qintar.app/en/sheets/gold-vs-cash-log.html)The amounts I saved in cash: had I bought gold with them at the time, what would they be worth today?

[All free sheets](https://qintar.app/en/sheets/)
