Split every rental mortgage payment into three parts. Principal lowers the loan balance on your balance sheet, interest is an expense on that property's P&L, and escrow goes into an escrow account that still belongs to you. Property tax and insurance become expenses later, when the servicer actually pays them out of escrow.
Why one payment needs three lines
Your bank shows one number leaving each month. Your lender sees three things in it. Part of the payment pays down what you owe, part is the cost of borrowing, and part is set aside so the servicer can pay your property tax and insurance bills when they come due.
Those three parts land in three different places in your books. Principal reduces a liability, the loan. Interest is an expense. Escrow is an asset: money held for you until the tax and insurance bills are paid from it. Only the interest belongs on the property's P&L in the month you pay it.
When the whole payment goes to one expense account, two things break at once. Expenses are overstated by the principal every month, and the loan balance on your balance sheet never goes down. By year end the books show a loss the property didn't have and a loan you no longer owe in full.
A worked example
Say you own a single-family rental with a fixed-rate loan. The payment is $1,900 a month: $1,500 of principal and interest, plus $400 for escrow. The January statement splits the $1,500 into $425 of principal and $1,075 of interest. The split shifts a little every month, with principal growing and interest shrinking, so the 12 statements add up to $5,160 of principal and $12,840 of interest for the year.
| Line | January | Year total | Where it goes |
|---|---|---|---|
| Principal | $425 | $5,160 | Lowers the loan balance (liability) |
| Interest | $1,075 | $12,840 | Mortgage interest expense |
| Escrow deposit | $400 | $4,800 | Escrow account (asset) |
| Total paid | $1,900 | $22,800 | Out of your bank account |
During the year the servicer pays the property tax bill of $3,120 and the insurance renewal of $1,680 out of escrow. Those payments total $4,800, the same as the year's escrow deposits, so the escrow account ends where it started, at an $800 cushion.
The property's real costs for the year are $12,840 of interest, $3,120 of property tax and $1,680 of insurance, or $17,640. If all $22,800 of payments had been booked as expense, the P&L would be overstated by $5,160, exactly the principal. Meanwhile the loan that started the year at $215,000 should end it at $209,840.
How to record it, step by step
- Set up the accounts once. One loan account per mortgage, set up as a liability. One escrow account per loan, set up as an asset. Expense accounts for mortgage interest, property tax and insurance, each tied to the property.
- Enter the opening loan balance. Use the lender's statement for the day your books start. Without it, principal payments reduce a balance that was never there, and the loan account goes negative.
- Record each payment from that month's statement. Principal to the loan account, interest to mortgage interest expense, escrow to the escrow account. Use the actual split on the statement, not January's split copied all year.
- Record escrow disbursements when they happen. When the servicer pays the tax bill or the insurance premium, move that amount out of escrow and into property tax or insurance expense. The servicer's online history or the annual escrow statement shows the dates and amounts.
- Update for the escrow analysis. Once a year the servicer recalculates escrow from the next year's expected bills. If the tax bill rises to $3,480 and insurance to $1,800, escrow becomes $440 a month and the payment becomes $1,940. Principal and interest stay at $1,500; only the escrow line changes.
- Reconcile the loan every month. The loan account balance should match the principal balance on the lender's statement, the same way a bank account matches its statement.
In REI Hub and in QuickBooks Online
In REI Hub, the mortgage payment template splits each payment into principal, interest and escrow, and every line carries the property, so the loan balance and that property's P&L stay right without extra steps. If you're moving from other software, REI Hub doesn't import from it directly: you pick a start date, enter each loan's balance as of that date, and record payments from there. Our REI Hub review covers the rest of what it does well and where it falls short.
In QuickBooks Online, split the payment when it comes through the bank feed: one line to the loan account, one to mortgage interest, one to escrow, each with the property's class or location (those need the Plus or Advanced plan). Escrow disbursements go in as a journal entry from escrow to the expense, with the same class. Either way works. The difference is how much setup it takes, which we compare in the best accounting software for rental property.
Mistakes we see most
- The whole payment booked as expense. Expenses are overstated by the principal and the loan never goes down.
- Escrow deposits booked as property tax. The monthly $400 isn't a tax bill. Booking it as tax puts the expense in the wrong months and the wrong accounts, and the year's tax figure won't match the actual bill.
- One split used all year. Interest in the books won't match the lender's year-end form.
- Escrow refunds booked as income. A surplus check from the servicer is your own escrow money coming back. It reduces the escrow account; it isn't rent or other income.
- No opening balance, or a loan set up as an expense account. The balance sheet can't show what you owe.
Year end: tie it to Form 1098
Your lender sends Form 1098 for each loan. Box 1 shows the mortgage interest you paid, and it should match your mortgage interest expense for that loan, $12,840 in the example. Box 2 shows the outstanding principal at the start of the year (or when the loan began, if that was this year), which should match your opening loan balance. Many lenders also show property tax paid from escrow on the form. If any of these don't match, find the difference before the books go to your CPA, not after.
Hand your CPA each Form 1098, the lender's year-end statement with the ending loan balance, the annual escrow statement, and the closing disclosure for any loan taken out or refinanced during the year. How points, closing costs and refinance fees are treated is your CPA's call.
How we handle it
With REI Hub bookkeeping, every mortgage in your portfolio is set up with its opening balance, split from the lender's statement each month, and reconciled to the loan balance. Escrow disbursements are recorded when the servicer pays them, and the year ends with interest, property tax and loan balances tied to each Form 1098. We do the same in QuickBooks Online for owners whose rentals sit next to another business, as part of our real estate bookkeeping.
If your loan balances haven't moved in a year, or your P&L shows the full payment as an expense, that's usually a short cleanup. Start with our REI Hub bookkeeping page to see how the monthly work runs. Plans start at $299 a month; any setup or catch-up fee is quoted up front.
Common questions
Is my whole mortgage payment an expense on my rental's P&L?
No. In the books, only the interest is an expense when you pay it. Principal lowers the loan balance, and escrow sits in an escrow account until the servicer pays property tax and insurance from it, which is when those become expenses. How any of it is treated on your return is your CPA's call.
Where do I get the principal and interest split each month?
From the lender's monthly statement or its online payment history. An amortization schedule works for a fixed-rate loan, but only until you make an extra principal payment, which changes every split after it. The statement is always the source to use.
What do I do with an escrow refund check?
Record it as money coming back out of the escrow account into your bank. It isn't income. The property tax and insurance expenses were already recorded when the servicer paid those bills from escrow.
How does REI Hub handle mortgage payments?
REI Hub has a mortgage payment template that splits each payment into principal, interest and escrow and ties it to the property. Set up each loan with its balance as of your start date first. Our REI Hub review covers how it handles the rest of a rental's books.
Are Your Loan Balances Right?
Book a free books review and we'll check how your mortgage payments, escrow and loan balances are recorded today.
Book a Free Books Review →