How do I track mortgage payments including escrow?
A mortgage payment to your lender actually contains several different transactions from an accounting perspective. Your monthly payment includes principal, interest, and often escrow for property taxes and insurance. Each component needs to go to a different account in your books.
Principal payments reduce your mortgage liability. When you pay $1,800 and $500 goes to principal, that $500 comes off your loan balance on the balance sheet. It’s not an expense. It’s paying down debt.
Interest is an expense. The interest portion of your payment goes to an interest expense account on your income statement. This is deductible for investment properties or if you use a qualifying home office.
Escrow is where most people get confused. The escrow portion sits with your lender until they pay property taxes and insurance on your behalf. You’re prepaying these expenses, so the money should be tracked as an asset until it’s actually spent.
Create an escrow asset account in your chart of accounts. Each month, the escrow portion of your payment goes to this account. When your lender pays your property tax bill, you move that amount from the escrow asset to property tax expense. Same for insurance. This method reflects what’s actually happening with the money and keeps your financials accurate.
Some business owners skip the escrow account and just expense property tax and insurance each month based on what they pay into escrow. This is simpler but less precise because the expense timing doesn’t match when taxes and insurance are actually incurred. For real estate investors tracking multiple properties, the accurate method is worth the extra effort.
Your lender sends an annual escrow analysis and may adjust your payment. Property taxes increase, insurance premiums change, and your escrow payment shifts accordingly. When this happens, update the split in your accounting software to reflect the new amounts going forward.
Set up your chart of accounts with a mortgage payable liability, an escrow asset under current assets, and separate expense accounts for mortgage interest, property tax, and property insurance. Your monthly mortgage statement shows exactly how much goes to each component.
If you’re managing rental properties or own your business building, getting this right matters for tax reporting and for understanding your actual expenses. Many virtual bookkeepers in New Mexico see mortgage payments coded entirely to interest expense or entirely to the loan balance, both of which create problems at tax time.
The split takes a few extra minutes each month but gives you books that actually reflect your financial position. You’ll know your true debt balance, your real interest expense, and whether your escrow balance is running high or low heading into the next analysis.
Santa Fe's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How do I track loads and income by customer?
Set up each broker, shipper, or freight company as a customer in your accounting software and create invoices for each load. Run income by customer reports monthly to see which customers generate the most revenue and which rates are worth your time.
Read answerWhat payroll records do I need to keep?
Keep employee tax forms, time records, pay stubs, and copies of all payroll tax returns. Federal law requires at least four years of retention, but seven years is safer.
Read answerHow do I prepare my books for my CPA?
Start by reconciling all bank and credit card accounts through year end. Then clear up any uncategorized transactions, document major purchases, and organize supporting records like receipts and contracts your CPA might need.
Read answerDo I need a bookkeeper who understands construction accounting?
If you're running multiple projects, using subcontractors, or billing based on milestones, then yes. A general bookkeeper will produce books that are technically accurate but won't show you which jobs actually make money.
Read answerHow do I handle progress billing for construction projects?
Set up billing milestones tied to project phases or completion percentages in your contract. Invoice as each milestone is reached, track retainage separately, and record everything in your accounting system so you know exactly where each project stands financially.
Read answerWhat bookkeeping mistakes do landlords commonly make?
Landlords often commingle personal and rental funds, fail to track income and expenses by property, and misclassify repairs versus capital improvements. Security deposit handling and depreciation tracking also trip up many property owners.
Read answer



