Tax, SDIRAs & Cost Segregation
Market News & Data
General Info
Real Estate Strategies

Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal


Real Estate Classifieds
Reviews & Feedback
Updated over 9 years ago on . Most recent reply

Entering Mortgage Payments in Quickbooks
Hi all -
I recently hired a bookkeeper to setup Quickbooks for me for my rental business. She entered 8 months of transactions for me and told me that for mortgage payments, she created a category of "Unallocated mortgage payments." The reason for this is that it becomes a hassle to properly allocate the PITI portions that come in every month with a mortgage payments.
However, she did mention at the end of the year when I get my mortgage interest statement that I would have to reconcile this. I'm wondering if this is how others are handling this and how that reconciliation works?
Right now all of my mortgage payments for all of my home loans are going into this one category.
Thanks,
Ehab
Most Popular Reply

@Ehab Shoukry I create amortization tables for my clients (if they don't provide them) and record their mortgage and escrow payments each month. I considered the annual reconciliation but find it's too much of a hassle, especially if it takes me a minute or so to copy the previous month's transaction, update principle and interest, and save the new transaction.
It kind of sounds like the bookkeeper is a cheaper one and just trying to save time.
Journal entry:
Debit: Principle (reduces notes payable)
Debit: Interest Expense
Debit: Lender Reserves (escrow)
Credit: Mortgage payment