Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Gold shop monthly profit: income and expenses

Gold shop monthly profit: income and expenses

Free sheet for goldsmiths and shop owners · How much did the shop make this month after expenses?

Big sales do not always mean a big profit. This sheet sets the month's income against the expenses and shows the net profit, its share of income, and how much the shop must bring in every working day just to cover its costs.

Download PDF130 KBDownload Excel60 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 "Gold shop monthly profit: income and expenses" sheet, with the table and the worked example

How to use it

  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.

Example The calculation with numbers

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.

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% 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.

Read more

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.

More free sheets

All free sheets