Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Staff sales and commission

Staff sales and commission

Free sheet for goldsmiths and shop owners · How many grams did each salesperson sell, and what is their 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.

Download PDF138 KBDownload Excel61 KB

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.

Preview of the first page of the "Staff sales and commission" sheet, with the table and the worked example

How to use it

  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.

Example The calculation with numbers

SalespersonPieceGrams soldMaking charge income (without VAT)CommissionCommission so far, this salesperson
Example: Mohamed21K chain10.0001,000.0050.0050.00
Example: Ahmed18K ring4.000600.0030.0030.00
Example: Mohamed21K bracelet22.0002,640.00110.00160.00
Example: AhmedTwo 21K wedding bands9.000810.0040.5070.50
ResultValue
Total grams45.000
Total making charge income5,050.00
Total commission230.50
Commission as a share of making charge income4.6%

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

The calculation

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

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

All free sheets