How to Track Customer Debts and Credit Sales in Your Nigerian Shop
Learn how to track customer debts and credit sales with credit limits, part payments, WhatsApp reminders and a debtor ledger, so you collect what you are owed.
By Ajinex Team · · 8 min read
In this article
- Why Nigerian shops sell on credit, and why that is fine
- Decide who gets credit, and how much
- Record every credit sale and every part payment
- How a debtor ledger works
- Age your debts
- Reminders that work, mostly on WhatsApp
- When to stop giving credit
- What software changes
- Frequently asked questions
- Next step
Every shop owner in Nigeria who has been in business for more than a year has a list of people who owe them money, and most of those lists live in a notebook, a phone, or somebody's head. Learning how to track customer debts properly is not about becoming hard-hearted; it is about making sure the credit you extend comes back.
Credit sales are not the problem. A wholesaler at Alaba or a provision store in Kano that refuses all credit will lose good customers to the shop next door. The problem is credit with no limit, no record of part payments, no reminders and no point at which you say "no more until you clear".
This guide sets out a system that works in a notebook and works better in software: how to decide who gets credit, how much, how to record every payment, when to remind, when to stop, and how a debtor ledger holds it all together.
Why Nigerian shops sell on credit, and why that is fine
Credit is woven into how trade works here. A restaurant buys tomatoes and pepper from the same market woman every morning and settles on Saturday. A retailer collects cartons from a distributor and pays when the goods have sold. A regular customer takes drugs from the chemist at month end and pays on the 27th when salary lands.
Done badly, credit quietly becomes the biggest "expense" in the business. A shop making ₦200,000 a month in profit with ₦600,000 sitting uncollected in the credit book is three months of profit away from having its own money.
The goal is not to stop selling on credit. The goal is to know, at any moment, exactly who owes what, since when, and whether you would give them more.
Decide who gets credit, and how much
Treat credit as a privilege you grant, not something customers assume.
Start every customer small
A new customer gets a small limit, say one week's typical purchase, and must clear it fully before the limit grows. You learn a lot about someone from how they handle their first ₦20,000.
Set a written credit limit per customer
Write the limit next to the customer's name. A reasonable rule of thumb for a trade customer is two to four weeks of their average purchases; for a retail customer, one month at most. If the balance reaches the limit, the next purchase is cash or nothing, and staff must not override that without the owner.
Know who they are
For anything beyond a few thousand Naira, record a full name, phone number (the one they actually use for WhatsApp), address or shop location, and where possible a second contact. A customer who objects to giving a phone number is telling you something.
Record every credit sale and every part payment
This is where notebooks fail. A credit sale is a normal sale in every way, except the payment is delayed. It must reduce stock, it must have a receipt, and it must be written against the right customer immediately.
Part payments are even more important to record properly, because they are where disputes start. "I paid you something last week" is not an entry. "₦15,000 received by transfer on 12 October, balance now ₦22,000" is.
For each payment record:
- Date and time
- Amount
- Method (cash, transfer, POS terminal, USSD)
- Which invoice or purchase it applies to, if the customer has several
- Who received it
- The new balance
Give the customer a receipt for every payment, even a small one. A receipt ends the argument before it begins. Software with credit sales built in prints the receipt, applies the payment to the right invoice, and updates the balance in one step, which is why a POS with credit support is worth having; see POS software for shops and supermarkets in Nigeria for what to look for.
How a debtor ledger works
A debtor ledger is a running account for each customer. One page per customer in a notebook, one tab per customer in a spreadsheet, or one customer record in software. Each line is either a sale (which increases what they owe) or a payment (which reduces it), and the balance is updated after every line.
| Date | Description | Sale (debit) | Payment (credit) | Balance |
|---|---|---|---|---|
| 1 Oct | 10 cartons Indomie, 5 cartons Peak milk, invoice 1041 | ₦185,000 | ₦185,000 | |
| 6 Oct | Transfer received | ₦100,000 | ₦85,000 | |
| 9 Oct | 4 cartons Golden Penny semovita, invoice 1058 | ₦52,000 | ₦137,000 | |
| 15 Oct | Cash received | ₦37,000 | ₦100,000 | |
| 22 Oct | Transfer received | ₦100,000 | ₦0 |
Three rules keep it honest:
- Nothing is written in the ledger that was not also recorded as a sale or receipt. The ledger is a view of the shop's transactions, not a separate book.
- The customer can see their own page on request. Transparency is your friend; most disputes are from customers who genuinely lost track.
- The total of all ledger balances is your total debtors figure, and it appears on your balance sheet as money owed to the business. If you use combined inventory and accounting software, this is automatic. Ajinex posts every credit sale and payment to the accounts and shows an outstanding balances view across all customers, so the debtors figure is always current without a separate reconciliation.
Age your debts
Not all debts are equal. ₦50,000 owed since Monday is fine. ₦50,000 owed since June is probably gone. Aging means grouping each customer's balance by how long it has been outstanding.
| Customer | Current (0-30 days) | 31-60 days | 61-90 days | Over 90 days | Total |
|---|---|---|---|---|---|
| Mama Ngozi Stores | ₦85,000 | ₦85,000 | |||
| Chukwudi Electronics | ₦40,000 | ₦60,000 | ₦100,000 | ||
| Alhaji Musa | ₦30,000 | ₦120,000 | ₦150,000 | ||
| Total | ₦125,000 | ₦60,000 | ₦30,000 | ₦120,000 | ₦335,000 |
Read the table from right to left. The "over 90 days" column is the one to worry about; realistically you will collect only part of it, and you should stop extending credit to anyone in it. The 31-60 column is where reminders earn their keep.
Do this every Friday. It takes ten minutes in a spreadsheet and no time at all in software that shows outstanding balances by age.
Reminders that work, mostly on WhatsApp
Nigerians run their business lives on WhatsApp, so that is where reminders go. The tone matters: firm, polite, specific, and never embarrassing in a group.
A simple ladder:
- Day the invoice is due: a short message with the amount, the invoice number and your account details. Attach the digital receipt or invoice. Many customers pay the same day simply because they were reminded.
- 7 days overdue: a second message, still polite, asking for a date they will pay. Get a date; a date is a commitment.
- On the promised date, if nothing arrives: a phone call, not a message. Calls get answered differently.
- 30 days overdue: credit stops. Say so plainly: "We will be glad to serve you on cash until the balance of ₦X is cleared." Most good customers respect this.
- 60 to 90 days: a visit if they are local, or a formal written demand if the amount is large. Offer a payment plan with dates. Part payments on a plan are better than nothing.
Send reminders from a business number, log every reminder and promise on the customer's ledger page, and make it easy to pay by putting your account details in every message.
When to stop giving credit
Have rules, so the decision is not personal and staff do not have to guess.
- Balance has reached the credit limit: cash only until it drops.
- Any amount over 30 days overdue: cash only until cleared.
- Two broken payment promises in a row: cash only for three months after clearing.
- A bounced or reversed transfer: cash only, permanently, unless the owner personally decides otherwise.
Stopping credit is not the same as stopping the relationship. Most customers keep buying for cash, and many clear their balance quickly once credit is paused, because they want it back.
When a debt is clearly not coming back, write it off in the books so your debtors figure and your profit stop lying to you. Keep chasing it if you like, but do not count it as an asset. If you want to understand how that write-off flows into your profit and loss, Accounting software for small businesses in Nigeria explains how a combined system handles it.
What software changes
The method above works on paper. Software makes it something you will actually keep doing.
- Every credit sale is recorded at the till like any other sale, so stock, receipt and customer balance update together.
- Credit limits are enforced at the point of sale; the cashier sees "limit reached" instead of guessing.
- Part payments are applied to the right invoice and the receipt prints immediately.
- The outstanding balances view shows every customer, their balance, and how old it is, without you adding anything up.
- The debtors total flows into your balance sheet automatically, and write-offs post to the right account.
Ajinex includes credit sales, per-customer limits, part payments and the debtors view on every plan, from ₦3,000 a month, with the accounting side built in. Wholesalers and distributors, who carry the heaviest credit books, may want to read Wholesale and distribution inventory software for traders in Nigeria for how it handles trade customers specifically.
Frequently asked questions
How do I track customer debts in a small shop?
Keep a debtor ledger with one page or record per customer, where every credit sale adds to the balance and every payment reduces it, with the new balance written after each line. Set a credit limit per customer, give a receipt for every payment, review the list weekly, and send reminders on WhatsApp as soon as a payment is due. Software does the same thing automatically from the point of sale.
What is a reasonable credit limit for a customer?
Start new customers with about one week of their typical purchases and increase it only after they have cleared in full a few times. For established trade customers, two to four weeks of average purchases is common; for retail customers, no more than a month. Write the limit down and enforce it at the till.
How should I record part payments from customers?
Record the date, amount, payment method, which invoice it applies to, who received it, and the new balance. Give the customer a receipt immediately, even for a small amount. The receipt and the ledger entry together are what settle disputes later.
When should I stop selling on credit to a customer?
When their balance reaches the agreed limit, when any amount is more than 30 days overdue, after two broken payment promises, or after a reversed or bounced payment. Make these rules known in advance so the decision is not personal, and keep serving the customer for cash.
Can inventory software handle credit sales and debtors?
Yes, if it is built for it. Look for credit sales at the point of sale, a credit limit per customer, part payments applied to specific invoices, an outstanding balances view with aging, digital receipts, and automatic posting of the debtors total to your accounts. Ajinex includes all of these on every plan.
Next step
Write down your current debtors this week, age them, and send the first round of reminders. Then put the system somewhere it will survive: start a 30-day free trial of Ajinex at the sign-up page, no card required, and see how credit sales and the debtors view work together on the Inventory and accounting software for Nigerian businesses, in one system page.
Ajinex Team
The people who build Ajinex, writing from what we learn supporting supermarkets, pharmacies, restaurants and wholesalers across Nigeria. Questions? Talk to us.