Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Silver stock count for a shop

Silver stock count for a shop

Free sheet for goldsmiths and shop owners · How many silver pieces and grams do I have in each category, and what are they worth?

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.

Download PDF134 KBDownload Excel60 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 "Silver stock count for a shop" sheet, with the table and the worked example

How to use it

  1. The price: The buying price for one gram of 999.
  2. The categories: The category, fineness, pieces and weight.
  3. The calculation: The pure silver and the value.
  4. The totals: Pieces, weight, pure silver and value.
  5. Check: Compare with your books.

Example The calculation with numbers

Buying price, 1 g of 999 silver (example): 88.08

CategoryFineness (per thousand)PiecesWeight (g)Pure silver (g)Estimated value
Example: rings925120780.000721.50063,613.33
Example: chains925601,150.0001,063.75093,788.89
Example: sets925151,275.0001,179.375103,983.33
Example: bars9998800.000799.20070,464.00
ResultValue
Total pieces203
Total weight (g)4,005.000
Total pure silver (g)3,763.825
Estimated value331,849.56

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

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

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

All free sheets