Back to Learn

The Aged Receivables Narrative: Turning Delinquency Into Context

A $3,832 balance doesn't have to kill your deal—if you control the story.

The Contrarian View

Delinquency isn't always bad. A 14-year tenant who's $1,200 behind but always catches up is a lower risk than a new tenant who pays on time but might leave in 6 months. Lenders understand this—but only if you give them the context.

When we submitted our Aged Receivables report showing $3,832 outstanding across 5 tenants, we could have just sent the numbers. That would have been a mistake.

Instead, we sent a narrative. Each tenant with an outstanding balance got a note explaining why the balance existed and what the resolution path was. The lender never asked a single follow-up question about delinquency.

The Raw Data vs. The Narrative

Here's what a B-tier analyst would have sent:

UnitTenant0-30 Days30-60 Days60-90 DaysTotal
24Maria Burkett$0$895$305$1,200
10Marleeta Veeder$845$422$1,267
25Marcelo Trevino$845$0$845
11Alex Hayes$420$420
33Noemi Hayes$100$100
TOTAL$3,832

The lender sees this and thinks: "This property has a collections problem."

Here's what we actually sent:

The S-Tier Aged Receivables Report

UnitTotal OwedStatusContext
24$1,200Moved OutMoved out 11/5. Balance reflects unpaid Oct & Nov rent. Unit possession recovered. Lease in place for collections.
10$1,267CurrentPartial balance. Tenant is communicative and long-standing (14 years); history of consistent catch-up payments.
25$845CurrentDec rent due. Tenant promised payment by Jan 15.
11$420CurrentPartial balance outstanding.
33$100CurrentMinor variance.

The lender sees this and thinks: "This operator knows their tenants. They have a plan for each situation."

Same data. Different narrative. Completely different lender perception.

The "14-Year Tenant" Frame

Marleeta in Unit 10 owed $1,267. That's the second-highest balance on the report. A B-tier analyst would have flagged her as a problem tenant.

But when we audited her payment history, we found something important: she's been in that unit for 14 years. Her ledger shows a consistent pattern—she falls behind occasionally, then catches up with a larger payment the following month.

Look at her payment history from our rent roll:

MonthRent PaidNotes
October 2025$1,000Arrears Collected
September 2025$1,000
August 2025$900
June 2025$1,100Arrears Collected
February 2025$1,045Includes catch-up of $200

The pattern is clear: Marleeta pays. Sometimes late, but she pays. And she's been doing this for 14 years without ever requiring eviction proceedings.

That context transforms her from a "delinquent tenant" into a "stable, long-term resident with a predictable payment pattern." The lender's risk assessment changes completely.

The "Possession Recovered" Frame

Maria in Unit 24 moved out owing $1,200. Without context, this looks like bad debt—money we'll never see.

But we framed it differently: "Unit possession recovered. Lease in place for collections."

This tells the lender three things:

  1. The unit is no longer occupied by a non-paying tenant. The bleeding has stopped.
  2. We have legal documentation. The lease is in place to pursue collections if we choose.
  3. This is a sunk cost, not an ongoing risk. Future rent from Unit 24 will come from a new tenant.

The lender may still haircut this $1,200 as bad debt. But they won't worry about Unit 24 as an ongoing collections problem—because it's not.

The Notes Column is Mandatory

Every row in your Aged Receivables report needs a Notes column. No exceptions.

What to Include in Notes

  • Tenant tenure: "Long-standing (14 years)" signals stability.
  • Payment pattern: "History of consistent catch-up payments" reframes delinquency as a pattern, not a crisis.
  • Resolution status: "Promised payment by [date]" or "Payment plan in place."
  • Unit status: "Moved out" + "Possession recovered" for former tenants.
  • Magnitude context: "$100 minor variance" tells the lender not to worry about small numbers.

The Data Integrity Check

Critical: Your Aged Receivables report must match your rent ledger. If the ledger shows Marleeta paid $1,000 in December, you cannot list her as owing $845 for December. Lenders cross-reference.

During our submission, we caught an error: the A/R report showed a tenant as delinquent for a month when our ledger clearly showed she had paid. Had we submitted that inconsistency, the lender would have questioned all of our data.

Before submitting any A/R report:

  1. Pull your rent ledger for the same period
  2. Verify each "outstanding" balance actually exists
  3. Check that payment dates in the ledger don't contradict "past due" claims in the A/R
  4. Reconcile any discrepancies before submission

The Threshold That Triggers Scrutiny

There's no official "maximum" delinquency rate for Freddie Mac SBL or similar lenders, but in our experience:

Delinquency LevelLender Response
Under 3% of GPRGenerally no additional scrutiny
3-5% of GPRMay ask for explanations (notes help here)
5-10% of GPRWill require detailed breakdown + collection plan
Over 10% of GPRSignificant DSCR impact; may affect loan sizing

Our $3,832 outstanding against ~$32,000/month in GPR (Gross Potential Rent) put us around 1% delinquency. With proper narrative context, it wasn't even a conversation.

Lenders don't fear delinquency. They fear uncertainty. Your job is to provide certainty—even when the numbers aren't perfect.

Need help with your T-12?

We turn messy books into funded deals. 48-hour turnaround.

Get Started