Skip to main content

Tagging Mortgage Payments

How to split a mortgage payment into principal, interest and escrow (property taxes and insurance).

Written by Morgan Kratochvil

A mortgage or land loan payment often includes more than principal and interest. Many lenders also collect escrow each month. They hold that money and use it to pay your property taxes and insurance for you. Each part of the payment needs its own tag, both for taxes and to keep your balance sheet accurate.

A typical monthly mortgage payment includes:

  • Principal pays down the loan balance. It goes to your mortgage account on the balance sheet, not your P&L.

  • Interest is an expense.

  • Escrow (if your lender collects it) is money set aside for property taxes and insurance.

For other kinds of loans, such as equipment or operating loans, see Tagging Loan Payments.

Before you start: set up your mortgage account

If you haven't added your mortgage to Ambrook yet:

  1. Go to Accounts and click New Account.

  2. Choose the Mortgage account type and give the account a name (for example, "Farm Credit – Home Farm Mortgage").

  3. Set the Starting Date and Starting Balance:

    • For a mortgage you already had when you started Ambrook: use the date your books start and the amount you owed on that date (principal balance only).

    • For a new mortgage: use the date you closed on the loan and a Starting Balance of $0.00.

  4. Click Save.

Mortgage accounts in Ambrook are set up manually. We don't usually recommend connecting them through your bank. For more detail, including how to record the loan amount on a new mortgage, see Adding a Loan Account.

Step 1: Find the split on your mortgage statement

Your monthly mortgage statement, or your lender's online portal, shows how each payment divides between principal, interest and escrow. Some statements also break escrow down into property taxes and insurance. Keep the statement handy for the next steps.

Step 2: Itemize the payment

  1. In the Ledger, find the mortgage payment and click the three dots next to it. You can also click the transaction to open its details and scroll down.

  2. Click Itemize.

  3. Add a line item for the principal: enter a description (for example, "Principal") and the amount.

  4. Click New Line and add a line item for the interest.

  5. If your payment includes escrow, click New Line and add a line item for it. If your statement lists property taxes and insurance separately, you can add a line for each instead.

  6. Check that Amount Remaining is $0.00, then click Done.

The line items now appear nested under the transaction in the Ledger. That's where you'll tag each one.

Paying by check? Itemize isn't available for check transactions yet. Instead, create a bill with line items for principal, interest and escrow, then match the check as the payment for that bill.

Already matched the payment? Click the three dots next to the transaction, choose Unmatch, then itemize it.

Step 3: Tag the principal

  1. In the Ledger, click the Category button on the principal line item.

  2. Choose Liability Adjustment.

  3. In the To field, select your mortgage account.

  4. Click Record.

This lowers the mortgage balance on your balance sheet.

Is your mortgage account syncing transactions from your bank? Use Account Transfer instead, and match the principal line item to the payment in the mortgage account. A Liability Adjustment on a connected account counts the principal twice.

Step 4: Tag the interest

Tag the interest line item to Mortgage Interest, or whichever interest category you use for real estate loans.

Step 5: Tag the escrow

Skip this step if your lender doesn't collect escrow.

There are two ways to handle escrow. Pick one and use it every month. If you're not sure which fits your books, check with your accountant.

Option A: Tag escrow straight to expenses (simplest)

Tag the escrow line item to the expense it pays for:

  • Property taxes → Property Tax (or Taxes)

  • Insurance → Insurance (or Property Insurance)

If your statement doesn't separate the two, use a percentage split. After choosing the first category, click Split and give each category a percentage based on your yearly tax and insurance bills.

This option is quick. The trade-off is timing: the expenses are recorded when you pay into escrow, not when your lender actually pays the tax or insurance bill.

Option B: Track escrow as an asset (more accurate)

Escrow is your money, held by the lender until the bills are due. To show it on your balance sheet:

  1. Go to Accounts → New Account, choose Other Current Asset and name it something like "Mortgage Escrow."

  2. Each month, tag the escrow line item as an Asset Adjustment with the escrow account in the To field.

  3. When your lender pays your property tax or insurance from escrow (your escrow statement shows this), open the escrow account's register and add a transaction for the amount paid. Tag it to Property Tax or Insurance.

  4. Once a year, compare the escrow account balance to your lender's annual escrow statement, and record any refund or shortage.

If your lender only reports interest at year end

Some lenders only report totals once a year, on Form 1098 and the annual escrow statement. You can also use this method if you'd rather not split every payment.

  1. Tag each full payment as a Liability Adjustment to your mortgage account.

  2. When you receive your year-end statements, open the mortgage account's register.

  3. Add an expense transaction for the total interest paid, and tag it to Mortgage Interest.

  4. If your payments included escrow, add transactions for the property taxes and insurance paid from escrow, and tag them to Property Tax and Insurance.

Why this works: Tagging the full payment to the mortgage lowers the balance by too much. The register transactions add the interest and escrow amounts back, so the balance matches your lender's statement and each expense ends up in the right category.

Is this mortgage on your home?

If the loan is for your personal home that is on separate taxes from your business that's in Ambrook, tag the payment (or its personal portion) to Personal Expense. You can also record it to your owner's equity account with an Equity Adjustment. See Managing Personal Expenses. If one mortgage covers both your house and your farmland, ask your accountant how to divide the interest, taxes and insurance.

Frequently Asked Questions

Can I set up an automation for my mortgage payment?

Not for the full split. You can't create automations for itemized transactions, and the principal, interest and escrow amounts usually change a little each month. We recommend itemizing each payment from your statement. If you have several months to catch up on, bulk tagging can speed up tagging the line items.

My escrow payment changed. Do I need to do anything?

No. Lenders often adjust escrow once a year when taxes or insurance premiums change. Use the new amounts from your statement when you itemize.

I received an escrow refund check. How do I tag it?

With Option A, tag the refund to the same Property Tax or Insurance category, which reduces the expense. With Option B, tag it as an Asset Adjustment to your escrow account.

My mortgage balance doesn't match my lender's statement. What should I check?

I paid off my mortgage. What now?

Did this answer your question?