What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Enter a Mortgage Payment in QuickBooks
QuickBooks loans

Principal, Interest and Escrow: How to Enter a Mortgage Payment in QuickBooks

Your bank feed shows one payment to the lender. Your books need up to three: principal, which lowers what you owe; interest, which is an expense; and escrow, money the lender holds to pay the property tax and insurance later. Take the amounts from the lender's statement, split the payment into those lines, and save.

A mortgage payment, opened up

The total usually stays the same until the lender's escrow review. Inside it, the principal and interest shares shift with every payment.

Example: one month on a rental property mortgage, figures for illustration only
Principal (To the mortgage liability account) $612.40
Interest (To Interest Expense) $1,104.60
Escrow for tax and insurance (To a Mortgage escrow asset account) $433.00
Payment leaving the bank (The one line in your bank feed) $2,150.00

Only the $612.40 lowers the mortgage balance. The escrow $433 isn't an expense yet. It becomes one when the lender pays the tax bill or the insurance premium out of it.

Setting up the accounts, then entering each payment

  1. 1

    Create the mortgage account

    Settings ⚙ Chart of accounts New

    Choose Long Term Liabilities with the Notes Payable detail type and name it after the property, for example "Mortgage, 14 Elm St". One account per property makes each balance easy to check against its lender.

    Watch for: the opening balance. For a mortgage you already had before your QuickBooks start date, the balance still owed on that date goes in here. How the other side is booked when the property is new to your books is worth a word with your accountant.

  2. 2

    Create the escrow account if the lender holds one

    Settings ⚙ Chart of accounts New

    An Other Current Asset named Mortgage escrow. It's money that's still yours, held by the lender, so it sits with your assets until it's spent.

  3. 3

    Split the payment

    Transactions Bank transactions

    Open the payment in the bank feed and choose Split. Line one: the mortgage account, principal. Line two: Interest Expense, interest. Line three: Mortgage escrow, the escrow amount. No feed? Use + New › Check or Expense with the same lines.

    Watch for: the total. QuickBooks lets the lines add up to anything, so check them against the statement before you save.

  4. 4

    Book what the lender paid from escrow

    + New Journal entry

    When the lender pays the property tax or the insurance, nothing moves in your bank. Use a journal entry: debit Property taxes or Insurance, credit Mortgage escrow, dated as the escrow statement shows. Categorizing property taxes covers which tax account to use.

  5. 5

    Tie out once a year

    Compare the mortgage account's balance on your balance sheet with the principal the lender says is still owed, and your interest total with the interest on the lender's year-end statement or Form 1098, if they send one. A gap usually means a month where the split was guessed.

Every part a mortgage payment can carry

Typical treatment for a business or rental property. Tax treatment varies, so confirm the less common lines with your accountant.

Part of the payment Usually goes to Worth knowing
Principal The mortgage liability account. Not an expense. It only reduces what you owe.
Interest Interest Expense, or Mortgage interest if you want it apart from other loans. Early in the loan this is most of the payment.
Escrow for property tax and insurance The Mortgage escrow asset account. It turns into Property taxes and Insurance expense when the lender pays those bills.
Private mortgage insurance (PMI) Often an Insurance or Mortgage insurance expense account. Generally an expense, not principal.
A late charge A Late fees account, or Bank charges if you keep fees together. Categorizing late fees has the options.

Loans, escrow, bank feeds and the house you live in

How do I record a regular loan payment in QuickBooks, not a mortgage?

The same split without the escrow line: principal to that loan's liability account, interest to Interest Expense, with the amounts from the lender's schedule. Entering a loan walks through a term loan from the day the money arrives, and a line of credit works a little differently because the balance moves both ways.

How do I set up an escrow account in QuickBooks for my mortgage?

Create an Other Current Asset account called Mortgage escrow. Each payment's escrow portion goes into it as its own split line. When the lender pays the tax or insurance, a journal entry moves that amount out of escrow and into the expense account. Some small businesses skip the asset and expense the escrow portion each month instead. It's simpler, but the expense then lands in the wrong months, so ask your accountant which they'd rather see.

How do I categorize a mortgage payment that shows up automatically in my bank feed?

Don't create a new check for it. Open the payment where it sits in the bank feed, choose Split, and enter the principal, interest and escrow lines there before you add it. Entering it separately as well leaves the payment on your books twice. QuickBooks won't work out the split for you either way, so keep the statement open.

The mortgage is on my own home but the business account pays it. How do I enter that?

Generally it isn't a business expense at all. If the business account paid it, it's usually booked as an owner's draw or distribution, covered in recording owner money. A home office share is normally worked out on the tax return, not by splitting the mortgage in QuickBooks. Your accountant will know which applies to you.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.