Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Credit book: each customer's balance after every entry

Credit book: each customer's balance after every entry

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. This calculator is the same as the "Credit sales book: what each customer owes" sheet. It runs in your browser and saves no data.

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

CustomerNoteOwed (credit sale)PaidCustomer balance after this entryDelete

Result

Who this calculator is for

This is the online version of the "Credit sales book: what each customer owes" sheet, made for goldsmiths and shop owners. A book that records credit sales and payments for each customer, works out the balance after every entry, and adds up everything customers owe the shop.

The question it answers: How much does each customer owe, how much have they paid, and what is left?

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.

Worked example

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total credit sales42,700.00
Total paid30,500.00
Owed to you by customers12,200.00

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Selling gold on credit: keeping a clear customer book.

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.

Related calculators

All calculators · All free sheets