# Craftsman account: gold out, work in and wages

> Free Excel and PDF sheet for a gold workshop's craftsman account: gold out, work in, scrap returned, loss against the agreed allowance, and wages.

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

---

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 KB](https://qintar.app/en/sheets/workshop-job-orders.pdf)[Download Excel62 KB](https://qintar.app/en/sheets/workshop-job-orders.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/workshop-job-orders.html).

![Preview of the first page of the "Craftsman account: gold out, work in and wages" sheet, with the table and the worked example](https://qintar.app/en/sheets/workshop-job-orders.png)

## 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 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 allowance](https://qintar.app/en/articles/goldsmith-job-orders.html)A step-by-step guide with a worked example.
- [Craftsman account: loss, allowance and wages](https://qintar.app/en/tools/workshop-job-orders.html)The 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.

[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

- [End-of-day cash close for a gold shop](https://qintar.app/en/sheets/shop-cash-close.html)Does the cash in the drawer match what should be there, or is there a gap?
- [Credit sales book: what each customer owes](https://qintar.app/en/sheets/shop-credit-book.html)How much does each customer owe, how much have they paid, and what is left?
- [Scrap gold and refining: from scrap to pure gold](https://qintar.app/en/sheets/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?

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