Accounts Receivable Aging Report: What Lenders Review

Your receivables total says how much customers owe. An aging report helps explain which balances remain unpaid, how long they have been outstanding, and where a financing provider may need more information.

When preparing an accounts receivable aging report for financing, the goal is a clear, reproducible record. For an established business, a useful submission includes the report settings, invoice detail, and explanations for unusual balances—not just a total copied into an application.

What an accounts receivable aging report shows

An aging report groups outstanding customer balances into time periods. A customer summary helps you see the overall position; invoice detail lets a reviewer examine individual transactions. Intuit’s aging-report guidance distinguishes these two views.

For a due-date-based report, columns may include current, 1–30 days past due, 31–60, 61–90, and older balances. These are reporting categories. They are not automatic financing eligibility rules.

Export the detail as well as the summary. A customer with a small net balance may have several unpaid invoices and unapplied credits that deserve separate attention.

Confirm which date the report uses

Two settings matter: the report’s as-of date and the date used to calculate age. Sage Intacct’s documentation illustrates that software can age transactions by invoice date, due date, or posting date.

Consider a hypothetical invoice issued August 1, due August 31, and still unpaid on September 28, 2026. It is 58 days from its invoice date, but 28 days past due. Describing it simply as “58 days old” leaves an important question unanswered.

Keep the basis visible on the export. If a provider asks for invoice-date aging and your system produces due-date aging, clarify the requested format before submission. Also check whether a historical report uses balances as of that date or incorporates subsequent payment activity.

Make the numbers traceable before sending them

Ask your accounting team to prepare a consistent file using the requested cutoff date. Useful detail includes customer name, invoice number, invoice date, due date, original invoice amount, remaining balance, and any credits or payments applied.

J.P. Morgan’s receivables guidance emphasizes matching collections to invoices and reconciling records. Put that into practice with three checks:

1. Match the detail to the summary. Confirm that each invoice appears once and that the customer totals add up.
2. Reconcile to the accounting records. Use the same entity, currency, and cutoff. Explain differences, including any separately recorded allowances, instead of forcing the totals to agree.
3. Review unapplied amounts. Investigate payments or credits still sitting separately from the invoices they belong to. Preserve the accounting trail when correcting an error.

Keep a dated copy of the export. Add later collections in a separate update so someone can follow what changed after the original report.

If customer payment timing is creating a funding need, apply with Sussex Capital and include the aging report you currently maintain. Explain the amount needed and what the financing would support.

What lenders review beyond the age columns

The OCC’s receivables financing handbook discusses customer quality, concentrations, delinquency trends, and reductions such as disputes, returns, and credits.

Prepare concise notes for balances that raise questions:

• Disputed invoices: Identify the disputed amount, the issue, and the next documented step toward resolution.
• Large customer balances: Show how much of the total depends on each major customer, including relevant related accounts.
• Payment status: Separate an expected payment, a customer’s stated payment date, and money actually received.
• Changes over time: Explain material balances moving into older categories, using reports prepared on the same basis.

An old invoice and a disputed invoice may be the same balance. Do not count the amount twice when explaining exceptions.

A hypothetical report: read the mix, not just the total

Assume a business has $100,000 outstanding on a report aged by days past due:

• Current: $60,000.
• 1–30 days past due: $25,000.
• 31–60 days past due: $10,000.
• 61–90 days past due: $5,000.
• More than 90 days past due: $0.

The overdue portion is $40,000, or 40% of the total. Now suppose one customer owes $35,000 across those categories. That customer represents 35% of total receivables; its balance is already included in the $100,000.

Suppose $8,000 of the $10,000 in the 31–60 category is disputed. The dispute is another fact about those invoices, not another $8,000 to add to receivables or overdue balances.

The useful follow-up is specific: which invoices make up that $8,000, what is disputed, and what evidence supports the expected collection? None of these example percentages establishes eligibility or a financing amount.

Receivables are not the same as available funding

A provider’s agreement determines which receivables qualify and how they support funding. Aging limits, concentration treatment, reserves, and other terms differ. There is no universal past-due cutoff that every financing provider uses.

Keep three amounts separate: the accounting balance, the eligible receivables determined under the proposed agreement, and the funds actually available. Our asset-based lending borrowing-base guide explains that next calculation.

Before submitting, put the summary, invoice detail, reconciliation, and exception notes together. Name the person who can answer billing questions and identify any existing financing secured by receivables. The business financing application document checklist covers the rest of the supporting file.

Sussex Capital is a commercial finance broker serving established businesses. Start your financing application with your funding purpose and current records. Funding providers determine eligibility, approvals, and terms.

Sources & further reading

• Intuit — Run an accounts receivable aging report in QuickBooks
• Sage Intacct — Customer Aging report
• J.P. Morgan — What are accounts receivable?
• Office of the Comptroller of the Currency — Accounts Receivable and Inventory Financing

Put your financing plans into motion

Tell Sussex Capital about your established business, how much capital you need, and what you want it to accomplish.

Start your application

Financing is subject to provider review, eligibility, and terms.