- Qintar
- Free sheets
- Selling on installments: payment, mark-up and balance
Selling on installments: payment, mark-up and balance
A customer wants to take the piece today and pay over several months? Before you agree, work out the installment, the total and what is left after each month, so the figures are clear to you and to the customer.
Notice: this sheet is a calculator only and not a fatwa. Scholars differ on selling gold in installments, so if you have a religious question, ask Dar al-Ifta or a fatwa authority you trust. The mark-up rate is yours to set and to agree with the customer.
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
- The price: Today's price of the piece, with the making charge and VAT.
- The down payment: What the customer pays now.
- Months and mark-up: The number of months and the monthly mark-up rate you set.
- The table: The month numbers 1, 2, 3 and so on.
- The result: The installment, the total and what is left after each month.
Example The calculation with numbers
Price of the piece today (example): 62,000.00 · Down payment (example): 20,000.00 · Number of months (example): 6 · Mark-up per month (example): 2.0%
| Month | Installment | Paid so far (with down payment) | Left for the customer to pay |
|---|---|---|---|
| 1 | 7,840.00 | 27,840.00 | 39,200.00 |
| 2 | 7,840.00 | 35,680.00 | 31,360.00 |
| 3 | 7,840.00 | 43,520.00 | 23,520.00 |
| 4 | 7,840.00 | 51,360.00 | 15,680.00 |
| 5 | 7,840.00 | 59,200.00 | 7,840.00 |
| 6 | 7,840.00 | 67,040.00 | 0.00 |
| Result | Value |
|---|---|
| Monthly installment | 7,840.00 |
| Mark-up on the balance | 5,040.00 |
| Total the customer pays | 67,040.00 |
| Mark-up as a share of the price | 8.1% |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Balance after the down payment = price − down payment.
- Mark-up = balance × monthly mark-up rate × number of months (a flat mark-up on the balance).
- Installment = (balance + mark-up) ÷ number of months.
- Left after each month = total − paid so far.
Terms used on this sheet
- Down payment
- The part of the price the customer pays on the day the piece is handed over (المقدم).
- Installment
- One of the equal monthly payments that follow (قسط).
- Flat mark-up
- An addition worked out on the starting balance for the whole period, rather than on what is left each month.
Read more
- Selling gold on installments: the payment and the totalA step-by-step guide with a worked example.
- Installment sale calculator: payment and totalThe same sheet online, with today's prices.
Frequently asked questions
Is the mark-up interest?
The sheet works out a flat mark-up on the balance after the down payment, at the rate you type. Scholars differ on selling gold in installments, so ask a fatwa authority you trust.
What if the gold price rises before the customer finishes paying?
The installment stays fixed at the agreed price. You hand over the gold today and are paid later, so if the price rises, that money will buy less gold. Keep that in mind when you set the down payment and the rate.
Where do I record the payments?
In the credit book sheet: one line for each installment paid, and the sheet shows the balance.
Does the mark-up compound month by month?
No. It is a flat percentage of the starting balance for each month, added once. In the example, 2% a month over 6 months gives a mark-up of EGP 5,040 on a balance of EGP 42,000.
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
- Buying used gold from customers: a daily logOn average, what did I pay today for each gram of pure gold in the used gold I bought?
- Zakat for a gold shop: the base and the nisabHow much is the shop's zakat this year?
- Break-even: how many grams to sell each month?How many grams must I sell each month to cover the shop's costs?