How to Set a Customer Credit Limit? Training on Base Limit, Trust Multiplier, Limit Utilization Rate, Overrun Management and the Cost of Bad Debt
How do you set a customer credit limit? Base limit, trust multiplier, utilization rate, overrun management and the cost of bad debt: a hands-on, 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is a customer credit limit, and why do you need one?
- Lesson 2: What data do you need for the limit?
- Lesson 3: How is the base limit calculated?
- Lesson 4: How is the trust multiplier determined?
- Lesson 5: How do you read limits and utilization in a five-customer portfolio?
- Lesson 6: What do you do when the limit is exceeded?
- Lesson 7: How much does a bad debt really cost?
- Lesson 8: How often should limits be reviewed?
- What are the most common mistakes in setting credit limits?
- How does NetKasam make credit limit management easier?
- Mini quiz: Test what you have learned
- Conclusion: Write down the limits of your three biggest customers this week
- Frequently Asked Questions About Customer Credit Limits
A customer you sell to on credit bought ₺25,000 worth of goods last month, wants ₺60,000 this month and says "I'll pay at the end of the month." Accepting grows the sale; refusing loses the customer. Most businesses make this decision on that day's gut feeling: one customer gets a limit that is too high, another one that is too low, and a customer who does not pay is noticed only after the receivable has grown. A credit limit lets you make this decision in advance, with numbers and with the same rule for everyone.
This article is not a narrative but an 8-lesson practical training. We will answer the question how do you set a customer credit limit with numbers, using a sample portfolio of five customers: what the limit is, what information to use, the base limit and trust multiplier, the limit utilization rate, managing overruns, the real cost of bad debt and how often limits should be reviewed. At the end there is a mini quiz with an answer key. For collecting receivables on time, see the article how to track receivables; here we build the stage before the receivable arises, namely the limit.
What will you be able to do by the end of this training?
In short: You will calculate a base limit per customer, apply a trust multiplier based on payment history, track the limit utilization rate, manage overruns and find out how many liras of sales it takes to make up for a bad debt.
- 01DataCollect monthly purchases, payment terms and payment history.
- 02BaseCalculate the base limit.
- 03MultiplierAdjust it based on payment history.
- 04DefinitionWrite the limit on the customer card.
- 05MonitoringTrack the utilization rate.
- 06ReviewUpdate limits regularly.
The training's 8 lessons: (1) what a credit limit is, (2) what data you need, (3) base limit, (4) trust multiplier, (5) portfolio and utilization rate, (6) overrun management, (7) the cost of bad debt, (8) review.
Lesson 1: What is a customer credit limit, and why do you need one?
In short: A credit limit is the highest open balance a customer can reach when buying from you on credit. When the limit is exceeded, new credit sales stop; this way, a single customer's failure to pay cannot put the whole business at risk.
| Without a limit | With a limit |
|---|---|
| Every order is approved on that day's gut feeling | The rule is set in advance |
| Big customers get unlimited payment terms | The open balance is capped |
| Problem receivables are noticed after they grow | An overrun is visible instantly |
| Disputes arise between the sales team and accounting | The decision is on record |
In NetKasam, when the open balance limit you set for a customer is exceeded, the system blocks new sales to that customer. If you work with cheques and promissory notes, cheques that have not yet matured also appear in the account's risk calculation. For details, see the customer and supplier account tracking and cheques and promissory notes pages. For the basics of current accounts, the article how to track a current account is helpful.
Lesson 2: What data do you need for the limit?
In short: Three pieces of data are enough: the customer's average monthly purchases, the payment term you give them and their payment history. All three come from your own records.
| Data | Where do you find it? | Why? |
|---|---|---|
| Average monthly purchases | Account statement, sales invoices | Shows normal volume |
| Due date | Agreement with the customer, invoice due date | Determines how long the open balance will remain |
| Payment history | Collection dates and delays | Shows reliability |
| Cheque and promissory note status | Cheque and promissory note records | Adds risk that has not yet matured |
A new customer has no history; in that case it is reasonable to start with a low trust multiplier and raise it after a few payments. If you charge deferred payment charge, see the article how to calculate deferred payment charge for the calculation.
Watch out for two mistakes when collecting data. First, take the monthly average from the last six months, not from a single busy month; a purchase in a campaign month inflates the limit. Second, read payment history not only as "did they pay" but as "how many days after the due date did they pay." If a customer always pays but pays fifteen days late every time, their actual payment term is longer than the contractual one, and the base limit should be calculated with this actual term. The invoice and collection dates on the account statement show this gap directly.
Lesson 3: How is the base limit calculated?
In short: Base limit = average monthly purchases × (payment term in days ÷ 30). The limit should be at least as large as the open balance the customer will carry during the payment term.
- Base limit = Average monthly purchases × (Payment term in days ÷ 30)
- Limit = Base limit × Trust multiplier
- Utilization rate = Open balance ÷ Limit × 100
- Recovery revenue = Bad debt ÷ Net margin
Prepared with sample values. Multipliers and thresholds are adapted to each business.
For example: a customer who buys ₺25,000 per month on 45-day terms has a base limit of 25,000 × (45 ÷ 30) = ₺37,500. The longer the term, the larger the open balance for the same volume; that is why the payment term is the strongest determinant of the limit. This calculation is a starting point; adapt it to your sector, products and the customer's financial structure.
Lesson 4: How is the trust multiplier determined?
In short: The trust multiplier increases or decreases the base limit according to the customer's payment history. You can use tiers such as 1.25 for a customer who pays on time, 0.75 for one who is often late and 0.5 for a first order.
| Payment history | Sample multiplier | Criterion |
|---|---|---|
| Pays on time | 1,25 | No delays in the last 6 months |
| Occasionally late | 1,00 | Some delays, but short |
| Often late | 0,75 | Several long delays |
| New customers | 0,50 | No history |
Lesson 5: How do you read limits and utilization in a five-customer portfolio?
In short: For each customer, place the limit, open balance and utilization rate side by side. Above 80% is a warning sign, above 100% calls for action.
| Customer | Monthly purchases | Due | Base limit | Multiplier | Limit |
|---|---|---|---|---|---|
| A | 40.000 ₺ | 30 days | 40.000 ₺ | 1,25 | 50.000 ₺ |
| B | 25.000 ₺ | 45 days | 37.500 ₺ | 1,00 | 37.500 ₺ |
| C | 60.000 ₺ | 30 days | 60.000 ₺ | 0,75 | 45.000 ₺ |
| D | 12.000 ₺ | 60 days | 24.000 ₺ | 1,00 | 24.000 ₺ |
| E | 80.000 ₺ | 15 days | 40.000 ₺ | 1,25 | 50.000 ₺ |
| Total | 206.500 ₺ |
| Customer | Limit | Open balance | Utilization rate | Situation |
|---|---|---|---|---|
| A | 50.000 ₺ | 34.000 ₺ | %68,0 | Normal |
| B | 37.500 ₺ | 36.800 ₺ | %98,1 | Alert |
| C | 45.000 ₺ | 47.500 ₺ | %105,6 | Limit exceeded |
| D | 24.000 ₺ | 9.600 ₺ | %40,0 | Normal |
| E | 50.000 ₺ | 21.000 ₺ | %42,0 | Normal |
| Total | 206.500 ₺ | 148.900 ₺ | %72,1 |
- Customer C105.6%
- Customer B98.1%
- Customer A68.0%
- Customer E42.0%
- Customer D40.0%
Prepared with sample values. Customer C's overrun is 47,500 − 45,000 = ₺2,500.
- Total limit₺206,500
- Customer A open balance−₺34,000
- Customer B open balance−₺36,800
- Customer C open balance−₺47,500
- Customer D open balance−₺9,600
- Customer E open balance−₺21,000
- Remaining limit₺57,600
Prepared with sample values. Total utilization rate is 72.1%.
Note: Although the total remaining limit appears to be ₺57,600, this figure is misleading; C has exceeded its limit and B is almost full. The remaining limit should be read customer by customer. To consider customer-based profitability as well, see the article how to calculate customer-based profitability.
Recommended readingHow to Track Receivables?Lesson 6: What do you do when the limit is exceeded?
In short: An overrun does not by itself mean refusing the sale; first collect payment, and if that is not possible, either raise the limit temporarily and deliberately or make the sale for cash.
| Option | When? | Note |
|---|---|---|
| Ask for payment first | If there are overdue receivables | Send a reminder and a statement |
| Cash or prepaid sale | If the customer needs goods urgently | Does not increase the open balance |
| Temporary limit increase | If payment history is good and volume is growing | Written, dated decision |
| Lower the limit | If delays are frequent | By talking with the customer |
In the example, Customer C has an overrun of ₺2,500 and its multiplier has dropped to 0.75; so with this customer, collection is discussed first and no new credit orders are accepted. In NetKasam, you can send automatic reminders for upcoming and overdue payments, balance reminders with ready-made templates via bulk SMS and share online statements; collecting by credit card with a payment link is also possible (online collection). For cheque risk, see the article how to track cheques and promissory notes.
There is one more principle in managing overruns: put exceptions on record. When the sales team says "this customer is good, let's go over the limit," if you write down who approved it, on what date and up to what amount, the exception does not turn into a habit. A temporary increase is given with an end date, and when that date arrives the limit returns to its previous value. This way the "temporary" increase does not become permanent, and management can see which customers keep asking for exceptions; a customer who constantly asks for exceptions usually signals that it is not the limit but the price and payment term agreement that needs to be renegotiated.
Lesson 7: How much does a bad debt really cost?
In short: Revenue needed to make up for a bad debt = loss ÷ net margin. Because net margin is low, even a small bad debt requires a very large amount of additional revenue.
If Customer B stops paying, the open balance of ₺36,800 is lost. If the net margin is 8%, making up for this loss requires 36,800 ÷ 0.08 = ₺460,000 in additional revenue. At a 12% margin it would take ₺306,667, at 5% it would take ₺736,000. In other words, a limit decision of ₺36,800, if it goes bad, is a decision that wipes out the profit of ₺460,000 in sales.
| Net margin | Revenue that makes up for a ₺36,800 loss |
|---|---|
| %5 | 736.000 ₺ |
| %8 | 460.000 ₺ |
| %12 | 306.667 ₺ |
| %20 | 184.000 ₺ |
- ₺206,500total limit of the five customers
- 72.1%total limit utilization rate
- ₺2,500Customer C's limit overrun
- ₺460,000revenue that makes up for a ₺36,800 loss (8% margin)
This calculation shows that setting a limit is not about restricting sales: preventing a loss is far cheaper than making up for the same loss. If you do not know your margin, see the article how to calculate profit margin.
Lesson 8: How often should limits be reviewed?
In short: A limit is not set once and forgotten. As volume, payment terms and payment behavior change, the limit changes too; review it at least once a quarter.
| When? | What to do? | Who? |
|---|---|---|
| Weekly | Customers with utilization above 80% are listed | Accounting |
| Month-end | Statements are shared and reconciliation is obtained | Accounting |
| Once a quarter | Monthly purchases, payment terms and multipliers are updated | Management |
| When a delay occurs | The multiplier is lowered and collection is discussed | Sales and accounting |
| New customers | Start with a low multiplier, raise it after 3 payments | Management |
For the effect of the receivables burden on cash planning, see the articles how to prepare a cash flow statement and how to calculate working capital. For choosing account software, the article how to choose customer and supplier account tracking software is a useful complement.
Recommended readingHow to Track a Current Account?How you explain the limit decision to the customer also affects the outcome. Present the limit not as a penalty but as part of your way of working: "Based on your monthly volume and payment term, your limit is this much; with regular payments, we review it after three months." When the customer knows the rule in advance, an overrun does not come as a surprise, and the collection conversation is easier to open. Holding the limit discussion face to face once a year with big customers keeps both the relationship and the information up to date.
What are the most common mistakes in setting credit limits?
- Setting the limit by gut feeling. It creates inconsistency and disputes between customers.
- Ignoring the payment term. For the same volume, risk grows as the term gets longer.
- Giving big customers an unlimited limit. The biggest receivable is the biggest risk of loss.
- Forgetting cheque risk. A cheque that has not yet matured is also open risk.
- Never updating the limit. The customer changes, the limit stays outdated.
- Letting overruns slide quietly. Every overrun should be a deliberate decision.
- Looking at the total remaining limit. Risk is read customer by customer.
How does NetKasam make credit limit management easier?
- Credit limit. You set an open balance cap for the customer; when it is exceeded, the system blocks new sales to that customer (customer and supplier account tracking).
- Cheque risk. Cheques that have not yet matured appear in the account's risk calculation; a cheque risk amount can be set for the customer (cheques and promissory notes).
- Reminders. Automatic reminders for upcoming and overdue payments; balance reminders via bulk SMS.
- Online statement. You share account activity with the customer; you can send a reconciliation letter with one click.
- Credit card collection. Account balances can be collected by credit card (online collection).
- Unlimited accounts. There is no limit on the number of customers you can create.
- Bookkeeping is free. Current account tracking is free in every plan; for details, see the pricing page.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- What is the base limit of a customer who buys ₺30,000 per month on 60-day terms?
- If the trust multiplier is 0.75, what is the limit?
- If the open balance is ₺40,000, what is the utilization rate?
- With a net margin of 10%, what revenue makes up for a bad debt of ₺20,000?
- Why can the total remaining limit be misleading on its own?
Answer key:
- 30.000 × (60 ÷ 30) = 60.000 ₺.
- 60.000 × 0,75 = 45.000 ₺.
- 40.000 ÷ 45.000 × 100 = %88,9.
- 20.000 ÷ 0,10 = 200.000 ₺.
- One customer may have exceeded their limit while others have plenty of room; risk arises customer by customer, and the total hides this.
Frequently Asked Questions About Customer Credit Limits
How is a customer credit limit set?
Average monthly purchases are multiplied according to the payment term in days (base limit), then a trust multiplier is applied based on payment history. The result is written to the customer card and reviewed regularly.
What happens if the risk limit is exceeded?
In NetKasam, when the open balance limit you set for a customer is exceeded, the system blocks new sales to that customer.
Are cheques included in the credit limit?
Cheques received as collection appear as risk until they mature and are deducted from the risk amount once paid.
How much limit should a new customer get?
Since there is no history, start with a low trust multiplier and raise it after a few regular payments.
Why does the payment term affect the limit?
At the same monthly volume, the longer the payment term, the larger the open balance the customer carries; that is why the term is the key input of the limit.
How often should I update the limit?
At least once a quarter; immediately if payment behavior changes.
Are there reminders for overdue receivables?
Yes. Balance reminders can be sent with automatic reminders and bulk SMS; online statements can also be shared.
Why is bad debt so expensive?
Because net margin is low, making up for the loss requires revenue many times the amount lost; in the example, ₺460,000 for ₺36,800 at a 8% margin.
Conclusion: Write down the limits of your three biggest customers this week
A credit limit is not a complex model; it is a written rule. This week, pull up the monthly purchases, payment terms and payment history of your three biggest credit customers, calculate the base limit and multiplier and set them on the customer card. When you look at utilization rates a month later, you will see which customer is quietly being financed by you.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.