Questions or registration help?(608) 444-6575support@powerofinterest.com

FREE MORTGAGE ESCROW TOOL

Escrow Shortage, Surplus & Deficiency Calculator

Build a month-by-month escrow forecast for property taxes, insurance, and other eligible expenses, then estimate whether the balance is above or below the target.

Build a 12-month escrow projection

Enter the current escrow account balance and planned disbursements. The tool uses aggregate account accounting with base monthly deposits and a selectable cushion.

Expected disbursements

Enter the month funds are expected to leave the escrow account. Add separate rows for installments of the same item.

Annual escrow estimate

—

Estimated annual expenses—
Base monthly deposit—
Selected cushion—
Target opening balance—

Educational model, not a compliant servicing statement. RESPA-covered accounts require specific analysis, estimate, timing, disclosure, and shortage/surplus rules; state law or the mortgage contract may impose a lower cushion.

What this escrow shortage calculator measures

Regulation X requires the aggregate method for covered mortgage escrow analyses. A 12-month trial running balance considers base deposits of one-twelfth of anticipated annual expenses and the month each expense is paid. The permitted cushion generally cannot exceed one-sixth of annual disbursements (two monthly base deposits), and lower limits may apply.

Shortage, surplus, and deficiency are different

How the tool handles expenses

Monthly projected base deposits are added before the month's listed disbursements. The calculator determines the minimum projected month-end trial balance, derives an illustrative target opening balance sufficient to protect the chosen cushion, and compares it to the entered actual opening balance. Your real servicer's payment posting dates and method may require adjustment.

Important: The example 12-month installment amount shown for a gap is not a declaration of what a servicer may legally demand. Surplus refunds and shortage/deficiency collection schedules depend on 12 CFR 1024.17(f), current payment status, and the amount involved.

Primary authority: CFPB Regulation X, 12 CFR § 1024.17. See also Annual Escrow Analysis Worksheet and RESPA Escrow Analysis Pro software for recurring escrow analysis work.

Published November 2026 · Calculations run in your browser; no information is sent to Power of Interest by these tools.