Skip to content
Two investors reviewing resources on a laptop

Get industry-leading resources — for free

Unlock resources for every investing strategy and stage with a free account.

By continuing, you agree to BiggerPockets LLC's Terms of Use and Privacy Policy

Followed Discussions Followed Categories Followed People Followed Locations
Tax, SDIRAs & Cost Segregation
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

User Stats

79
Posts
118
Votes
Ehab Shoukry
  • Investor
  • Houston, TX
118
Votes |
79
Posts

Entering Mortgage Payments in Quickbooks

Ehab Shoukry
  • Investor
  • Houston, TX
Posted

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

User Stats

1,561
Posts
2,287
Votes
Brandon Hall
  • CPA
  • Raleigh, NC
2,287
Votes |
1,561
Posts
Brandon Hall
  • CPA
  • Raleigh, NC
Replied

@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

Loading replies...