GUIDE
Rental Property Mortgage Payment Bookkeeping: How to Record Principal, Interest and Escrow
A rental mortgage payment is one amount that does 3 jobs in the books: principal lowers the loan, interest is a cost of the property, and escrow is your money held by the lender.
The examples use Demo Rentals LLC, a sample company. Property 1 at 275 Demo St, Davis has a 30-year fixed loan from Example Mortgage Co with escrow. Property 2 at 1640 Test Way, Vacaville has a new loan without escrow. Every number is invented data.
Why is a mortgage payment not one expense?
Because one payment does 3 jobs. Principal pays down the loan, interest is a cost of the property, and escrow is money the lender holds for property tax and insurance. Only the interest is a cost that month.
Recorded as one expense, the payment makes every month look worse than it was. It also leaves the loan balance in the books stuck at the day you borrowed.
Splitting the payment is one of the monthly routines in the rental property bookkeeping guide, next to rent, deposits and repairs.
How do you split a payment into principal, interest and escrow?
Take the 3 amounts from the lender’s statement. Post principal to the loan, interest to mortgage interest and escrow to escrow held by the lender. The 3 lines must add up to the payment that left the bank.
- 1Open the lender’s statement for the month and find the principal, interest and escrow parts of the payment.
- 2Record the payment from checking as one transaction with 3 lines.
- 3Post principal to the loan account, interest to mortgage interest for that property, and escrow to escrow held by the lender.
- 4Check that the 3 lines add up to the amount that left the bank.
- 5Check the loan balance in the books against the balance on the statement.
Here is the October 2026 payment on Property 1, due Oct 1, 2026.
| Account | Amount | What it means |
|---|---|---|
| Loan, Example Mortgage Co | $236.40 | Principal. The loan balance goes down. |
| Mortgage interest, Property 1 | $1,214.60 | Interest. A cost of Property 1 in October. |
| Escrow held by the lender | $623.00 | Escrow. Still your money, held for tax and insurance. |
| Checking, Sample Credit Union | -$2,074.00 | The whole payment leaves the bank. |
| Lines add up to | $0.00 | The 3 parts equal the payment |
Principal $236.40 plus interest $1,214.60 plus escrow $623.00 equals $2,074.00. Debits show as positive amounts and credits as negative.
The 3 accounts each have a fixed place in the books. The real estate chart of accounts lists them in its rental module.
Where do the numbers for the split come from?
From the lender’s monthly statement or its amortization schedule. On a fixed-rate loan the payment stays the same, but each month a little more goes to principal and a little less to interest.
Here are the 10 payments on Property 1 from January to October 2026. The principal and interest payment is $1,451.00 every month, and escrow adds $623.00.
| Due | Principal | Interest | Escrow | Payment |
|---|---|---|---|---|
| Jan 1, 2026 | $225.02 | $1,225.98 | $623.00 | $2,074.00 |
| Feb 1, 2026 | $226.26 | $1,224.74 | $623.00 | $2,074.00 |
| Mar 1, 2026 | $227.50 | $1,223.50 | $623.00 | $2,074.00 |
| Apr 1, 2026 | $228.76 | $1,222.24 | $623.00 | $2,074.00 |
| May 1, 2026 | $230.01 | $1,220.99 | $623.00 | $2,074.00 |
| Jun 1, 2026 | $231.28 | $1,219.72 | $623.00 | $2,074.00 |
| Jul 1, 2026 | $232.55 | $1,218.45 | $623.00 | $2,074.00 |
| Aug 1, 2026 | $233.83 | $1,217.17 | $623.00 | $2,074.00 |
| Sep 1, 2026 | $235.11 | $1,215.89 | $623.00 | $2,074.00 |
| Oct 1, 2026 | $236.40 | $1,214.60 | $623.00 | $2,074.00 |
| Jan to Oct 2026 | $2,306.72 | $12,203.28 | $6,230.00 | $20,740.00 |
After the October payment the loan balance is $220,726.41, as on the lender's statement.
Principal grew from $225.02 in January to $236.40 in October. Interest fell by the same amount. The split changes every month, so it is read from the statement every month.
What happens when the lender pays tax and insurance from escrow?
The escrow balance goes down and the property records the cost. A property tax installment paid from escrow becomes property tax that month, and the insurance premium becomes insurance that month.
The $623.00 a month is set to cover a year: $5,940 of property tax in 2 installments of $2,970, plus $1,536 of hazard insurance. That is $7,476 a year. The lender pays the tax in December and April and the insurance at the April renewal.
| Date | What happened | Escrow held by the lender | Cost of Property 1 |
|---|---|---|---|
| Jan 1, 2026 to Oct 1, 2026 | 10 escrow deposits in the payments | $6,230.00 | $0.00 |
| Apr 10, 2026 | Lender pays a property tax installment | -$2,970.00 | $2,970.00 |
| Apr 28, 2026 | Lender pays the yearly hazard insurance | -$1,536.00 | $1,536.00 |
| Jan to Oct 2026 | Net change | $1,724.00 | $4,506.00 |
The escrow column is the change in the balance the lender holds.
The tax and insurance are costs in April, the month the lender paid them, not in the months the escrow was building up. That is why Property 1's April looks expensive and its other months do not.
How do you check the loan and escrow balances?
Each month, match the loan balance and the escrow balance in the books to the lender’s statement. At year end, match the year’s interest to the lender’s Form 1098 when you receive one.
If the books and the statement disagree, the usual cause is a split copied from the wrong month or an escrow payment the lender made that was never recorded. Matching the loan statement is part of reconciling bank, card and loan statements, a step on the month-end close checklist.
If Example Mortgage Co sends a Form 1098 for Property 1, we match the interest on it to the interest in the books for the year. A lender may also list real estate taxes or insurance paid from escrow in Box 10, which the IRS instructions for Form 1098 describe as an optional box, so we match those escrow lines the same way. The form goes into the year-end package with the books. How the interest and tax are reported on the return is your CPA's call.
What changes when a loan has no escrow?
There is no escrow line. The payment splits into principal and interest only. You pay the property tax and insurance yourself and record each one as a cost of the property when you pay it.
Property 2 was refinanced with Example Mortgage Co on Oct 22, 2026. The new $240,000 loan has no escrow. Its payment is $1,616.92 of principal and interest, first due Dec 1, 2026.
The lender's schedule splits that first payment into $1,425.00 of interest and $191.92 of principal. It is a schedule, not a payment yet, and the books record it when it is paid.
The loan itself came from the refinance, which paid off the rehab loan. We set out that entry in cash-out refinance bookkeeping.
What does the split do to your bank balance and your profit?
The bank balance drops by the whole payment. Profit drops only by the interest, plus tax and insurance in the months the lender pays them. Booked as one cost, the payment overstates costs every month.
In October, $2,074.00 left checking for Property 1. Only $1,214.60 of it is a cost of October. Booked as one cost, Property 1's October costs would be $859.40 too high.
The gap between money out and cost is the same idea behind cash flow vs profit in real estate bookkeeping.
Your company's performance, one deal at a time.
For your rentals, Flipper Bookkeeping keeps the books and sends you, every month, a profit and loss for each property and each rehab, with cash against profit. See rental property bookkeeping services.