Commercial Real Estate Loan Covenant Tracking Software for Landlords

The loan closed. The closing binder is saved. Then the property moves into normal operations, and the loan agreement becomes easy to forget—until an annual financial package, a debt-service test, an insurance certificate, or a lender request lands with a short deadline.
That is the real covenant-tracking problem for commercial landlords. It is not a question of doing fresh underwriting every month. It is post-close administration: knowing what the signed documents require, when something is due, where the supporting numbers came from, and whether the lender received the right version.
For a single property, that work may begin in a spreadsheet and a shared folder. As the portfolio grows, the risk is usually not that nobody has the documents. It is that the loan agreement, reporting calendar, accounting records, lender correspondence, and owner responsibilities live in different places.
This guide covers a practical operating workflow. It is general information, not legal, lending, tax, or accounting advice. The signed loan documents, lender instructions, and your own accountant and counsel control when there is a question about a requirement or calculation.
What Loan Covenant Tracking Actually Means
A covenant tracker is a working record of the obligations that apply after closing. It should turn long legal documents into an operating view without pretending to replace them.
For each loan, a landlord should be able to answer:
- What document creates the requirement?
- What exactly must be delivered, maintained, tested, or avoided?
- When is it due, and what event starts the clock?
- Who prepares it, reviews it, and sends it?
- Which source records support the submission or test?
- What was sent to the lender, when, and by whom?
Banks themselves are expected to have processes for monitoring loan covenants and for obtaining periodic borrower information.[^1] That does not dictate a borrower’s internal process, but it explains why a lender may be precise about formats, reporting periods, certifications, and follow-up questions.
Start With the Controlling Loan Package
Do not build a tracker from memory, an old closing checklist, or a term sheet. Start with the executed documents and identify which version controls.
The core package often includes the loan agreement, promissory note, mortgage or deed of trust, guaranties, assignments, cash-management or deposit-account documents, and every amendment, waiver, consent, or modification. A requirement may appear in more than one place, and an amendment may change only one part of the original agreement.
For each item in the tracker, store a link to the source document and the section reference. The summary field should use plain operational language, but the source citation gives the reviewer a fast way back to the actual text.
A useful record might look like this:
| Field | Example operating entry | | --- | --- | | Requirement | Deliver annual property operating statement and current rent roll | | Controlling source | Loan Agreement, Section 6.4; Amendment No. 2, Section 3 | | Trigger | Fiscal year-end | | Due rule | Within the period stated in the agreement after fiscal year-end | | Owner | Controller prepares; asset manager reviews; authorized signatory sends | | Source records | General ledger, property financials, rent roll, supporting schedules | | Delivery evidence | Dated email or portal confirmation and final PDF package | | Status | Not started, in preparation, submitted, accepted, or follow-up required |
The goal is not to interpret ambiguous language inside the tracker. Flag ambiguity, attach the relevant excerpt, and ask counsel or the lender for direction before treating the summary as a rule.
Track More Than Financial Ratios
Debt-service coverage, leverage, liquidity, and net-worth tests get attention because they are measurable. But many operational misses happen outside the ratio tab.
Build categories that fit the actual loan package:
- Financial reporting: property operating statements, rent rolls, borrower or guarantor financial statements, tax returns, budgets, and compliance certificates.
- Financial and performance tests: DSCR, debt yield, loan-to-value, liquidity, net worth, occupancy, leasing, or other tests specifically stated in the agreement.
- Property and collateral requirements: insurance, tax status, inspections, repairs, reserves, environmental items, and replacement reserves where applicable.
- Consent and notice items: leases over a stated threshold, major contracts, ownership changes, additional debt, transfers, casualty, litigation, default notices, or material tenant events.
- Loan lifecycle dates: rate-reset dates, extension conditions, maturity, appraisal updates, refinance milestones, and reserve-release tests.
The exact list varies by lender and property. For income-producing CRE, supervisory guidance discusses periodic property information such as operating statements and rent rolls, with the timing tied to property stability and risk.[^2] Use that as context—not as a substitute for your own agreement’s delivery schedule.
Put Dates on a Calendar With Lead Time
A due date by itself is not a workflow. A report due 90 days after year-end may need accounting close, review, lender-format changes, and sign-off long before the final deadline.
For every recurring requirement, track four dates:
1. Trigger date — such as fiscal year-end, quarter-end, policy expiration, or a lease event. 2. Contract due date — calculated from the written requirement. 3. Internal preparation date — when the responsible person needs inputs in hand. 4. Review and delivery date — when the final package needs approval and submission.
Create reminders at more than one interval. A 60-day reminder is useful for annual reporting, but it will not save a 10-business-day notice requirement. Include the notice method as well: email, lender portal, overnight delivery, or another method named in the documents. If the agreement requires notice to a particular address or person, preserve that detail in the tracker rather than relying on a general lender contact list.
Tie Each Test to Defined Inputs
The most dangerous covenant dashboard is a green one that uses the wrong formula.
Before calculating any ratio, record the definition from the agreement. “Net operating income,” “debt service,” “liquidity,” and “net worth” can be defined differently across loans. A lender may exclude nonrecurring income, require trailing-period figures, use a particular reserve treatment, or specify whether the calculation is property-level, borrower-level, or guarantor-level.
For each test, maintain a small calculation card:
- The agreement’s defined terms and section references
- Testing frequency and measurement period
- Formula exactly as required
- Data owner for each input
- Source report, account mapping, and report date
- Review owner and approval date
- Final calculation and supporting file
Do not quietly substitute a management-report number because it is convenient. If accounting must map a general-ledger account differently for the covenant calculation, document the mapping and keep the bridge. That makes the number explainable later—to a lender, a new controller, or your own review team.
If a result is close to the threshold, treat that as a prompt for a careful review, not an automatic conclusion that a default exists. Confirm the definitions, timing, cure provisions, notice requirements, and lender process with the people who advise you.
Make Document Collection a Repeatable Process
Most reporting packages are assembled from records that already exist: a rent roll, trial balance, bank statement, property operating statement, insurance certificate, tax bill, or entity financial statement. The failure point is often the handoff between systems and people.
Create a recurring checklist for each requirement that names every input and its owner. For an annual package, that may include:
- Final property operating statement for the required period
- Current rent roll, including lease dates and current charges
- Borrower and guarantor financial statements if required
- Tax returns or other specified filings
- Insurance evidence and renewal details
- Compliance certificate or lender-provided form
- Explanations for material variances, if requested
Link the final package back to the documents and reports used to prepare it. Your lease records matter here: a current abstract, amendments, rent schedule, and tenant notices make it easier to confirm what the rent roll is showing. See our guide to NNN lease document management for a practical way to keep those source records usable.
Give Every Requirement One Accountable Owner
“The team handles it” is not an owner.
Assign one accountable person to each tracker item, even when several people contribute. The accountable owner is responsible for moving the item to completion, escalating missing information, and preserving the evidence. Supporting roles can include the controller, property manager, asset manager, outside accountant, lender contact, and authorized signatory.
Use clear statuses that match the work:
- Not started
- Waiting on source documents
- In preparation
- Under internal review
- Submitted to lender
- Lender follow-up required
- Complete
This is especially helpful during vacations, staff changes, refinancing, or a sale. A new team member should be able to see what is pending without opening every email thread from the last year.
Keep a Delivery and Decision Trail
An audit trail is simply the history needed to reconstruct an answer. It should show the requirement, the information used, the review performed, the delivered package, and any lender response.
For every completed item, retain:
- The final report or certificate sent
- The supporting calculation and source reports
- The delivery evidence, including date, recipient, and submission method
- Lender acknowledgement, questions, and final response when available
- Any waiver, consent, amendment, or extension connected to the requirement
Do not overwrite prior submissions when a lender asks for a revision. Keep the earlier version, label the replacement clearly, and note why it changed. The point is not to create paperwork for its own sake. It is to avoid rebuilding the history from scattered inboxes when someone asks, “What did we tell the lender last quarter?”
What to Look For in Covenant Tracking Software
Software can help when it keeps the daily operating pieces connected. It cannot decide what an ambiguous loan provision means or certify compliance for you.
Look for a workflow that can keep the following in one reliable view:
- Loan and property record with lender contacts and key dates
- Requirement tracker with source-document links and section references
- Recurring tasks, calculated due dates, and reminders
- Assigned owner, reviewer, and status for each item
- Attachments for reports, certificates, correspondence, and delivery evidence
- A time-stamped activity history that preserves prior versions and follow-up
Also ask the practical questions. Can you find the amendment that changed a reporting requirement? Can you see the final rent roll used in a submitted package? Can a reviewer tell who approved the calculation? Can you hand the workflow to another person without rebuilding it?
PigJet can help commercial landlords organize property records, lease information, documents, tasks, and operating history around the work that has to get done. For the financial records feeding a lender package, see commercial property owner statement software. For a separate look at loan underwriting inputs, see our NNN DSCR loan guide.
A Simple First 30-Day Setup
If your loan administration is currently split across folders, calendars, and email, start with one active loan rather than trying to clean up the full portfolio at once.
1. Gather the executed loan documents and amendments. 2. List every recurring report, test, notice, consent, and lifecycle date. 3. Add the controlling-document reference and an accountable owner to each item. 4. Build the calendar with preparation and review dates, not only lender deadlines. 5. Define the source records and calculation method for each financial test. 6. Save a completed reporting package and its delivery evidence as the model for the next cycle.
That first pass will expose missing documents, unclear ownership, and requirements that need professional interpretation. Those are useful findings. Better to find them during a structured review than on the final day of a lender deadline.
Bottom Line
Commercial real estate loan covenant tracking is an operating discipline. The signed loan documents remain the authority, but a practical tracker makes them usable after closing.
When definitions, dates, inputs, source files, owners, notices, and delivery evidence are connected, the team spends less time hunting through old folders and more time resolving real questions early. That is the standard to look for in a spreadsheet, a shared process, or covenant-tracking software.
If you are building a more reliable operating record for a commercial portfolio, talk with PigJet about keeping property documents, lease records, tasks, and history easier to manage.
[^1]: Office of the Comptroller of the Currency, *Commercial Loans*, Comptroller’s Handbook, accessed September 15, 2026. [^2]: Office of the Comptroller of the Currency, *Commercial Real Estate Lending*, Comptroller’s Handbook, accessed September 15, 2026.