Free · no sign-up
Free customer credit book Excel template
In this template every purchase on credit and every payment is one row: date, customer, type and amount. The “Customers” sheet works out each customer's total credit, what they have paid, what is still owed and the date of the last movement, marks those who still owe as “Owes” and shows your total receivables.
Inside the file
- AhmetOwes
- Credit
- ₺940.00
- Paid
- ₺500.00
- Owed
- ₺440.00
- Last movement
- Yesterday
- AyşeSettled
- Credit
- ₺320.00
- Paid
- ₺320.00
- Owed
- ₺0.00
- Last movement
- 9 days ago
- MehmetOwes
- Credit
- ₺1,890.00
- Paid
- ₺0.00
- Owed
- ₺1,890.00
- Last movement
- 3 days ago
- ZeynepOwes
- Credit
- ₺180.00
- Paid
- ₺0.00
- Owed
- ₺180.00
- Last movement
- 6 days ago
| Customer | Credit | Paid | Owed | Last movement | Status |
|---|---|---|---|---|---|
| Ahmet | ₺940.00 | ₺500.00 | ₺440.00 | Yesterday | Owes |
| Ayşe | ₺320.00 | ₺320.00 | ₺0.00 | 9 days ago | Settled |
| Mehmet | ₺1,890.00 | ₺0.00 | ₺1,890.00 | 3 days ago | Owes |
| Zeynep | ₺180.00 | ₺0.00 | ₺180.00 | 6 days ago | Owes |
- Total receivables
- ₺2,510.00
- Customers who owe
- 3
What's in the file?
- How to useFive steps and a privacy note.
- CreditDate, customer, type (Credit or Payment), amount and note; every credit and every payment is a row.
- CustomersPer customer: credit, paid, owed, last movement and status; your total receivables and how many still owe beside it.
How to use it
- Download and open the file; write the names of the customers you give credit to on the “Customers” sheet.
- Each time a customer takes goods on credit, add a row on the “Credit” sheet: date, customer, “Credit” and the amount.
- When a payment comes in, add a “Payment” row on the same sheet; what's owed goes down by itself.
- On the “Customers” sheet, see who still owes what and the last movement; your total receivables sit beside it.
- For privacy, don't put customers' phone numbers in this file and don't share it.
To open it in Google Sheets
- 1. Download the file.
- 2. Upload it to Google Drive.
- 3. Right-click the file → Open with → Google Sheets.
Frequently asked questions
How do you keep a customer credit book in Excel?
Every credit and every payment is a row: date, customer, type and amount. A customer's credits minus their payments is what they still owe. In this template the type is picked from a list, and the “Customers” sheet shows what's owed, the last movement and who still owes, by itself.
How do I move old debts over from a paper book?
Open one “Credit” row per customer with today's date and write “Earlier balance” in the note. You don't need to enter past purchases one by one; from now on you keep it row by row.
Is there a limit on customers?
Formulas are ready for 300 rows; for more, copy the last row down. In Çetele the credit book is free and has no customer limit.
How do I remind a customer what they owe?
Excel doesn't send messages; you write the amount yourself. In Çetele, “Remind on WhatsApp” on the customer's page opens a ready message with what they owe; you are the one who sends it.
More templates
- Stock tracking templateEnter purchases, use, sales and waste; stock and days left work themselves out.
- Recipe cost templateEnter ingredients and what you paid; cost per portion and a price come out.
- Appointment book templateEnter appointments, mark them done; weekly takings and no-show rate come out.
- Members and packages templateEnter members and the register; classes left, end date and “Ending soon” by themselves.
Have a good day at work!
In Çetele the credit book is free with no customer limit: record a credit in two taps, a payment comes off what's owed, it tells you on the customer's pay day, and you remind them on WhatsApp with a ready message.
