QuickBooks

How to Enter a Mortgage Payment in QuickBooks (Splitting Principal From Interest)

A mortgage payment isn't one expense, it's two. The principal portion pays down a liability account; the interest portion is a genuine expense. Split the transaction, send part to your mortgage liability account and part to an Interest Expense account, using the numbers from your lender's statement. Here's the full walkthrough, including what to do if escrow is bundled into the payment too.

The full walkthrough

1. Set up a liability account for the loan, if you haven't already. Go to Settings > Chart of Accounts > New, choose Long Term Liabilities (or Other Current Liabilities for the portion due within a year) as the account type, pick Notes Payable as the detail type, which works fine for a mortgage, and name it something you'll recognize, like 'Mortgage - [Property].'

2. Get the principal and interest split from your lender. QuickBooks has no idea how your payment actually breaks down. Your mortgage statement or amortization schedule has the exact numbers for each payment; pull it up before you start.

3. Find the payment in your bank feed, or start a new transaction. If the account's connected, open Transactions, find the payment, and click to expand it. If it's not, use + New > Check or Expense instead.

4. Split it into at least two lines. Switch from a single category to Split. Line one: your mortgage liability account, the principal amount. Line two: an Interest Expense account, the interest amount. If escrow for taxes or insurance is bundled into the payment, add a third line for however you track that.

5. Confirm the lines total the full payment, then save. Check the math against your statement before you click Add or Save and close, QuickBooks won't stop you from being off by a few dollars.

Where the same entry gets tedious every single month

This split isn't a one-time setup; it's the same two numbers, different every month, for the life of the loan. Early payments are mostly interest, and that balance shifts a little further toward principal with each one, so a recurring transaction template built with one month's numbers quietly drifts wrong the moment it repeats.

That leaves someone pulling the statement, checking the current split, and re-entering it by hand every single time a payment posts, for as long as the mortgage exists. It's not hard, it's just permanent, and it's exactly the kind of repeating manual task that never gets fixed because no single instance of it feels worth automating.

What we've built on top of QuickBooks mortgage and loan entries

Splits that pull from the real amortization schedule

The payment gets split into the correct principal and interest automatically, sourced from an actual amortization schedule, not a fixed template that was only right the month it was built.

Loan payments posted the moment they clear

Connect the loan servicer or bank feed and the payment gets recorded and split the same day funds move, instead of someone reconstructing it from a statement at month-end.

What loan or mortgage entry are you still splitting by hand every month?

Tell us which one and where the numbers actually come from, and we'll tell you if it can post itself correctly going forward.

Let's talk

Splitting the same mortgage payment by hand every single month?

Tell us where your amortization numbers live today, a spreadsheet, a lender portal, a PDF statement, and we'll tell you whether that split can run itself. This one payment is a small piece of the picture; n-frames automates whatever's manual in a business, in QuickBooks or anywhere else.

Let's talk

Frequently Asked Questions

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

Same mechanic, different account names. Split the payment between the loan's liability account for the principal portion and an Interest Expense account for the interest, using the numbers from your lender. Works the same whether it's a term loan, a vehicle loan, or a line of credit, as long as the lender gives you a principal/interest breakdown per payment.

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

Create a separate account for it, usually an Other Current Asset if you're tracking the balance your lender is holding on your behalf for taxes and insurance. When a payment includes an escrow contribution, add it as a third split line going into that account instead of folding it into principal or interest, which keeps the two genuinely different things from blending together on your books.

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

Same split, just a different starting point. Instead of creating a new Check or Expense transaction, click the payment where it already sits in the bank feed, switch it to Split, and enter the principal and interest lines there before clicking Add. QuickBooks won't guess the split for you either way; it still comes from your statement.