Loan Covenant Tracking Template for Excel

What loan covenant tracking is

Loan covenant tracking is the practice of recording every credit facility, its covenants, and each certification against its threshold and due date — alongside the security interests, guarantees, and letters of credit tied to that debt — in one place.

A covenant certificate comes due 45 days after quarter-end, and no one calendared it. A lender’s diligence team asks for every facility, UCC filing, and guarantee, and the answer sits scattered across a deal folder. This loan covenant tracking template for Excel keeps that record together before either moment arrives.

This is a record of a company’s debt stack, not a model. It carries no payment schedule and no amortization math. It proves what a company owes and has pledged against it, not what a facility will cost over time.

What’s inside the Excel workbook

This corporate treasury spreadsheet template ships as one Excel workbook, 13 sheets deep. A Start Here tab leads, followed by 12 data sheets covering accounts, facilities, covenants, security, guarantees, and letters of credit. Together they hold 177 fields behind 24 pre-built dropdown lists, and the workbook opens in Google Sheets as well as Excel.

Bank accounts and controls

Bank Accounts — 17 fields — is the master list of every deposit and operating account. It holds institution, SWIFT/IBAN, currency, account type, and the dual-signature threshold that gates a wire above a set amount.

Account Signatories sits alongside it, on its own sheet, keyed back to the Bank Accounts row it belongs to. It records who can transact on each account, without crowding the account row itself. A dual-signature threshold on one account and a single approver on another stay visible side by side, instead of buried in a bank’s own portal.

Credit facilities and covenants

Credit Facilities, Facility Parties, Facility Amendments, Facility Covenants, and Covenant Certifications form the core of this workbook. Together, these five sheets make it a credit facility tracking spreadsheet template and a debt covenant compliance tracker template in one.

Credit Facilities — 20 fields — holds real instrument types: revolver, term loan, line of credit, mezzanine, bridge loan, and bond. Each row carries rate, reference rate, spread, floor, and maturity. Facility Parties — 8 fields — records borrowers, co-borrowers, and guarantors with a liability type and guarantee amount.

Facility Amendments — 19 fields — logs every re-pricing, maturity extension, or covenant change on its own row. A re-pricing never overwrites the prior terms.

Facility Covenants — 11 fields — covers financial covenants such as leverage ratio, interest coverage ratio, and minimum liquidity, plus negative and affirmative covenant types. Each row carries a threshold, a certification due date and frequency, breach terms, and waiver details. Miss the certification date and the covenant technically breaches, whether or not the underlying ratio would have passed.

Covenant Certifications — 13 fields — closes the lifecycle: covenant, certification schedule, compliance result, and waiver. Each certification gets its own row, with a certified value tested against the threshold and a result of Compliant, Non-Compliant, or Waived.

Security, guarantees, and LCs

Security Interests — 11 fields — records the collateral pledged to secure financing. Security Interest Filings — 13 fields — tracks the UCC filing itself: filing type, jurisdiction, filing office, and lapse date. That lapse date is the field that quietly kills a perfected priority if it’s missed.

Guarantees — 18 fields — covers parent, subsidiary, payment, and performance guarantee types, each with an obligation and a maximum amount. A subsidiary’s covenant breach can pull that guarantee exposure straight to the parent.

Letters of Credit — 24 fields — covers standby, commercial, import, export, revolving, transferable, and back-to-back LCs, with issuing and advising banks and drawing conditions. LC Amendments — 13 fields — logs every LC modification on its own row. Together, these three sheets make up the guarantee and letter of credit tracker half of the workbook.

How to track loan covenants in Excel

To track loan covenants in Excel:

1. Add a row per facility in Credit Facilities. Facility type, commitment, rate, and maturity go on every row before anything else.
2. Attach each covenant to its facility, with a threshold, a frequency, and a due date. Facility Covenants ties every requirement back to the facility it belongs to.
3. Give each certification its own row. A quarter’s compliance result never overwrites the last certification in Covenant Certifications.
4. Log security interests and UCC filings, with lapse dates. A pledge without a tracked filing date is a priority waiting to lapse.
5. Record guarantees and letters of credit against the obligations they support. Each one keys back to the facility or entity it protects.
6. Sort Certifications by due date, and Filings by lapse date. That’s the fastest way to see what’s coming due first across the whole debt stack.

One row per instrument

Each row in Credit Facilities should represent exactly one instrument. Covenants, certifications, security interests, guarantees, and letters of credit each key back to the facility or entity they belong to. Flattening a covenant into a notes cell loses exactly what this tracker exists to hold.

Certification and lapse dates

Sort or filter Covenant Certifications by due date, or Security Interest Filings by lapse date. The next deadline in that category rises to the top.

A quarterly certification and an annual UCC continuation land on different clocks, so a shared sort order keeps both visible. Add your own conditional-formatting rule to either date column for a visual cue between sorts.

In Excel: Home > Conditional Formatting > Highlight Cells Rules > A Date Occurring. The workbook ships with raw dates only. It carries no formulas or built-in alerts, and nothing here fires a reminder until you set one up.

Built for corporate treasury teams

CFOs, treasurers, controllers, and finance counsel at multi-entity organizations with bank debt feel a scattered covenant record first. They’re the ones asked to produce every certification, filing, and guarantee the moment a lender or an auditor calls.

Free templates online typically stop at a single covenant-ratio table or a payment schedule. This workbook runs the opposite way, carrying the full lifecycle — facility, covenant, certification, waiver — alongside the security, guarantee, and LC stack behind it. A covenant breach surfaces in a certification nobody calendared, and a lapsed UCC filing surfaces when a junior lender jumps priority.

Bank Accounts and Credit Facilities key to the holding entity, so a group with several subsidiaries shares one workbook instead of a spreadsheet per entity.

When a spreadsheet stops working

This tracker covers a growing debt stack before it runs into real edges. There’s no version history, so an overwritten covenant threshold erases its own past. With more than one person editing the file, nothing controls who sees which facility’s terms.

Nothing fires an alert when a certification or a UCC lapse date comes due. That gap can run for a full quarter. It usually surfaces during a lender audit or a refinancing.

A workbook also has no workflow. Nobody gets routed a task when a covenant test comes up short, and no one signs off on a waiver inside the file itself. Those steps happen in email threads that never make it back into the tracker.

From workbook to system

This template’s column headers match Lextree’s import templates, so it loads directly into loan covenant compliance software — no re-keying, no remapping.

Certifications that surface themselves

From there, dates drive reminders instead of waiting for someone to open the sheet. Finance leaders overseeing covenant compliance use them so a certification chases itself instead of appearing at the next lender audit.

Frequently asked questions

What is loan covenant tracking? Loan covenant tracking is the practice of recording every credit facility, its covenants, and each certification against its threshold and due date — alongside the security interests, guarantees, and letters of credit tied to that debt — in one place.

What are the three types of loan covenants? Affirmative covenants require the borrower to do something, negative covenants prohibit an action, and financial covenants set a threshold to maintain — a leverage ratio, an interest coverage ratio, or a minimum liquidity level, for example. The workbook’s Facility Covenants sheet records all three covenant types against every facility.

Is this a debt schedule or amortization calculator? No. This template records facilities, covenants, and certifications as they stand today. It computes no interest, no payment schedule, and no amortization — those live in a different kind of workbook entirely.

Does this track property or real-estate financing covenants? No. Property-secured financing and its covenants belong to a commercial property register, keyed to the property itself. This workbook holds company-wide credit-facility covenants instead.

Is this template for lenders or borrowers? This is a borrower-side tool, built for a company tracking its own facilities, covenants, and certifications — not a lender monitoring covenants across a portfolio of many borrowers. A lender managing that kind of portfolio needs a different tool entirely.

How do I track loan covenants in Excel? Log every credit facility on its own row, then attach each covenant with a threshold, a certification frequency, and a due date. Give each certification its own row in Covenant Certifications rather than overwriting the last one.

How often are loan covenants tested? Most covenants are certified quarterly or annually, and the certification frequency field on Facility Covenants records each covenant’s own schedule. Covenant Certifications then logs every period against its due date, so the testing history stays on record.

How do I track covenant compliance certificates? Covenant Certifications holds one row per certification — the period it covers, the due date, the submission date, the certified value, and the compliance result: Compliant, Non-Compliant, or Waived. Sorting by due date surfaces the next certificate coming due.

What happens if a loan covenant is breached? What happens after a breach depends on the terms of the facility itself — many breaches end in a lender waiver rather than a default. The workbook records each facility’s breach terms and waiver details on Facility Covenants, and every certification logs a result of Compliant, Non-Compliant, or Waived on Covenant Certifications.

Can I track credit facilities and amendments in one spreadsheet? Yes. Credit Facilities holds the current terms, while Facility Amendments logs every re-pricing, maturity extension, or covenant change on its own row. The original terms stay on record instead of being overwritten.

How do I track security interests and UCC filings? Security Interests records the collateral, secured party, and priority for each pledge. Security Interest Filings tracks the UCC filing itself, including its lapse date — the field that quietly kills a perfected priority if it’s missed.

Can I track letters of credit and guarantees? Yes. Letters of Credit covers standby, commercial, and back-to-back LCs with issuing bank and drawing conditions. Guarantees tracks parent, subsidiary, payment, and performance guarantees with a maximum exposure amount.

Can one workbook cover multiple entities’ bank accounts? Yes. Bank Accounts and Credit Facilities each key to the holding entity, so a group with several subsidiaries shares one workbook instead of a spreadsheet per entity.

Who is this template for? CFOs, treasurers, controllers, and finance counsel at multi-entity organizations carrying bank debt, credit facilities, or letters of credit.

Is the template free, and does it work in Google Sheets? Yes. Enter your email below and the workbook is sent to your inbox — no credit card, no sales call. It opens in Google Sheets as well as Excel, dropdowns included.