- Qintar
- Calculators
- Staff commission calculator for a gold shop
Staff commission calculator for a gold shop
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.
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
- 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.
Worked example
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| 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% |
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
- 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.
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
- Cash close calculator: count the drawer and compareDoes the cash in the drawer match what should be there, or is there a gap?
- Credit book: each customer's balance after every entryHow much does each customer owe, how much have they paid, and what is left?
- Scrap and refining calculator: how much pure gold?How many grams of pure gold are in my scrap, and how much comes back after refining?
- Wholesaler account: balance in pure gold and making chargeHow many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- Gold shop monthly profit calculatorHow much did the shop make this month after expenses?