The Receivables Aging Report: The Due Diligence Document That Reveals More Than the P&L

Sellers hand you a P&L and call it transparency. It isn’t. The P&L tells you what revenue was recognized. It says nothing about whether that revenue was actually collected — or whether it’s sitting in a 90-day bucket slowly turning into a write-off.

The accounts receivable aging report is the document that answers the questions the P&L can’t. Every dollar owed to the business is segmented by how old the debt is. That segmentation tells you more about operational health, collection discipline, and revenue quality than almost anything else in the due diligence stack.

Most buyers never ask for it. That’s a serious mistake.

Why the AR Aging Report Deserves Its Own Due Diligence Meeting

When you’re reading a funeral home’s financial statements, you typically see three data points about receivables: revenue on the income statement, total AR on the balance sheet, and possibly bad debt expense. None of those numbers tells you how the money moves.

The balance sheet shows you total AR — a single number, say $180,000. The aging report breaks that $180,000 into time buckets: how much is current, how much is 30–60 days old, how much is 60–90, how much is older than 90 days. Each bucket has a different collectibility profile. Each bucket tells a different story about operations.

A business with $180,000 in receivables and 80% in the current bucket is fundamentally different from a business with $180,000 in receivables and 40% in the 90+ bucket. The balance sheet cannot distinguish them. The aging report can.

What This Document Connects To

The AR aging report doesn’t live in isolation. It connects directly to:

• Quality of earnings analysis — uncollectible AR inflates earnings
• Working capital adjustments at closing — stale AR should be excluded from the working capital peg
• Insurance assignment cash flow dynamics — insurance AR has a distinct aging pattern from family AR
• First-year cash flow planning — knowing what’s actually collectible shapes your cash runway assumptions

Request the AR aging report as a standalone due diligence deliverable, not buried in the data room as an afterthought. Schedule a dedicated conversation to walk through it with the seller.

What Each Aging Bucket Reveals

The Corporate Finance Institute’s accounts receivable aging methodology defines aging buckets as a structured diagnostic — each window reflects a different collection risk profile. Applied to funeral home acquisitions, the interpretation is as follows.

Current (0–30 Days)

Healthy benchmark: 60–70% of total AR.

This is revenue billed within the last month. For insurance claims, this is expected — insurance typically takes 30–60 days to pay from initial filing. For family receivables, current means the family is paying on time or just received their statement.

If current accounts are below 60% of total AR, start asking why. If they’re above 75%, that’s a positive signal — the business is billing promptly and collecting quickly.

30–60 Days

Normal for insurance, watch flag for family.

Insurance claims regularly sit in this bucket. That’s not a problem by itself — it’s a function of carrier processing times. What you’re watching for is whether specific carriers dominate this bucket. If 80% of 30–60 day AR is from a single carrier, that carrier is slow, or the business has filing problems with that carrier.

Family receivables in the 30–60 day bucket warrant a different question: is this a payment plan or a missed payment? The difference matters. A structured payment plan at 45 days is a receivable. A family that was supposed to pay and hasn’t is an early collection problem.

60–90 Days

Suggests filing errors, carrier friction, or collection avoidance.

Insurance claims older than 60 days are a yellow flag. Well-operated funeral homes using insurance assignment companies (like American Funeral Financial or Express Funeral Funding) typically get paid in 3–10 business days on assigned claims — they never enter the aging report at all. Direct billing to carriers should still settle within 45 days.

If you’re seeing significant volume in the 60–90 day bucket, ask for the carrier breakdown. Are these resubmissions? Claim denials under appeal? Missing documentation? Each explanation points to a different operational problem.

Family receivables at 60–90 days are a red flag. At this stage, the family has received multiple statements and has not paid. Either the business doesn’t have a collections process, or it does and the family is ignoring it.

90+ Days

Systemic collection problem if above 15–20% of total AR.

This is the diagnostic number. If more than 15–20% of total AR is over 90 days old, the business has a structural collection problem — not a one-time miss. The SBA’s financial due diligence guidelines for acquisition loans (SBA.gov) emphasize that stale receivables must be excluded from working capital projections and flagged for collateral purposes. A lender will not count 90+ day AR as a liquid asset.

What to do with this bucket: Request an itemized list of every account over 90 days. Name, amount, family or insurance, last contact date, and whether a payment arrangement exists. Review 20 accounts at random. You’ll know within 30 minutes whether these are collectible or already written off in everything but accounting.

Worked Example

Assume the business reports $200,000 in total AR. The aging breakdown looks like this:

On the surface, 10% in 90+ looks manageable. But 14% in 60–90 is concerning — that bucket is likely to migrate into 90+ before closing unless there’s active collection activity. Combined, $48,000 (24% of AR) is at material risk. If industry bad debt runs 2–3%, you’d expect $4,000–$6,000 in annual write-offs on $200K in AR. The current aging suggests actual losses could be $20,000–$35,000. That’s a pricing conversation.

Insurance Assignment Receivables: The Hidden Efficiency Test

Separate insurance AR from family AR in your analysis. They have different risk profiles, different aging patterns, and different collection levers.

The Benchmark That Matters

A well-run funeral home that handles insurance claims internally should settle most claims within 45 days of filing. Above 60 days is a flag. Above 90 days suggests either chronic filing errors or problematic relationships with specific carriers.

The most efficient operators don’t carry meaningful insurance AR at all. They use assignment funding companies — organizations that advance the funeral home the insurance benefit upfront and collect from the carrier directly. American Funeral Financial and Express Funeral Funding are two of the larger providers. When a funeral home uses assignment funding correctly, insurance AR drops to near zero on the aging report.

If the business you’re evaluating has material insurance AR in the 60–90+ day buckets, that’s a signal they’re not using assignment funding — and possibly a signal they’re leaving cash on the table that you can capture post-acquisition. See the insurance assignment cash flow gap guide for a full breakdown of what that operational shift looks like.

Carrier-Level Questions to Ask

• Which three carriers make up the majority of insurance AR?
• Has the seller had any claims denied or sent to secondary review in the past 12 months?
• Are there any carriers with whom the business has documented friction (slow payment, frequent denials)?
• Does the business file claims electronically or by mail? (Mail filing is a velocity killer.)

Assignment Funding as a Benchmark

If you can’t get a clean carrier-by-carrier breakdown, use this proxy: ask whether the business uses assignment funding companies for any insurance claims. If yes, look at what percentage of insurance cases go through assignment vs. direct billing. A business doing 60% direct billing with average 75-day insurance AR has a knowable efficiency gap. You can model the improvement.

Family Receivables: What Payment Plans Really Mean

Payment plans are common in funeral services. The NFDA has documented that a significant portion of funeral home families request some form of deferred payment arrangement, particularly for arrangements exceeding $8,000–$10,000 total. The question isn’t whether payment plans exist — it’s whether the business has any discipline around them.

The Owner-Empathy Trap

Many independent funeral home operators built their practice on community relationships. That’s a genuine competitive advantage. It also creates a structural weakness: owners who extend credit to grieving families without any formal documentation, payment terms, or follow-up process.

The result is payment plans that aren’t really plans — they’re informal arrangements that the owner follows up on when they remember, that families let slide because no one is pressing them, and that eventually become social obligations too awkward to collect on. These don’t show up as bad debt until the business is sold.

When you review family receivables in the 60–90+ day buckets, ask: does each account have a signed payment agreement? Is there a documented follow-up cadence? Has any account been referred to a collection agency or an attorney? If the answers are mostly no, you’re looking at an informal lending operation, not a collections process.

Credit Card at Time of Service

The cleanest signal of collection discipline is the percentage of arrangements where full payment is collected at time of service by credit card. Businesses that have normalized credit card payment at arrangement conference have near-zero family AR aging issues. Those that avoid the conversation — because it feels crass or the owner is conflict-averse — carry the collection risk on their balance sheet instead.

Ask the seller: what percentage of families pay in full by credit card at the time of arrangement? If the number is below 40–50%, probe why. The answer tells you a lot about collection culture.

Bad Debt Write-Offs: The Number Nobody Volunteers

Bad debt write-offs are rarely surfaced proactively in a deal. They may appear in the financial statements as a line item, or they may be buried in revenue adjustments, discount entries, or simply not recorded at all — with uncollectible accounts sitting permanently in AR.

Industry Benchmarks

• 1–3% of revenue: Normal operating range for a well-run funeral home
• 3–5% of revenue: Elevated — warrants investigation but not necessarily a dealbreaker
• Above 5% of revenue: Structural collection problem or accounting irregularity

NFDA industry data on payment patterns reflects that independent funeral homes tend to run at the higher end of the range due to lower collection infrastructure compared to consolidators. A business doing $800,000 in revenue with $45,000 in annual write-offs (5.6%) has a problem worth quantifying.

Request Three Years of Write-Off History

One year of write-off data can be an anomaly. Three years reveals a trend. Specifically, look for:

• Whether write-offs are consistent year-over-year or spike in a specific year (a spike may indicate a large single account or a change in policy)
• Whether the write-off rate is increasing, decreasing, or flat
• Whether write-offs appear as a formal line item or are embedded in revenue adjustments

The most aggressive form of write-off concealment is simply not recording them — leaving uncollectible accounts in AR indefinitely. When you cross-reference the aging report with write-off history, you can identify accounts that have aged past 180+ days with no corresponding write-off. Those are phantom receivables. They should be excluded from the balance sheet entirely when you model the business.

Write-Offs Buried in Adjustments

Ask the seller or their accountant directly: how are uncollectible accounts written off in the general ledger? If the answer involves revenue adjustments, discounts, or credit memos rather than a formal bad debt expense account, the income statement is overstating both revenue and expenses inconsistently. This is a quality of earnings issue that requires an adjustment to EBITDA.

Using the AR Aging Report as a Negotiation Lever

Poorly managed receivables do double duty for a buyer: they justify a lower purchase price and they represent a real post-acquisition improvement opportunity. Don’t treat collection problems as a reason to walk away without first quantifying what they’re worth.

Quantifying the Collection Gap

Run this calculation:

1. Identify total AR in the 90+ bucket
2. Apply a realistic collection rate to that bucket — industry experience suggests 30–50% collectibility for accounts 90–180 days, and under 20% for accounts over 180 days
3. Subtract expected collections from total 90+ AR to get estimated loss
4. Add that estimated loss to any write-offs the seller isn’t formally recording
5. That total is your quantified collection gap

If the collection gap is $40,000 on a $1.2M purchase price, you have a direct case for a price reduction, a working capital adjustment, or both.

Working Capital Adjustment at Closing

The standard working capital peg in funeral home acquisitions includes AR as a current asset. If the AR balance includes significant stale or uncollectible accounts, the peg is inflated. You have two options:

• Exclude 90+ day AR from the working capital peg — treat it as a below-the-line item rather than a current asset
• Apply a haircut to the peg — reduce the target working capital by the estimated uncollectible portion

See the working capital adjustments at closing guide for how to structure this negotiation. This is one of the most common post-LOI negotiating points in small funeral home transactions, and having the aging data makes the case objective rather than adversarial.

The Post-Acquisition Upside Case

Separately from the price adjustment, model what happens if you tighten collections post-acquisition. If the business is currently writing off 5% of revenue and you bring that to 2%, the annual improvement on $800,000 in revenue is $24,000 — a real increment of operating cash flow that belongs in your acquisition model as an identifiable value creation lever.

This framing is useful in seller conversations too. Rather than presenting collection problems as seller failure, you’re acknowledging them as an operational improvement you’re taking on. That’s a more productive negotiating posture.

The AR Audit Checklist: What to Request and What to Look For

Documents to Request

• Full AR aging report — current as of the most recent month-end, broken out by bucket (0–30, 31–60, 61–90, 91–120, 120+)
• Itemized list of accounts over 90 days — name, amount, last payment date, status (active plan, disputed, collection agency, no contact)
• Three years of bad debt write-off history — formal write-off log or general ledger detail
• Insurance AR broken out by carrier — for any carrier with claims over 45 days old
• Any accounts currently with a collection agency or attorney — name, amount, status
• Payment plan agreements — sample of five to ten active plans, including signed documentation and payment history

Red Flags

• 90+ day AR exceeds 20% of total AR
• No formal bad debt write-off process — uncollectibles have never been written off
• Significant insurance AR over 60 days with no documented filing issues
• Family receivables with no signed payment agreements
• Write-off rate above 5% of revenue
• Write-offs increase year-over-year without a corresponding explanation
• Seller cannot produce itemized aging by account — only summary-level totals
• Any large single-account receivable (>$15,000) over 90 days with no active collection activity

Green Flags

• 90%+ of insurance AR is under 45 days
• Business uses assignment funding for a meaningful percentage of insurance cases
• Formal write-off policy with annual review cycle
• Payment plans are documented with signed agreements and consistent payment history
• Collection rate for payment plan accounts exceeds 85%
• Bad debt write-offs are stable at 1–2% of revenue over three years

How to Incorporate into Your Financial Model

• Exclude 90+ day AR from working capital calculations — model it separately as a “recovery asset” with a 30% haircut
• Adjust normalized EBITDA downward by the difference between actual write-offs and a 2% normalized rate — if actual is 5%, add back 3% of revenue as an addback you’ll recover through better collection
• Build a post-close collection improvement scenario — show what 2% write-off discipline does to year-two and year-three cash flow
• Use the collection gap calculation as the basis for a working capital peg reduction in LOI negotiation

Frequently Asked Questions

How do I get the AR aging report if the seller is reluctant to provide it?

Frame it as a lender requirement rather than a buyer request. SBA lenders reviewing financial due diligence for acquisition financing require current receivables aging as part of the underwriting package. If the seller won’t produce it, that resistance is itself a data point. No legitimate business with clean receivables withholds an aging report.

What’s the difference between gross AR and net AR on the balance sheet?

Gross AR is the total amount billed and owed. Net AR is gross AR minus an allowance for doubtful accounts — an estimate of what the business doesn’t expect to collect. If the balance sheet shows net AR without disclosing the allowance, ask for the gross figure and the allowance separately. A large allowance on a small balance sheet means the seller knows the receivables are troubled.

Can I use the aging report to challenge the purchase price after signing an LOI?

Yes, but timing matters. LOIs are typically non-binding on price, and the due diligence period is specifically designed to surface information that affects valuation. If the aging report reveals material uncollectible AR that wasn’t disclosed pre-LOI, you have a legitimate basis to renegotiate price or working capital terms before the purchase agreement is executed.

What if the business has very few family receivables because they require payment upfront?

That’s a positive signal. A business that collects full payment at time of service has near-zero family AR aging risk. Confirm this by reviewing the payment methods on a sample of arrangement records — you’re looking for high credit card or cash payment rates at arrangement conference, not deferred billing.

Is insurance AR different from family AR in terms of collectibility?

Yes, materially. Insurance AR is collectible from a solvent carrier — it’s a timing problem, not a credit risk problem. Family AR is a credit risk with a person who may not have the means or motivation to pay. Treat them entirely differently in your analysis. Stale insurance AR (60–90 days) is usually an operational fix. Stale family AR (60–90 days) is a collection culture problem.

Connecting This to the Broader Due Diligence Picture

The AR aging report doesn’t stand alone. It’s one piece of a larger financial picture that includes the income statement, balance sheet, quality of earnings analysis, and first-year cash flow modeling.

What makes the aging report powerful is specificity. Every number in it is an actual account, an actual family, an actual carrier. It converts abstract financial risk into operational reality. When you know that $28,000 of the business’s receivables is sitting with three families who haven’t responded to statements in 90 days, you can make a decision. When you only know that total AR is $180,000, you can’t.

The buyers who get the best deals — and avoid the worst post-closing surprises — are the ones who read the operational data, not just the summary financials. The AR aging report is one of the most operational documents in the due diligence package. Treat it that way.

Funeralhomebuyer.org provides independent educational content for professionals evaluating funeral home acquisition. This guide does not constitute legal, accounting, or financial advice. Consult qualified professionals before making acquisition decisions.