- Qintar
- Free sheets
- Silver stock count for a shop
Silver stock count for a shop
Counting silver works like counting gold, only with different finenesses. This sheet adds up the categories and works out the pure silver and its estimated value at today's price.
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 price: The buying price for one gram of 999.
- The categories: The category, fineness, pieces and weight.
- The calculation: The pure silver and the value.
- The totals: Pieces, weight, pure silver and value.
- Check: Compare with your books.
Example The calculation with numbers
Buying price, 1 g of 999 silver (example): 88.08
| Category | Fineness (per thousand) | Pieces | Weight (g) | Pure silver (g) | Estimated value |
|---|---|---|---|---|---|
| Example: rings | 925 | 120 | 780.000 | 721.500 | 63,613.33 |
| Example: chains | 925 | 60 | 1,150.000 | 1,063.750 | 93,788.89 |
| Example: sets | 925 | 15 | 1,275.000 | 1,179.375 | 103,983.33 |
| Example: bars | 999 | 8 | 800.000 | 799.200 | 70,464.00 |
| Result | Value |
|---|---|
| Total pieces | 203 |
| Total weight (g) | 4,005.000 |
| Total pure silver (g) | 3,763.825 |
| Estimated value | 331,849.56 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Pure silver = weight × fineness ÷ 1000.
- Estimated value = pure silver ÷ 0.999 × the buying price of 1 g of 999 (a gram of 999 holds 0.999 g of pure silver; an estimate without the making charge).
Terms used on this sheet
- Fineness
- The silver content in parts per thousand, stamped on the piece: 999 or 925 are the most common.
- Pure silver
- The silver inside a piece: weight × fineness ÷ 1000.
- Buying price
- The price at which a shop buys silver. Stock is valued at this price because it is what the metal would fetch.
Read more
- Counting silver stock: pure silver and value by categoryA step-by-step guide with a worked example.
- Silver stock count calculator for a shopThe same sheet online, with today's prices.
Frequently asked questions
Does the value include the making charge?
No. The value covers the silver only, scaled by its fineness against the 999 price.
Why divide by 0.999?
Because the price you type is for one gram of 999 silver, which holds 0.999 g of pure silver. The sheet turns the pure silver into grams of 999, then multiplies by the price.
Is there a sheet for pricing silver?
Yes: "Pricing silver pieces in the shop".
What do 925 and 999 mean?
Parts of silver per thousand. 999 is almost pure silver, used for bars; 925 is 92.5% silver, the usual fineness for jewelry, with other metals added for strength.
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?