Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Credit sales book: what each customer owes

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 KBDownload Excel60 KB

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.

Preview of the first page of the "Credit sales book: what each customer owes" sheet, with the table and the worked example

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

CustomerNoteOwed (credit sale)PaidCustomer balance after this entry
Example: Mr. Mahmoud21K wedding band (invoice 101)24,500.0010,000.0014,500.00
Example: Mr. Sami18K chain (invoice 102)18,200.005,000.0013,200.00
Example: Mr. MahmoudInstallment0.005,000.009,500.00
Example: Mr. SamiInstallment0.006,000.007,200.00
Example: Mr. MahmoudInstallment0.004,500.005,000.00
ResultValue
Total credit sales42,700.00
Total paid30,500.00
Owed to you by customers12,200.00

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

The calculation

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

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.

More free sheets

All free sheets