# Sales commission in a gold shop: working it out clearly

> How to work out salespeople's commission in a gold shop: grams sold, making charge income, commission per gram or as a percentage, with an example.

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

---

How many grams did each salesperson sell, and what is their commission?

A clear commission prevents arguments at the end of the month. The first step: every sale is recorded under the name of the person who made it, day by day.

There are two common ways to work it out: an amount for every gram sold, or a percentage of the making charge income. The sheet accepts both, and the choice is yours.

Basing commission on the making charge rather than the selling price ties it to the work, not to moves in the gold price that have nothing to do with the salesperson's effort.

The total commission as a share of making charge income is worth watching: if it grows quickly, review the method.

## Why the making charge is the natural base

In an Egyptian gold shop the selling price of a piece has two parts: the gold, priced by the gram at the day's rate, and the making charge per gram for the work. The gold part rises and falls with the market whatever the salesperson does.

The making charge is the shop's own income from the sale, before 14% VAT is added to it. That is why the sheet asks for the making charge income without VAT: the VAT is passed on to the tax authority and is not the shop's money.

## The example in plain words

Mohamed is paid EGP 5 for every gram he sells. He sells a 10 g 21K chain (EGP 1,000 of making charge) for a commission of EGP 50, then a 22 g bracelet (EGP 2,640 of making charge) for EGP 110. His total is EGP 160.

Ahmed is paid 5% of the making charge. An 18K ring with EGP 600 of making charge earns him EGP 30, and two wedding bands with EGP 810 earn EGP 40.50, for a total of EGP 70.50.

Across 45 g and EGP 5,050 of making charge income, the shop pays EGP 230.50 in commission, or 4.6% of that income.

## The calculation

- Commission = grams × commission per gram + making charge income × commission %.
- Commission so far = the sum of this salesperson's commissions from the start of the month to this line.
- How commission is paid, and at what rate, is your decision: the sheet calculates what you type.

## Example A worked example

| Salesperson | Piece | Grams sold | Making charge income (without VAT) | Commission | Commission so far, this salesperson |
| --- | --- | --- | --- | --- | --- |
| Example: Mohamed | 21K chain | 10.000 | 1,000.00 | 50.00 | 50.00 |
| Example: Ahmed | 18K ring | 4.000 | 600.00 | 30.00 | 30.00 |
| Example: Mohamed | 21K bracelet | 22.000 | 2,640.00 | 110.00 | 160.00 |
| Example: Ahmed | Two 21K wedding bands | 9.000 | 810.00 | 40.50 | 70.50 |

| Result | Value |
| --- | --- |
| Total grams | 45.000 |
| Total making charge income | 5,050.00 |
| Total commission | 230.50 |
| Commission as a share of making charge income | 4.6% |

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

## Terms used on this sheet

- **Making charge:** The fee for the work on a piece, charged per gram (مصنعية). In Egypt VAT of 14% applies to it, so the sheet counts it without VAT.
- **Commission:** The amount a salesperson earns on their sales, in whatever form the owner sets.
- **Running total:** A total that grows line by line, here kept separately for each salesperson.

## Step by step with the sheet

1. **The sale:** The salesperson, the piece, the grams and the making charge income.
2. **The commission:** Pounds per gram, or a percentage of the making charge.
3. **The calculation:** The commission on each sale.
4. **Per person:** Each salesperson's total up to their latest sale.
5. **Month end:** The total, and its share of making charge income.

**The sheet is free:** [Staff sales and commission](https://qintar.app/en/sheets/shop-staff-sales.html) (Excel and PDF), or [try it online](https://qintar.app/en/tools/shop-staff-sales.html) with today's prices.

## Frequently asked questions

**What is the usual commission?**

There is no single figure. It is the shop owner's decision. The sheet does not suggest a rate, and the figures in the example are illustrations.

**Why base it on the making charge and not the selling price?**

Most of the selling price is the value of the gold, which moves with the market. The making charge is the work the salesperson sells. If you prefer another base, change the formula.

**Can I keep a whole month in one file?**

Yes, it has 40 lines. If you need more, copy the last line down.

**Why must each name be written the same way?**

The running total adds up by name. "Mohamed" and "Mohammed" would be two different people to the sheet.

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)
