# Customer orders and deposits | Free sheet

> Free Excel and PDF book for custom orders in a gold shop: piece, karat, weight, agreed price, deposit, payments and the amount due on collection.

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

---

# 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 KB](https://qintar.app/en/sheets/shop-orders-deposits.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/shop-orders-deposits.xlsx)

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](https://qintar.app/en/tools/shop-orders-deposits.html).

![Preview of the first page of the "Customer orders and deposits" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-orders-deposits.png)

## 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%

| Customer | Piece | Weight (g) | Order price | Deposit | Later payments | Due on collection |
| --- | --- | --- | --- | --- | --- | --- |
| Example: Mr. Hany | Two 21K wedding bands | 9.000 | 56,545.65 | 20,000.00 | 0.00 | 36,545.65 |
| Example: Mr. Karim | 18K name necklace | 6.500 | 35,627.80 | 10,000.00 | 15,000.00 | 10,627.80 |
| Example: Mr. Ali | 21K ring | 5.000 | 31,585.25 | 5,000.00 | 0.00 | 26,585.25 |

| Result | Value |
| --- | --- |
| Total of all orders | 123,758.70 |
| Total deposits and payments | 50,000.00 |
| Due on collection | 73,758.70 |

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

## 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.

## Read more

- [Custom gold orders: recording the deal and the deposit](https://qintar.app/en/articles/gold-orders-deposits.html)A step-by-step guide with a worked example.
- [Orders and deposits calculator: what each customer owes](https://qintar.app/en/tools/shop-orders-deposits.html)The same sheet 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.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Customer repairs: weight in and weight out](https://qintar.app/en/sheets/shop-repairs-log.html)Did the piece go back to the customer at the same weight? And what does the repair cost?
- [Display stock: pieces and weight by category](https://qintar.app/en/sheets/shop-inventory-by-category.html)How many pieces and grams do I have in each category and karat, and what are they worth?
- [Staff sales and commission](https://qintar.app/en/sheets/shop-staff-sales.html)How many grams did each salesperson sell, and what is their commission?

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