- Qintar
- Free sheets
- Gold loss at each stage of manufacturing
Gold loss at each stage of manufacturing
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.
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
- The stage: The job, the stage and the karat.
- The weights: Before and after the stage.
- The allowance: The percentage you accept for that stage.
- The loss: The sheet works it out, with its percentage.
- 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 goesA step-by-step guide with a worked example.
- Gold loss calculator for each manufacturing stageThe 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.
More free sheets
- Gold savings goal: how much to put aside each monthI 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 itHow many grams of gold does the family own, who holds them, and what are they worth?
- Comparing gold bar prices between sellersBars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?