RECEIVABLES
Accounts Receivable Aging as a Funding Document
How an aging report turns into borrowing capacity, which balances get excluded first, and what the same report quietly says about how you run the business.
Somebody asked you for an aging report, you exported one, and it came out as a wall of customer names and columns. It looks like a bookkeeping artifact. In a funding file it is doing two jobs at once, and neither one is obvious from looking at it.
The first job is collateral. If you are borrowing against receivables, the aging is the asset, and the report is how the amount you can draw gets calculated. The second job applies even when nobody is lending against them: your receivables are usually the largest current asset on the balance sheet, and the aging is the only document that says whether that number is real. A balance sheet says 342,000 dollars. The aging says whether it is 342,000 dollars of money arriving soon or 342,000 dollars that includes a customer who stopped answering in March.
What the report actually is
Rows are customers. Columns are age buckets, commonly current, one to thirty days, thirty-one to sixty, sixty-one to ninety, and everything past ninety. Each open invoice lands in a column based on how old it is.
Based on how old it is from what is the detail that trips people up. A report can age invoices from the invoice date or from the due date, and the two produce different pictures of the same business. On sixty-day terms, an invoice issued forty-five days ago is current by due date and sits in the thirty-one to sixty column by invoice date. Same invoice. Same customer. Nothing wrong.
So label it. Put the basis at the top of the report and say it again in your cover note. An aging with no stated basis gets read on whichever assumption the reader defaults to, and if that assumption is the harsher one, you have handed over a worse version of your own business for no reason.
It has to tie
The total of the aging must equal the accounts receivable balance on your balance sheet for the same date. Same day, same number.
When it does not, one of them is wrong, and an analyst comparing the two will find the difference before you do. The usual causes are dull. Unapplied customer credits sitting outside the aging. A journal entry posted directly to the receivable account instead of against an invoice. Credit balances being netted in one report and shown separately in the other. A report run as of today against a balance sheet run as of month end.
Run both as of the same closed month end, check that the totals match, and fix the books if they do not. This takes ten minutes and it removes an entire category of question.
What gets removed before anybody lends against it
A facility that lends against receivables defines eligibility in its own agreement, and the definitions are not standard across agreements. But the categories of exclusion recur, because they all answer the same question: will this particular dollar be collected in the ordinary course.
Invoices past a stated age come out. Balances owed by a company you also own come out. Government and foreign receivables are often treated separately because collection works differently. Progress billings on work not yet accepted come out where the customer can still dispute them. Balances from a customer who also sells to you come out to the extent of what you owe them, since that customer can offset. And any one customer above a stated concentration percentage is capped, with the excess treated as ineligible.
Then an advance rate is applied to what survives.
The arithmetic
Take that 342,000 dollar total and break it out: 187,000 current, 82,000 in the one to thirty bucket, 42,000 in thirty-one to sixty, 18,000 in sixty-one to ninety, and 13,000 past ninety.
Say the 13,000 past ninety belongs to three smaller accounts, and that 8,000 of the total is owed by a sister company you also own. Your largest customer is at 117,000, which is about thirty-four percent of everything outstanding.
Now suppose the agreement excludes anything past ninety days, excludes related parties, caps a single customer at twenty-three percent of the gross total, and advances seventy-eight percent against what remains. Those percentages are set by the lender in the document; you do not pick them, and different facilities use different ones.
Twenty-three percent of 342,000 is 78,660, so the excess above the cap on your largest customer is 38,340. Take out the 13,000, the 8,000, and the 38,340, and eligible receivables come to 282,660. At seventy-eight percent, the availability is roughly 220,000 dollars.
You have 342,000 of receivables and about 220,000 of borrowing capacity. Nothing in that sequence is a trick, every step is written in the agreement, and two of the three deductions are things you could have changed with enough lead time.
Days sales outstanding
One number summarizes the whole report. Divide receivables by credit sales for a period, then multiply by the days in that period.
With 342,000 outstanding against 693,000 of sales across a ninety-one day quarter, that is about forty-five days.
By itself forty-five means nothing. Set beside your stated terms it means quite a lot. On thirty-day terms, forty-five days says you are financing your customers for an extra two weeks on every invoice, out of your own working capital, at whatever your money costs you. That is the real conversation hiding inside an aging report, and it is worth having regardless of whether anybody is lending you anything.
Track it monthly. A rising number is the earliest warning you get, and it shows up long before the cash problem does.
What the aging says about how you run the place
An experienced reader learns things from this report that have nothing to do with collateral.
Whether invoices go out when the work finishes or whenever somebody gets to it. A cluster of invoices all dated the last day of the month is a tell.
Whether anybody is calling. A balance sitting untouched at a hundred and forty days says either nobody called or the customer is not going to pay, and the reader cannot tell which, so they assume the second one.
Whether you set terms at all. Invoices scattered across every possible age with no pattern suggests terms are being negotiated one customer at a time, or not written down.
Whether you have a concentration you have not noticed. Plenty of owners know their biggest customer is big and have never divided.
Producing one worth sending
Run it as of a closed month end. Label the aging basis. Check the total against the balance sheet. Use real customer names rather than lumping small accounts into a line called various, because a reader cannot assess a concentration they cannot see. Show credit balances separately instead of netting them into other customers.
Then write four or five lines underneath. The largest customer and what they are as a share of the total. The oldest balance, what happened, and what you are doing about it. Any related-party amount, named as such. Your stated terms, and your current days sales outstanding against them.
That note takes fifteen minutes and it answers most of what the reader was going to ask. The ones who do this are not better at collections than everybody else. They just stopped letting the report speak for itself.
Common questions
what is an accounts receivable aging report used for in a loan
It does two jobs. When you borrow against receivables it is the collateral itself, and the eligible portion of it sets how much you can draw. Even when nothing is secured by it, the aging is the only document that shows whether the receivable figure on your balance sheet represents money arriving soon or a balance nobody is collecting.
why is my borrowing base lower than my total receivables
Because eligibility is defined in the loan agreement and several categories come out before anything is advanced. Balances past a stated age, amounts owed by companies you also own, disputed or unaccepted progress billings, and the portion of any single customer above a concentration cap are common exclusions. An advance rate is then applied to whatever survives.
how do I calculate days sales outstanding
Divide your receivable balance by credit sales for a period, then multiply by the number of days in that period. Compare the result against the terms you actually put on your invoices. If your terms are thirty days and the calculation says forty-five, you are funding your customers for the extra fifteen days out of your own working capital.