# Gold Holdings Log: Free Excel and PDF

> Free Excel and PDF log for every gold piece you own: weight, karat and price paid, value at today's buy price, profit or loss, and your break-even price.

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

---

# Gold Holdings Log

Free sheet for individuals · How many grams you own, what they are worth today, and whether you are up or down. · [العربية](https://qintar.app/sheets/gold-holdings-log.html)

How many grams of gold do you own, what are they worth today, and are you up or down? In this log you write one line per piece: the date you bought it, a description, the karat, the weight and what you paid. It works out the pure gold in each piece, its value at today's buy price, the profit or loss and the break-even price, then totals each karat and the whole collection.

[Download PDF159 KB](https://qintar.app/en/sheets/gold-holdings-log.pdf)[Download Excel66 KB](https://qintar.app/en/sheets/gold-holdings-log.xlsx)

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells; everything else is worked out for you.

![Preview of the first page of the "Gold Holdings Log" sheet, with its table and worked example](https://qintar.app/en/sheets/gold-holdings-log.png)

## How to use it

1. **Record each piece:** On each row type the date, a description, the kind, the karat, the weight and the total you paid, plus the making charge if you know it.
2. **Tick invoice and hallmark:** Put a ✓ under "Invoice?" and "Hallmark?". The hallmark is the official stamp that shows the karat. Pieces without papers are harder to sell, so the ticks show you what is missing.
3. **Type today's buy price:** In the Summary tab, type the buy price per gram for each karat from Qintar's gold price page. The buy price is what a shop pays you, so it is what you would get if you sold.
4. **Read value and break-even:** Each row shows its value today, the profit or loss in Egyptian pounds and in percent, and the break-even price per gram.
5. **Check the totals:** The Summary tab adds up each karat and the whole collection, and its "If you sell" block takes off a deduction percent that you choose.

## Example three pieces at the buy prices of 3 Nov 2026

Values use the buy prices in the file's example (24K: EGP 7,009.37, 21K: EGP 6,160.25, 18K: EGP 5,259.00 per gram). The amounts paid and the dates are examples, to show how the log works.

| Piece | Karat | Weight (g) | Pure gold (g) | Paid | Value today | Profit / loss | % | Break-even per gram |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Gold pound | 21K | 8 | 7 | 41,600.00 | 49,282.00 | 7,682.00 | 18.5 | 5,200.00 |
| 10 g bar | 24K | 10 | 9.99 | 68,000.00 | 70,093.70 | 2,093.70 | 3.1 | 6,800.00 |
| Ring | 18K | 4 | 3 | 21,000.00 | 21,036.00 | 36.00 | 0.2 | 5,250.00 |
| Total |  | 22 | 19.99 | 130,600.00 | 140,411.70 | 9,811.70 | 7.5 |  |

The break-even price is what you paid divided by the weight. If today's buy price for the karat is above it, the piece is in profit on paper; if below, at a loss on paper. In the "If you sell" block, a 2% deduction (an example figure) takes EGP 2,808.23 off the value of EGP 140,411.70, leaving EGP 137,603.47: EGP 7,003.47 (5.4%) more than was paid.

## Explained: Why keep a record of your gold

If your gold arrived piece by piece over the years (a wedding set, a few gold pounds, a bar when savings allowed), you probably cannot say what it is all worth today. The invoices sit in different drawers, and the prices were paid in different years.

A simple log fixes that. Write one line per piece on the day you buy it, with the weight, the karat and the total you paid, making charge included. From there the arithmetic is easy. Pure grams are the weight times the purity: 0.999 for 24K, 0.875 for 21K and 0.75 for 18K. Today's value is the weight times today's buy price for that karat.

Why the buy price and not the sell price? Because the value of something you own is what you could get for it. Shops buy at a lower price than they sell, and they do not pay you back the making charge you paid on a piece, or the VAT on it. So a ring bought recently is usually worth less on paper than you paid. That is normal, and the log shows it plainly instead of letting it surprise you on the day you sell.

The break-even price is the number to watch. It is what you paid divided by the weight: the buy price per gram the market has to reach before you can sell without a loss. For bars, where the fee per gram is small next to the gold price, it sits close to the price you paid per gram. For jewelry with a high making charge it sits higher, so the same money needs a bigger price rise to break even.

Keep the invoice and photograph the hallmark of each piece too. When you sell, a shop can check a piece with papers quickly, and the log tells you which pieces have them. Update the buy prices once a week or whenever you are curious, and the totals tell you, in grams and in pounds, where your gold stands.

### More on this topic

- What the break-even price means
- Invoice and hallmark: two papers that matter on the day you sell

## Questions people ask

**Why does the log value my gold at the buy price?**

Because that is what a shop would pay you if you sold today. The sell price is what you would pay to buy, and it is higher.

**Why does a piece of jewelry show a loss right after I bought it?**

The total you paid includes the making charge and the VAT on it, and shops do not pay these back when they buy gold from you. The piece shows a profit only once the buy price rises above its break-even price.

**Do I have to type prices every day?**

No. Update the buy prices whenever you want to know where you stand. The file has no live data, so the values change only when you type new prices.

## Related calculators and guides

- [Gold break-even calculator: gain or loss if you sell now](https://qintar.app/en/tools/gold-break-even-calculator.html)
- [The Qintar app: your holdings with profit and loss](https://qintar.app/app/)

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 are 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. It is free, with no ads.

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

## More free sheets

- [Gold and Silver Zakat Sheet](https://qintar.app/en/sheets/gold-zakat-sheet.html)Have you reached the nisab, how much zakat is due, and when does your year end?
- [Gold Quick Reference: Karats, Units, Making Charges](https://qintar.app/en/sheets/gold-quick-reference.html)Every number and word you need before you walk into a gold shop in Egypt, on one page.
- [Gold Shop Daily Ledger: Sales, Purchases, Gold Flow](https://qintar.app/en/sheets/shop-daily-ledger.html)How many grams came in and went out today, and where your balance stands.

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