Accounts Receivable Aging

An accounts receivable aging is a report that lists what each customer owes a business, sorted by how long each invoice has been outstanding, and it determines which receivables count as collateral in a borrowing base.

Formula

How is an accounts receivable aging measured?

Each customer's balance is split into buckets by days from invoice date (some agings use days past due date instead).

Share of a bucket = bucket balance / total receivables

Share past 60 days = (61 to 90 days + over 90 days) / total receivables

  • Buckets: commonly 0 to 30, 31 to 60, 61 to 90 and over 90 days.
  • Customer detail: the balance and bucket split for each customer, which reveals concentration and slow accounts that totals hide.
  • Total: must equal accounts receivable on the balance sheet or the borrowing base certificate for the same date.

What does an aging show on a sample C&I deal?

Illustrative figures for Sample Fabrication, Inc. at fiscal year end.

Days from invoiceAmountShare
0 to 30$960,00060.0%
31 to 60$384,00024.0%
61 to 90$144,0009.0%
Over 90$112,0007.0%
Total$1,600,000100.0%

The total ties to the balance sheet. Over 60 days is $256,000 (16.0%). The customer detail adds three findings the totals do not show:

  • Customer 1 owes $520,000, 32.5% of all receivables, all within 60 days.
  • Customer 7 owes $60,000, of which $40,000 (66.7%) is over 90 days.
  • Customer 4 owes $90,000 and is also a supplier owed $48,000 by Sample Fabrication.

Together with the $112,000 over 90 days, these findings produce $300,000 of ineligible receivables under the revolver's illustrative terms.

How do lenders use an aging?

For an asset-based loan or revolver, receivables are the primary collateral, and the aging is the evidence of what they are worth. Old balances are less likely to be collected, a large customer can slow payment and change the borrower's cash position in a month, and customers who are also suppliers can offset what they owe. Many lenders require an aging with each borrowing base certificate and test it during periodic field examinations.

Illustrative policy treatment: an accounts receivable aging with every borrowing base certificate, tied to the certificate total, with invoices over 90 days ineligible.

Where does aging analysis go wrong?

  • Accepting an aging whose total does not tie to the general ledger or the certificate for the same date.
  • Ignoring re-aging, where invoices are reissued or credits applied to move balances into newer buckets.
  • Reading only bucket totals and missing a customer with most of its balance past 90 days.
  • Mixing invoice-date and due-date agings across periods, which changes every bucket.
  • Leaving unapplied cash and credit memos off the report, which overstates the balances.

Where does the aging appear in the credit memo?

A summary of the buckets, the largest customers and the trend in the over-90 share appears in the collateral section of a revolver memo, beside days sales outstanding and the borrowing base calculation.

Related terms

Ineligible receivables, borrowing base, customer concentration, days sales outstanding, borrowing base certificate.

Where LenderBox does this work

Through financial spreading, LenderBox reads each receivables aging, ties its total to the certificate and the balance sheet and cites every figure to its page, so past-due, cross-aged and concentrated accounts are found before you advance.

See it worked on a deal you bring.

A 30-minute demo can run on documents you bring: LenderBox reads the file, shows the source page behind each figure, and checks the result against your credit policy.

See it on your deal
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.