Insights / Lender reporting
Borrowing base reporting without the monthly scramble
If your company has an asset-based loan, the borrowing base certificate decides how much you can draw. It is also one of the most error-prone reports finance produces, because it is often rebuilt by hand from an aging report every week or month.
How a borrowing base works
The lender advances a percentage of eligible collateral, usually accounts receivable and sometimes inventory, minus reserves. The basic math:
- Gross receivables
- minus ineligible receivables
- = eligible receivables, times the advance rate
- plus eligible inventory times its advance rate, if included
- minus reserves = availability, then minus outstanding loans = excess availability
The ineligibles that cause trouble
Your credit agreement defines them. Common ones include:
- Aged items: invoices past a set number of days from invoice date.
- Cross-aging: if a large share of a customer's balance is past due, all of it can become ineligible.
- Concentration limits: exposure to one customer above a set percentage.
- Contra accounts: customers you also owe money to.
- Affiliates, foreign customers, credits in prior periods and unapplied cash.
Automate it from the ERP
- Build an aging by invoice date (not due date, unless your agreement says so) at the invoice level.
- Add fields that flag each ineligible category, driven by rules, not manual tagging.
- Calculate cross-aging and concentration at the customer level.
- Tie total receivables to the general ledger every time, with the difference shown.
- Output the certificate in your lender's format with a supporting detail tab.
Common mistakes
- Using due-date aging when the agreement specifies invoice date.
- Leaving unapplied cash in gross receivables.
- Missing a customer who has become a vendor (contra).
- Not reconciling the aging to the GL before submitting.
Want this done for you?
We build these processes inside your ERP, usually NetSuite. Start with a free 30-minute teardown.