# Casting batch: gold in, gold out and the loss

> Free Excel and PDF sheet for casting batches in a gold workshop: gold in, pieces out, sprues returned, the loss against your allowance, and the average.

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

---

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

![Preview of the first page of the "Casting batch: gold in, gold out and the loss" sheet, with the table and the worked example](https://qintar.app/en/sheets/workshop-casting-batch.png)

## 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

| 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 batch](https://qintar.app/en/articles/gold-casting-loss.html)A step-by-step guide with a worked example.
- [Casting loss calculator: each batch and its allowance](https://qintar.app/en/tools/workshop-casting-batch.html)The 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.

[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

- [Customer orders and deposits](https://qintar.app/en/sheets/shop-orders-deposits.html)What does each order cost, how much has the customer paid, and what is still due?
- [Customer repairs: weight in and weight out](https://qintar.app/en/sheets/shop-repairs-log.html)Did the piece go back to the customer at the same weight? And what does the repair cost?
- [Display stock: pieces and weight by category](https://qintar.app/en/sheets/shop-inventory-by-category.html)How many pieces and grams do I have in each category and karat, and what are they worth?

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