- Qintar
- Free sheets
- Gold position: is the shop long in gold or in cash?
Gold position: is the shop long in gold or in cash?
A shop has gold in the window and with the craftsman, owes gold to the wholesaler, holds cash and owes cash. This sheet adds it all up and shows the net.
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 items: Everything you hold, are owed or owe, one line each.
- The gold: In grams of pure gold.
- The cash: In Egyptian pounds.
- The price: Today's buying price for 24K.
- The net: Net gold, net cash and the total.
Example The calculation with numbers
Buying price, 1 g of 24K (example): 7,009.37
| Item | Gold you hold or are owed (g pure) | Gold you owe (g pure) | Cash you hold or are owed | Cash you owe | Net of the item, EGP |
|---|---|---|---|---|---|
| Example: display and bars (from the stock count) | 1,347.200 | 9,452,475.74 | |||
| Example: scrap in the shop | 105.000 | 736,720.57 | |||
| Example: gold with the craftsman | 131.250 | 920,900.71 | |||
| Example: owed to the wholesaler (gold and making charge) | 219.500 | 11,800.00 | −1,551,896.81 | ||
| Example: safe and bank | 185,000.00 | 185,000.00 | |||
| Example: credit owed by customers | 17,800.00 | 17,800.00 |
| Result | Value |
|---|---|
| Net gold (g pure) | 1,363.950 |
| Net cash | 191,000.00 |
| Net gold in EGP | 9,570,000.21 |
| Total in EGP | 9,761,000.21 |
| Gold as a share of the total | 98.0% |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Net gold = total pure gold you hold or are owed − pure gold you owe.
- Net cash = cash you hold or are owed − cash you owe.
- Total = net gold ÷ 0.999 × the 24K buying price + net cash.
Terms used on this sheet
- Position
- What a shop holds and is owed, minus what it owes, kept separately for gold and for cash.
- Pure gold
- Weight × purity: 21K is 0.875 pure, 18K is 0.75 pure. Turning everything into pure gold lets karats add up.
- Wholesaler
- The trader or workshop that supplies jewelry to shops (تاجر الجملة). Shops often owe it gold as well as the making charge in cash.
Read more
- A gold shop's position: finding net gold and net cashA step-by-step guide with a worked example.
- Gold position calculator: net gold and net cashThe same sheet online, with today's prices.
Frequently asked questions
Why work in pure gold?
So that gold of different karats adds up to one figure.
Is this the shop's balance sheet?
No. It is a summary of the position only, not financial statements. See your accountant for anything official.
Where do the figures come from?
From the stock count, craftsman, wholesaler, credit book and cash sheets.
Why does the gold share matter?
The higher the share of gold in the total, the more a move in the gold price changes what the shop is worth. The price move sheet shows by how much.
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
- Gold savings goal: how much to put aside each monthI want to reach a set number of grams in a set time. How much should I save each month?
- Family gold register: every piece and who owns itHow many grams of gold does the family own, who holds them, and what are they worth?
- Comparing gold bar prices between sellersBars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?