# Gold loss at each stage of manufacturing | Free sheet

> Free Excel and PDF sheet for gold loss at each stage of manufacturing: weight before and after each stage, the loss and its %, against your allowance.

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

---

# Gold loss at each stage of manufacturing

Free sheet for goldsmiths and shop owners · At which stage does the gold loss happen: casting, filing or polishing?

The total loss on a job is one figure, but the useful question is where it happens. This sheet weighs the work before and after each stage and tells you which stage loses the most.

[Download PDF134 KB](https://qintar.app/en/sheets/workshop-process-wastage.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/workshop-process-wastage.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-process-wastage.html).

![Preview of the first page of the "Gold loss at each stage of manufacturing" sheet, with the table and the worked example](https://qintar.app/en/sheets/workshop-process-wastage.png)

## How to use it

1. **The stage:** The job, the stage and the karat.
2. **The weights:** Before and after the stage.
3. **The allowance:** The percentage you accept for that stage.
4. **The loss:** The sheet works it out, with its percentage.
5. **Compare:** Within the allowance or above it.

## Example The calculation with numbers

| Job | Stage | Weight before (g) | Weight after (g) | Loss (g) | Loss % | Status |
| --- | --- | --- | --- | --- | --- | --- |
| Example: bracelets 610 | Filing and finishing | 318.400 | 316.900 | 1.500 | 0.47% | Within allowance |
| Example: bracelets 610 | Soldering | 316.900 | 316.600 | 0.300 | 0.09% | Within allowance |
| Example: bracelets 610 | Polishing | 316.600 | 315.400 | 1.200 | 0.38% | Above allowance |

| Result | Value |
| --- | --- |
| Total loss (g) | 3.000 |

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

## The calculation

- Loss = weight before the stage − weight after it.
- Loss % = loss ÷ weight before.
- If the loss is greater than weight before × allowance, the stage is "Above allowance".

## Terms used on this sheet

- **Loss:** Gold that leaves the work during a stage and is not recovered at once (الفاقد).
- **Allowance:** The loss percentage you accept for a stage (السماح). Anything above it is worth a closer look.
- **Filings:** Gold dust and shavings from filing and polishing (رايش). They are collected and refined, so they are not truly lost.

## Read more

- [Gold loss at each manufacturing stage: finding where it goes](https://qintar.app/en/articles/gold-wastage-by-stage.html)A step-by-step guide with a worked example.
- [Gold loss calculator for each manufacturing stage](https://qintar.app/en/tools/workshop-process-wastage.html)The same sheet online, with today's prices.

## Frequently asked questions

**What allowance should each stage have?**

That comes from your workshop's experience. The sheet suggests no figures, and the ones in the example are illustrations.

**Do the filings collected count as loss?**

Filings that are collected and sent for refining are not lost. Record them in the filings and sweepings sheet so you know how much comes back.

**Why weigh after every stage?**

So you know which stage needs fixing, instead of searching through the whole job.

**Does the karat change the calculation?**

No, the loss is in grams of the alloy you are working. The karat is recorded so you can compare jobs of the same karat with each other.

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

- [Gold savings goal: how much to put aside each month](https://qintar.app/en/sheets/gold-goal-planner.html)I want to reach a set number of grams in a set time. How much should I save each month?
- [Family gold register: every piece and who owns it](https://qintar.app/en/sheets/family-gold-register.html)How many grams of gold does the family own, who holds them, and what are they worth?
- [Comparing gold bar prices between sellers](https://qintar.app/en/sheets/bar-prices-compare.html)Bars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?

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