- Qintar
- Calculators
- Credit book: each customer's balance after every entry
Credit book: each customer's balance after every entry
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.
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
- Record the entry: The customer's name, a note (the invoice number or the piece), and the amount owed or paid.
- Same name: Write the customer's name the same way every time, because the balance is added up by name.
- The balance: The customer balance column shows what is left to pay after this entry.
- The totals: Total credit sales, total paid, and what customers owe you.
- 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:
| Result | Value |
|---|---|
| Total credit sales | 42,700.00 |
| Total paid | 30,500.00 |
| Owed to you by customers | 12,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
- 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.
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
- Cash close calculator: count the drawer and compareDoes the cash in the drawer match what should be there, or is there a gap?
- Scrap and refining calculator: how much pure gold?How many grams of pure gold are in my scrap, and how much comes back after refining?
- Wholesaler account: balance in pure gold and making chargeHow many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- Gold shop monthly profit calculatorHow much did the shop make this month after expenses?
- Orders and deposits calculator: what each customer owesWhat does each order cost, how much has the customer paid, and what is still due?