Building a closing sources-and-uses reconciliation

A closing sources-and-uses reconciliation explains where every dollar comes from, where it goes, and which amounts remain restricted after funding. It is the link between the financing model, payoff requirements, lender conditions, and settlement statement. A balanced spreadsheet is necessary, but it is not sufficient if a source is unavailable on the closing date or a use has been counted twice.

For a large multifamily refinance or acquisition, prepare the reconciliation early and update it as evidence becomes final. Assign responsibility for the source of every amount. The owner should be able to explain both the settlement cash and the liquidity available immediately afterward.

Start with cash actually available at closing

Separate the committed amount from the initial advance, later advances, and amounts retained or directed by the lender. Identify borrower equity already delivered, additional cash to be wired, permitted deposit credits, and any other accepted source. An unfunded future commitment cannot pay today's closing invoice.

The Dean Owner–MF 1 May 2025 property loan illustrates one structure: it provides a single borrowing and states that the senior lender has no obligation to make additional advances for the property. The same transaction separately addresses other financing arrangements. Its mechanics should not be replaced with an assumed revolving availability.^[1]

For a staged loan, request the actual initial advance and retained amounts from the lender. Do not infer them solely from the face amount of the note. Conversely, if the lender wires the gross advance and the closing agent directs part into required reserves, show that routing without inventing a separate funding reduction.

Record each source's status: committed, conditional, delivered, or expected later. A partner's anticipated capital contribution is not delivered equity. Confirm the approvals and timing needed to make it available, particularly when different entities fund the property borrower.

Reconcile payoff through the funding date

Obtain current payoff statements and understand their validity period, interest calculation, fees, prepayment amounts, releases, and wiring instructions. The modeled loan balance alone may omit the amounts needed to discharge the existing obligations.

Dean Owner's agreement separately addresses interest and prepayment mechanics. Those provisions demonstrate why a contractual payoff calculation can include more than outstanding principal; the actual existing loan and issued payoff statement control the transaction being closed.^[1]

Suppose an illustrative refinance uses a $92 million initial loan advance and $850,000 of new borrower cash. Its assumed uses are $82.4 million of debt payoff, $1.7 million of exit charges, $1.15 million of closing costs, $2.6 million of initial tax and insurance reserves, and $1.8 million of repair funding. Total sources are $92.85 million; listed uses total $89.65 million; the residual is $3.2 million.

This is a simplified hypothetical, not a quote of fees or reserve requirements. The $82.4 million payoff line assumes all principal and interest assigned to that line are included. If the final payoff adds $90,000 beyond that amount, residual cash falls to $3.11 million unless another source or use changes.

Check whether any existing reserves are being credited, transferred, or returned later. Record the actual agreed treatment. A reserve held by the old lender should not fund the new settlement merely because the owner expects a refund after discharge.

Avoid confusing reserves with spendable proceeds

For each required reserve, state the amount, account, funding route, purpose, and conditions on withdrawal. If repair funding is placed in a controlled account at closing, it is a use of settlement cash even though the money remains associated with the property.

Freddie Mac's reserve guidance distinguishes accounts and their administration, including insurance premiums and replacement funding. Its provisions do not make every reserved dollar immediately available for general operations or owner distributions.^[2]

In the hypothetical reconciliation, the $1.8 million repair line is funded once. If that same amount appears again as a separate “lender holdback” without reducing the actual advance or identifying a different requirement, the model could double-count the restriction. Reconcile the lender's cash flow and account records instead of relying on labels.

Freddie Mac's replacement-reserve disbursement provisions address documentation, completion, and qualifying expenditures. A borrower should therefore model the timing of reimbursement separately from funding a repair account.^[2]

If the owner must first pay contractors and then obtain reimbursement, retain the needed interim liquidity outside the restricted account. Add that liquidity requirement to the post-closing cash forecast, without automatically treating it as another settlement expense. The reconciliation and the operating forecast answer different timing questions.

Match the statement to the authorized funding process

Identify which parties perform escrow and funding functions and who delivers the settlement statement. Freddie Mac's current title chapter prescribes funding arrangements for applicable applications, including specified title-underwriter, affiliate, or subsidiary requirements and jurisdictional qualifications. The owner should confirm the arrangement with the Seller/Servicer rather than assume any settlement provider can perform every role.^[3]

Review the statement against lender instructions, approved fees, invoices, contractual credits, reserve requirements, and equity evidence. Identify changes from the last approved version and obtain the relevant parties' acceptance before disbursement. A new fee can change both residual cash and the amount a partner must contribute.

The same Freddie Mac section specifies delivery of the settlement statement by the relevant funding party. Retain that official record and reconcile it to the owner's model; an informal estimate does not replace the final transaction evidence.^[3]

Use a controlled verification process for payment details and changes. Assign people to confirm instructions through established channels and record the confirmation. Treat an unexpected change in payee or account as an item requiring resolution before funding, not as an ordinary spreadsheet edit.

Keep funding conditions separate from arithmetic

A transaction can balance financially while a lender condition remains unsatisfied. Confirm executed documents, authority, required opinions, diligence acceptance, insurance, lien releases, certifications, and other conditions under the actual commitment and agreements.

The VineBrook 2025 rental-housing credit agreement conditions effectiveness on specified documents, certificates, approvals, fees, and other requirements. It also permits repayment and termination of its existing facility simultaneously with the new advance. Those are transaction-specific coordinated conditions, not proof that every lender permits the same closing sequence.^[4]

For a property refinance with multiple capital providers, identify what each party needs before releasing money. Resolve circular dependencies in the agreed closing instructions. A junior provider expecting confirmation of senior funding and a senior provider expecting junior equity require an accepted sequence, not two independent promises.

VineBrook's agreement also makes satisfaction or valid waiver of the conditions relevant to whether funding obligations become effective. Do not describe an unresolved condition as waived merely because the financing team expects to finish it shortly.^[4]

Explain the cash position after settlement

After funding, reconcile the final statement, account balances, reserve deposits, debt balances, and outstanding invoices. Distinguish cash returned to the borrower from restricted funds, reimbursements expected later, and amounts retained for operating needs.

For the illustration, $3.2 million is the arithmetic residual before any further operating allocation. If $1 million must remain for planned operations and interim repair reimbursement, only $2.2 million remains before any additional restrictions or distributions. The loan documents and ownership agreements determine what can actually leave the borrower.

Preserve the final reconciliation and explanations of material changes. It should tell an owner, lender, and accountant the same story: funded sources equal disbursed uses and remaining cash, while restrictions and later obligations are visible. That is the basis for a clean closing and a realistic first-month liquidity plan.