Commercial Property Loan Escrow Reconciliation: A Monthly Checklist for Landlords

Commercial Property Loan Escrow Reconciliation: A Monthly Checklist for Landlords
Lender-held tax and insurance escrow is easy to ignore when the monthly loan payment clears. The trouble usually appears later: a tax bill was paid from the wrong period, an insurance premium was not reflected as expected, the servicer changes the monthly deposit, or a shortage notice lands when cash is already committed elsewhere.
That is why this review deserves its own monthly workflow. It is not a bank reconciliation, a tenant property-tax true-up, or a loan-covenant report. It is a comparison of the servicer's escrow record with the deposits, tax and insurance support, and open questions you maintain for the property.
Use your note, loan agreement, escrow agreement, servicer instructions, and qualified advisers as the controlling source when they differ from this checklist. The process below is an operating control, not legal, tax, lender, or accounting advice.
Start with the records that describe the same month
Pull the current loan or servicer statement first. Then gather the property records needed to explain every escrow movement:
- The prior month's reconciled escrow schedule and closing balance.
- The current loan or servicer statement, including principal-and-interest and escrow portions when shown.
- Proof of the month's loan payment and any separate escrow deposit, wire, or adjustment.
- Property-tax bills, payment confirmations, assessment notices, and correspondence that affect the period.
- Insurance invoices, declarations, renewal notices, premium-financing records if applicable, and payment confirmations.
- The active loan documents and recent servicer notices, including shortage, reserve, payment-change, or transfer notices.
Do not assume every lender uses the same layout or cadence. Commercial loan documents determine what is escrowed, how deposits are calculated, whether reserves are separate, and what the borrower must provide. For example, Fannie Mae's multifamily guide describes monthly tax and insurance escrow deposits for certain loan tiers, while other tiers may use different funding or evidence-of-payment requirements.[^1]
Reconcile the opening balance, deposits, and disbursements
Build a simple schedule for each loan and escrow type. Keep tax, insurance, replacement reserves, and other lender-held accounts distinct unless the servicer statement expressly combines them.
Use this basic test:
> Opening escrow balance + deposits and credits - disbursements and debits = expected closing escrow balance
Compare the expected closing balance to the balance on the servicer statement. If they do not agree, leave the difference visible rather than forcing the schedule to balance.
For every deposit, confirm the date, amount, payment reference, and the account it was meant to fund. For every disbursement, record the payee, property, expense type, covered period, invoice or bill number, and proof of payment. A payment that is valid for the property can still be posted to the wrong escrow bucket or reporting period.
The point is not to recreate the servicer's accounting system. It is to maintain a clear owner-side record that can answer: What did we expect the servicer to hold? What did it receive? What did it pay? What remains unresolved?
Match tax and insurance activity to supporting records
Tax and insurance are often the two biggest escrow movements, and they need support beyond a line item on a statement.
For property taxes
- Match the disbursement to the applicable taxing authority, parcel or account number, and billing period.
- Compare the amount paid with the bill, installment coupon, receipt, or online payment confirmation.
- Flag supplements, reassessments, appeals, refunds, credits, and penalties separately. Do not net them into a normal installment without an explanation.
- Note whether a payment relates to a period before acquisition, a prior owner, or a tenant reimbursement workflow. That classification may matter later, but it does not change the servicer reconciliation.
For property insurance
- Match the disbursement to the carrier, broker, policy number, insured property, and policy term.
- Compare the amount with the premium invoice, declarations page, renewal documentation, or installment notice.
- Confirm that the payment date and amount make sense alongside the policy effective date; investigate a payment that does not line up instead of assuming it renewed coverage.
- Keep lender-required evidence and correspondence with the loan record, but route coverage, endorsement, mortgagee-clause, and policy-interpretation questions to the broker, insurer, lender, or counsel as appropriate.
Escrow administration is recognized as part of commercial real-estate loan administration, alongside payment processing and servicing controls.[^2] A monthly support file makes it easier to spot an unexplained movement before the next tax or insurance deadline.
Treat timing differences as a work list, not an error
Not every difference means money is missing. Common timing differences include a borrower payment received near month-end, a servicer posting after the statement cutoff, an annual premium paid in installments, a tax payment scheduled before the bill appears in your files, or a refund processed later than the original charge.
Track each difference with:
- Description: what does not match.
- Amount: the exact unreconciled amount.
- Expected resolution: posted payment, corrected allocation, incoming bill, refund, or servicer explanation.
- Owner: the person responsible for obtaining the next record or answer.
- Due date: when the item needs another review.
- Status: open, pending servicer, pending broker, pending tax authority, or resolved.
Avoid calling a difference a shortage until you know what it represents. A servicer may use the term differently from the way your internal schedule does. Read the notice and loan documents, then ask the servicer to explain the calculation in writing if the change is unclear.
Flag shortages and payment changes early
A shortage notice is a cash-planning issue before it is a bookkeeping issue. Review it against the statement, your reconciliation schedule, recent tax and insurance activity, and any change in the required monthly deposit.
Ask focused questions:
1. Which escrow category created the change: taxes, insurance, or another required item? 2. Is the issue an actual unpaid or underfunded amount, a revised estimate, a timing difference, or a new reserve requirement? 3. What amount is due, on what date, and how will the servicer apply it? 4. Does the new monthly payment include a change to principal and interest, escrow, or both? 5. What supporting calculation or transaction history can the servicer provide?
Document the response in the loan file. If the answer affects a forecast, a property cash plan, a tax position, insurance coverage, or a loan-document obligation, bring in the qualified adviser who handles that question rather than making an assumption from the statement alone.
Assign an owner and close the month deliberately
Each property needs one accountable person for the monthly review, even if several people supply documents. At close, save the completed reconciliation, statement, support for material tax and insurance activity, and the open-item list together.
Before marking the month complete, confirm that:
- The opening balance agrees to last month's reconciled closing balance.
- All deposits and disbursements on the servicer statement are either supported or listed as open items.
- Tax and insurance items are matched to the best available source record.
- Timing differences have an owner and next review date.
- Any shortage, payment change, transfer notice, or unexplained transaction has been routed to the servicer or a qualified adviser.
- The final schedule states the servicer-reported closing balance and your expected closing balance, including any unreconciled difference.
This record becomes especially useful when a servicer changes, a refinance starts, a tax bill is disputed, or someone asks why the monthly payment moved. You will have a month-by-month explanation instead of a stack of statements to reconstruct.
Keep loan escrow separate from tenant and bank workflows
The same property may have three related but different reviews:
- Bank reconciliation: compares the landlord's bank activity and book balance.
- Tenant tax or CAM true-up: applies lease terms to tenant recoveries and reimbursements.
- Loan escrow reconciliation: compares the lender or servicer's tax-and-insurance escrow activity with property support.
One record can inform another, but they should not be substituted for each other. A tenant reimbursement does not prove that a servicer paid the tax bill. A cleared bank payment does not prove that a lender-held escrow account is fully funded. Keeping the workflows separate makes exceptions easier to explain and assign.
For adjacent controls, use PigJet's commercial property bank reconciliation checklist, NNN property-tax proration and true-up guide, and NNN lease property-insurance requirements guide.
[^1]: Fannie Mae Multifamily Guide, Section 307: Escrow Requirements for Taxes and Insurance describes monthly tax and insurance escrow deposits for certain multifamily loan tiers. It is an example of a lender program, not a substitute for your loan documents or servicer instructions. [^2]: Office of the Comptroller of the Currency, Commercial Real Estate Lending lists escrow administration among real-estate loan-administration procedures for regulated institutions.
PigJet helps commercial landlords keep property documents, deadlines, tasks, and operating records connected. See how PigJet supports commercial property operations.