Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Casting batch: gold in, gold out and the loss

Casting batch: gold in, gold out and the loss

Free sheet for goldsmiths and shop owners · How much gold did this casting batch lose, and is it within the allowance?

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.

Download PDF136 KBDownload Excel61 KB

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.

Preview of the first page of the "Casting batch: gold in, gold out and the loss" sheet, with the table and the worked example

How to use it

  1. The batch: The number, the karat and the gold that went in.
  2. After casting: The weight of the pieces and of the sprues and tree returned.
  3. The allowance: The percentage your workshop accepts.
  4. The loss: The sheet works it out, with its percentage.
  5. Follow up: The average loss across all batches.

Example The calculation with numbers

BatchKaratGold in (g)Pieces out (g)Sprues and tree returned (g)Loss (g)Loss %Status
Example: C-0121500.000318.400179.1002.5000.50%Within allowance
Example: C-0218300.000201.20096.9001.9000.63%Above allowance
Example: C-0321450.000290.000157.6002.4000.53%Within allowance
ResultValue
Total gold in1,250.000
Total loss6.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

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

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

All free sheets