Qintar logoQintar
  1. Qintar
  2. Guides
  3. Custom gold orders: recording the deal and the deposit

Custom gold orders: recording the deal and the deposit

What does each order cost, how much has the customer paid, and what is still due?

A piece made to order (wedding bands, a name necklace, a ring in a special size) takes time between the agreement and the collection, and the gold price can change during that time. That is why the agreement has to be written down.

Four things matter most in the agreement: the karat, the estimated weight, the price per gram (fixed now, or the price on the day of collection) and the making charge. The policy is the shop's decision; what matters is that the customer knows it.

The deposit and any later payments are recorded next to the order, and the amount due works itself out. When the piece is finished, its real weight sets the final price.

This book protects both the shop and the customer: each side knows what has been paid and what is left, without relying on anyone's memory.

How a custom order works in an Egyptian gold shop

Gold jewelry in Egypt is priced by weight: the gram price of the karat, plus a making charge per gram, plus VAT on the making charge only. A made-to-order piece follows the same rule, but its weight is only known once it is made.

So the customer pays a deposit, the shop writes down the estimated weight and the agreed prices, and the final amount is settled on collection with the real weight. A shop that writes these figures down avoids most arguments.

The example in plain words

Mr. Hany orders two 21K wedding bands of about 9 g at EGP 6,180.25 a gram with a making charge of EGP 90 a gram. With VAT on the making charge, the order comes to EGP 56,545.65. He pays a deposit of EGP 20,000, so EGP 36,545.65 is due on collection.

Mr. Karim orders an 18K name necklace of 6.5 g at EGP 5,276 a gram and EGP 180 of making charge: EGP 35,627.80. He has paid EGP 10,000 and then EGP 15,000, so EGP 10,627.80 is left. Mr. Ali's 5 g 21K ring comes to EGP 31,585.25, with EGP 26,585.25 due after a EGP 5,000 deposit.

Across the three orders the shop has EGP 123,758.70 of work on the books, has received EGP 50,000, and will collect EGP 73,758.70 when the pieces are handed over.

The calculation

Example A worked example

VAT on the making charge (example 14%): 14%

CustomerPieceWeight (g)Order priceDepositLater paymentsDue on collection
Example: Mr. HanyTwo 21K wedding bands9.00056,545.6520,000.000.0036,545.65
Example: Mr. Karim18K name necklace6.50035,627.8010,000.0015,000.0010,627.80
Example: Mr. Ali21K ring5.00031,585.255,000.000.0026,585.25
ResultValue
Total of all orders123,758.70
Total deposits and payments50,000.00
Due on collection73,758.70

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

Terms used on this sheet

Deposit
The amount a customer pays up front when ordering a piece (عربون). It is taken off the price on collection.
Making charge
The fee for the work, charged per gram of the piece (مصنعية). It is quoted separately from the gold price.
Name necklace
A chain with a name cut out in gold, a common made-to-order piece in Egypt.

Step by step with the sheet

  1. The order: The customer, the piece, the karat and the estimated weight.
  2. The agreement: The price per gram and the making charge you agreed.
  3. The deposit: The amount paid up front, and any payment after it.
  4. What is due: The sheet works out the order price and the balance.
  5. Collection: Type the real weight when the piece is ready.

The sheet is free: Customer orders and deposits (Excel and PDF), or try it online with today's prices.

Frequently asked questions

Does the sheet fix the price for the customer?

No. Whether you fix the price on the day of the order or charge the price on the day of collection is your shop's policy. The sheet uses whatever you type in "Agreed price per gram".

The exact weight is not known before the piece is made. What do I type?

Type the estimated weight. When the piece is finished, type the real weight, and the price and the amount due are worked out again.

Can I print a receipt for the customer?

The PDF has a table you can fill in by hand, and you can print the customer's line from the Excel file.

Why is VAT only on the making charge?

In Egypt, VAT of 14% is charged on the making charge, not on the gold itself. The sheet keeps the rate in a cell you can change.

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.