Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Craftsman account: gold out, work in and wages

Craftsman account: gold out, work in and wages

Free sheet for goldsmiths and shop owners · How much gold did the craftsman take and return? Is the loss within the allowance? What are the 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.

Download PDF145 KBDownload Excel62 KB

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.

Preview of the first page of the "Craftsman account: gold out, work in and wages" sheet, with the table and the worked example

How to use it

  1. Record the order: The number, the craftsman, the karat and the gold handed over.
  2. When it comes back: The weight of the finished work and of the scrap or filings returned.
  3. The agreement: The allowance % and the wage per gram for each order.
  4. The loss: The sheet works it out and compares it with the allowance.
  5. The wages: Weight of the work received × wage per gram.

Example The calculation with numbers

Job orderCraftsmanKaratGold handed over (g)Work received (g)Scrap / filings returned (g)Loss (g)Loss above allowance (g)Wages (EGP)Status
Example: 501Example: Master Hassan21200.000192.4005.5002.1000.0006,734.00Within allowance
Example: 502Example: Master Hassan1860.00057.1001.2001.7000.5003,426.00Above allowance
Example: 503Example: Master Reda21150.0000.0000.0000.0000.0000.00Still with the craftsman
ResultValue
Total handed over410.000
Total received249.500
Loss above allowance0.500
Total wages10,160.00

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

The calculation

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

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

All free sheets