reserves and cash control · Intermediate

Tax and insurance escrows: annual true-ups and payment timing

Reconcile monthly tax and insurance deposits with actual bill dates, opening balances and prospective escrow adjustments.

Illustrative examples. This is a constructed educational scenario, not a reported Jaken Finance Group transaction or financing offer.
The decision in brief

An escrow can balance over a year and still run short before a bill is due. Model the dated cash balance, then separate recurring deposits from any catch-up funding.

Tax and insurance escrow planning requires both an annual estimate and a dated cash schedule. Dividing expected bills by twelve estimates a recurring deposit. It does not prove that the escrow will contain enough money when a large bill must be paid.

Begin with the actual account balance, pending deposits, known bills and the servicer’s required funding dates. Those dates may precede the tax authority’s or insurer’s deadline. A borrower needs to know when cash must arrive in the escrow, who sends invoices and who confirms payment. The analysis should cover a full billing cycle rather than ending at an arbitrary calendar year.

Separate the account rules from the projection

Section 2.6(d) of the May 18, 2023 Guggenheim term loan agreement provides one contractual example of estimated monthly escrow payments, deficiency adjustments and conditional treatment of excess funds. It is an individual agreement, not a nationwide escrow rule.

For a live loan, extract the controlling provisions for deposits, notice of deficiencies, invoice delivery, payment responsibility and excess balances. Identify whether the lender can revise estimates and what happens if an exemption, appeal or insurance change is unresolved. Do not import residential mortgage escrow assumptions into a commercial agreement without establishing that they apply.

The projection should identify each number as a known invoice, a lender estimate or a borrower assumption. An assessment appeal can be modeled as a separate scenario; it should not silently reduce the cash plan before the reduction is effective and accepted for escrow purposes.

Worked exhibit: a balanced year with a midyear shortage

Assume hypothetical annual taxes of $120,000 and insurance of $36,000. Monthly deposits are $13,000, the opening escrow is $20,000, taxes are paid in two $60,000 installments in months 3 and 9, and insurance is paid in month 6. Assume each monthly deposit is credited before that month’s bill. Ignore interest and fees.

Month-end checkpoint Cumulative deposits Cumulative bills Projected escrow balance
Month 3 $39,000 $60,000 −$1,000
Month 6 $78,000 $96,000 $2,000
Month 9 $117,000 $156,000 −$19,000
Month 12 $156,000 $156,000 $20,000

The negative balances identify required additional funding; they do not assume the account can actually pay bills while overdrawn. Although annual deposits equal annual bills, the schedule needs at least $19,000 more initial cash to avoid a negative balance. An invented planning minimum of $10,000 increases the initial catch-up amount to $29,000.

That $10,000 cushion is an assumption for this example, not a legal requirement or lender standard. The actual required deposit could differ because of payment dates, estimate methodology, existing balances or contractual protections.

Test a true-up without losing the timing problem

Now assume revised taxes of $132,000, paid in two $66,000 installments, and insurance of $42,000. Annual charges rise to $174,000. A revised monthly deposit of $14,500 is $1,500 above the original amount.

With the same $20,000 opening balance and deposit timing, balances at months 3, 6 and 9 become −$2,500, −$1,000 and −$23,500. Month 12 still finishes at $20,000. Maintaining the illustrative $10,000 minimum throughout the schedule would require $33,500 of initial additional funding.

The recurring increase and the catch-up deposit solve different problems. The extra $1,500 per month funds the higher annual burden. The $33,500 establishes the modeled timing cushion. Adding only the monthly increase would leave the largest projected shortage unresolved.

If revised bills become known halfway through the year, do not restart the model as though the new monthly deposit began in January. Use the actual current balance and remaining deposits. Recalculate the maximum shortage using the dates still ahead.

Reconcile accounting expense and escrow cash

Avoid counting the same tax or insurance cost twice in property cash flow. The operating statement may recognize an expense over a period while bank activity shows deposits into escrow and later payments from escrow. A cash bridge should explain these movements separately.

For example, recording both a $13,000 monthly escrow deposit and the entire annual bill as unrestricted cash outflows can overstate funding needs if the bill is paid from the funded escrow. Conversely, removing the expense from an underwriting calculation merely because cash is escrowed can overstate property earnings. Use a consistent accounting and cash-flow convention and disclose the reconciliation.

Confirm whether any expected refund or excess balance is actually available to the borrower. A projected surplus is not an authorized distribution. Record the servicer’s decision and any credit against future deposits separately from cash returned.

Maintain a payment evidence file

Retain assessments, invoices, policy effective dates, revised estimates, deposit notices, account statements and evidence that charges were paid. Assign responsibility for sending updated bills and checking that the servicer used the correct property and coverage period.

The useful output is a dated balance forecast with an identified minimum, a documented recurring deposit and a separate catch-up decision. Refresh it when a bill changes, an account credit arrives or the payment calendar shifts. That makes an escrow true-up an explainable cash event rather than an unexpected demand disconnected from the property’s operating plan.

Sources and evidence

  1. SEC-filed Guggenheim term loan agreement, May 18, 2023Section 2.6(d), Tax and Insurance Escrow Fund · Checked 2026-10-21 · Historical individual contract; the schedule and cushion are invented.

Source dates and applicability matter. Report an error or a changed source.

Keep working through the decision

Related resources