# Filings and sweepings: how much gold came back?

> Free Excel and PDF sheet for a gold workshop's filings and sweepings: weight sent, lab purity, expected vs returned pure gold, the fee and the net value.

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

---

Free sheet for goldsmiths and shop owners · The filings and sweepings we sent to the lab: how much should come back, and how much actually did?

Filings, floor sweepings and wash water all hold gold that comes back through refining. This sheet records each batch and compares the pure gold returned with what the lab's test said to expect.

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

![Preview of the first page of the "Filings and sweepings: how much gold came back?" sheet, with the table and the worked example](https://qintar.app/en/sheets/workshop-dust-recovery.png)

## How to use it

1. **The batch:** The type and the weight sent.
2. **The test:** The purity the lab measured.
3. **What came back:** The pure gold returned and the fee.
4. **Compare:** The expected gold and the difference.
5. **The value:** At today's price, minus the fee.

## Example The calculation with numbers

Buying price, 1 g of 24K (example): 7,009.37

| Batch | Type | Weight sent (g) | Lab purity (per thousand) | Expected pure gold (g) | Pure gold returned (g) | Difference (g) | Net value |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Example: October | Filings | 42.000 | 610 | 25.620 | 25.400 | −0.220 | 176,692.21 |
| Example: October | Floor sweepings | 1,800.000 | 9 | 16.200 | 15.900 | −0.300 | 110,606.54 |
| Example: November | Filings | 38.500 | 640 | 24.640 |  |  |  |

| Result | Value |
| --- | --- |
| Expected pure gold (all batches) | 66.460 |
| Expected from the batches returned | 41.820 |
| Pure gold actually returned | 41.300 |
| Difference (returned − expected) | −0.520 |
| Total net value | 287,298.76 |

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

## The calculation

- Expected pure gold = weight sent × the purity the lab measured ÷ 1000.
- Difference = pure gold returned − expected (once it is returned).
- Net value = returned ÷ 0.999 × the 24K buying price − returned × the lab fee per gram.

## Terms used on this sheet

- **Filings:** Gold dust and shavings from filing and polishing (رايش), collected at the bench.
- **Floor sweepings:** Dust swept from the workshop floor, which holds fine gold particles (تراب).
- **Purity per thousand:** A lab result in parts per thousand: 610 means 61% of the weight is gold.

## Read more

- [Workshop filings and sweepings: did the lab return your gold?](https://qintar.app/en/articles/gold-dust-recovery.html)A step-by-step guide with a worked example.
- [Filings and sweepings calculator: expected vs returned](https://qintar.app/en/tools/workshop-dust-recovery.html)The same sheet online, with today's prices.

## Frequently asked questions

**Where does the purity figure come from?**

From the lab's test of a sample. The sheet does not estimate purity; it uses the lab's figure.

**What does a negative difference mean?**

That less came back than the test suggested. Ask the lab how they calculate and what loss rate they apply.

**How much is the lab fee?**

Whatever you agree with the lab. The figure in the example is an illustration.

**Why is floor dust worth sending?**

Because gold dust settles everywhere in a workshop. Even at a low purity, a large weight of sweepings can hold many grams of pure gold, as the example shows.

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/)
