# Display stock: pieces and weight by category

> Free Excel and PDF sheet for a gold shop's display stock: pieces and weight per category and karat, pure gold, average weight and value at today's price.

Source: https://qintar.app/en/sheets/shop-inventory-by-category.html
Language: English
قنطار (Qintar)، qintar.app

---

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 KB](https://qintar.app/en/sheets/shop-inventory-by-category.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/shop-inventory-by-category.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/shop-inventory-by-category.html).

![Preview of the first page of the "Display stock: pieces and weight by category" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-inventory-by-category.png)

## 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

| Category | Karat | Pieces | Total weight (g) | Pure gold (g) | Average weight per piece (g) | Value at the buying price |
| --- | --- | --- | --- | --- | --- | --- |
| Example: rings | 21 | 64 | 278.500 | 243.688 | 4.352 | 1,715,629.63 |
| Example: chains | 21 | 40 | 412.000 | 360.500 | 10.300 | 2,538,023.00 |
| Example: bracelets | 21 | 22 | 596.200 | 521.675 | 27.100 | 3,672,741.05 |
| Example: wedding bands | 18 | 30 | 162.000 | 121.500 | 5.400 | 851,958.00 |
| Example: bars | 24 | 12 | 95.000 | 94.905 | 7.917 | 665,890.15 |
| Example: gold pounds | 21 | 10 | 80.000 | 70.000 | 8.000 | 492,820.00 |

| Result | Value |
| --- | --- |
| Total pieces | 178 |
| 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 price | 9,937,061.83 |

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

## The calculation

- Pure gold = weight × karat purity (24K = 0.999, 21K = 0.875, 18K = 0.75).
- Average weight per piece = total weight ÷ number of pieces.
- Value = weight × today's buying price per gram of the same karat (without the making charge).

## 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

- [A gold shop's display stock: grams by category and karat](https://qintar.app/en/articles/gold-shop-inventory-summary.html)A step-by-step guide with a worked example.
- [Display stock calculator: pieces, weight and value per karat](https://qintar.app/en/tools/shop-inventory-by-category.html)The same sheet online, with today's prices.

## 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.

[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

- [Customer orders and deposits](https://qintar.app/en/sheets/shop-orders-deposits.html)What does each order cost, how much has the customer paid, and what is still due?
- [Customer repairs: weight in and weight out](https://qintar.app/en/sheets/shop-repairs-log.html)Did the piece go back to the customer at the same weight? And what does the repair cost?
- [Staff sales and commission](https://qintar.app/en/sheets/shop-staff-sales.html)How many grams did each salesperson sell, and what is their commission?

[All free sheets](https://qintar.app/en/sheets/)
