Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Gold shop monthly profit calculator

Gold shop monthly profit calculator

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. This calculator is the same as the "Gold shop monthly profit: income and expenses" sheet. It runs in your browser and saves no data.

Settings and prices

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

ExpenseAmount for the monthShare of expensesDelete

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

  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.

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:

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

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

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

All calculators · All free sheets