A credit limit is the maximum you are prepared to lose to one customer. Set it on purpose.
Set a customer credit limit from three things: how much they are likely to buy on credit, how risky they are, and how much loss you can accept. Gather trade references, financial information or a credit report, size the limit to expected monthly purchases multiplied by the payment terms, then adjust for risk. Have limits approved by authority level and review them at least yearly.
A useful starting point is the amount the customer will owe you at any one time if they pay on time:
Starting limit = expected monthly credit purchases × (payment terms in days ÷ 30)
A customer buying around 40,000 a month on 30-day terms needs a limit of about 40,000; on 60-day terms, about 80,000. Add a small margin for timing. In Excel: =B2*(B3/30)
Gather information in proportion to the amount at stake:
Score the risk as low, medium or high, and apply a factor to the starting limit, for example 100%, 75% and 50%, or require security for high-risk customers. Write the factors into your credit control policy.
| Limit | Approver |
|---|---|
| Up to a low threshold | Credit controller |
| Up to a medium threshold | Finance manager |
| Above that | Financial controller or finance director |
The approver should be independent of sales. Sales input is valuable, but the person paid on the sale shouldn't approve the risk.
Review every limit at least once a year, and sooner if the customer starts paying late, if a credit report changes, or if they ask for more. A simple Excel review list helps: customer, limit, current balance, highest balance in the last 12 months, average days to pay and last review date. Flag customers whose highest balance is far below their limit, which may be safely reduced, and customers who keep hitting it.
=IF(E2>365,"REVIEW DUE","")
with days since last review in column E.
Start new customers with a lower limit or shorter terms, and increase both after a period of on-time payment. It costs little and protects you from the most common source of bad debt: customers you don't know yet. The credit control process covers what happens after the limit is set.
The method is the same in both countries. Credit reports come from different agencies in each market, and the public information available, such as filed accounts at Companies House in the UK, differs.
Applies the payments your customers make to the invoices they are paying, including part-payments and one payment for several invoices, and shows what is still owed. Runs in your browser on your own computer: nothing is uploaded.
Work out DSO and the cash tied up in late payers. Free to use online.
The Credit Control & Receivables System calculates ageing, DSO, best-possible DSO and CEI from the ledger, shapes a bad debt provision to IFRS 9 / ASC 326 logic and requires independent approval for credit limits and write-offs. Excel, no macros, one-time price.
A simple method is expected monthly credit purchases multiplied by the payment terms in months, adjusted for the customer's risk.
Someone independent of sales, at an authority level that matches the size of the limit.
Yes. Counting only invoiced amounts lets a customer build up exposure through orders that haven't been invoiced yet.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.