- Qintar
- Free sheets
- Gold shop monthly profit: income and expenses
Gold shop monthly profit: income and 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.
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
- Income: The making charges without VAT, the gold margin and any other income.
- Expenses: One line per expense, with its amount for the month.
- Working days: The number of days the shop was open.
- Net profit: Income minus expenses, and its share of income.
- 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
| Expense | Amount for the month | Share of expenses |
|---|---|---|
| Example: rent | 25,000.00 | 30.5% |
| Example: salaries | 45,000.00 | 54.9% |
| Example: electricity and water | 3,500.00 | 4.3% |
| Example: insurance and security | 4,000.00 | 4.9% |
| Example: packaging and bags | 1,500.00 | 1.8% |
| Example: other expenses | 3,000.00 | 3.7% |
| Result | Value |
|---|---|
| Total income | 154,000.00 |
| Total expenses | 82,000.00 |
| Net profit | 72,000.00 |
| Net profit as a share of income | 46.8% |
| Expenses per working day | 3,153.85 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Income = making charges (without VAT) + gold margin + any other income.
- Net profit = income − total expenses.
- Expenses per day = expenses ÷ working days: what must come in every working day just to cover costs.
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
- A gold shop's monthly profit: finding your real netA step-by-step guide with a worked example.
- Gold shop monthly profit calculatorThe same sheet 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.
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?