Store Credit Ledger Excel
A digital ledger that automatically calculates, per customer, the credit extended, the amount paid, the remaining balance and the number of days overdue.
How to keep a customer credit ledger in Excel
Every entry in a credit ledger (veresiye, selling to customers on a tab) must have five pieces of information: date, customer name and phone number, item purchased, amount and the promised payment date. When these five fields are filled in, collections speed up and disputes go away. A paper notebook gets lost and can't see the total; Excel or a mobile app shows your total receivables instantly.
The five fields the ledger needs
Date: when it was given. Name and phone: so you can send reminders. Item/description: the answer to "what did they buy?" — the most useful field in a dispute. Amount: the exact figure. Promised date: the starting point for follow-up.
A credit entry without a phone number is, more often than not, an entry you never collect.
Habits that speed up collections
A short reminder message the day before the due date noticeably raises the collection rate. Calling within the first 3 days after the payment date passes is far more effective than waiting two weeks.
Accept partial payments and record every payment in the ledger right away; customers keep paying as they see their debt going down.
Setting a limit
Set an upper limit for each customer (for example 2.000 ₺) and don't extend new credit once the limit is reached. A ledger without limits leaves your working capital out on the street within a few months.
Don't give a new customer a large amount of credit the first time; start small and see how they pay.
Moving from a paper notebook to digital
A paper notebook has three problems: it gets lost, it can't see the total, and it doesn't remind you of late payments. Excel solves all three; if you put the file in your cloud account, you can check it from your phone too.
If you need fast entry at the counter, a mobile credit-ledger app is more convenient: picking a customer and typing the amount takes a few seconds, and the app sends the reminder.
The legal side
A credit ledger is a private record in which you track your own receivables; it does not replace official books. You still need to document your sales with a receipt or invoice. For large amounts, getting a promissory note or a written acknowledgment of debt strengthens your hand if collection becomes a problem.
Frequently asked questions
Should I sell on credit?
For neighborhood shopkeepers, credit often means customer loyalty. The way to manage the risk isn't to refuse; it's to set limits, keep clean records and follow the due dates.
What can I do about a customer who doesn't pay?
First try a written reminder and an offer of partial payment. If that gets no result and the amount is high, you will need legal advice about enforcement proceedings; that's why detailed records matter.
Is it safe to keep the ledger on a phone?
A file kept in your cloud account is safer than a paper notebook that can get lost. Make sure two-step verification is turned on for your account.