How to Catch PAR Drift in Your Consumer Loan Portfolio Before Delinquency Deepens
Brian Allen
May 22, 2026
9 mins read
Portfolio at Risk (PAR) drift is the week-over-week accumulation of Days Past Due (DPD) that advances individual loans from one delinquency bucket to the next before any monitoring routine flags them.
The most common reason I’ve seen that surprises consumer lenders at month-end is skipping a mid-cycle check. PAR drift doesn’t announce itself. It shows up in the data a week before it crosses the threshold, if you know which report to pull and what to sort by.
The Federal Reserve’s FRED data (DRCLACBS) puts the consumer loan delinquency rate at 2.39% as of Q4 2024. The nine metrics that drive meaningful portfolio analysis, including DPD, depend on data that stays accurate between reporting cycles. A structured weekly check is the only mechanism that keeps it that way.
I’m walking you through the four steps that cover the full weekly check sequence with a defined intervention trigger attached to each tier.
You use one of the two methods to record missed payments, and each method maps to a specific monitoring report. Run the Aging Report for loans managed under the open-ended method, and the Loan Balances Report for loans managed under the $0 entry method.
Aging Reports vs. Loan Balances Reports
| Recording Method | What Happens to an Unpaid Period | Signal Surfaced | Report to Run |
|---|---|---|---|
| $0 entry method | Period closed with a $0 entry; loan status shows as ‘Current’ | Outstanding Interest, Outstanding Late Fees, Lender Fees | Loan Balances Report |
| Open-ended method | Period left unclosed; no entry recorded | Open pay periods, aging dues per period | Aging Report |
Running the Aging Report on a $0 method portfolio, or the Loan Balances Report on an open-ended portfolio, is the most common reason a weekly check surfaces misleading data.
The $0 method classifies loans as ‘Current’ even when their outstanding balances are actively aging. The Loan Balances Report is the only instrument that explicitly surfaces those categories, separate from current-period dues.
If your loan tracking setup uses both methods across different loan types, run both reports and segment the output before filtering. A misconfigured payment waterfall 4 Payment Waterfall Mistakes Corrupting Your Consumer Loan Delinquency Reports can suppress the outstanding balance categories that the Loan Balances Report depends on.
In Bryt, both the Aging Report and the Loan Balances Report are standard reports available under the Reports tab – no custom setup required. The Aging Report corresponds directly to the open-ended method; the Loan Balances Report corresponds to the $0 entry method. Filter and export settings are documented at Reports 2.0 and Using Report Filters.
Two signals appear in the report data before a loan’s DPD crosses the next threshold: open pay periods and outstanding balance categories. Filter for both before sorting by any dollar amount.
1. Open Pay Periods
It indicates that a scheduled payment was neither recorded nor closed with a $0 entry. The DPD clock runs against those unclosed periods, but the loan shows no outstanding balance category on its summary page and no status flag indicating it is past due.
In a portfolio managed under the open-ended method, an open pay period is the only pre-threshold signal available. A loan can accumulate DPD across two or three open periods with nothing in the balance summary surfacing it as at-risk.
2. Outstanding Balance Categories
It indicates a formally recorded payment shortfall. Under the $0 method, when a period closes unpaid, interest and late fees are transferred to Outstanding Interest and Outstanding Late Fees on the loan’s summary.
These balances age alongside the loan’s DPD accumulation. Filtering by any non-zero outstanding balance category surfaces every loan carrying a recorded shortfall, regardless of its current-period status.
Apply the filter before sorting by dollar size. A $400 outstanding interest balance on a loan 23 days into a 30-day DPD period poses a greater immediate risk than a $4,000 outstanding balance on a loan that missed its first payment three days ago. Dollar size is the wrong filter at this stage. DPD proximity is what matters.
A capable loan management system surfaces both signals separately and at the portfolio level, so the operator does not have to open individual loan records to identify which loans have entered the pre-threshold window.
In Bryt, each loan’s Summary page surfaces Outstanding Interest, Outstanding Late Fees, and Outstanding Lender Fees separately from current-period dues under the Loan Balances section. The Loan Status section shows the number of Days Late per loan. These two data points are the filter inputs for the weekly check. For open pay period visibility at the portfolio level, the Aging Report exports the full aging breakdown across all loans.
Sort by the rate of DPD accumulation per week, not by outstanding dollar balance. A loan adding five DPD days per week at 26 days outstanding is more urgent than a loan carrying ten times the balance that added one day.
The table below shows why outstanding balance size is the wrong sort key:
| Function | Loan A | Loan B |
|---|---|---|
| Outstanding balance | $10,000 | $1,200 |
| Current DPD position | 22 days | 26 days |
| DPD added this week | 2 days | 5 days |
| Days to 30-day threshold | 8 days | 4 days |
| Priority ranking | #2 | #1 |
Loan B has a smaller outstanding balance and a lower DPD position, but it is four days from crossing the 30-day threshold. Loan A has eight days. The sort that matters is days to the next bucket boundary, not dollars owed.
For each loan in the filtered set: calculate DPD days accumulated since the last weekly check, then sort by that figure against the distance remaining to the next boundary: 30, 60, or 90 DPD. Loans closest to the boundary get the highest priority, regardless of dollar size.
A capable loan management system surfaces the DPD data points needed to complete this ranking without requiring the operator to pull data from multiple screens or manually reconstruct the aging position.
In Bryt, the Aging Report (open-ended portfolios) and the Loan Balances Report ($0 method portfolios) contain all the data points required to rank loans by DPD proximity. Export as Excel using the ‘Data and Headers/Footers’ Bands Filter setting for the cleanest column output, documented at Using Reports. For teams on the Custom User Fields add-on module, a dedicated DPD tracking field can be added to each loan record to log the weekly accumulation figure directly alongside the export, reducing re-entry between checks.
The difference between a watch list and a delinquency report is a defined action. Set the intervention trigger for each tier when the list is built, not after the threshold crossing is confirmed.
I’ve seen operations teams build the list every Monday and never act on it until the report confirms what they already knew. The trigger has to be set when the list is built, not after.
Structure the watch list into three tiers based on DPD proximity to the next bucket boundary:
| Tier | DPD Proximity | Assigned Action |
|---|---|---|
| 1. Immediate action | Within 7 days of the next threshold |
|
| 2. Flag for next check | Within 14 days of the next threshold |
|
| 3. Monitor | Open pay periods, low DPD accumulation rate |
Include in the next check’s starting filter. No priority action required this cycle. |
The CFPB Consumer Response Annual Report documents misapplied payments and delinquency servicing failures as recurring categories of borrower complaints. A watch list that triggers action before the crossing also serves as a compliance record showing the lender acted on available data.
Note: The 7- and 14-day bands are starting points calibrated for monthly-pay consumer loans. Adjust them to match your portfolio’s payment schedule: weekly or bi-weekly payers warrant tighter detection windows.
A capable loan management system (LMS) provides the operator with reporting tools, outstanding balance visibility, and export functionality to build and action a tiered watch list in a single weekly session.
In Bryt, the Aging Report and Loan Balances Report, combined with the Loan Status section showing Number of Days Late per loan, provide operators with all the inputs needed to populate all three watch list tiers. Report access and export settings are documented at Reports 2.0.
The four steps: matching reports with recording method, filters for open pay periods and outstanding balances, ranking loans by distance, and building a watch list along with intervention triggers work when your platform gives you the right instruments.
The question now is whether your current loan management system meets that standard or forces you to work around it.
A consumer installment lender running a weekly PAR drift check needs the following from their loan management system:
| Capability | Why It Matters |
|---|---|
| Method-matched reports: separate Aging and Loan Balances Reports | Pulling the wrong report for your recording method surfaces the wrong loans |
| Outstanding balance categories visible at the portfolio level | Open pay periods and outstanding amounts must be filterable without opening individual loan records |
| Loan-level DPD visibility on the summary page | The number of Days Late per loan is the ranking input. It must be accessible without a custom report |
| Excel export with clean column output | The DPD accumulation sort is a manual step; the export needs to be clean enough to sort without cleanup |
| Stock reports available without custom setup | A weekly routine that depends on a custom report configuration is one that won’t run consistently |
If your current platform requires you to open individual loan records to retrieve any of the above, or routes you to a static month-end report as the only delinquency view, the bottleneck is the system, not the cadence.
With Bryt, the weekly check described in this guide runs in under minutes on a portfolio of 50 to 500 loans and produces a tiered watch list that the team can act on the same day.
If your current setup doesn’t meet the checklist above, see how Bryt handles consumer installment loan servicing or book a demo to walk through the weekly check workflow with your own portfolio data.
© 2026 Bryt Software LLC. All Rights Reserved.