Add a mortgage (including amortization and escrow)

  • Are responsible for paying the mortgage

  • Want to track the amortization of the loan

In this article, you'll learn how to:

  1. Record only the mortgage expense
  2. Add a mortgage, including amortization and escrow.    
  3. Make a mortgage payment
  4. Record a payment made from escrow by the mortgage company

1. Record only the mortgage expense

Use this solution if you:

  • Are responsible for paying the mortgage
  • Do not need or want to track the amortization of the loan

To add a mortgage:

    1. Add an expense account called Mortgage Expense to your Chart of Accounts.
    2. Record a check to the mortgage company each month. Use the Mortgage Expense account when you write the check.

      If the mortgage amount doesn't change each month, use the recurring check feature.

    3. This expense will appear on reports such as an income statement, income statement detailed, and rental owner statement.

      For more detail on the loan's progress, work directly with the mortgage service company. For example, the mortgage company can help you track escrow, interest paid, insurance payments, etc.

2. Add a mortgage, including amortization and escrow

  1. To begin, add the loan, the building, and associated accounts to your Chart of Accounts.

    • A mortgage is typically considered a long term liability account.

    • Add the property that was purchased by the loan as a fixed asset account.

    • Add escrow that is held by the mortgage company as a current asset account.

      Make sure to uncheck Cash asset.

      escrow_article_screenshot_1.png

       

    • Add mortgage interest as an expense account.

    • Add specific expenses that may be paid directly by the mortgage company from escrow as expense accounts

      For example - fire insurance, homeowner's insurance, etc.

      If you have multiple mortgages to track, consider naming the liability account after the bank. Mortgage. #1234 with Anywhere Bank is much easier to decipher than a generic mortgage.

      Similarly, consider naming the fixed assets after the buildings. One Main Street and 15 Any Avenue are more descriptive than building.

  2. Record the initial loan with a general journal entry.

    • Credit the mortgage's liability account.

    • Debit the property's fixed asset.

    • If you've already made some payments, balance the general journal entry using Opening Balance Equity as the offsetting account.

      For example, let's say the mortgage is for a property valued at $100,000 and the remaining principal balance is $80,000. The general journal entry for this mortgage would be.

    DEBIT: Property Fixed Asset - $100,000

    CREDIT: Loan - $80,000

    CREDIT: Opening Balance Equity - $20,000



    escrow_article_screenshot_2.png

3. Make a mortgage payment

Making mortgage payments is easy.

 

  • Record a check using the bank as the payee. When you write the check, apply the money to the appropriate accounts such as mortgage liability, interest expense, escrow, etc.

The mortgage liability account is the loan's principal.

escrow_article_image_3.png

4. Record a payment from escrow by the mortgage company

(Optional) To record a payment made from escrow by the mortgage company, use a general journal entry.

For example, let's say there was $10,000 in escrow. The mortgage company used $5,000 to pay property taxes. The general journal entry for this escrow payment would be:

DEBIT: Property tax expense - $5,000

CREDIT: Escrow current asset - $5,000

Escrow_article_screenshot_4.png

 

To report on the mortgage, consider using a balance Sheet or transaction Detail by account report.

Some portions of the mortgage, such as property taxes and interest payments, will appear on reports such as an income statement, income statement detailed, and rental owner statement.



Article #: 111169

 

Still have questions?

Create a support ticket anytime, and we'll get back to you as soon as possible.

Submit a support ticket