# Credit sales book: what each customer owes | Free sheet

> Free Excel and PDF credit book for a gold shop: credit sales and payments per customer, the balance after each entry, and the total owed to you.

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

---

# Credit sales book: what each customer owes

Free sheet for goldsmiths and shop owners · How much does each customer owe, how much have they paid, and what is left?

If you let customers pay for a piece later, or in installments, a paper notebook gets messy fast. This sheet puts every sale and every payment on its own line, works out the customer's balance after it, and adds up what all customers owe you. The book is in Egyptian pounds: what a customer owes stays the same whatever the gold price does.

[Download PDF138 KB](https://qintar.app/en/sheets/shop-credit-book.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-credit-book.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-credit-book.html).

![Preview of the first page of the "Credit sales book: what each customer owes" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-credit-book.png)

## How to use it

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.

## Example The calculation with numbers

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

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

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

## Read more

- [Selling gold on credit: keeping a clear customer book](https://qintar.app/en/articles/credit-sales-book.html)A step-by-step guide with a worked example.
- [Credit book: each customer's balance after every entry](https://qintar.app/en/tools/shop-credit-book.html)The same sheet online, 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)

## More free sheets

- [End-of-day cash close for a gold shop](https://qintar.app/en/sheets/shop-cash-close.html)Does the cash in the drawer match what should be there, or is there a gap?
- [Scrap gold and refining: from scrap to pure gold](https://qintar.app/en/sheets/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?
- [Wholesaler account: weight, making charge and payments](https://qintar.app/en/sheets/shop-wholesaler-account.html)How many grams of pure gold and how many pounds of making charge do I owe the wholesaler?

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