# Gold position calculator: net gold and net cash

> Gold position calculator: net gold and net cash. After everything owed to me and everything I owe, what is my net gold and net cash? Free, in your browser.

Source: https://qintar.app/en/tools/shop-gold-position.html
Language: English
قنطار (Qintar)، qintar.app

---

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. This calculator is the same as the ["Gold position: is the shop long in gold or in cash?" sheet](https://qintar.app/en/sheets/shop-gold-position.html). It runs in your browser and saves no data.

## Who this calculator is for

This is the online version of the "Gold position: is the shop long in gold or in cash?" sheet, made for goldsmiths and shop owners. A sheet that brings every item together: gold you hold or are owed (stock, with a craftsman, with customers), gold you owe (to the wholesaler, to customers), and cash both ways. It shows the net pure gold, the net cash, and the total at today's price.

The question it answers: After everything owed to me and everything I owe, what is my net gold and net cash?

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

## Worked example

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

With the example figures in the table above (the rows marked "Example"), the calculator gives:

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

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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

Want to keep your work? [Download the sheet as Excel or PDF](https://qintar.app/en/sheets/shop-gold-position.html). For a step-by-step explanation: [A gold shop's position: finding net gold and net cash](https://qintar.app/en/articles/gold-shop-position.html).

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

## Related calculators

- [Cash close calculator: count the drawer and compare](https://qintar.app/en/tools/shop-cash-close.html)Does the cash in the drawer match what should be there, or is there a gap?
- [Credit book: each customer's balance after every entry](https://qintar.app/en/tools/shop-credit-book.html)How much does each customer owe, how much have they paid, and what is left?
- [Scrap and refining calculator: how much pure gold?](https://qintar.app/en/tools/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?
- [Wholesaler account: balance in pure gold and making charge](https://qintar.app/en/tools/shop-wholesaler-account.html)How many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- [Gold shop monthly profit calculator](https://qintar.app/en/tools/shop-monthly-profit.html)How much did the shop make this month after expenses?

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