Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Staff commission calculator for a gold shop

Staff commission calculator for a gold shop

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. This calculator is the same as the "Staff sales and commission" sheet. It runs in your browser and saves no data.

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

SalespersonPieceGrams soldMaking charge income (without VAT)Commission per gram (EGP)Commission % of making charge (%)CommissionCommission so far, this salespersonDelete

Result

Who this calculator is for

This is the online version of the "Staff sales and commission" sheet, made for goldsmiths and shop owners. A sheet for each salesperson's sales: the grams sold and the making charge income, the commission worked out the way you decide (pounds per gram and/or a percentage of the making charge), and a running total for each person.

The question it answers: How many grams did each salesperson sell, and what is their commission?

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.

Worked example

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total grams45.000
Total making charge income5,050.00
Total commission230.50
Commission as a share of making charge income4.6%

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Sales commission in a gold shop: working it out clearly.

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.

Related calculators

All calculators · All free sheets