How do you reconcile conflicting documents in a commercial loan package?

The quick read: Reconcile conflicting loan documents with a dated discrepancy log that identifies each value, source period, definition and proposed correction. Distinguish reporting differences from factual errors before changing the request. Preserve the originals, support the resolution and send a controlled update to every affected reviewer so lenders compare the same property facts and remaining uncertainties.

A buyer comparing lender proposals needs one consistent account of the property’s income and closing cash. Use the discrepancy log below to preserve different reporting periods, identify the supported part of a variance, and carry the unresolved amount into every revised request. All worked dates and figures are hypothetical.

Which discrepancies should be resolved first?

Resolve discrepancies affecting borrower identity, requested proceeds, property income or closing cash first because those facts can change lender underwriting and the financing structure rather than merely the presentation of the package. Record the documents involved and the decision affected. A difference should remain visible until its explanation is supported and the appropriate reviewer accepts the correction.

Create a discrepancy log with document name, version, effective period, reported value and owner of the response. Separate a factual conflict from a lender adjustment. The borrower rent roll might be correct while the lender underwrites a different income amount; changing the rent roll to imitate underwriting would obscure the actual property record.

Use materiality tied to the financing decision. An old address or signature capacity can matter even when no amount changes. A formatting difference may need no correction if the underlying facts agree. Assign an evidence owner to each unresolved item and identify which lender analysis or closing document depends on the answer.

Source context: Commercial Real Estate Lending handbook. Bank supervisory context includes borrower analysis, loan structure and documentation. Its scope should not be treated as a universal rule or approval of the investor's proposed transaction.

How do date and definition differences create apparent conflicts?

Date and definition differences create apparent conflicts when documents describe different periods, cash movements or accounting categories even though each may accurately reflect its own scope. Align the reporting basis before concluding that one file is wrong. Record the explanation so an investor and lender can reproduce the reconciliation instead of relying on an unsupported narrative.

A rent roll is a snapshot, while an operating statement covers a period. A budget shows expectations, while a trailing statement records historical results. Separate those bases before comparing their totals. Ask whether tenant charges, concessions, reimbursements or nonrecurring items are included in each figure.

Check whether a statement uses cash or accrual accounting and whether the property was owned for the full period. Preserve the original classification and explain any normalized presentation separately. If an amount has been annualized, show the original period and calculation. An unexplained annual total can look more certain than the underlying record supports, especially during lease-up or ownership transition.

Filled discrepancy log — hypothetical package reviewed October 9, 2026:

The dates expose two differences: a point-in-time rent schedule is being annualized, while the other statement records a prior year’s cash. The supported $40,000 does not resolve the remaining $10,000 or establish the lender’s accepted income.

What does an illustrative rent reconciliation show?

An illustrative rent reconciliation shows how annualized current scheduled rent can differ from historical collected rent without proving that either document is false or that the larger amount supports underwriting. Use invented figures to separate time period and payment status. The lender then evaluates the actual records and adjustments appropriate to the proposed financing request.

Illustrative example: a current rent roll lists $50,000 of monthly scheduled base rent. Multiplying by twelve produces $600,000 of annualized scheduled rent. A historical statement shows $550,000 collected over the prior year. The $50,000 difference is not automatically missing money; the records may reflect different occupancy dates, concessions or collection outcomes.

Suppose supported historical records identify $30,000 from vacancy and $20,000 from concessions or noncollection under the invented scenario. Those explanations total $50,000. Keep the collected figure at $550,000 and show the current schedule separately. Do not overwrite historical income with the annualized run rate. If evidence explains only $40,000, the remaining $10,000 stays unresolved until supported.

Source context: 2023 CRE workouts policy. This policy addresses borrower resources within CRE accommodation and workout review. Its scope should not be treated as a universal rule or approval of the investor's proposed transaction.

How should source documents and corrections be preserved?

Preserve source documents and corrections as separate dated versions because replacing an original file without explanation prevents the lender from understanding what changed and why a prior analysis may need revision. Identify the authoritative record for each fact. A corrected summary should link to support and state whether related worksheets or representations also require an update.

Use meaningful version dates and a concise change note. Retain the original file in the working evidence set rather than sending a fresh file under the same ambiguous name. Include the reason for correction and the preparer responsible.

Do not edit signed third-party documents to make them agree with a preferred financing narrative. Ask the issuing party for a correction or provide a supported explanation of the discrepancy. For a borrower spreadsheet, check formulas and source references before distributing the replacement. A change in one input can affect income, reserves, requested proceeds and closing cash; the correction log should name those downstream effects instead of merely saying updated.

Who should decide whether a difference is resolved?

The appropriate source owner and affected reviewer should decide whether a difference is resolved because the person assembling the package may not have authority to reinterpret financial records, title evidence or loan conditions. Record the support and response. A broker can organize the question, while the accountant, counsel or lender resolves the treatment within that party’s responsibility.

Route accounting questions to the preparer and lender analysis questions to the lender. Ask counsel to resolve borrower authority or legal identity conflicts. If the issuer of an appraisal or title report must correct a record, retain that dependency instead of assuming that a borrower note is a substitute.

Track separate statuses such as explained, supporting evidence received and accepted for the particular review. A supported explanation can remain subject to a lender adjustment. Mark the treatment precisely so a future reviewer does not mistake acceptance of a file for approval of the requested proceeds or waiver of a loan condition.

Source context: 2020 property loan reporting provisions. This filed contract illustrates transaction-specific documentation and conditions. Its scope should not be treated as a universal rule or approval of the investor's proposed transaction.

How should lenders receive the final reconciliation?

Lenders should receive a concise correction notice with the revised package, affected values and unresolved questions because different versions can produce apparently conflicting term sheets based on different property facts. Identify the recipients and dates. Request confirmation of which analysis needs updating without representing a lender’s acknowledgment as a new credit approval or commitment to close.

Use one controlled package with a manifest of the current documents. Summarize the change in plain language and preserve a reference to the superseded version. Avoid sending only the corrected page if the rest of the package still contains the old amount.

Ask each lender whether the change affects sizing, cash requirements or documentation. Record the responses beside the relevant proposal version. If one lender has not received the update, its quote should be labeled as based on the earlier information. That preserves a fair comparison and prevents the investor from choosing a lower-rate indication whose underwriting assumptions no longer match the financing request.

How should the corrected package be submitted?

Submit a corrected package that preserves the original source records, identifies the revised summary and carries unresolved differences into every affected financing comparison. State which values changed and which did not. The broker should record recipient updates, while the source preparer and lender determine whether the explanation supports their respective accounting or credit treatment.

For the hypothetical log, the correction notice reads: “Request v2 keeps historical collections at $550,000 and separately shows $600,000 current annualized scheduled rent. Records explain $40,000 of the variance; $10,000 remains unresolved. The earlier summary did not distinguish the periods. Please identify any sizing or closing-cash analysis that used the earlier presentation.” This is sample wording, not a message sent to a lender.

Keep this document-reconciliation log as the common workflow for amount and version conflicts. Authority questions still require the actual governing documents; closing disclosures still require the relevant executed records. A shared correction log avoids duplicating the same workflow in each topic while preserving the distinct professional decisions.

YieldStack is a commercial mortgage brokerage. For commercial financing review, include the discrepancy log, original and corrected rent/collection summaries, supporting records, requested proceeds and the proposal versions affected. Identify the person obtaining the unresolved evidence and the date it is needed. An acknowledged update does not establish credit approval.

Submit the reconciled documents and open-item log.

The bottom line

The example leaves historical collections unchanged at $550,000, shows the $600,000 current schedule separately and keeps $10,000 unresolved. Carry that same explanation to every affected proposal. A supported partial reconciliation is more useful than replacing an inconvenient historical number or marking the whole variance resolved.