Glossary
Accounts receivable aging report
An accounts receivable aging report lists unpaid customer invoices and groups them by how long they have been outstanding or past due.
The aging report is one of the first documents requested in invoice factoring and accounts receivable financing. It provides a dated snapshot of who owes the business money, how much is open, and how old each balance is.
The report is useful only when it is current, complete, and prepared on a clearly stated basis.
Key takeaways
- The report should have a clear “as of” date.
- Aging can be measured from invoice date or due date.
- Common buckets are current, 1–30, 31–60, 61–90, and over 90 days.
- Factors use the report to review customer concentration, age, disputes, and possible eligibility.
- Old balances, credits, unapplied cash, and inconsistencies require explanation.
- The total should reconcile to the accounts receivable balance in the accounting records.
What appears on an aging report?
A detailed report commonly includes:
- Customer name
- Invoice number
- Invoice date
- Due date
- Original invoice amount
- Open balance
- Aging bucket
- Credits or unapplied cash
- Total by customer
- Total for the full ledger
- Report date
Some reports summarize only by customer. A factor may request invoice-level detail.
Common aging buckets
| Customer | Current | 1–30 past due | 31–60 | 61–90 | Over 90 | Total |
|---|---|---|---|---|---|---|
| Customer A | $40,000 | $10,000 | $0 | $0 | $0 | $50,000 |
| Customer B | $20,000 | $15,000 | $5,000 | $0 | $0 | $40,000 |
| Customer C | $0 | $0 | $0 | $10,000 | $5,000 | $15,000 |
| Total | $60,000 | $25,000 | $5,000 | $10,000 | $5,000 | $105,000 |
The periods can be customized. Microsoft’s finance documentation describes configurable aging-period definitions rather than one mandatory schedule.[1]
Invoice date versus due date
A report aged from invoice date measures how long the invoice has existed.
A report aged from due date measures how long the invoice has been past due.
Assume an invoice was issued 45 days ago with net-60 terms:
- Invoice-date aging places it in a 31–60-day bucket.
- Due-date aging still treats it as current.
Both reports can be correct. The basis must be stated.
How a factor uses the aging report
The report helps the factor evaluate:
Customer concentration
The factor can see how much of the ledger is owed by each account debtor. A single customer representing most of the receivables can limit availability.
Invoice age
The agreement may exclude invoices beyond a stated age. Older balances may also indicate disputes or collection problems.
Payment patterns
Repeated movement into older buckets can show that a customer pays slowly even when it eventually pays in full.
Credits and dilution
Credit memos, returns, rebates, offsets, short pays, and unapplied cash can reduce the amount expected to be collected.
Borrowing or factoring availability
The factor applies its eligibility rules to the report. The total accounts receivable balance is not necessarily the eligible balance.
Red flags to correct before submission
Common issues include:
- Report is several weeks old
- Customer names do not match contracts or invoices
- Negative balances are unexplained
- Credits are not applied
- Paid invoices remain open
- One invoice appears twice
- The report does not reconcile to the general ledger
- Invoice dates or due dates are missing
- Large balances are marked current despite being overdue
- Disputed invoices are mixed with clean receivables
- Related-party receivables are not identified
- Permanent-placement fees and temporary-staffing invoices are combined without explanation — a common issue in factoring temporary staffing invoices
A clean aging report does not guarantee approval. A poor report can delay the review.
Real-world example
A manufacturer reports $500,000 in accounts receivable. The aging shows:
- $350,000 owed by one customer
- $60,000 more than 90 days old
- $25,000 in unapplied credits
- $40,000 under dispute
The factor does not calculate availability from the $500,000 headline balance. It first considers concentration, age, credits, disputes, and customer limits.
The eligible amount can be materially lower.
How to prepare a reliable report
Run the report as of the most recent closed business day. Apply receipts and credits. Identify disputes. Reconcile the total to the general ledger. Use customer legal names consistently. Export invoice-level detail when possible.
If the accounting system cannot generate a clean report, fix the records before requesting factoring. The aging report is evidence of both collateral quality and financial control.
Common misconception: older always means uncollectible
An older invoice may still be collectible. Long contractual terms, customer payment cycles, government processes, or portal delays can explain the age.
The factor still needs to understand why the balance is old and whether the agreement permits it.
Sources
Frequently asked questions
- What aging buckets should the report use?
- Common buckets include current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days, but the business and funding partner may use different periods.
- Should aging be based on invoice date or due date?
- Either method can be used. The report should state the basis clearly and apply it consistently so the reviewer can interpret the buckets correctly.
- Does an old invoice automatically become ineligible?
- Not automatically, but many factoring agreements set aging limits. An older invoice can also signal a dispute, collection problem, or payment issue that requires explanation.
- Why must the aging reconcile to the general ledger?
- A mismatch can indicate missing invoices, unapplied cash, credits, duplicate entries, or stale data. Reviewers need confidence that the report represents the actual receivable balance.