Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Gold position: is the shop long in gold or in cash?

Gold position: is the shop long in gold or in cash?

Free sheet for goldsmiths and shop owners · After everything owed to me and everything I owe, what is my net gold and net 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.

Download PDF141 KBDownload Excel60 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 "Gold position: is the shop long in gold or in cash?" sheet, with the table and the worked example

How to use it

  1. The items: Everything you hold, are owed or owe, one line each.
  2. The gold: In grams of pure gold.
  3. The cash: In Egyptian pounds.
  4. The price: Today's buying price for 24K.
  5. The net: Net gold, net cash and the total.

Example The calculation with numbers

Buying price, 1 g of 24K (example): 7,009.37

ItemGold you hold or are owed (g pure)Gold you owe (g pure)Cash you hold or are owedCash you oweNet of the item, EGP
Example: display and bars (from the stock count)1,347.2009,452,475.74
Example: scrap in the shop105.000736,720.57
Example: gold with the craftsman131.250920,900.71
Example: owed to the wholesaler (gold and making charge)219.50011,800.00−1,551,896.81
Example: safe and bank185,000.00185,000.00
Example: credit owed by customers17,800.0017,800.00
ResultValue
Net gold (g pure)1,363.950
Net cash191,000.00
Net gold in EGP9,570,000.21
Total in EGP9,761,000.21
Gold as a share of the total98.0%

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

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

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

All free sheets