How to Handle Mortgage Escrow Accounts in Quicken 2012 - dummies

How to Handle Mortgage Escrow Accounts in Quicken 2012

By Stephen L. Nelson

Like with most things, you can handle mortgage escrow account in Quicken 2012 the easy way (which is rough, dirty, and unshaven) or the hard way (which is precise, sophisticated, and cumbersome).

If you have a mortgage, you know the basic procedure. Although your mortgage payment may be $599.55 per month, your friendly mortgage company (while insisting that it trusts you completely) makes you pay an extra $125 per month for property taxes and other such things.

In other words, even though you’re paying only $599.55 per month in principal and interest, your monthly payment to the mortgage company is, according to this example, $724.55 ($599.55 + $125).

The mortgage company, as you probably know, saves this money for you in an escrow account or a set of escrow accounts. A couple of times yearly, the mortgage company pays your property taxes; and, a time or two per year, it pays your homeowner’s insurance. If you have private mortgage insurance, it may pay this fee every month as well. And so it goes.

The rough, dirty, and unshaven method of working with escrow accounts

Suppose that you do pay an extra $125 per month. You can treat this extra $125 as another expense category, such as Tax:Property or Other Housing or Property Expenses.

Here is a sample Split Transaction window filled out this way.


This approach doesn’t tell you how much moolah you have stashed away in your escrow accounts. It also doesn’t tell you how much you really spend in the way of homeowner’s insurance, what you’re entitled to claim as a property tax deduction, or how much they’re bleeding you for private mortgage insurance.

To get these figures, you have to peruse the monthly and annual mortgage account statements — that is, if you get them. Or you have to call the mortgage lender and rattle a cage or two.

The precise, sophisticated, and cumbersome approach to working with escrow accounts

You say you can’t live with the uncertainty, the stress, the not knowing? You can set up an asset account for each escrow account for which the mortgage company collects money.

You set up asset accounts like you set up a checking account. And, in fact, you should think of escrow accounts essentially as special checking accounts into which your lender deposits money collected from you so that it can pay your property taxes and insurance.

You set up an asset account with its starting balance equal to the current escrow account balance. To do so, follow these steps:

  1. Display the Quicken home page or some other Quicken tab that shows the Accounts bar along the left edge of the window.

  2. Click the Add An Account button to indicate that you want to create a new account.

  3. As you step through the seemingly interminable account setup process, identify the account as an asset account and give it a name.

  4. Tell Quicken how much money is in the account as of a specific date.

    If you’ve set up an account or two in your time, this process should take you about 40 seconds.

After you set up your asset account and record its current balance, you’re ready to cruise. Record payments in the escrow as account transfers whenever you record the actual loan payment.

You need to do one other thing. When you set up an escrow account, you must record the payments that the bank makes from your escrow account to the county assessor (for property taxes) and to the insurance company (for things such as homeowner’s and private mortgage insurance). You don’t know when these payments are really made, so watch your monthly mortgage account statements.

When the mortgage company disburses money from the escrow account to pay your first property tax assessment, for example, you need to record a decrease equal to the payment for property taxes and then categorize the transaction as a property tax expense. This process isn’t tricky in terms of mechanics. The account increases after every loan payment and decreases after a disbursement.

Basically, the Asset Account register mirrors the Checking Account register. The only difference is that the Payment and Deposit fields are labeled Decrease in the latter and Increase in the former. To get to this account’s register, click its name in the Accounts bar.

This second approach doesn’t seem like all that much work, does it? And if you use this approach, you can track escrow balances and escrow spending precisely. You can, for example, pull your property tax deduction right from Quicken.