Debtor Segmentation Calculator
General information, not legal or financial advice. Terms of Use.
Paste trade-channel ageing
One row: Name, Within buying window, Beyond window, optional Legal flag. Paste tab-separated Excel cells, or use comma/semicolon-separated rows. Quote fields containing the delimiter or a line break. Indian and Western thousand separators are accepted inside a numeric cell; in comma-separated rows a grouped amount must be quoted. Blank lines are ignored. Amounts must be non-negative numbers, with a positive total for each customer. Duplicate customer names must be resolved before scoring. Legal values: Yes, legal, notice or filed apply the legal override. No, no legal action, no legal notice or not filed do not. Unknown and blank mean that legal status has not been supplied or confirmed; they do not apply the override. Other wording is rejected. Keep all amounts in one currency and unit throughout the book; this tool does not convert currencies.
Segmentation
FAQs
Do I need purchase history?
No. The model runs on a debtor ageing, while recent open invoices are only a proxy for continuing activity.
Should institutional buyers be included?
No. Tender/institutional cycles need a different analysis.
Is this a benchmark?
No. It is a segmentation model.
HOW TO INTERPRET THE RESULT
Use segments to vary action, not to label customers
Segmentation is useful when it changes what the team does next. Read the output as a way to distinguish high-value, high-risk or operationally blocked accounts rather than as a permanent description of a customer. Validate the underlying balances, ages and dispute status before assigning action. A large current balance may require credit monitoring rather than collection; a smaller old balance with weak evidence may need immediate reconstruction. Consider concentration and strategic dependency separately from invoice age. The same debtor may move between segments as evidence is completed, disputes are resolved or payment behaviour changes. Assign an owner, action and review date to each priority segment, then measure movement in cash and ageing. The tool does not estimate recovery probability and should not replace account-level judgement, customer context or legal advice. Its purpose is to allocate scarce management attention more deliberately.