Mortgage Escrow Shortage Calculator
Enter the bills your servicer expects to pay from escrow and the current account balance. The calculator projects the aggregate trial balance, shortage or surplus, recovery charge, and resulting mortgage payment.
Estimated escrow shortage$100.00
- Base monthly escrow payment
- $650.00
- Maximum selected cushion
- $1,300.00
- Required opening target balance
- $2,600.00
- Estimated escrow surplus
- $0.00
- Monthly shortage recovery
- $8.33
- Escrow payment during recovery
- $658.33
- Total mortgage payment during recovery
- $2,458.33
- Payment change during recovery
- $58.33
- Total mortgage payment after recovery
- $2,450.00
- Upfront amount to restore target
- $100.00
- Lowest-balance month
- October
- Shortage or surplus treatment
- The modeled shortage is less than one month's escrow payment. Regulation X permits the servicer to leave it alone, require repayment within 30 days, or spread it over at least 12 months.
Aggregate trial balance
| Month | Base deposit | Scheduled disbursements | Trial balance |
|---|---|---|---|
| January | $650.00 | $0.00 | $650.00 |
| February | $650.00 | $0.00 | $1,300.00 |
| March | $650.00 | $0.00 | $1,950.00 |
| April | $650.00 | $3,000.00 | -$400.00 |
| May | $650.00 | $0.00 | $250.00 |
| June | $650.00 | $0.00 | $900.00 |
| July | $650.00 | $0.00 | $1,550.00 |
| August | $650.00 | $1,800.00 | $400.00 |
| September | $650.00 | $0.00 | $1,050.00 |
| October | $650.00 | $3,000.00 | -$1,300.00 |
| November | $650.00 | $0.00 | -$650.00 |
| December | $650.00 | $0.00 | $0.00 |
Assumes monthly escrow deposits are posted before scheduled disbursements in each projection month.
Property tax installments are modeled as equal payments at the selected frequency.
How to use this calculator
- Choose the first month in the new escrow account year.
- Enter the current escrow balance, current escrow payment, and principal-and-interest payment.
- Add the expected tax, insurance, and other escrow disbursements with their payment months.
- Set the cushion and shortage repayment period, then compare the target balance with your current balance.
How the escrow shortage is calculated
Federal mortgage servicing rules use aggregate analysis, which looks at the escrow account as one account instead of testing taxes and insurance separately. The servicer projects monthly deposits and scheduled disbursements for the next escrow account year, then finds the amount needed so the projected balance does not fall below the allowed target.
The calculator follows that trial-balance method. Let A be projected annual disbursements: property tax plus homeowners insurance plus any other escrowed bill. The base monthly escrow payment is:
P = A / 12
Let q be the selected cushion in months. The selected cushion is:
C = P x q
Property tax is divided into one, two, or four equal installments. Homeowners insurance and the other escrow item are placed in their selected due months. For each month k, the calculator combines all disbursements due that month as Dk and projects a no-opening-balance trial balance:
Rk = R(k-1) + P - Dk
The starting trial balance is zero. Let M be the lowest value among zero and the 12 monthly trial balances. The opening target balance is:
T = C - M
If your current escrow balance B is less than T, the difference is the modeled shortage. If B is greater than T, the difference is the modeled surplus. A shortage is spread across the selected repayment period, so the temporary recovery charge is shortage / months. The payment after the recovery period removes that temporary charge but keeps the new base escrow payment.
What moves the result most
The timing of large bills often matters as much as the annual total. A property tax bill due early in the escrow year can create a deeper low point than the same bill due near the end. The cushion also matters: a two-month cushion adds two base escrow payments to the opening target, while a zero cushion only prevents the trial balance from going negative.
The current balance determines whether the target creates a shortage or surplus. Paying a shortage in a lump sum can remove the modeled recovery charge, but the base escrow payment can still rise when the projected annual bills are higher than the old monthly escrow deposit.
What this leaves out
This estimate does not replace the annual escrow statement. It assumes equal property tax installments, one annual homeowners premium, one other annual escrow item, and monthly deposits posted before that month's scheduled disbursements. It does not model supplemental tax bills, midyear premium changes, delinquent payments, interest on escrow balances, state-law limits below the federal maximum, or a servicer's exact posting conventions.
Worked example
Suppose the new escrow year starts in January. The current escrow balance is $2,500, the current escrow payment is $600 per month, and principal and interest are $1,800 per month. Expected escrow disbursements are $6,000 of property tax paid in April and October, plus $1,800 of homeowners insurance paid in August.
Total annual disbursements are $7,800, so the base monthly escrow payment is $650. With a two-month cushion, the selected cushion is $1,300. The no-opening-balance trial balance reaches its lowest point in October at -$1,300, so the required opening target balance is $2,600.
Because the current balance is $2,500, the modeled shortage is $100. Spread over 12 months, the shortage recovery is $8.33 per month. The escrow payment during recovery is $658.33, making the total mortgage payment $2,458.33 during recovery and $2,450 after the shortage is repaid.
Common questions
Why did my escrow payment increase even if my mortgage rate did not change?
The escrow part of a mortgage payment is separate from principal and interest. It can increase when projected property taxes, insurance premiums, or the required opening target balance rise. A temporary shortage recovery charge can also increase the payment for the repayment period.
How is an escrow shortage calculated?
The servicer projects monthly escrow deposits and scheduled disbursements for the next account year. It finds the lowest trial balance, adds enough opening balance to keep that low point from going negative, and then adds any allowed cushion. A shortage exists when the current escrow balance is below that target.
What is the two-month escrow cushion?
Regulation X generally allows a cushion no greater than one-sixth of estimated annual escrow disbursements, which equals two months of base escrow payments. A mortgage document or state law may require a smaller cushion. The calculator lets you test any cushion from zero to two months.
Can I pay an escrow shortage in a lump sum?
Many servicers allow a lump-sum payment, but the federal rule describes permitted servicing choices rather than guaranteeing every option in every case. Paying the shortage up front can remove the modeled recovery charge. It does not remove any increase caused by higher projected taxes or insurance.
What happens when an escrow analysis finds a surplus?
For a current borrower, Regulation X generally requires the servicer to refund a surplus of $50 or more within 30 days of the analysis. If the surplus is under $50, the servicer may refund it or credit it against the next year of escrow payments. Different treatment may apply if the borrower is not current.
What is the difference between an escrow shortage and an escrow deficiency?
A shortage means the account balance is positive but below the target balance at the analysis date. A deficiency means the escrow account has a negative balance because the servicer advanced funds. Regulation X gives different repayment rules for deficiencies, so this calculator rejects a negative starting balance.