# Escrow Analysis Overview

Complexity:

Audience: Accounting, Loan Servicing/Collections Managers, Administrator, Compliance, Data

### Introduction

Escrow analysis is a periodic audit of escrow funds received to determine whether funds collected into escrow accounts will be sufficient to fulfill estimated escrow disbursements (payments made from escrow). In a typical escrow analysis, the lender will enter information on planned disbursements (payments) they will make from those accounts. The lender will usually also specify a cushion amount for each escrow account (typically equal to some number of escrow payments). The cushion is an amount above the disbursement amount that will be collected.

Escrow analysis will take all this information and determine if the amount collected in escrow so far, plus the amount that will be collected before the disbursement date will cover the estimated disbursement amount. At the end of the analysis, LoanPro will generate a downloadable statement to show the results. The statement will be different based on if there is a surplus, shortage, or deficiency.

Escrow analysis only needs to be performed at the beginning of a loan and once a year after that. When the analysis is performed, there are specific documents that need to be provided to the borrower. These documents can be generated by LoanPro.

### Howto Run anEscrow Analysis

Before you run an analysis, you'll need to set up escrow buckets on whichever accounts you want to analyze. You'll first have to create an escrow bucket at the tenant level, and then log an escrow adjustment on a loan to make that bucket collect money with each payment. Lastly, you might want to add some estimated disbursements showing when and to whom you plan to remit money from the bucket. Once you've got accounts set up to collect and disburse escrow, you're ready to perform an escrow analysis.

#### Selecting Loans

From the loan manager, search for the set of loans that you want to perform an escrow analysis on. Click the data options drop-down and select 'Run Escrow Analysis'. This will bring up a screen where you can select which loans from that group you want to run the analysis on. When you've got the right list of loans, click the green 'Start Escrow Analysis' button in the top right corner and pick the escrow bucket that you'd like to analyze.

This will bring you to the next page, where you enter two key dates for future escrow analyses:

• Escrow Analysis Start Date – This is when the analysis is performed.
• Escrow Computation Year Start Date – This is when the escrow year starts.

When you've entered the dates, click the blue 'Set Dates' button to continue.

#### Step 1 – Starting Balance

On the Starting Balance page, you'll see a quick summary of your current balance, estimated disbursements, and the difference between them, called the starting balance.

#### Step 2 – Anticipated Disbursements

On this page, you'll see a review of anticipated disbursements you've already saved. If there aren't any there yet, you can add them now.

To add a disbursement, you'll need to enter the date, amount, frequency, category, and vendor. You can also add a memo to explain what the disbursement is for.

#### Step 3 – Initial Trial

This step shows the loan schedule according to the plan you've created so far. It shows how much escrow is collected with each payment, and what this contributes to the balance of the escrow bucket. The yellow highlight shows which line has the lowest balance in the computation year.

#### Step 4 – Adjustment/Analysis Summary

This step shows the escrow you'll collect over the computation year and compares it to the total disbursements. Depending on the difference between those figures, you'll have one of three possible outcomes:

• A surplus means the amount exceeds the cushion amount for the account. You'll likely collect more than you'll need to cover all the anticipated disbursements and the cushion. You can credit the additional funds towards the next year's escrow or the loan's balance, or make no change at all.
• A shortage is an amount less than the cushion, but greater than $0.00. You'll be able to cover all anticipated disbursements, but you haven't reached the cushion amount. You can choose to let the shortage exist, or add some additional escrow payments to make up the difference. • A deficiency is an amount less than$0.00. You won't collect enough escrow to cover your anticipated disbursements. You can either keep things how they are, or add some additional escrow payments to cover the difference.

#### Step 5 – Escrow Analysis & Actions Confirmation

This step summarizes the analysis and lists the actions that you're about to make. The left side of the screen shows

#### Step 6 – Statement Output & Summary

This step is similar to the previous one. On the left, it shows the same basic analysis information. On the right half of the screen, however, it shows the escrow schedule for the coming computation year, listing each payment and disbursement in chronological order.

When you click 'Finish', you'll exit the escrow analysis tool.

### Common Uses & Questions

Most lenders, who use escrow for the purpose for which it was designed, will run escrow analysis once a year. If you use escrow analysis, you will likely send the final report to each borrower that needs it. The generation can't be done automatically and can't be sent through automated communications channels.

Accounting Use
While accounting may not be directly concerned with escrow analysis and the report it generates, the analysis is a good way to see whether a shortfall or surplus is anticipated. It will also be important in accounts payable to be able to match the disbursement and the money collected to make sure you aren't losing money when paying for escrow items.

Servicing/Collections Manager Use

You will likely set up escrow inside of LMS, and you may make some or all of the escrow decisions. It's important to know that while LoanPro can generate an escrow analysis, it can't be done automatically. This means that you should have a process for running escrow analysis and sending the analysis form that LoanPro generates to your borrowers.

Compliance Use
There are likely laws in your jurisdiction that dictate how much of a cushion you can collect, how often escrow analysis must be done, and requirements for sending the escrow analysis report to borrowers. The information in this article should tell you what you need to know to guide the setup of escrow buckets and escrow analysis to meet requirements.

Data Use
If you need to pull data to understand the escrow you are collecting, you can pull the escrow balance per bucket, per loan from the Loan Status Archive table. You can get escrow transactions from the Escrow Transactions table. There are other tables that contain escrow information. All the tables can be found in the Database Tables article.

Can I set up this report to run automatically and send the report to borrowers? No. The report must be run manually and must be sent manually.

### Terminology

Most of these terms are also covered in our Escrow Overview article, but here's a quick rundown.

 Term Definition Escrow Bucket Escrow buckets are the different categories that you can put escrow money into. These are configured at the tenant level. Escrow Adjustment Escrow adjustments determine when and how much money from each payment will go into an escrow bucket. Escrow Transaction Escrow transactions let you deposit or withdraw money from an escrow bucket. A transaction that sends money to a third party (like an insurer or tax collector) is often called a disbursement or remittance. Escrow Vendor The third party that you will remit money to. You can set things up in your tenant-level settings.

### What’s Next

You might also be interested in making changes to an escrow bucket outside of the analysis tool. Our article on Updating Escrow Account Settings will show you how to edit the default settings for escrow buckets, or the settings on individual loans. Escrow Estimated Disbursements will help you add or edit the transactions you anticipate in the future.