← All articles

·6 min read

Customer Credit Limit for Distributors: Block Risky Orders Before Unpaid Invoices Pile Up

Most bad debt is approved the moment a sales order is entered for a customer who already owes too much. Here is how to set a credit limit and payment terms for each customer, check them automatically, and send risky orders to the owner before goods leave the warehouse.

  • credit limit
  • customer credit
  • credit control
  • sales order
  • bad debt
  • payment terms
  • distribution
  • sme
Customer Credit Limit for Distributors: Block Risky Orders Before Unpaid Invoices Pile Up

A shop owner calls your sales rep for another delivery. The rep is happy, takes the order, and the warehouse ships it the next morning. Nobody checked that this shop already has three unpaid invoices, the oldest one 45 days late. A month later the shop closes and you are left with Rp 80 million you will probably never see. A customer credit limit for distributors is the simple control that stops this: every customer gets a maximum amount they can owe, and the system checks it the moment an order is entered, not weeks later when finance starts chasing.

This post explains how to set sensible limits and payment terms, which two checks to run automatically on every sales order, and how to route over-limit orders to the owner without slowing down the whole sales team.

Why bad debt starts at the sales order, not the invoice

Most distributors manage credit risk after the fact. Finance prints an aging report at the end of the month, highlights the late customers, and someone starts making phone calls. By then the goods are gone. Each new delivery to a late customer makes the debt bigger and your negotiating position weaker.

The cheapest moment to say no, or to say pay first, then we ship, is before the order is confirmed. At that point you still hold the stock and the customer still wants something from you. That is why the check belongs in the sales order process, not in the collection process.

How to set a customer credit limit for distributors

You do not need a credit scoring model. For most SMEs, a few clear rules work well.

Base the limit on real purchase history

Look at what each customer bought per month over the last 6 to 12 months and how fast they paid. A practical rule of thumb:

  • Credit limit = average monthly purchases x (payment terms in days / 30) x 1.2 to 1.5
  • Example: a minimarket buys about Rp 40 million per month on 30-day terms. Its limit would be around Rp 50 to 60 million. That covers normal ordering with some room for a busy month, but not for two months of unpaid goods.

Customers who always pay on time can get the higher multiplier. Customers who often pay late get the lower one, or shorter terms.

Treat new customers differently

A new customer has no history, so start small: cash on delivery for the first two or three orders, then a modest limit such as Rp 10 to 20 million. Raise it after three to six months of on-time payments.

Write payment terms per customer, not per company

Store terms such as 14, 30 or 45 days in the customer record. The system needs this number to calculate when each invoice becomes overdue. If terms are only in a salesperson's head, no automatic check is possible.

Review every quarter

Limits go stale. Set a reminder to review the top 30 customers by volume every three months. This takes an hour and catches customers whose business is shrinking.

The two checks to run on every sales order

When a sales order is saved, the system should run two checks automatically. Either one failing puts the order on hold.

Check 1: Will this order push the customer over the limit?

The calculation is:

unpaid invoices + delivered but not yet invoiced + open orders + this order > credit limit

Many systems only count unpaid invoices. That is a gap: a rep can enter five orders in one day and each one looks fine on its own. Counting open orders and uninvoiced deliveries closes that gap.

Check 2: Does the customer have invoices overdue too long?

Even a customer under the limit is risky if an old invoice is still unpaid. Pick a grace period, for example 7 days after the due date. If any invoice is more than 7 days overdue, the order is held regardless of the balance.

Decide in advance whether each check is a hard block or a warning. A common setup: over limit by less than 10 percent shows a warning to the rep; anything above that, or any overdue invoice, needs approval.

Routing over-limit orders to the owner

A block with no way out just makes sales angry, and they will find workarounds like splitting orders or using another customer's account. The fix is a fast, clear approval path.

  1. The order is saved with status Waiting for approval. The warehouse cannot pick it.
  2. The owner or finance manager gets a notification, ideally on WhatsApp or email, with the key facts: customer name, order value, current balance, limit, oldest overdue invoice and days late.
  3. The approver chooses: approve this order once, reject, approve if the customer pays a specific invoice first, or approve a smaller quantity.
  4. The decision and reason are recorded, so you can see later who approved what and why.
The goal is that the person deciding sees the full picture on one screen, in under a minute, without calling finance.

If the owner becomes a bottleneck, delegate: the finance manager approves up to Rp 25 million over the limit, the owner approves anything larger. Approvals should normally be answered within a few hours so delivery schedules do not slip.

What it takes to set this up, and what it costs

You have three realistic options.

  • Your existing accounting or ERP software. Many packages have a credit limit field, but often they only show a warning and ignore open orders or overdue days. Check what yours actually does before buying anything new.
  • A custom module on top of your current system. If your sales orders and invoices are already digital, adding both checks plus an approval flow with WhatsApp notifications typically takes 3 to 6 weeks and costs roughly Rp 15 to 40 million, depending on how clean your data is and how many systems are involved.
  • Spreadsheets. Fine for setting the initial limits, but not for checking every order in real time. Someone will forget.

Be honest about the prerequisites. The checks are only as good as your payment data: if customer payments are recorded once a week, the system will block customers who have already paid. Payments need to be entered daily. Expect some pushback from the sales team in the first month, so explain clearly that the rules protect their commission too, since unpaid sales usually do not count.

Start with your aging report

You can begin this week without any new software. Pull your accounts receivable aging report, list your top 20 customers, and write down a limit and payment terms for each using the rule above. That exercise alone usually reveals two or three customers who should have been stopped months ago. If you then want the checks and approvals to run automatically inside your order process, contact CodeWorks and we will review your current setup and give you a clear scope and cost estimate.