- Qintar
- Free sheets
- Pricing silver pieces in the shop
Pricing silver pieces in the shop
Pricing silver is like pricing gold, except that the making charge is a much larger share of the price. This sheet values the silver by its fineness, adds the loss, the making charge and its VAT and your margin, and rounds the 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 cost: The cost of 1 g of 999 silver, the VAT rate and the rounding.
- The piece: The fineness and the weight.
- The extras: The loss, the making charge and the margin.
- The price: The rounded price and the price per gram.
- The tag: Write the price on the piece.
Example The calculation with numbers
Cost of 1 g of 999 silver (example): 88.08 · VAT on the making charge, as on your invoices (example): 14% · Round to the nearest, EGP (example): 5
| Piece | Fineness per thousand | Weight (g) | Silver value | Making charge | VAT on making charge | Rounded price | Price per gram |
|---|---|---|---|---|---|---|---|
| Example: 925 ring | 925 | 8.000 | 652.44 | 360.00 | 50.40 | 1,150 | 143.75 |
| Example: 925 chain | 925 | 20.000 | 1,631.11 | 600.00 | 84.00 | 2,510 | 125.50 |
| Example: 999 bar | 999 | 100.000 | 8,808.00 | 600.00 | 84.00 | 9,670 | 96.70 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Silver value = weight × fineness ÷ 999 × cost of 1 g of 999 (an estimate by ratio).
- Price = silver value + loss + making charge + VAT on the making charge + margin.
- Rounded price = ROUND(price ÷ step) × step, and price per gram = rounded price ÷ weight.
Terms used on this sheet
- Fineness
- The silver content in parts per thousand: 999 is almost pure silver; 925 is 92.5% silver, with other metals added for strength.
- Making charge
- The fee for the work, per gram (مصنعية). On silver it is often a large part of the price.
- Margin
- The shop's markup on the silver value, as a percentage you set.
- Rounding
- Bringing the price to the nearest EGP 5 or 10 (or whatever step you choose) for a clear price tag.
Read more
- Pricing silver pieces: fineness, making charge, marginA step-by-step guide with a worked example.
- Silver piece pricing calculator for shopsThe same sheet online, with today's prices.
Frequently asked questions
Why divide by 999?
Because the cost you type is for a gram of 999 silver. A 925 piece holds less silver in that proportion, so this is an estimate by ratio.
What VAT rate applies to the making charge?
Type the rate on your invoices. The 14% in the example is an illustration, as on the gold sheets.
What loss and margin should I type?
Those are your shop's decisions. The sheet does not suggest figures, and the examples are illustrations.
Why round the price?
A round figure is easier to read on a price tag. The sheet then works out the price per gram after rounding, so you see what each gram really sells for.
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
- Customer orders and depositsWhat does each order cost, how much has the customer paid, and what is still due?
- Customer repairs: weight in and weight outDid the piece go back to the customer at the same weight? And what does the repair cost?
- Display stock: pieces and weight by categoryHow many pieces and grams do I have in each category and karat, and what are they worth?