# Fair Price Sheet for Any Gold Piece: Free Excel and PDF

> Free Excel and PDF sheet that works out a fair price for any gold bar, coin or jewelry piece in Egypt: gold value, usual making charge and 14% VAT.

Source: https://qintar.app/en/sheets/fair-price-sheet.html
Language: English
قنطار (Qintar)، qintar.app

---

# Fair Price Sheet for Any Gold Piece

Free sheet for individuals · Did you pay a normal price for that bar, coin or bracelet? · [العربية](https://qintar.app/sheets/fair-price-sheet.html)

Bought a gold bar, a gold pound or a bracelet in Egypt and not sure the price was normal? This sheet values the gold at the day's price, adds the usual making charge for that kind of piece and the 14% VAT that applies to the making charge only, then compares the result with what you paid and gives a plain verdict. It follows the same logic as Qintar's fair price checker, in a file you keep, with one row per piece.

[Download PDF170 KB](https://qintar.app/en/sheets/fair-price-sheet.pdf)[Download Excel64 KB](https://qintar.app/en/sheets/fair-price-sheet.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 "Fair Price Sheet for Any Gold Piece" sheet, with its table and worked example](https://qintar.app/en/sheets/fair-price-sheet.png)

## How to use it

1. **Type the day's prices:** Open Qintar's gold price page and copy the sell price per gram of 24K, 21K and 18K into the yellow cells. The sell price is what shops sell at, so it is what a buyer pays. Note the time of the last update.
2. **Add the piece:** On a new row choose the kind (bar, pound/coin, simple, medium or complex jewelry), the karat and the weight in grams, as written on the invoice.
3. **Type what you paid:** Enter the total on the invoice. If the invoice shows the making charge per gram, type it in the optional column and the sheet uses it instead of the usual range.
4. **Read the range and the gap:** The row shows the gold value, the low and high end of the usual price, and how far above it you paid, in Egyptian pounds and in percent.
5. **Read the verdict:** Each row ends with one of five verdicts: within the usual range, slightly high, above usual, well above usual, or below the gold value (check the piece).

## Example a bar and a bracelet at EGP 7,032.37 (24K) and EGP 6,180.25 (21K) per gram

The sum uses the sell prices in the file's example (3 Nov 2026): EGP 7,032.37 per gram of 24K and EGP 6,180.25 per gram of 21K. The usual bar fee for a 5 g bar is EGP 100 per gram, and the usual making charge for medium 21K jewelry is EGP 80 to 150 per gram. These are usual figures from when the sheet was made, not any one shop's price.

| Piece | Gold value | Usual from | Usual to | Paid | Extra | Verdict |
| --- | --- | --- | --- | --- | --- | --- |
| SAM 5 g bar | 35,161.85 | 35,731.85 | 35,731.85 | 36,200.00 | 468.15 (1.3%) | Slightly high |
| 10 g bracelet | 61,802.50 | 62,714.50 | 63,512.50 | 62,800.00 | 0 | Within the usual range |

The bar cost EGP 36,200.00 against a usual EGP 35,731.85: EGP 468.15 (1.3%) more, so the sheet rates it "Slightly high". The bracelet cost EGP 62,800.00, below the top of its range at EGP 63,512.50, so it is "Within the usual range".

## Explained: How to check the price of a gold bar before you pay

A gold price in Egypt has three parts, and you can check each one in a minute. The first is the gold itself: the weight of the piece times the price per gram for its karat. Use the sell price, because that is the price at which a shop sells and you buy. The buy price is what a shop pays when you sell to it, and it is always lower. In the file's example, a 5 g bar of 24K at a sell price of EGP 7,032.37 holds EGP 35,161.85 of gold.

The second part is the making charge, which Egyptian shops quote per gram rather than per piece. For bars it covers the hallmark, the packaging and the seller's margin, and the fee per gram falls as bars get heavier: the usual figure when the sheet was made was EGP 100 per gram for a 5 g bar, so EGP 500 for this one. For jewelry it depends on how much work the design needs, which is why the sheet uses a low and a high figure for simple, medium and complex pieces.

The third part is VAT. Egypt charges 14% VAT on the making charge only, not on the value of the gold. On EGP 500 that is EGP 70. Add the three parts and you get EGP 35,731.85: the usual price of this bar on that day.

Now compare that figure with the invoice. If you paid much more, ask the jeweler to break the price down: the price per gram used, the making charge per gram, and whether VAT was included. The gold price moves during the day, so if your invoice is from yesterday or from a different hour, part of the gap may simply be the market.

The sheet does not say a shop is right or wrong. It shows where you stand against the usual range, so you can ask the right questions and compare two shops next time. Do the sum before you pay, not after: it is much easier to negotiate before the invoice is written.

### More on this topic

- Why small bars cost more per gram than big ones
- Yesterday's price is not today's: how to compare like with like

## Questions people ask

**Which gold price does the sheet use?**

The one you type into the yellow cells. Copy it from Qintar's gold price today page, and use the sell price per gram, because that is what you pay when you buy.

**Are the usual making charges in the sheet fixed prices?**

No. They are the usual figures published when the sheet was made (3 November 2026), for guidance only; the current figures are in Qintar's calculators. If your invoice shows a making charge per gram, type it in and the sheet uses yours.

**If the verdict says "well above usual", was I overcharged?**

Not necessarily. It means you paid clearly more than the usual range. Check the invoice, the hallmark and the weight, and ask about each item in numbers. A complex design or a price from a different time of day can explain part of it.

## Related calculators and guides

- [Gold fair price checker: did you pay a fair price?](https://qintar.app/en/tools/gold-fair-price-checker.html)
- [Bought a gold bar in Egypt: was the price fair?](https://qintar.app/en/articles/gold-bar-fair-price.html)

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 Holdings Log](https://qintar.app/en/sheets/gold-holdings-log.html)How many grams you own, what they are worth today, and whether you are up or down.
- [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?
- [Pricing a Piece in Your Gold Shop](https://qintar.app/en/sheets/shop-piece-pricing.html)What the price of a piece is made of, and what your margin really is.

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