Can I Afford This Property?Commercial real estate financing, worked out

How to maintain a financing request change log after initial submission

A change log tracks every update to a financing request after submission, helping sponsors show lenders that the project is managed actively and material changes are disclosed. This guide explains what to record, why it matters, and how to prepare a simple workpaper.

Source: CodexTopic: Financing process and document control1317 wordsUpdated 2026-11-19

A change log tracks every update to a financing request after submission, helping sponsors show lenders that the project is managed actively and material changes are disclosed. This guide explains what to record, why it matters, and how to prepare a simple workpaper.

What a change log is and why it matters

A change log is a running record of every material update to a financing request after it has been submitted to a lender. It is not a formal underwriting requirement, but it serves two practical purposes. First, it helps the sponsor keep track of what has changed and when, which is useful when answering lender follow-up questions. Second, it signals to the lender that the sponsor is organized and transparent. The OCC Commercial Real Estate Lending handbook notes that examiners consider factors such as changes in external factors like national, regional, and local economies, CRE markets, and industry outlook when reviewing a bank's portfolio. [1] A change log is a suggested way to prepare information that mirrors this level of scrutiny on the borrower side.

What to record in the change log

Record the date of each change, a brief description of what changed, the reason for the change, and how it affects the financing request. Material changes include adjustments to the sources and uses of funds, the development budget or schedule for construction projects, the rent roll or trailing twelve months of operating statements for existing properties, the pro forma and its assumptions, the sponsor's schedule of real estate owned, and financial statements for principals or guarantors. The OCC handbook also flags warning indicators such as construction budget overruns, changes to construction plans, materials, finishes, and borrower requests for significant reallocation of funds to other budget line items, as well as draw requests ahead of schedule for work yet to be completed. [1] These are the kinds of changes to log. Also record changes in tenant mix, lease expirations, vacancy rates, or rental rates, as the OCC handbook notes that declining sales prices or rental rates, slower absorption of space than anticipated, and increasing vacancy and turnover rates are warning indicators. [1] For construction loans, record any changes to the project's status, including whether improvements are constructed as proposed, and whether material changes have been made to the plans or the construction budget. [1]

How the change log affects the financing discussion

The change log is not a substitute for the lender's own monitoring, but it helps the sponsor demonstrate active management. The OCC handbook states that close monitoring to allow timely recognition of potential issues and the ability to recognize and anticipate financial difficulties are important tools in effectively controlling risk. [1] By maintaining a log, the sponsor shows the lender that potential issues are being identified and addressed. For example, if a construction project experiences delays, the log can show that the sponsor has already evaluated the impact on the budget and schedule. The OCC handbook notes that construction delays or other unanticipated events that could lead to cost overruns are warning indicators. [1] Logging the delay and the sponsor's response can help the lender see that the situation is being managed. Similarly, if a property's rent roll changes due to a major tenant leaving, the log can show the sponsor's plan to backfill the space and the expected impact on net operating income.

A concrete workpaper: the change log template

Prepare a simple spreadsheet or document with the following columns: Date of change, Category (e.g., budget, schedule, rent roll, financial statements, pro forma, sponsor information), Description of change, Reason for change, Impact on financing request (e.g., changes to loan amount, timing, debt service coverage). Keep it as a living document. Update it each time a material change occurs, even if the change seems minor. The OCC handbook recommends that for construction loans, examiners determine whether sufficient funds remain to complete the project. [1] A change log that tracks budget changes helps the sponsor and lender both assess this question. For existing properties, the OCC handbook notes that examiners review current rent rolls and leases, assess the quality and mix of tenants, and note any significant volume of leases scheduled to expire. [1] A change log that tracks lease expirations and renewals helps the sponsor present this information clearly.

Distinguishing timing differences: rent roll versus trailing twelve months

A current rent roll is a snapshot of the property's occupancy and income at a single point in time. It shows who is renting, what space they occupy, the rent they pay, and the lease term. A trailing twelve months (T-12) of operating statements shows the actual income and expenses over the past twelve months. The two serve different purposes. The rent roll shows the current situation, while the T-12 shows historical performance. When comparing totals, the sponsor should explain any differences. For example, if the rent roll shows higher gross rent than the T-12 average, it may be because of recent rent increases or new tenants. If the T-12 shows higher vacancy than the rent roll, it may be because the property has recently leased up. The OCC handbook advises examiners to comment on trends in net operating income, vacancy, and expenses. [1] A change log that tracks both the rent roll and T-12 over time helps the sponsor and lender see these trends clearly.

Distinguishing income and cash flow terms

Gross rent is the total rent a property could collect if fully occupied at market rates. Collected income is the rent actually received, which may be lower due to vacancies, concessions, or bad debt. Net operating income (NOI) is the income after operating expenses but before debt service. Capital expenditures (capex) are spending on improvements or replacements that are not operating expenses. Debt service is the loan payments, including principal and interest. Equity cash flow is the money left after all expenses, capex, and debt service. The OCC handbook states that for income-producing properties, lenders assess the adequacy of cash flow to meet debt service requirements. [1] A change log that tracks changes in NOI, vacancy, and expenses helps the sponsor show the lender how the property's cash flow is trending. The OCC handbook also notes that for owner-occupied buildings, the analysis concentrates on the ability of the owner's cash flow to service debt. [1] The change log should reflect the appropriate focus.

Suggested way to prepare information for the change log

Record changes as they happen, not just when the lender asks. Use the log as a communication tool. When submitting an updated financing request, include the change log as a separate document. The OCC handbook notes that examiners consider changes in external factors such as national, regional, and local economies, CRE markets, and industry outlook. [1] A change log that tracks these external factors, along with property-specific changes, shows the lender that the sponsor is monitoring the full picture. The log should be factual and concise. Avoid opinions or speculation. If a change is due to a market condition, state the condition and the date it was observed. If a change is due to a tenant decision, state the tenant's action and the date it was communicated.

Three short FAQs

What is a change log?

A change log is a running record of every material update to a financing request after it has been submitted to a lender. It tracks the date, description, reason, and impact of each change.

Do lenders require a change log?

No, a change log is not a lender requirement. It is a suggested way to prepare information that helps the sponsor stay organized and demonstrate active management to the lender.

How often should I update the change log?

Update the change log each time a material change occurs. This could be daily, weekly, or monthly depending on the project. The key is to record changes promptly so the log is accurate and useful.

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.

Open the loan sizing calculator

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.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt