Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Customer orders and deposits

Customer orders and deposits

Free sheet for goldsmiths and shop owners · What does each order cost, how much has the customer paid, and what is still due?

A piece made to order comes with an agreement: a price, an estimated weight and a deposit. This sheet puts the whole agreement on one line, works out the order price and what is still due, and updates by itself when you type the real weight of the finished piece.

Download PDF138 KBDownload Excel61 KB

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.

Preview of the first page of the "Customer orders and deposits" sheet, with the table and the worked example

How to use it

  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.

Example The calculation with numbers

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.

The calculation

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.

Read more

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.

More free sheets

All free sheets