- Qintar
- Free sheets
- Wholesaler account: weight, making charge and payments
Wholesaler account: weight, making charge and payments
Dealing with a wholesaler usually means two currencies: gold by weight, and the making charge in Egyptian pounds. This sheet keeps the account in both: every delivery, every payment, and the balance after each entry.
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
- Record deliveries: The note, the karat, the weight and the making charge per gram.
- Record payments: Gold by weight and karat, cash, or both on the same line.
- Pure gold: The sheet turns every weight into pure gold so that karats add up.
- The balance: After every line: pure gold you owe and making charge you owe.
- Valuation: Type the 24K price if you want a total in pounds.
Example The calculation with numbers
24K price per gram, for valuation (example): 7,009.37
| Note | Karat | Weight received (g) | Making charge per gram | Paid in gold (g) | Paid in cash (EGP) | Gold balance (pure) | Making charge balance (EGP) |
|---|---|---|---|---|---|---|---|
| Example: chains received | 21 | 250.000 | 60.00 | 218.750 | 15,000.00 | ||
| Example: paid in scrap | 21 | 120.000 | 113.750 | 15,000.00 | |||
| Example: making charge paid | 21 | 10,000.00 | 113.750 | 5,000.00 | |||
| Example: rings received | 18 | 80.000 | 110.00 | 173.750 | 13,800.00 | ||
| Example: paid in gold | 21 | 100.000 | 5,000.00 | 86.250 | 8,800.00 |
| Result | Value |
|---|---|
| Pure gold you owe | 86.250 |
| Equals 24K (g) | 86.336 |
| Making charge you owe (EGP) | 8,800.00 |
| Total in EGP at the valuation price | 613,963.33 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Pure gold = weight × karat purity (21K = 0.875, 18K = 0.75, 24K = 0.999).
- Gold balance = total pure gold received − total pure gold paid.
- Making charge balance = the sum of (weight received × making charge per gram) − cash paid.
Terms used on this sheet
- Wholesaler
- The trader or workshop that supplies finished jewelry to retail shops (تاجر الجملة).
- Making charge
- The fee for the work, charged per gram of the piece (مصنعية). Between shop and wholesaler it is usually settled in pounds.
- Gold for gold
- Settling the gold part of an account by handing over gold, such as scrap, of the same pure weight instead of paying its price.
- Pure gold
- The gold inside an alloy: weight × purity. 21K is 0.875 pure and 18K is 0.75 pure.
Read more
- A wholesaler account in gold: weight, making charge, paymentsA step-by-step guide with a worked example.
- Wholesaler account: balance in pure gold and making chargeThe same sheet online, with today's prices.
Frequently asked questions
Does the sheet decide how I pay?
No. How you settle with the wholesaler (gold for gold, or cash) is between you; you record it. The sheet adds up what you type.
Why count in pure gold?
Because 100 g of 21K is not the same as 100 g of 18K. In pure gold the balance is one clear number.
Can I print it and give it to the wholesaler?
Yes. The account page is set up for printing, so you can go through it together line by line.
Why is the making charge a separate balance?
The gold part of the account is in grams and the making charge is in pounds. Kept apart, neither one changes when the gold price moves.
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
- End-of-day cash close for a gold shopDoes the cash in the drawer match what should be there, or is there a gap?
- Credit sales book: what each customer owesHow much does each customer owe, how much have they paid, and what is left?
- Scrap gold and refining: from scrap to pure goldHow many grams of pure gold are in my scrap, and how much comes back after refining?