Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Silver stock count calculator for a shop

Silver stock count calculator for a shop

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. This calculator is the same as the "Silver stock count for a shop" sheet. It runs in your browser and saves no data.

Settings and prices

Loading today's prices…

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

CategoryFineness (per thousand)PiecesWeight (g)Pure silver (g)Estimated valueDelete

Result

Who this calculator is for

This is the online version of the "Silver stock count for a shop" sheet, made for goldsmiths and shop owners. A table for counting silver stock: the category, the fineness, the number of pieces and the weight, the pure silver, the estimated value at today's buying price for 999 silver, and the totals.

The question it answers: How many silver pieces and grams do I have in each category, and what are they worth?

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.

Worked example

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

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total pieces203
Total weight (g)4,005.000
Total pure silver (g)3,763.825
Estimated value331,849.56

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Counting silver stock: pure silver and value by category.

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.

Related calculators

All calculators · All free sheets