A mortgage payment is not one transaction. It is three, sometimes four, and booking the whole thing as one lump against a single account is one of the most common ways rental property books go wrong without the owner noticing for months.
What one mortgage payment actually contains
A typical payment splits into principal, interest, and often an escrow portion for property taxes and insurance. Each piece behaves differently in your books:
- Principal reduces the loan balance. It is not an expense; it moves money from cash to a reduction in a liability account.
- Interest is an expense, the only piece of the payment that actually reduces your taxable income.
- Escrow is neither. It is cash handed to the lender to hold until they pay your property taxes and insurance on your behalf, so it belongs in an asset account until it is spent.
The mistake: booking the whole payment as an expense
If your monthly mortgage payment gets coded entirely to a “Mortgage Expense” line, your expenses are overstated by the principal and escrow portions, and your loan balance never goes down in your books even though it is going down in reality. Run a balance sheet a year later and the loan balance is still showing the amount from day one. That mismatch is one of the more common reasons a lender or a CPA asks a real estate investor for corrected books before they will use them.
Setting it up correctly
Three accounts, minimum: a long-term liability account for the loan itself, an interest expense account, and an other-current-asset account for escrow if your loan has one. Every mortgage payment is entered as a split transaction across these three (or two, without escrow), not a single line. Most lenders provide an amortization schedule showing the principal-and-interest split for every payment for the life of the loan; use it rather than estimating, since the split shifts every month as the loan amortizes.
Where this compounds across a portfolio
One property, one mortgage, this is a five-minute monthly entry. Across a portfolio of several properties, each with its own loan and its own amortization schedule, the entries need to tie to the right property and, if the properties sit in separate LLCs, the right entity. A loan balance that is wrong on one property’s books usually means every downstream number for that property, from equity to cash-on-cash return, is wrong too.
What escrow shortages and refunds do to your books
Lenders periodically reconcile the escrow account and either bill for a shortage or refund a surplus. Both need their own entry against the escrow asset account, not against interest or principal. A shortage payment is not an expense; a refund is not income. Get this wrong consistently and the escrow asset balance in your books drifts further from what the lender’s statement actually shows, until nothing reconciles.
How to tell if this is already wrong in your books
Pull your loan’s year-end statement from the lender and compare the ending balance to what your books show as the liability. If they do not match, the payments have not been split correctly, possibly for the life of the loan. The fix is usually a handful of journal entries to true up the balance to the lender’s statement, followed by correctly splitting every payment going forward.
We do bookkeeping and fractional-CFO work for real estate investors, not tax prep, so for how mortgage interest deductions apply to your specific situation, that is a question for your CPA. If your loan balances need to be trued up against the lender’s statements, book a free discovery call.
Is a mortgage payment tax deductible?
Only the interest portion is deductible as an expense. Principal is not deductible; it is a return of borrowed money. Escrow payments are not deductible when paid into escrow, though the taxes and insurance the escrow account pays for may be, depending on your situation.
What accounts do I need to record a mortgage in QuickBooks?
At minimum, a long-term liability account for the loan and an interest expense account. If your loan includes escrow, add an other-current-asset account for it, since that money is not yet spent, just held.
How do I know the principal-and-interest split for each payment?
Your lender’s amortization schedule shows this for every payment over the life of the loan. Use that schedule rather than estimating, since the split changes every month as the loan pays down.
Financing the rehab? See how flip renovation costs, including loan interest, split into COGS versus capitalized costs.
Recent Comments