Sonbola SONBOLA

Home / Guides / Customer debts

How do you track customer debts and reduce arrears?

Selling on credit brings in customers, but it may silently drain your capital. These are practical steps to adjust it.

Practical guide · 9 min read ·

In many stores, the debt problem does not appear suddenly, but rather accumulates slowly: a customer postpones payment for a week, a ledger that is not updated, a check that is bounced and not registered, and a representative who sells on credit to a customer who has exceeded his limit. When you start collecting, you discover that the amount is larger than you expected, that the customer is not satisfied with the number, and that at the same time you are required to pay your suppliers. Selling on credit is not a mistake in itself. The mistake is selling on credit without a system. The following steps will help you build this system, whether your debts are small or large.

1. Record every debt and payment as it occurs

A debt that is not recorded at the moment becomes a matter of dispute later, and a payment that is received without receipt is forgotten or double-counted. Make the rule clear to you and your employees: Do not release goods on credit without an invoice in the name of the customer, and do not receive payment without a receipt delivered to him. If the customer pays partly in cash and partly by check, record them on a single instrument with two lines.

Open for each future customer his own card before the first invoice, and record in it his phone number, the currency of dealing with him, his tax number if he is a merchant, and the price level that you agreed upon. A customer who purchases as a “cash customer” on the invoice cannot be asked for anything after a month.

If you still rely on a paper debt book, transfer current balances to a program once, and make the program your only reference after that.

Tip: When transferring balances from the ledger, ask each customer to confirm their balance, by call or text, so you start from an agreed-upon number.

2. Set a debt ceiling and repayment period for each customer

Credit limit It is the highest amount allowed for the customer's debt to reach, and Credit term It is the number of days you wait for it to be paid, such as 30 days from the date of the invoice. When determining them for each customer, look at:

  • The volume of the customer’s monthly purchases, and the extent of his previous payment regularity.
  • Nature of his work: A contractor or merchant who is waiting for collection from others may require a longer period.
  • Your ability to wait without your payment to your suppliers being affected; The duration of credit you grant should not exceed much the period granted by your supplier.

Start with a conservative ceiling for a new customer, raise it gradually as he commits, and review all ceilings once every three months. The most important thing is that the sales employee and the representative know this ceiling, and that deferred sales stop when it exceeds it, except with your approval, and not at the employee’s discretion. When the ceiling is registered in the customer’s card in the program, the employee does not need to save it or embarrass the customer.

3. Send account statements regularly

Many late payments are caused by the customer not knowing his exact balance, doubting it, or thinking that the last payment closed the account. Send to every indebted customer A detailed account statement at least once a month It shows each invoice with its date and number, each payment, and the balance after each transaction. A customer who is informed of his account has less objection and is quicker to pay, and the monthly statement reveals errors even though they are small: an invoice registered to the wrong customer, or a payment that was not recorded.

Choose a medium that they actually read. The printed statement delivered with the goods gets lost in the vehicle; As for a WhatsApp message or SMS containing the same statement, it remains on his phone and he can refer to it. Send the statement on a fixed date, such as the first of every month, so that the customer gets used to it and does not feel that he has been targeted by it.

4. Review your debt aging report each week

The total balance alone is not enough; A debt that is one week old is very different from a debt of the same value that is four months old. Debt aging report Each customer's debt is distributed into time periods according to the invoice date, so you know who is late and how long ago. If your credit term is 30 days, you can read the report like this:

Omar Al-Din What does it mean? What are you doing?
Up to 30 days A debt within the agreed upon period Regular follow-up only
From 31 to 60 days Late start A friendly reminder with your account statement
From 61 to 90 days Obvious lag Direct call, and temporarily stopping deferred sales
More than 90 days A debt at risk Meeting, and written agreement on scheduled payments

Allocate a fixed half hour to this report every week, and start from the last two rows. The longer the debt is due, the less chance there is of recovery. Also look at the trend: If the total of debts older than 60 days grows from one week to the next, the problem is with the sales policy, not with a specific customer.

5. Follow up on post-dated checks ahead of time

A post-dated check is not a guaranteed payment until it is cashed. So:

  • Record every incoming check immediately upon receipt, along with its due date, the name of the bank, and the name of the drawer, even if the drawer is not the customer himself.
  • Every week, review the checks that are due in the coming days, and remind their owners two or three days in advance.
  • If a check is returned, record its return immediately so that the amount is returned to the customer's balance, and stop accepting new checks from him until the issue is resolved.
  • If you return an incoming check to your supplier, keep a clear record of it, because its bounce will be up to you, and the supplier will demand it from you.

Also pay attention to the checks you issue: collect their due dates with the checks received in one list, organized by date, so that you know weeks in advance whether your collections will be enough to cover them.

6. Deal with each currency separately

In the Palestinian market, the customer buys in shekels, some items are priced in dollars, and some contractors pay in dinars. If you mix these currencies into one balance, you will never know how much it is actually worth to you. Agree with each futures customer on the currency of his account from the beginning, record it on his card, and when he pays in another currency, record the exchange rate you agreed upon on the instrument itself.

Ask your program for a statement of account showing the balance in the customer's currency, not a total converted at today's rate. A customer who owes you $1,000 should see $1,000 on his statement, no matter how much the exchange changes. If you buy from your supplier in dollars and sell in shekels, monitor the difference between the exchange rate on the day of purchase and the day of collection. Selling on credit for three months may eat up all of your profit margin if the exchange rate moves against you.

7. Follow a clear, gradual collection plan

When the steps are known in advance, collection becomes a routine task for any employee, not a personal encounter. Here is an example of a plan that you can modify to suit your business:

  1. Upon maturity: A friendly reminder with your account statement.
  2. After a week of delay: A telephone call to agree on a specific payment date, and the date is recorded.
  3. After a month of delay, or when the ceiling is exceeded: Stopping the credit sale until payment is made, while continuing the cash sale.
  4. After 2 months: A direct meeting, and a written agreement on scheduled payments on dates, preferably by post-dated checks.
  5. If all of this is not possible: Consult a lawyer or competent authority before taking any legal action, and make sure that your invoices and statements are signed or sent to the customer beforehand.

Maintain respect at every step; Most late customers want to pay, but need a reminder or arrangement. Distribute the task: the first message is sent by the employee, the call is made by the accountant or manager, and you attend the meeting.

8. Measure your collection speed each month

The indicator tells you Average collection period The number of days it takes on average to collect the price of your forward sales:

Average collection period = (Total customer debts today ÷ forward sales during the period) x number of days in the period

Example: If your total customer debt today is 12,000, and your forward sales in the last 90 days are 36,000, then your average collection period = (12,000 ÷ 36,000) x 90 = 30 days.

Compare the result with the length of credit you grant: If you grant 30 days and the average is 55 days, then the collection needs stronger follow-up, or the ceilings for some customers are higher than they should be. More important than the number itself is its trend from month to month: is it getting better or worse? Calculate it on the same day every month and record it, and you'll know within three months if your plan is working.

9. Ready-made reminder templates

Copy the following message for your first due reminder, and edit it as appropriate:

Hello [customer name], hope you are well.
We would like to remind you that your account balance with [store name] has reached [amount] as of [date], and [amount due] has been due from it.
We have attached the account statement for you to review, and we are happy for you to contact us to arrange the appropriate payment date.
Thank you for dealing with us.

Here is a second message after two weeks without a response, still polite but requesting a specific date:

Hello [customer name].
We have not received a response to the statement of account sent on [date], and the amount currently due is [amount due].
Please inform us of the payment date during this week, or call us at [phone number] if you have any notes on the statement.
With appreciation, [name of shop].

How does Sonbola help you with this?

In Sonbola, it opens a card for each customer in his currency, tax number, and pricing level, sets a credit limit and credit period for him, extracts a detailed account statement and debt aging report at any time, and sends the invoice or account statement to the customer via WhatsApp or via SMS from within the program. The receipt voucher accepts more than one line and payment method: cash, card, and check transfer in one receipt. The information panel displays the total debts in front of you, and “Accounting” follows the entire cycle of incoming and outgoing checks, including the return of the incoming check, with multiple currencies and an exchange rate for each transaction. Try it for 30 days without a payment card, and... Compare versions . If your store sells on credit more than others, read about it Building materials stores , or Spare parts , or Supermarkets and groceries , or Clothing stores .

Try Sonbola on your own work

Start a free 14-day Sonbola Web trial in your browser, or download the Windows version and try it for 30 days or 500 invoices, whichever comes first, with no payment card.

Or message us on WhatsApp, download the Windows version, or see pricing.

Collecting part of a debt: what remains?

Training example in one currency: a customer owes 1,000, pays 300, then buys another 200 on credit. The balance becomes 900 if there are no returns or other movements. The payment reduces debt and the new sale increases it; do not record the 300 collection as another sale.

Review the receipt voucher and account statement, checking the party, currency and date. Look for missing or duplicate transactions before changing a balance. To distinguish debt from cash, read high sales, little cash?.

Explore this task with Sonbola AI

Explore a balance reminder draft in the AI assistant, then return to the report and source record to review the result. Availability depends on edition, activation and permissions.

Explore the illustrative example