Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime
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

Updated over 9 years ago on . Most recent reply presented by

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,286
Votes
Brandon Hall
  • CPA
  • Raleigh, NC
2,286
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...