# Gold trade journal: gain or loss? | Free sheet

> Free Excel and PDF gold trade journal: cost with the fee and VAT, realized gain or loss on closed trades, and open trades at today's buying price.

Source: https://qintar.app/en/sheets/gold-trade-journal.html
Language: English
قنطار (Qintar)، qintar.app

---

# Gold trade journal: gain or loss?

Free sheet for individuals · How much did I gain or lose on each gold trade I closed? And what are the ones I still hold worth?

If you buy and sell gold over time, it is hard to know from memory how much you really made. This sheet records every trade and keeps the realized result apart from the result on paper.

[Download PDF137 KB](https://qintar.app/en/sheets/gold-trade-journal.pdf)[Download Excel62 KB](https://qintar.app/en/sheets/gold-trade-journal.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/gold-trade-journal.html).

![Preview of the first page of the "Gold trade journal: gain or loss?" sheet, with the table and the worked example](https://qintar.app/en/sheets/gold-trade-journal.png)

## How to use it

1. **The purchase:** The grams, the price per gram you paid and the fee per gram.
2. **The sale:** The price per gram you sold at, and the deduction, if you sold.
3. **Today's price:** Today's buying price, to value what you still hold.
4. **The result:** Realized and paper results for each trade.
5. **The totals:** Total realized, total on paper and total cost.

## Example The calculation with numbers

VAT on the fee (example 14%): 14% · Today's buying price, same karat (example): 7,009.37

| Trade | Grams | Cost | Realized gain / loss | Paper gain / loss | % | Status |
| --- | --- | --- | --- | --- | --- | --- |
| Example: 10 g bar | 10.000 | 67,526.00 | 2,567.70 | 0.00 | 3.8% | Closed |
| Example: 5 g bar | 5.000 | 35,020.00 | 0.00 | 26.85 | 0.1% | Open |
| Example: 20 g bar | 20.000 | 145,052.00 | 0.00 | −4,864.60 | −3.4% | Open |

| Result | Value |
| --- | --- |
| Realized (closed trades) | 2,567.70 |
| On paper (open trades) | −4,837.75 |
| Total | −2,270.05 |
| Total cost | 247,598.00 |

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

## The calculation

- Cost = grams × (price per gram you paid + fee per gram × (1 + VAT)).
- Realized = grams × sale price × (1 − deduction) − cost (closed trades).
- On paper = grams × today's buying price − cost (open trades).

## Terms used on this sheet

- **Realized:** A gain or loss on a trade you have closed: you sold and were paid.
- **On paper:** A gain or loss on gold you still hold, at today's buying price. It changes every day until you sell.
- **Bar fee:** The fee per gram a shop charges on a gold bar, with 14% VAT on the fee only.
- **Deduction:** A percentage some shops take off when they buy back gold.

## Read more

- [A gold trade journal: realized gains versus paper gains](https://qintar.app/en/articles/gold-trades-journal.html)A step-by-step guide with a worked example.
- [Gold trade journal: realized and on paper](https://qintar.app/en/tools/gold-trade-journal.html)The same sheet online, with today's prices.

## Frequently asked questions

**Does the sheet tell me when to sell?**

No. It only works out the result of what you have done, and it does not predict prices.

**Why value open trades at the buying price?**

Because that is the price you would be paid if you sold today, so it is the most honest figure for what an open trade is worth.

**What if my trades are in different karats?**

The sheet has one valuation price. Split the trades over two copies, one per karat.

**Why does a trade bought today already show a small loss?**

You bought at the selling price and paid a fee and its VAT, while the trade is valued at the lower buying price. The price has to rise by that gap before the paper result turns positive.

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?
- [Display stock: pieces and weight by category](https://qintar.app/en/sheets/shop-inventory-by-category.html)How many pieces and grams do I have in each category and karat, and what are they worth?

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