- Qintar
- Calculators
- Gold shop monthly profit calculator
Gold shop monthly profit calculator
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. This calculator is the same as the "Gold shop monthly profit: income and expenses" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "Gold shop monthly profit: income and expenses" sheet, made for goldsmiths and shop owners. A sheet that adds up the month's income (making charges, the gold margin and any other income), subtracts the expenses line by line, and shows the net profit, its share of income and the expenses per working day.
The question it answers: How much did the shop make this month after expenses?
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.
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
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| 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 |
This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.
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.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: A gold shop's monthly profit: finding your real net.
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.
Related calculators
- Cash close calculator: count the drawer and compareDoes the cash in the drawer match what should be there, or is there a gap?
- Credit book: each customer's balance after every entryHow much does each customer owe, how much have they paid, and what is left?
- Scrap and refining calculator: how much pure gold?How many grams of pure gold are in my scrap, and how much comes back after refining?
- Wholesaler account: balance in pure gold and making chargeHow many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- Orders and deposits calculator: what each customer owesWhat does each order cost, how much has the customer paid, and what is still due?