Customer Account Tracking Excel
A statement table that tracks the debit–credit balance per customer or supplier account across all transactions and gives due-date warnings.
Customer Credit Ledger (Veresiye) Excel Template
The credit ledger Excel template (veresiye defteri, the tab book small shops keep for customers who buy on credit) is a ready-made file that replaces the paper notebook and keeps the customer name, phone, amount owed, payments made and remaining balance in a single table. It automatically counts the days overdue once the promised payment date has passed, and turns the row green when the debt is settled. It is designed for grocers, supermarkets, butchers, greengrocers, hardware stores and small shopkeepers.
Free download
Excel (.xlsx) · formulas, drop-down lists and colored alerts built in · no membership required.
📄 28 KB · .xlsx🧮 Formulas ready🔓 No password, no watermark💳 Free
What columns are in the template?
| Column | What it does |
|---|---|
| Date | The day the goods were given on credit. |
| Customer Name / Phone | Who owes the money, and a phone number for reminders. |
| Item Taken / Description | What was given on credit; the most useful column when there is a dispute. |
| Credit Amount | The total amount owed. |
| Paid | The amount you have collected so far; for payments in installments, update this cell. |
| Remaining Debt | Automatic: Credit Amount − Paid. |
| Promised Payment | The date the customer promised to pay. |
| Days Overdue | Automatic: counts how many days late it is if the promised date has passed. |
| Status | Automatic: PAID (green), OVERDUE (red) or OPEN (yellow). |
How to use it
- Download the file and delete the sample rows.
- Open one row for each credit sale; be sure to enter the customer's phone number.
- Update the "Paid" cell as you receive partial payments; the remaining debt drops automatically.
- Enter the promised payment date; once it has passed, the overdue counter starts.
- On the "Summary" sheet, see the total money you have out on the street and the number of overdue accounts.
Who is it for?
- Grocers, supermarkets, butchers, greengrocers, bakeries
- Hardware stores, general stores, feed dealers
- Tea houses, restaurants and other small neighborhood businesses
- Small wholesalers who sell on terms to neighborhood shopkeepers
Frequently asked questions
Is it legal to keep a credit ledger?
The record you keep to track your own receivables is up to you. However, this ledger does not replace official accounting records; you still need to document your sales with receipts or invoices.
What happens if a customer denies the debt?
Filling in the description column in detail and writing the date and amount makes things easier for you. For large amounts, getting a promissory note or a written document is the safest option. Give a document when you take payment, too: the payment received receipt template prints the amount paid and the remaining debt in two copies, one staying with the customer and one with you.
Can I check it from my phone?
If you put the file on Google Drive or OneDrive, you can view and edit it from your phone. For quick entries at the counter, a mobile credit ledger app is more convenient.
How do I track a customer who has more than one debt?
Enter each debt as a separate row and write the customer name the same way each time. When you pick that name in the filter, you see all their debts and the total.
How many customers can I use the template for?
The formulas are set up for 300 rows and can easily be extended. If you have hundreds of open accounts, a program that can send reminders will save you time.
Related templates
Income and Expense Table Excel
Totals income and expenses by category; calculates VAT, the grand total and net profit/loss automatically.
Daily Cash Book
Keeps a day-by-day record of cash going into and out of the cash box; automatically finds the difference between the end-of-day count and the book.
Invoice Tracking Excel
Brings issued and received invoices, VAT, collections and overdue receivables together in a single table.
Last updated: September 25, 2026
Search terms: credit ledger excelcustomer credit tracking templatedebt tracking excelshopkeeper credit ledger