Qintar logoQintar
  1. Qintar
  2. Guides
  3. A gold shop's monthly profit: finding your real net

A gold shop's monthly profit: finding your real net

How much did the shop make this month after expenses?

A gold shop's profit comes from two main sources: the making charge, and the difference between the price at which it sells gold and what that gold cost. Both must be counted without the VAT that is passed on to the tax authority.

Fixed expenses such as rent and salaries are paid whether the month was good or not. That is why "expenses per working day" is useful: it is the least that must come in every day.

The share of each expense shows where the money goes. If one line takes half of all expenses, that is the first place to look.

Save a copy every month and compare. One month on its own says little; month against month shows the direction.

Why VAT stays out of income

In Egypt, VAT of 14% is charged on the making charge only, not on the value of the gold. The shop collects it from the customer and pays it to the tax authority, so it passes through the till without belonging to the shop.

If you count it as income, the month looks better than it was. The sheet asks for the making charge income without VAT for that reason.

The example in plain words

The shop earns EGP 96,000 in making charges and EGP 58,000 of gold margin: EGP 154,000 of income. Expenses come to EGP 82,000, so the net profit is EGP 72,000, or 46.8% of income.

Salaries are the largest expense at 54.9% of the total, then rent at 30.5%. Over 26 working days the shop spends EGP 3,153.85 a day, so that is what it must bring in daily before it makes any profit.

The calculation

Example A worked example

Making charge income for the month, without VAT (example): 96,000.00 · Gold margin, selling price minus cost (example): 58,000.00 · Other income (example): 0.00 · Working days in the month (example): 26

ExpenseAmount for the monthShare of expenses
Example: rent25,000.0030.5%
Example: salaries45,000.0054.9%
Example: electricity and water3,500.004.3%
Example: insurance and security4,000.004.9%
Example: packaging and bags1,500.001.8%
Example: other expenses3,000.003.7%
ResultValue
Total income154,000.00
Total expenses82,000.00
Net profit72,000.00
Net profit as a share of income46.8%
Expenses per working day3,153.85

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

Terms used on this sheet

Making charge
The fee for the work on a piece, charged per gram (مصنعية). In Egypt VAT of 14% is charged on the making charge only, not on the gold.
Gold margin
The difference between the selling price of the gold sold and what it cost the shop.
Working day
A day the shop was open. Dividing the expenses by them gives the daily cost the shop must cover.

Step by step with the sheet

  1. Income: The making charges without VAT, the gold margin and any other income.
  2. Expenses: One line per expense, with its amount for the month.
  3. Working days: The number of days the shop was open.
  4. Net profit: Income minus expenses, and its share of income.
  5. Compare: Save a copy each month and compare.

The sheet is free: Gold shop monthly profit: income and expenses (Excel and PDF), or try it online with today's prices.

Frequently asked questions

Why is the making charge counted without VAT?

The VAT you collect on the making charge is not your income: you pass it on to the tax authority. So income is counted without it.

How is the gold margin worked out?

It is the difference between your selling price and the cost of the gold you sold during the month. If you use the piece pricing or day book sheets, you can add it up from them.

Does this replace an accountant?

No. It is a simple monthly check. Taxes and official accounts are for your accountant.

Where does a gold shop's income come from?

Mainly from two places: the making charge on each piece, and the margin between the price the shop sells gold at and what that gold cost it. The sheet keeps them apart.

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.