# Selling gold on credit: keeping a clear customer book

> How to record credit sales and installments in a gold shop: one line per entry, the balance after each payment, and the total owed to you, with an example.

Source: https://qintar.app/en/articles/credit-sales-book.html
Language: English
قنطار (Qintar)، qintar.app

---

How much does each customer owe, how much have they paid, and what is left?

Selling on credit can win a customer, but without an orderly book it loses money. The first rule: every entry gets its own line, whether it is a sale or a payment, with a date and a note.

A running balance after each entry saves you from adding everything up again. When the customer comes in to pay, you look at the last line under their name and know at once what is left.

Write the note clearly: the invoice number, the piece and the karat. That protects you and the customer if there is a disagreement later.

And check the total every week. "Owed to you by customers" is an important figure for the shop: it is money you have earned but do not hold yet, and you need to know it when you plan your buying.

## Why the balance is in pounds, not grams

When you sell a piece on credit, the customer owes you a sum of money, so this book keeps the debt in Egyptian pounds. If the gold price moves next month, the amount owed does not change.

Some debts are agreed in grams instead, as with wholesalers. Those belong in a different book that counts pure gold, such as the wholesaler account sheet.

## The example in plain words

Mr. Mahmoud buys a 21K wedding band for EGP 24,500 and pays EGP 10,000, so he owes EGP 14,500. He then pays two installments of EGP 5,000 and EGP 4,500, and his balance falls to EGP 9,500 and then EGP 5,000.

Mr. Sami buys an 18K chain for EGP 18,200 and pays EGP 5,000, leaving EGP 13,200. One installment of EGP 6,000 brings him to EGP 7,200.

Across both customers the shop sold EGP 42,700 on credit and has been paid EGP 30,500, so EGP 12,200 is still owed to it: the two last balances, EGP 5,000 and EGP 7,200, added together.

## The calculation

- Customer balance = everything the customer owes − everything they paid (same name, up to this line).
- Owed to you = total credit sales − total paid.

## Example A worked example

| Customer | Note | Owed (credit sale) | Paid | Customer balance after this entry |
| --- | --- | --- | --- | --- |
| Example: Mr. Mahmoud | 21K wedding band (invoice 101) | 24,500.00 | 10,000.00 | 14,500.00 |
| Example: Mr. Sami | 18K chain (invoice 102) | 18,200.00 | 5,000.00 | 13,200.00 |
| Example: Mr. Mahmoud | Installment | 0.00 | 5,000.00 | 9,500.00 |
| Example: Mr. Sami | Installment | 0.00 | 6,000.00 | 7,200.00 |
| Example: Mr. Mahmoud | Installment | 0.00 | 4,500.00 | 5,000.00 |

| Result | Value |
| --- | --- |
| Total credit sales | 42,700.00 |
| Total paid | 30,500.00 |
| Owed to you by customers | 12,200.00 |

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

## Terms used on this sheet

- **Credit sale:** Selling a piece now and being paid later, in one payment or several (بالآجل).
- **Installment:** One of the agreed payments toward a credit sale (قسط).
- **Balance:** What the customer still owes after an entry: everything sold to them minus everything they paid.

## Step by step with the sheet

1. **Record the entry:** The customer's name, a note (the invoice number or the piece), and the amount owed or paid.
2. **Same name:** Write the customer's name the same way every time, because the balance is added up by name.
3. **The balance:** The customer balance column shows what is left to pay after this entry.
4. **The totals:** Total credit sales, total paid, and what customers owe you.
5. **Follow up:** Check the balances every week and call anyone who is behind.

**The sheet is free:** [Credit sales book: what each customer owes](https://qintar.app/en/sheets/shop-credit-book.html) (Excel and PDF), or [try it online](https://qintar.app/en/tools/shop-credit-book.html) with today's prices.

## Frequently asked questions

**Does the sheet add interest or late fees?**

No. It records only the amounts you type, with no interest or fees of any kind.

**Can I record the debt in grams instead of pounds?**

This sheet works in Egyptian pounds. If you deal in grams of gold, as shops do with wholesalers, use the wholesaler account sheet.

**What if I write a name two different ways?**

The balance splits between two names. Give each customer one fixed name, or add the last 4 digits of their phone number.

**Is this book a contract with the customer?**

No, it is your own record. Keep the invoice or agreement you give the customer, and write its number in the note column so you can find it.

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)
