Preparing a lender questions tracker tied to original source documents
A concrete worksheet to log lender underwriting questions, link each to its original source document, and distinguish factual answers from assumptions—so you can respond faster and negotiate from evidence.
A concrete worksheet to log lender underwriting questions, link each to its original source document, and distinguish factual answers from assumptions—so you can respond faster and negotiate from evidence.
When a lender reviews a commercial real estate financing request, questions arrive in waves: an email about the rent roll, a call about the guarantor's liquidity, a follow-up on the take-out commitment. Each question tests whether the story the sponsor told in the loan request holds up against the documents. A lender questions tracker turns that back-and-forth into a structured record. This guide explains how to build one, what to put in it, and how the information it captures affects the financing discussion.
What a lender questions tracker is and why it matters
A lender questions tracker is a working document, kept by the sponsor, that logs every underwriting question the lender asks, the source document that supports the answer, and whether the answer is a fact from that source or a reasonable assumption. The tracker does not replace the loan request; it organizes the evidence behind it. When a lender asks about lease-up conditions in a forward commitment, the sponsor can point to the commitment letter and the property's lease status rather than guess. [1] notes that forward commitments are subject to performance criteria such as lease-up to break even with leases at minimum rental rates. A tracker that records the commitment's specific conditions and ties them to the current rent roll and lease-up schedule gives the lender a clear, document-backed answer. The tracker also helps the sponsor identify gaps before the lender does—for example, if the take-out commitment references a minimum debt service coverage ratio that the pro forma does not show.
Building the tracker: columns and what to record
Create a spreadsheet with these columns: question date, lender contact, question summary, source document name and page or tab, answer, whether the answer is a fact or an assumption, and follow-up needed. For each question, record the exact wording from the lender, then locate the supporting document. If the question is about historical net operating income, the source is the trailing twelve-month (T-12) operating statement, not the current rent roll. [2] explains that a rent roll and trailing twelve months of operating statements are separate items for existing properties. The T-12 shows twelve historical months; the rent roll is a snapshot. Comparing the two without adjusting for timing differences can misrepresent income. The tracker's "fact or assumption" column forces the sponsor to decide: The T-12 reports historical income and expenses on its stated accounting basis (fact), but the pro forma assumes future rent growth (assumption). Labeling each answer this way keeps the lender conversation honest and avoids presenting projections as certainties.
How the tracker affects the financing discussion
A completed tracker changes how the sponsor and lender talk about risk. When the lender asks about the interest reserve, the sponsor can show the reserve account balance and the draw schedule from the development budget, not just a verbal estimate. [1] describes an interest reserve as a reserve account established by the lender. The tracker that links the question to the budget line item and the reserve agreement demonstrates that the sponsor has already accounted for the cost of carry. Similarly, if the lender questions the loan-to-value ratio, the tracker can reference the appraisal and the supervisory loan-to-value limits discussed in [1], which note that loans exceeding those limits may be appropriate based on other credit factors. The sponsor can then present the supporting evidence—strong debt service coverage, low leverage on other properties—rather than argue about the ratio in isolation. The tracker also helps the sponsor prepare for the quarterly board reporting requirement mentioned in [1] for loans above the supervisory LTV limits. By tracking the lender's questions and the sponsor's answers, the sponsor builds an audit trail that can be shared with the board or the lender's compliance team.
Concrete workpaper: the lender questions log
Below is a suggested format for the workpaper. The sponsor fills one row per question.
Using the tracker to ask the actual lender
The tracker is not a substitute for talking to the lender. It is a preparation tool. Before a call or email, the sponsor reviews the tracker to see which questions are open and which documents are still needed. When the lender asks a new question, the sponsor adds it to the tracker immediately, even if the answer is not yet known. This prevents the same question from being asked twice and shows the lender that the sponsor is organized. [2] states that lenders quote on what they are given, and most of what they ask for is material a sponsor already has. The tracker makes that material easy to find. It also helps the sponsor identify patterns. If every question is about the rent roll, the rent roll may need to be reorganized or supplemented with a lease abstract.
When the tracker reveals a gap
A gap in the tracker is not a failure; it is a reason to ask the lender for guidance. If the sponsor cannot find a source document for a particular question, the tracker should note that and list what would be needed to answer. For example, if the lender asks about environmental liability, the sponsor can note that no Phase I or Phase II report is in the file. [1] does not directly address environmental reports, but the tracker's fact-or-assumption column would mark the answer as an assumption until a report is obtained. The sponsor can then ask the lender whether a Phase I is required for this property type and loan size, rather than guessing. The tracker turns uncertainty into a clear action item.
How often should I update the lender questions tracker?
Update the tracker each time you receive a question from the lender, ideally within 24 hours. If you wait, you risk forgetting the context or losing the email thread. Regular updates also help you spot trends, such as repeated questions about the same document.
Do I need to share the tracker with the lender?
Not unless you choose to. The tracker is for your internal use. Some sponsors share a summary of answered questions to show responsiveness, but the full tracker is a working document. Keep it private unless the lender specifically requests it.
What if I cannot find a source document for a lender question?
Note the gap in the tracker and move on. Do not fabricate an answer. Instead, list what document would be needed and ask the lender whether it is required. Lenders prefer a clear "we do not have that yet, but we can get it" over an unsupported guess.
This guide is a suggested way to prepare information. Submission of a loan request is a preliminary step, not an engagement.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).