Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Orders and deposits calculator: what each customer owes

Orders and deposits calculator: what each customer owes

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. This calculator is the same as the "Customer orders and deposits" sheet. It runs in your browser and saves no data.

Settings and prices

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

CustomerPieceKaratWeight (g)Agreed price per gramMaking charge per gramDepositLater paymentsOrder priceDue on collectionDelete

Result

Who this calculator is for

This is the online version of the "Customer orders and deposits" sheet, made for goldsmiths and shop owners. A book for pieces made to order for a customer: the piece, the karat, the estimated weight and the agreed price, the deposit and any later payments, and what is left to pay on collection.

The question it answers: What does each order cost, how much has the customer paid, and what is still due?

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.

Worked example

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

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total of all orders123,758.70
Total deposits and payments50,000.00
Due on collection73,758.70

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Custom gold orders: recording the deal and the deposit.

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.

Related calculators

All calculators · All free sheets