Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Wholesaler account: weight, making charge and payments

Wholesaler account: weight, making charge and payments

Free sheet for goldsmiths and shop owners · How many grams of pure gold and how many pounds of making charge do I owe the wholesaler?

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.

Download PDF142 KBDownload Excel62 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 "Wholesaler account: weight, making charge and payments" sheet, with the table and the worked example

How to use it

  1. Record deliveries: The note, the karat, the weight and the making charge per gram.
  2. Record payments: Gold by weight and karat, cash, or both on the same line.
  3. Pure gold: The sheet turns every weight into pure gold so that karats add up.
  4. The balance: After every line: pure gold you owe and making charge you owe.
  5. 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

NoteKaratWeight received (g)Making charge per gramPaid in gold (g)Paid in cash (EGP)Gold balance (pure)Making charge balance (EGP)
Example: chains received21250.00060.00218.75015,000.00
Example: paid in scrap21120.000113.75015,000.00
Example: making charge paid2110,000.00113.7505,000.00
Example: rings received1880.000110.00173.75013,800.00
Example: paid in gold21100.0005,000.0086.2508,800.00
ResultValue
Pure gold you owe86.250
Equals 24K (g)86.336
Making charge you owe (EGP)8,800.00
Total in EGP at the valuation price613,963.33

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

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

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

All free sheets