Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Craftsman account: loss, allowance and wages

Craftsman account: loss, allowance and wages

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. This calculator is the same as the "Craftsman account: gold out, work in and wages" sheet. It runs in your browser and saves no data.

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

Job orderCraftsmanKaratGold handed over (g)Work received (g)Scrap / filings returned (g)Allowance % (agreed) (%)Wage per gramLoss (g)Loss %Loss above allowance (g)Wages (EGP)StatusDelete

Result

Who this calculator is for

This is the online version of the "Craftsman account: gold out, work in and wages" sheet, made for goldsmiths and shop owners. A sheet for job orders: the gold handed to the craftsman, the finished work received, what came back as scrap or filings, the loss compared with the allowance you agreed, and the wages.

The question it answers: How much gold did the craftsman take and return? Is the loss within the allowance? What are the wages?

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.

Worked example

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total handed over410.000
Total received249.500
Loss above allowance0.500
Total wages10,160.00

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

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Craftsman accounts in a gold workshop: loss and allowance.

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.

Related calculators

All calculators · All free sheets