To calculate a delinquency percentage, divide the delinquent amount by the total amount and multiply by 100. That single sentence covers the arithmetic, but the number it produces only means something if you first decide two things: whether you’re measuring dollars or accounts, and what “delinquent” means for the pool you’re looking at. Get those decisions right and the formula does its job. Get them wrong and a healthy portfolio can look troubled, or a real collection problem can hide behind a clean-looking rate.
What Counts as Delinquent
An account becomes delinquent once a required payment goes unpaid past its due date. For credit reporting purposes, the meaningful threshold is 30 days past due, because that is the point at which creditors typically report the late payment to the credit bureaus.1Experian. What Is a Delinquency on a Credit Report? For mortgage loans, the Consumer Financial Protection Bureau defines delinquency as beginning on the date a periodic payment of principal, interest, and escrow becomes due and unpaid.2Consumer Financial Protection Bureau. Comment for 1024.31 – Definitions
Most lenders sort delinquent accounts into aging buckets: 30, 60, 90, and 120-plus days past due. Severity drives consequences. A 30-day late payment is a stumble; a 90-day delinquency signals a borrower in real trouble. When an account stays delinquent for roughly 120 to 180 days, the creditor typically charges it off, writing it down as a loss. A charge-off doesn’t erase the debt, but portfolio calculations usually exclude charged-off balances from the delinquency pool because they’ve moved to a different ledger.
Pick your aging threshold before you pull any numbers. A “30-plus” rate captures everything from mildly late to severely overdue. A “90-plus” rate isolates accounts most likely headed to default. The Federal Reserve publishes delinquency rates that include all loans 30 days or more past due.3Federal Reserve. Charge-Off and Delinquency Rates on Loans and Leases at Commercial Banks – The Calculation of Delinquency Rates Switching thresholds midway through an analysis gives you an apples-to-oranges comparison.
Pulling the Two Numbers You Need
Every calculation needs a total pool (the denominator) and a delinquent pool (the numerator). What goes in each pool depends on what you’re measuring.
- Personal credit: Pull your reports from the three major bureaus. Late payments appear with their aging status (30, 60, 90 days). Count your total open accounts and identify which show a past-due status.
- Business accounts receivable: Use the aging report your accounting software generates. The total pool is all outstanding invoices; the delinquent pool is every invoice past its payment terms.
- Lending portfolio: Banks pull delinquent loan data from regulatory filings, using Schedule RC-N for delinquent loans and Schedule RC-C for total loans.3Federal Reserve. Charge-Off and Delinquency Rates on Loans and Leases at Commercial Banks – The Calculation of Delinquency Rates
In a spreadsheet, set up columns for account name, total balance, payment due date, and days overdue. One row sums all balances (the denominator). Another sums only the balances that meet your delinquency threshold (the numerator). This structure catches data entry mistakes before they contaminate the result. The most common error is leaving charged-off or closed accounts in the total pool, which inflates the denominator and makes the delinquency rate look artificially low.
The Balance-Based Formula
The balance-based method measures how much money is at risk. It’s the approach the Federal Reserve uses when it publishes delinquency rates for commercial banks: divide the dollar amount of delinquent loans by the dollar amount of total loans outstanding.3Federal Reserve. Charge-Off and Delinquency Rates on Loans and Leases at Commercial Banks – The Calculation of Delinquency Rates
Balance Delinquency Rate = (Total Delinquent Balances ÷ Total Portfolio Balance) × 100
Take a portfolio with $500,000 in outstanding loans. Of that, $25,000 is 30 or more days past due. Divide $25,000 by $500,000 to get 0.05, then multiply by 100. The balance delinquency rate is 5%. Five cents of every dollar lent is currently overdue.
This is the standard method for financial institutions because it reflects actual exposure. One large delinquent mortgage moves the rate more than a dozen small overdue credit cards, which is exactly the point. If you need to know how much capital is tied up in non-performing debt, use this formula.
The Account-Based Formula
The account-based method measures how many borrowers are falling behind, regardless of loan size. Instead of dollar amounts, you count accounts.
Account Delinquency Rate = (Number of Delinquent Accounts ÷ Total Number of Accounts) × 100
Using the same portfolio: 200 loan accounts, 10 past due. Divide 10 by 200 to get 0.05, then multiply by 100. The account delinquency rate is 5%. Here a $500 personal loan that’s 60 days overdue carries the same weight as a $200,000 mortgage that’s 60 days overdue.
This approach is useful for spotting operational problems. If your account-based rate is climbing while your balance-based rate stays flat, a lot of small borrowers are struggling and your big loans are performing fine. That pattern may point to underwriting weaknesses in a specific product line rather than a portfolio-wide issue.
Which One to Use
Neither formula is inherently better. They answer different questions, and running both gives the most complete picture.
- Use the balance-based rate when you need to assess financial exposure, report to regulators, or compare against Federal Reserve benchmarks. Banks use this version in call reports and investors look at it when evaluating a loan pool.
- Use the account-based rate when you want to understand borrower behavior, evaluate collection team performance, or track how many customers are at risk of default. For a business tracking what percentage of clients pay late, this is the number.
The two rates can diverge sharply. A portfolio might show a 2% balance rate but a 15% account rate if many small accounts are overdue while a few large loans stay current. Looking at only one metric in that scenario would mislead. Lending institutions track both and investigate whenever the gap between them widens.
Reading the Result
A raw percentage means little without context. What counts as “high” depends on the type of debt. Credit cards carry higher delinquency rates than mortgages in almost every economic environment because unsecured revolving debt is riskier. According to the New York Federal Reserve, 4.8% of all outstanding household debt was in some stage of delinquency in the fourth quarter of 2025.
Some rough benchmarks:
- Mortgage portfolios: Rates under 2% are generally considered healthy. Rates above 5% signal serious stress, as the 2008 financial crisis demonstrated.
- Credit card portfolios: Higher baseline rates are normal given the unsecured nature of the debt. Rates in the 2% to 4% range are typical for prime borrowers; subprime portfolios often run higher.
- Business accounts receivable: The acceptable range varies by industry and payment terms, but most businesses target keeping past-due receivables below 10% to 15% of total outstanding invoices.
Track the percentage over time rather than fixating on a single snapshot. A rate that jumps from 2% to 4% in one quarter tells you something is changing fast, even if 4% might be acceptable in isolation. Seasonal patterns matter too: retail lenders often see delinquency rates tick up in January and February as consumers recover from holiday spending.
Mistakes That Distort the Number
Even people who know the formula get tripped up by data problems. A few pitfalls to watch for:
- Mixing time periods. If your delinquent balance is measured as of March 31 but your total portfolio balance is from March 15, the ratio is off. Both numbers must come from the same date.
- Including charged-off or closed accounts. A loan that’s been written off is no longer delinquent in the conventional sense; including it inflates the delinquent pool. Closed accounts with zero balances shouldn’t sit in the total pool either.
- Ignoring partial payments. Some borrowers pay less than the minimum due. Whether that account counts as delinquent depends on your threshold; most institutional definitions require a full periodic payment, not just any payment activity.
- Confusing “days past due” with “payment cycles missed.” An account 35 days past due has missed one payment cycle. An account 65 days past due has missed two. The aging bucket (30, 60, 90) reflects missed cycles, not a precise day count.
The cleanest way to avoid these errors is to pull numerator and denominator from the same source system on the same date, and to define your delinquency threshold explicitly before running the calculation. Changing the definition after seeing the results is how misleading numbers end up in front of boards and regulators.