# Selling on installments: payment, mark-up and balance

> Free Excel and PDF sheet for a gold shop selling on installments: the monthly payment from the price, down payment, months and mark-up, and what is left.

Source: https://qintar.app/en/sheets/shop-installment-sales.html
Language: English
قنطار (Qintar)، qintar.app

---

Free sheet for goldsmiths and shop owners · If I sell on installments, what is the monthly payment, and how much will the customer pay in the end?

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

[Download PDF136 KB](https://qintar.app/en/sheets/shop-installment-sales.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-installment-sales.xlsx)

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](https://qintar.app/en/tools/shop-installment-sales.html).

![Preview of the first page of the "Selling on installments: payment, mark-up and balance" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-installment-sales.png)

## How to use it

1. **The price:** Today's price of the piece, with the making charge and VAT.
2. **The down payment:** What the customer pays now.
3. **Months and mark-up:** The number of months and the monthly mark-up rate you set.
4. **The table:** The month numbers 1, 2, 3 and so on.
5. **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 total](https://qintar.app/en/articles/gold-installment-sales.html)A step-by-step guide with a worked example.
- [Installment sale calculator: payment and total](https://qintar.app/en/tools/shop-installment-sales.html)The 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.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Buying used gold from customers: a daily log](https://qintar.app/en/sheets/shop-used-gold-buying.html)On 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 nisab](https://qintar.app/en/sheets/shop-zakat.html)How much is the shop's zakat this year?
- [Break-even: how many grams to sell each month?](https://qintar.app/en/sheets/shop-break-even.html)How many grams must I sell each month to cover the shop's costs?

[All free sheets](https://qintar.app/en/sheets/)
