- Qintar
- Free sheets
- Craftsman account: gold out, work in and wages
Craftsman account: gold out, work in and wages
Every gram that goes out to a craftsman has to come back: as finished work, as scrap, or as a loss within the agreed allowance. This sheet keeps each job order on one line and compares the loss with the allowance you agreed.
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
- Record the order: The number, the craftsman, the karat and the gold handed over.
- When it comes back: The weight of the finished work and of the scrap or filings returned.
- The agreement: The allowance % and the wage per gram for each order.
- The loss: The sheet works it out and compares it with the allowance.
- The wages: Weight of the work received × wage per gram.
Example The calculation with numbers
| Job order | Craftsman | Karat | Gold handed over (g) | Work received (g) | Scrap / filings returned (g) | Loss (g) | Loss above allowance (g) | Wages (EGP) | Status |
|---|---|---|---|---|---|---|---|---|---|
| Example: 501 | Example: Master Hassan | 21 | 200.000 | 192.400 | 5.500 | 2.100 | 0.000 | 6,734.00 | Within allowance |
| Example: 502 | Example: Master Hassan | 18 | 60.000 | 57.100 | 1.200 | 1.700 | 0.500 | 3,426.00 | Above allowance |
| Example: 503 | Example: Master Reda | 21 | 150.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.00 | Still with the craftsman |
| Result | Value |
|---|---|
| Total handed over | 410.000 |
| Total received | 249.500 |
| Loss above allowance | 0.500 |
| Total wages | 10,160.00 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Loss = gold handed over − work received − scrap and filings returned.
- Allowance = gold handed over × the agreed allowance %. Anything above it is "Above allowance".
- Wages = weight of the work received × wage per gram.
Terms used on this sheet
- Craftsman
- The goldsmith who makes pieces to order for a shop or workshop (صنايعي). In the example, craftsmen carry the title "master" (معلم).
- Allowance
- The loss percentage agreed in advance (السماح). Loss within it is accepted; anything above it is settled between you.
- Filings
- Gold dust and shavings from filing and polishing (رايش), collected and returned because they are still gold.
Read more
- Craftsman accounts in a gold workshop: loss and allowanceA step-by-step guide with a worked example.
- Craftsman account: loss, allowance and wagesThe same sheet online, with today's prices.
Frequently asked questions
What allowance should I agree?
You agree it with the craftsman, and it varies with the kind of work. The sheet does not suggest a figure, and the ones in the example are illustrations.
Are wages paid on the gold handed over or on the work received?
In the sheet they are paid on the weight of the work received. If your agreement is different, change the formula in the wages column.
What about an order that has not come back yet?
Leave the work received empty or zero, and the status shows "Still with the craftsman".
Why is there always some loss?
Melting, filing and polishing each take away a little gold. Part of it comes back as filings and scrap; the rest is the loss the allowance is meant to cover.
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
- End-of-day cash close for a gold shopDoes the cash in the drawer match what should be there, or is there a gap?
- Credit sales book: what each customer owesHow much does each customer owe, how much have they paid, and what is left?
- Scrap gold and refining: from scrap to pure goldHow many grams of pure gold are in my scrap, and how much comes back after refining?