Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Display stock: pieces and weight by category

Display stock: pieces and weight by category

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

The stock in the display cases is the largest part of a gold shop's money. This sheet sums it up category by category: how many pieces and grams of each karat, the pure gold, and the value at today's price.

Download PDF145 KBDownload Excel61 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 "Display stock: pieces and weight by category" sheet, with the table and the worked example

How to use it

  1. The prices: Today's buying price per gram for each karat.
  2. The categories: One line per category and karat, with the number of pieces and the weight.
  3. The calculation: Pure gold, average weight per piece and value.
  4. The totals: Total pieces and weight for each karat.
  5. Compare: Check it against your stock count and books every month.

Example The calculation with numbers

Buying price, 1 g of 24K (example): 7,009.37 · Buying price, 1 g of 21K (example): 6,160.25 · Buying price, 1 g of 18K (example): 5,259.00

CategoryKaratPiecesTotal weight (g)Pure gold (g)Average weight per piece (g)Value at the buying price
Example: rings2164278.500243.6884.3521,715,629.63
Example: chains2140412.000360.50010.3002,538,023.00
Example: bracelets2122596.200521.67527.1003,672,741.05
Example: wedding bands1830162.000121.5005.400851,958.00
Example: bars241295.00094.9057.917665,890.15
Example: gold pounds211080.00070.0008.000492,820.00
ResultValue
Total pieces178
Total weight (g)1,623.700
Of which 21K (g)1,366.700
Of which 18K (g)162.000
Of which 24K (g)95.000
Total pure gold (g)1,412.268
Value at the buying price9,937,061.83

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

Display stock
The finished pieces in the shop's cases and window (المعروض), as opposed to scrap or gold at the workshop.
Pure gold
The gold inside an alloy: weight × purity. It lets different karats add up to one figure.
Gold pound
A coin of 8 g of 21K gold (جنيه ذهب), sold in Egypt alongside bars and jewelry.
Buying price
The price at which a shop buys gold. It is lower than the selling price that customers pay.

Read more

Frequently asked questions

Does the value include the making charge?

No. The value is at the buying price of the gold only, so you know what the metal you hold is worth. The making charge belongs in your pricing.

Does this replace a stock count?

No, it is a summary of the display stock. Counting the stock and matching it with the books is done in Qintar's gold stock count and loss sheet.

Why the average weight per piece?

It tells you about the kind of stock you carry. If the average weight of your rings rises or falls, that matters for your next purchases.

Why value at the buying price and not the selling price?

The buying price is what the gold would fetch if it were sold today. It is the cautious figure for what the stock is worth as metal.

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