- Qintar
- Calculators
- Orders and deposits calculator: what each customer owes
Orders and deposits calculator: what each customer owes
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.
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
- The order: The customer, the piece, the karat and the estimated weight.
- The agreement: The price per gram and the making charge you agreed.
- The deposit: The amount paid up front, and any payment after it.
- What is due: The sheet works out the order price and the balance.
- 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:
| Result | Value |
|---|---|
| Total of all orders | 123,758.70 |
| Total deposits and payments | 50,000.00 |
| Due on collection | 73,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
- Order price = weight × (agreed price per gram + making charge × (1 + VAT)).
- Due on collection = order price − deposit − later payments.
- When the piece is ready, type its real weight instead of the estimate, and the price and the amount due update.
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
- Cash close calculator: count the drawer and compareDoes the cash in the drawer match what should be there, or is there a gap?
- Credit book: each customer's balance after every entryHow much does each customer owe, how much have they paid, and what is left?
- Scrap and refining calculator: how much pure gold?How many grams of pure gold are in my scrap, and how much comes back after refining?
- Wholesaler account: balance in pure gold and making chargeHow many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- Gold shop monthly profit calculatorHow much did the shop make this month after expenses?