- Qintar
- Free sheets
- Staff sales and commission
Staff sales and commission
Commission motivates salespeople, but working it out at the end of the month is painful if sales were not recorded as they happened. This sheet records every sale under the name of the person who made it and works out the commission the way you choose.
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.

How to use it
- The sale: The salesperson, the piece, the grams and the making charge income.
- The commission: Pounds per gram, or a percentage of the making charge.
- The calculation: The commission on each sale.
- Per person: Each salesperson's total up to their latest sale.
- Month end: The total, and its share of making charge income.
Example The calculation with numbers
| 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.
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.
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.
Read more
- Sales commission in a gold shop: working it out clearlyA step-by-step guide with a worked example.
- Staff commission calculator for a gold shopThe same sheet online, 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.
More free sheets
- Customer orders and depositsWhat does each order cost, how much has the customer paid, and what is still due?
- Customer repairs: weight in and weight outDid the piece go back to the customer at the same weight? And what does the repair cost?
- Display stock: pieces and weight by categoryHow many pieces and grams do I have in each category and karat, and what are they worth?