Skip to content

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
×
Take Your Forum Experience
to the Next Level
Create a free account and join over 3 million investors sharing
their journeys and helping each other succeed.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
Already a member?  Login here
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...