# Old-for-New Gold Exchange Quote for Customers

> Free Excel and PDF quote for gold shops trading a customer's old gold for a new piece: old value, new gold, making charge, VAT and the difference, itemized.

Source: https://qintar.app/en/sheets/shop-exchange-quote.html
Language: English
قنطار (Qintar)، qintar.app

---

Free sheet for gold shops · Hand the customer a clear, itemized exchange calculation. · [العربية](https://qintar.app/sheets/shop-exchange-quote.html)

When a customer brings old gold to trade for a new piece, this sheet works out the exchange: the old gold at your buy price (less any deduction you apply), the new gold at your sell price, the making charge and 14% VAT on the making charge only, and the difference one side pays the other. A "Customer quote" tab prints the whole breakdown on one page you can hand over.

[Download PDF131 KB](https://qintar.app/en/sheets/shop-exchange-quote.pdf)[Download Excel63 KB](https://qintar.app/en/sheets/shop-exchange-quote.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 "Old-for-New Gold Exchange Quote for Customers" sheet, with its table and worked example](https://qintar.app/en/sheets/shop-exchange-quote.png)

## How to use it

1. **Type today's prices:** Enter today's buy and sell prices per gram for each karat, and your shop's name.
2. **Describe the old gold:** Type its weight and karat, and the deduction you apply to old gold, if any.
3. **Describe the new piece:** Type its weight, karat and making charge per gram. VAT of 14% on the making charge is added automatically.
4. **Read the difference:** The sheet says whether the shop pays the customer or the customer pays the shop, and how much.
5. **Hand over the quote:** Print the "Customer quote" tab: it lists every item with its weight and price, and the total.

## Example 35 g of old 21K for 32.49 g of new 21K

The old gold is valued at the buy price of EGP 6,160.25 and the new at the sell price of EGP 6,180.25 (3 Nov 2026). There is no deduction on the old gold and the making charge is EGP 120 per gram: an example, not a shop's price.

| Item | Calculation | EGP |
| --- | --- | --- |
| Old gold value | 35 × 6,160.25 | 215,608.75 |
| New gold value | 32.49 × 6,180.25 | 200,796.32 |
| Making charge | 32.49 × 120 | 3,898.80 |
| 14% VAT on the making charge | 3,898.80 × 0.14 | 545.83 |
| New total | gold + making charge + VAT | 205,240.95 |
| Difference to the customer (received) | old value − new total | 10,367.80 |

When the old gold is worth more than the new total, the customer receives the difference; when it is worth less, the customer pays it. Every item is written out so the customer can see each number.

## Explained: Give the customer the exchange in numbers

In an exchange of old gold for new, it is easy for the customer to hear only a single figure, "pay this much" or "take this much", with no way to see how it was reached. A written breakdown changes that.

An exchange has two sides. On one side is the customer's old gold, valued at the price at which the shop buys: weight times the buy price for its karat, less any deduction the shop applies to old gold. On the other side is the new piece, valued like any sale: the new weight times the sell price for its karat, plus the making charge per gram, plus VAT of 14% on the making charge only.

The difference between the two is what changes hands. In the example, 35 g of old 21K is worth EGP 215,608.75 at the buy price, and the new 21K piece of 32.49 g comes to EGP 205,240.95 with its making charge and VAT, so the shop pays the customer EGP 10,367.80. Had the new piece been heavier, the customer would have paid instead.

The quote tab prints each line with its weight and price, which is what builds trust: the customer can check every number against the price board and see that VAT is charged only on the making charge. If you apply a deduction to old gold, write it on the quote rather than hiding it in a lower price.

Scholars hold two known views on exchanging gold for gold. Egypt's Dar al-Ifta permits the exchange with the difference paid, on the basis that worked gold is a commodity, not money. Some scholars prefer that the customer first sells the old gold and then buys the new piece, as two separate deals. The sheet shows the same numbers either way; for a ruling, ask a fatwa authority you trust.

### More on this topic

- Being open about an exchange builds a loyal customer
- The ruling on exchanging gold: the two views

## Questions people ask

**Is exchanging old gold for new allowed?**

Scholars hold two known views: Egypt's Dar al-Ifta permits the exchange with the difference paid, treating worked gold as a commodity; some scholars prefer a sale of the old gold, then a purchase of the new. This is not a fatwa: ask a fatwa authority you trust.

**Why is old gold valued at the buy price?**

Because the shop is buying it, just as it would buy gold from any customer. The new piece is valued at the sell price, as in any sale.

**Do I have to apply a deduction on old gold?**

No. Any deduction is your decision, and the example uses 0%. If you apply one, write it on the customer quote.

## Related calculators and guides

- [Gold exchange calculator: old gold for new in Egypt](https://qintar.app/en/tools/gold-exchange-calculator.html)
- [Swapping old gold for new in Egypt: a fair deal?](https://qintar.app/en/articles/gold-exchange-old-for-new.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 Stock Count and Manufacturing Loss](https://qintar.app/en/sheets/shop-stock-and-loss.html)Does your count match the book, and is workshop loss within your limit?
- [Daily Gold Price Board for Your Shop](https://qintar.app/en/sheets/shop-price-board.html)A clean price board to hang in the shop and update every day.
- [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?

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