Insights / Lender reporting

Borrowing base reporting without the monthly scramble

7 minute read · Dellajax

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

  1. Build an aging by invoice date (not due date, unless your agreement says so) at the invoice level.
  2. Add fields that flag each ineligible category, driven by rules, not manual tagging.
  3. Calculate cross-aging and concentration at the customer level.
  4. Tie total receivables to the general ledger every time, with the difference shown.
  5. Output the certificate in your lender's format with a supporting detail tab.
For field exams: keep every certificate's detail file. Examiners will test a sample of invoices, and a saved, rule-based detail file turns a stressful week into a quick one.

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.