# Gold sale invoice: gold, making charge and VAT

> Free Excel and PDF gold sale invoice for several pieces: the gold at the price for its karat, the making charge, 14% VAT on it, and the total due.

Source: https://qintar.app/en/sheets/shop-sale-invoice.html
Language: English
قنطار (Qintar)، qintar.app

---

Free sheet for goldsmiths and shop owners · Exactly how much will the customer pay for these pieces?

The customer has chosen several pieces with different karats and making charges, and wants to know what they will pay and why. This invoice shows, for each piece, the gold, the making charge and the VAT.

[Download PDF143 KB](https://qintar.app/en/sheets/shop-sale-invoice.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-sale-invoice.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/shop-sale-invoice.html).

![Preview of the first page of the "Gold sale invoice: gold, making charge and VAT" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-sale-invoice.png)

## How to use it

1. **The prices:** Today's selling price per gram for each karat.
2. **VAT and discount:** The VAT on the making charge and any discount.
3. **The pieces:** One line per piece with its karat, weight and making charge.
4. **The details:** The gold, the making charge and the VAT for each piece.
5. **The total:** What the customer pays.

## Example The calculation with numbers

Selling price, 1 g of 24K (example): 7,032.37 · Selling price, 1 g of 21K (example): 6,180.25 · Selling price, 1 g of 18K (example): 5,276.00 · VAT on the making charge: 14% · Discount on the making charge (example): 0%

| Piece | Karat | Weight (g) | Making charge per gram | Gold | Making charge | VAT | Total |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Example: ring | 21 | 4.350 | 180.00 | 26,884.09 | 783.00 | 109.62 | 27,776.71 |
| Example: chain | 18 | 6.200 | 220.00 | 32,711.20 | 1,364.00 | 190.96 | 34,266.16 |
| Example: gold pound | 21 | 8.000 | 60.00 | 49,442.00 | 480.00 | 67.20 | 49,989.20 |

| Result | Value |
| --- | --- |
| Total weight (g) | 18.550 |
| Gold | 109,037.29 |
| Making charge | 2,627.00 |
| VAT on the making charge | 367.78 |
| Total due from the customer | 112,032.07 |

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

## The calculation

- Gold = weight × the selling price per gram for the piece's karat.
- Making charge = weight × making charge per gram × (1 − discount).
- VAT = making charge × 14%: VAT applies to the making charge only, not to the gold.
- Total = gold + making charge + VAT.

## Terms used on this sheet

- **Making charge:** The fee for the work on a piece, charged per gram (مصنعية). It is shown apart from the gold on an Egyptian invoice.
- **VAT:** Value added tax of 14% in Egypt, charged on the making charge only.
- **Gold pound:** A gold coin of 8 g of 21K (جنيه ذهب), sold alongside jewelry and bars.
- **Selling price:** The price per gram at which the shop sells gold, set for each karat.

## Read more

- [A gold sale invoice: showing gold, making charge and VAT](https://qintar.app/en/articles/gold-sale-invoice.html)A step-by-step guide with a worked example.
- [Gold sale invoice: gold, making charge and VAT](https://qintar.app/en/tools/shop-sale-invoice.html)The same sheet online, with today's prices.

## Frequently asked questions

**What exactly is VAT charged on?**

VAT of 14% is charged on the making charge only, not on the price of the gold.

**Can this be an official invoice?**

The sheet works out and explains the amount to the customer. If your shop is registered in Egypt's e-invoice or e-receipt system, the official receipt comes from that system.

**Why is the making charge on a gold pound lower?**

Coins and bars usually carry a lower making charge than jewelry. Type the making charge you actually take on each piece.

**Why is the gold priced by karat?**

Each karat holds a different share of pure gold, so Egyptian shops quote a separate price per gram for 24K, 21K and 18K. The sheet takes the price that matches each piece.

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

- [Buying used gold from customers: a daily log](https://qintar.app/en/sheets/shop-used-gold-buying.html)On average, what did I pay today for each gram of pure gold in the used gold I bought?
- [Selling on installments: payment, mark-up and balance](https://qintar.app/en/sheets/shop-installment-sales.html)If I sell on installments, what is the monthly payment, and how much will the customer pay in the end?
- [Zakat for a gold shop: the base and the nisab](https://qintar.app/en/sheets/shop-zakat.html)How much is the shop's zakat this year?

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