All guides
Guide · Financials – G/L

Reporting to your lender

A bank line of credit set up with the bank's rules, the borrowing base certificate built from your books each month, and loan covenants tested every night.

2 min read

Watch it done: Show your lender the numbers

A line of credit secured on receivables and inventory usually comes with two monthly chores: a borrowing base certificate, saying how much you may borrow against what you hold, and covenants, the ratios the bank wants you to stay within. BeanDish builds the certificate from your books and tests the covenants for you.

The facility

Open Controls – Compliance › Lender reporting. It shows each facility's latest certificate, what you can borrow, your excess availability and its covenants. Click Add facility.

  • Main. The name, the lender, the limit, the loan account its balance sits on, and the day of the month the bank wants last month's certificate.
  • Receivables. The bank's rules: how old an invoice can be before it stops counting, the cross-age share, the concentration cap for any one customer, the advance rate, and whether customers billed outside the US are left out. Intercompany customers are always left out.
  • Inventory. The slow-moving days, the advance rate and an optional cap. Lots on hold and expired lots never count.

Click Save changes.

The borrowing base certificate

Click Borrowing base, choose the as-of date and click Run. You see receivables less each ineligible line, inventory less its ineligible lines, the borrowing base, the loan balance and the excess availability.

Save certificate keeps it exactly as it stood, so the figures you sent the bank never change afterwards. Export it to PDF or Excel for the bank; Receivables by customer is the detail behind it. Saved certificates are listed below.

Covenants

On the Covenants tab, click Add covenant: a name, the measure, at least or at most, the threshold, how often it is tested, and a warning margin that flags it at risk before it is breached. Open a covenant to see its history.

Covenants are tested each night once a period's reporting day has passed. A covenant at risk or breached raises an alert. The compliance calendar lists each certificate due and each covenant test.

See every step

The video above shows a facility, a certificate and its covenants in about two minutes. The tutorial below goes slower, through every rule. The same tutorial is in BeanDish under Learn › Tutorials.

Report to your lender, step by step

A bank line of credit from start to month end: the facility and the bank’s receivables and inventory rules, the borrowing base certificate run from the books, saved and exported for the bank, and the covenants tested every night. (3:43)