Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
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

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