- Qintar
- Free sheets
- Casting batch: gold in, gold out and the loss
Casting batch: gold in, gold out and the loss
In casting, gold goes in and comes out as pieces, sprues and a tree, and the difference is the loss. This sheet records each batch, works out its loss and percentage, and compares it with the allowance you set for your workshop.
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 batch: The number, the karat and the gold that went in.
- After casting: The weight of the pieces and of the sprues and tree returned.
- The allowance: The percentage your workshop accepts.
- The loss: The sheet works it out, with its percentage.
- Follow up: The average loss across all batches.
Example The calculation with numbers
| Batch | Karat | Gold in (g) | Pieces out (g) | Sprues and tree returned (g) | Loss (g) | Loss % | Status |
|---|---|---|---|---|---|---|---|
| Example: C-01 | 21 | 500.000 | 318.400 | 179.100 | 2.500 | 0.50% | Within allowance |
| Example: C-02 | 18 | 300.000 | 201.200 | 96.900 | 1.900 | 0.63% | Above allowance |
| Example: C-03 | 21 | 450.000 | 290.000 | 157.600 | 2.400 | 0.53% | Within allowance |
| Result | Value |
|---|---|
| Total gold in | 1,250.000 |
| Total loss | 6.800 |
| Average loss % | 0.54% |
| Above allowance (g) | 0.100 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Loss = gold in − weight of the pieces − sprues and tree returned.
- Loss % = loss ÷ gold in. Allowance = gold in × the allowance % you type.
- Average loss = total loss ÷ total gold in.
Terms used on this sheet
- Casting
- Pouring molten gold into molds to make many pieces at once (صب).
- Sprues and tree
- The channels and the central stem that carry the molten gold into the molds. They are cut off after casting and go back to be melted.
- Allowance
- The loss percentage you accept for your workshop (السماح). Anything above it is flagged.
Read more
- Casting loss in a gold workshop, batch by batchA step-by-step guide with a worked example.
- Casting loss calculator: each batch and its allowanceThe same sheet online, with today's prices.
Frequently asked questions
What is a normal casting loss?
It varies with the workshop, the equipment and the casting method. The sheet does not suggest a figure: type the allowance from your own experience. The figures in the example are illustrations.
Do the returned sprues go into the next batch?
Usually they go back to be melted. Record them here as returned, and when a new batch goes in, count them with the gold going in.
Why an average loss?
One batch can be an exception. The average over a month shows how the workshop really performs.
Is the loss the same as gold that was stolen or wasted?
Not necessarily. Some gold is always lost in melting and casting. The allowance is the share you treat as normal; batches above it deserve a look at the heat, the molds and the scale.
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
- Customer orders and depositsWhat does each order cost, how much has the customer paid, and what is still due?
- Customer repairs: weight in and weight outDid the piece go back to the customer at the same weight? And what does the repair cost?
- Display stock: pieces and weight by categoryHow many pieces and grams do I have in each category and karat, and what are they worth?