How to monitor loan covenants between quarterly reports

The compliance certificate is a backward-looking document. By the time you sign it, the quarter it describes is over and the next test is already underway. If that certificate is the only time anyone computes your covenants, you are flying a quarter behind the aircraft.

Here is how to run a live, between-quarters read — and why it is worth the effort.

Start from the books, not a spreadsheet

The most common monitoring tool is a spreadsheet that someone updates by hand. It drifts the moment a journal entry lands or a cell formula is overwritten. A durable approach pulls the inputs directly from QuickBooks:

• P&L lines for the EBITDA build — operating income, interest, taxes, depreciation, amortization.
• Balance-sheet items for leverage and liquidity — funded debt and cash.

Recompute from the source each time and the number you monitor always reconciles to the books.

Carry the non-QuickBooks inputs forward

A few covenant inputs simply do not exist in QBO, and that is fine — you enter them once and carry them:

• The scheduled debt service (principal and interest) from your amortization schedule.
• The financed vs. unfinanced capex split.
• Revolver availability and any cash-tax estimate.

These change slowly. Set them with the agreement and revisit when the facility changes.

Watch the slope, not just the line

A single quarter's pass tells you little. Track each covenant across periods and the trend does the talking: leverage creeping up two-tenths a quarter as EBITDA softens is a breach you can see coming long before the threshold.

Set a watch band — a cushion around each threshold — and treat the band as your real deadline. Inside it, you still have options. Past it, you are negotiating.

Project the next test

Between-quarters monitoring becomes genuinely useful when it looks forward. Take your trailing-twelve-month position, grow EBITDA by a plausible (or deliberately conservative) assumption, amortize the debt on schedule, and recompute. The output you want is simple: the first period any covenant is projected to breach.

That single date reframes everything. Instead of "did we pass last quarter," the question becomes "what do we change before the quarter that breaks" — a capex deferral, an early paydown, or an amendment conversation you start from a position of foresight rather than apology.

That is the whole game: turn the covenant from a quarterly verdict into a continuous, forward-looking instrument.