Roll-rate analysis of delinquencies provides critical insights into the timing and magnitude of overdue accounts, influencing cash flow and financial health.
By monitoring this KPI, organizations can identify trends that lead to improved collections and reduced write-offs.
A high roll rate often indicates inefficiencies in credit management or customer engagement, while a low rate suggests effective operational efficiency.
Companies that leverage roll-rate analysis can enhance forecasting accuracy, optimize cash reserves, and align their strategies with financial goals.
Ultimately, this KPI serves as a vital performance indicator for maintaining robust cash flow and achieving sustainable growth.
Roll-rate Analysis of Delinquencies belongs to one KPI group, Credit and Collections, where it ranks as a deep supporting entry beneath the group's headline credit metrics: Days Sales Outstanding (DSO), Collection Effectiveness Index (CEI), Bad Debt Percentage, and Average Days Delinquent (ADD). Its balanced scorecard perspective is financial, and it is unusual among its co-metrics because it is a method rather than a single number: it tracks how accounts move from one delinquency stage to the next in order to forecast future losses.
That distinction defines its role. The metrics ranked above it are largely lagging, reporting what collection and credit results have already occurred, while roll-rate analysis is forward-looking, estimating where the receivables book is heading before bad debt actually crystallizes. The tension worth naming is exactly that gap in timing. A healthy current Bad Debt Percentage can sit on top of worsening roll rates in the early delinquency stages, so the aggregate metrics can look calm while the pipeline of future losses fills. Read roll-rate analysis as the early-warning layer beneath DSO and Bad Debt Percentage, because it surfaces deterioration a quarter or more before the lagging metrics register it.
Because roll-rate analysis has no single formula, measuring it well means defining the delinquency stages and the transitions between them with discipline. Set the buckets first, commonly current and then successive past-due stages, and decide the cohort: a roll rate is the share of balances or accounts in one stage that move to the next over a defined period. Decide whether you measure by balance or by account, since a few large accounts can dominate a balance-weighted roll rate while an account-weighted one treats every borrower equally, and the two tell different stories.
Hold the stage definitions and the period fixed, because the whole value of the analysis is comparability over time, and changing a bucket boundary or the observation window breaks the trend you are trying to read. Be deliberate about cures and partial payments: whether an account that pays down below a threshold rolls backward, and how you treat re-aged or restructured accounts, materially changes the rates and is a common place for the analysis to be quietly flattered.
Segment by product, vintage, and origination channel, because delinquency behaves differently across them and a blended roll rate hides the cohort that is actually deteriorating. Read the early-stage transitions most closely, since they move first, and treat the analysis as a forecast feeding Bad Debt Percentage rather than a standalone score.
Many organizations overlook the nuances of roll-rate analysis, leading to misinterpretations that can exacerbate financial issues.
Enhancing roll-rate performance requires a multifaceted approach that focuses on proactive engagement and data-driven decision-making.
We have 4 relevant benchmarks in our benchmarks database.
Source: Subscribers only
Source Excerpt: Subscribers only
Additional Comments: Subscribers only
| Value | Unit | Type | Company Size | Time Period | Population | Industry | Geography | Sample Size |
| Subscribers only | percent | annualized share of balances transitioning into delinquency | Q2 2024 | auto loan balances | auto loan debt | United States |
Source: Subscribers only
Source Excerpt: Subscribers only
Additional Comments: Subscribers only
| Value | Unit | Type | Company Size | Time Period | Population | Industry | Geography | Sample Size |
| Subscribers only | percent | transition rate | Q2 2023 | credit card debt | United States |
Source: Subscribers only
Source Excerpt: Subscribers only
Formula: Subscribers only
Additional Comments: Subscribers only
| Value | Unit | Type | Company Size | Time Period | Population | Industry | Geography | Sample Size |
| Subscribers only | percent | flow into serious delinquency | Q2 2024 | credit card balances | credit card debt | United States |
Source: Subscribers only
Source Excerpt: Subscribers only
Additional Comments: Subscribers only
| Value | Unit | Type | Company Size | Time Period | Population | Industry | Geography | Sample Size |
| Subscribers only | percent | annualized share of balances transitioning into delinquency | Q2 2024 | credit card balances | credit card debt | United States |
Browse the Top Benchmarked KPIs in Credit and Collections
KPI Depot tracks this metric from sources that are themselves studies of delinquency transitions, the Federal Reserve Bank of New York and the Financial Stability Oversight Council, and the first lesson is that there is no single roll-rate number, only transition rates that depend entirely on how the stages and the flow are defined. The Federal Reserve material defines one measure as the balances that newly became at least ninety days late in a quarter divided by the balances that were current or less than ninety days past due the quarter before, while other entries report an annualized share of balances transitioning into delinquency. Those are different calculations of the same idea, and they are not interchangeable.
The portfolio also changes what the number means. The sources cover auto loan balances and credit card balances separately, and delinquency moves very differently across product types, so a transition rate for one kind of debt tells you little about another. These are also balance-weighted measures over specific quarters in a particular economy, so the macroeconomic moment is built into them.
Before using any external roll-rate or transition figure, confirm how it defines each delinquency stage and the flow between them, whether it is balance-weighted or account-weighted, which debt product it covers, and the period it reflects. Because this metric is a method rather than a fixed formula, a figure with no definition attached cannot be compared to your own at all.
Roll-rate Analysis of Delinquencies is not named in the Credit and Collections KPI group's published OKR examples, but it serves the group's objective of mitigating credit risk exposure to improve portfolio quality and reduce losses, which sets its key results as Bad Debt Percentage, recovery rates, and write-off amounts. Roll-rate analysis is the forecasting engine beneath those outcomes: it predicts the bad debt that objective is trying to prevent.
A team pursuing that objective can use roll-rate analysis as a leading key result, framed as reducing the transition of balances from early to later delinquency stages, since stopping the roll early is what keeps the lagging bad-debt and write-off numbers down. Tying it to the same objective as those outcome metrics is the point, because it turns a forecasting method into an early action that protects the portfolio. Any roll-rate target a team sets is an internal goal tied to its own book and economic conditions, not a benchmark.
This KPI is associated with the following categories and industries in our KPI database:
KPI Depot takes you from KPI intelligence to finished deliverable. Consultants, strategy teams, FP&A leaders, and analytics teams use it to answer the two hardest questions in performance management, what to measure and what the target should be, and then to produce the scorecard itself.
The difference is intelligence, not just data. Anyone can list metrics. Every KPI in KPI Depot carries 13 practical attributes, from formula and measurement approach to diagnostic questions, risk warnings, and Balanced Scorecard perspective, across 15 corporate functions and 153 industries. And every target you set is grounded in our database of 34,304 source-attributed benchmarks, each detailing metric value, company size, time period, industry, geography, sample size, and source. Benchmark data at this scale is otherwise the domain of research services costing thousands to hundreds of thousands of dollars per year.
When your metrics are selected, KPI Depot finishes the job: export an interactive Strategy Map, a Balanced Scorecard with formulas and tracking columns, or a CSV KPI pack, and go from research to working deliverable in hours instead of weeks.
Formerly the Flevy KPI Library, KPI Depot is trusted by teams at organizations including Accenture, EY, IBM, PepsiCo, Samsung, and Vodafone.
Got a question? Email us at [email protected].
Roll-rate analysis tracks the movement of accounts receivable through various delinquency stages. It helps organizations understand how quickly overdue accounts are escalating and informs collection strategies.
By identifying trends in delinquency, organizations can implement proactive measures to collect outstanding debts. This reduces the time accounts remain overdue, thereby enhancing cash flow.
Customer payment behavior, economic conditions, and credit policies all impact roll rates. Understanding these factors allows businesses to tailor their strategies effectively.
Monthly reviews are recommended for most organizations, while weekly assessments may be beneficial for those experiencing rapid changes in customer behavior or economic conditions.
Yes, by analyzing historical data and current trends, organizations can forecast potential delinquencies. This allows for timely interventions to mitigate risks.
Effective communication can significantly reduce delinquencies. Proactive outreach and clear payment instructions foster trust and encourage timely payments.
Each KPI in our knowledge base includes 13 attributes.
A clear explanation of what the KPI measures
The typical business insights we expect to gain through the tracking of this KPI
An outline of the approach or process followed to measure this KPI
The standard formula organizations use to calculate this KPI
Insights into how the KPI tends to evolve over time and what trends could indicate positive or negative performance shifts
Questions to ask to better understand your current position is for the KPI and how it can improve
Practical, actionable tips for improving the KPI, which might involve operational changes, strategic shifts, or tactical actions
Recommended charts or graphs that best represent the trends and patterns around the KPI for more effective reporting and decision-making
Potential risks or warnings signs that could indicate underlying issues that require immediate attention
Suggested tools, technologies, and software that can help in tracking and analyzing the KPI more effectively
How the KPI can be integrated with other business systems and processes for holistic strategic performance management
Explanation of how changes in the KPI can impact other KPIs and what kind of changes can be expected
NEW Mapping to a Balanced Scorecard perspective (financial, customer, internal process, learning & growth)