- Qintar
- Free sheets
- Customer repairs: weight in and weight out
Customer repairs: weight in and weight out
Most disputes over repairs are about weight. This sheet records the weight of the piece in front of the customer when you take it in, the gold you add, and the weight when you hand it back, and tells you whether the weight checks out.
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.

How to use it
- Taking it in: Weigh the piece in front of the customer and type the weight and the receipt number.
- Gold added: If you add gold, type its weight and its price per gram.
- The fee: The repair fee you agreed.
- Handing it back: Weigh the piece again in front of the customer.
- The check: The sheet compares the weights and works out what is due.
Example The calculation with numbers
Accepted weight difference, g (example): 0.050
| Receipt no. | Piece and repair | Weight when received (g) | Gold added (g) | Weight when returned (g) | Difference (g) | Due from the customer | Weight check |
|---|---|---|---|---|---|---|---|
| Example: 1201 | Broken chain: soldered | 12.350 | 0.050 | 12.390 | −0.010 | 459.01 | Weight checks out |
| Example: 1202 | Ring: made smaller | 6.100 | 0.000 | 5.820 | −0.280 | 200.00 | Check the weight |
| Example: 1203 | Bracelet: new clasp | 18.400 | 0.000 | 0.000 | 0.000 | 250.00 | Not handed back yet |
| Result | Value |
|---|---|
| Total due from customers | 909.01 |
| Total repair fees | 600.00 |
| Total gold added (g) | 0.050 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Difference = weight when returned − weight when received − gold added. Within the accepted difference: "Weight checks out".
- Due from the customer = repair fee + gold added × its price per gram.
- Making a ring smaller lowers its weight: note the piece that was cut off, or count it as returned to the customer.
Terms used on this sheet
- Receipt
- The slip the shop gives the customer when it takes in a piece, with a number that matches the line in this book.
- Solder
- A small amount of gold used to join a broken chain or link (لحام). It adds weight, so it is charged.
- Accepted difference
- The small weight difference you treat as normal for your scale, in grams.
Read more
- Gold repairs for customers: recording the weightA step-by-step guide with a worked example.
- Repairs book: weight in, weight out and the feeThe same sheet online, with today's prices.
Frequently asked questions
How big a difference should I accept?
You set it, according to how precise your scale is and the kind of work. The figure in the example is an illustration.
Making a ring smaller lowers its weight. What do I do?
The gold that was cut off belongs to the customer. Note it and give it back, or settle it as you agree; the sheet shows the difference so you do not forget it.
Why weigh in front of the customer?
So that both figures are agreed from the start. That settles any argument at collection.
Why is a tiny difference normal?
Every scale has a limit to its precision, and polishing can take off a trace of gold. The accepted difference covers that; anything larger is flagged.
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
- Customer orders and depositsWhat does each order cost, how much has the customer paid, and what is still due?
- Display stock: pieces and weight by categoryHow many pieces and grams do I have in each category and karat, and what are they worth?
- Staff sales and commissionHow many grams did each salesperson sell, and what is their commission?