Skip to content

QuickBooks For Real Estate Investors

QuickBooks For Investors America's Only Complete System For Real Estate Investors using Quick Books Pro

  • Home
  • JOIN NOW!
  • Investor Books Pro
  • Workshop Videos
  • Support
  • Log In

Category: HOW TO VIDEOS

Escrowed Funds Refund Overpayment on Reserves Held by Lender

Posted on November 24, 2019June 11, 2024 By Mike Butler

QUESTION from Jared:

Hi Mike,

I am absolutely loving the videos and system you have created with Investor Book’s Pro.  I successfully have caught up my 2019 books using the system and am using my “rainy weekends” as you mention in the Quick Start videos to fill in previous years (to determine the cost basis of my properties.. and I’m super analytical and want my numbers to match).  I’m making my way back to 2016 and almost have everything wrapped up.    

For one of my properties I purchased subject to the existing mortgage, the mortgage company escrows taxes and insurance.  I cancelled the seller’s insurance and purchased my own at the time of closing.  A month after I purchased the property, a disbursement went out of the escrow account to my insurance company.  A few days later, the seller’s previous insurance company sent the refunded insurance money to the mortgage company.  The mortgage company added the funds to the escrow balance.

I’m not sure where what account to choose in the Escrow register since it wasn’t originally my funds.  Initially I thought I would put it in the fixed asset for the property but the money doesn’t go to benefit the property but rather it is sitting in the escrow account.  Any advice on how to best enter this?  One other way I thought to do is add the refund to the starting escrow balance and call it good.  The numbers would work and it wouldn’t impact any of my company financials.

Jared

Please login to view more of this post

HOW TO VIDEOS, INVESTOR BOOKS, Escrow Accounts

ARMs – Adjustable Rate Mortgages from A to Z

Posted on October 30, 2019June 11, 2024 By Mike Butler

18 min video

Please login to view more of this post

HOW TO VIDEOS, INVESTOR BOOKS, ARMs Adjustable Rate Mortgages

How to Enter Cash Purchase Using a Silent Private Lender

Posted on August 6, 2019June 11, 2024 By Mike Butler

QUESTION from Stacey:
 
Hi Mike,
 
I’ve watched every video that I have access to, but I am still unclear on how to put in my private loan balances. 
 
For example, I purchased a property last year. 

I borrowed money from a private lender, put that in my account and then paid cash at closing. 
 
I entered the closing statement as a check.
 
Where do I enter the $50,000 loan I’m paying on every month? (I memorized a check I can send every month, but I don’t know where to put the balance of the loan.)
 
If I could have help with one of these properties, 
then I am hopeful  I could input the rest of them correctly. 
 
Please advise! Thanks!
 
Stacey

Please login to view more of this post

HOW TO VIDEOS, INVESTOR BOOKS, Borrow Money, Closing Statements, Memorized Transactions, Buying

QuickBooks Tax Time Documents – How To Go 100% Paperless as You Receive Important Tax Documents

Posted on January 10, 2019June 11, 2024 By wizard

QuickBooks Tax Time Documents

How To Go 100% Paperless as You Receive Important Tax Documents
then simply email your QuickBooks Pro file to your CPA.

 The Only Complete System for Real Estate using QuickBooks Pro

49 min video

Please login to view more of this post

HOW TO VIDEOS, YEAR END STUFF TO DO, Year End

How to Create Print Monthly Statements

Posted on August 13, 2018June 11, 2024 By wizard

How to Create – Print or Email Statements to Your Tenants or Loan Customers

  1. Make sure Your Printer is SET UP Properly for Statements
  2. CLICK On Create Statements SPEED BUTTON
  3. Select the Proper Date Range
  4. Select WHO will get your STATEMENTS
  5. From the DROP DOWN LIST, Select MONTHLY STATEMENTS
  6. UNCHECK the Box PRINT DUE DATE
  7. ALWAYS Click PRINT PREVIEW Before clicking Print

2 minute video

Please login to view more of this post

HOW TO VIDEOS, TENANT TRACKING, Existing Tenants, Statements

How To Handle Two or More Tax Returns in Your Investor Books Pro Company File (Multiple Entities)

Posted on August 14, 2017June 11, 2024 By Mike Butler

29 minute video shows you step by step

Please login to view more of this post

HOW TO VIDEOS, INVESTOR BOOKS, Multiple Entities

How to Properly Enter Buying Real Estate with Seller Financing

Posted on August 4, 2017June 11, 2024 By Mike Butler

19 min video

Please login to view more of this post

HOW TO VIDEOS, INVESTOR BOOKS, Borrow Money, Buying

Earnest Money Paid To You When Selling a Property

Posted on June 24, 2017June 11, 2024 By Mike Butler

How to Properly Enter
a $2,000 Earnest Money Check Paid to You

If You are a Licensed Real Estate Agent, You will deposit it into your Broker’s Escrow Account

QUESTION from Chuck: 

Hey Mike,

I am doing a wholesale deal. I will be doing a double close on it.
I received a $2,000 non-refundable deposit (EM but paid directly to me).

How do I enter a transaction like this. I tried to look it up on the videos but the link is broken. Thanks for the help

I tried to look it up on the videos but could not find this one.

Thanks for the help
Chuck C

Please login to view more of this post

HOW TO VIDEOS, INVESTOR BOOKS, Closing Statements, Earnest Money, Escrow Accounts, Selling

Refinance including Cash Out ReFi’s

Posted on March 17, 2017June 11, 2024 By Mike Butler

18 min video

Please login to view more of this post

HOW TO VIDEOS, INVESTOR BOOKS, Borrow Money, ReFinance

How To Remove DUE DATE when Creating Statements in Tenant Tracking

Posted on February 21, 2017June 11, 2024 By wizard

Question from Marietta Grimes:

Mike, when I am creating statements, a DUE DATE appears in the description area on every statement charge. How Do I Remove This?  

Thanks
Marietta

Please login to view more of this post

HOW TO VIDEOS, TENANT TRACKING, Existing Tenants, Statements

Posts pagination

Previous 1 2 3 … 6 Next

Library

  • GETTING STARTED (3)
    • Why 2 Company Files (1)
    • What is Investor Books Pro? (1)
    • What is Tenant Tracking? (1)
  • REGISTERED USERS ONLY (14)
    • STEP 1 – "Post Office Method" Accounting Training (1)
    • STEP 2 – Investor Books Pro System (1)
    • STEP 3 – Fast Start Guide (2)
    • STEP 4 – Setting Auto BackUps (2)
    • STEP 5 – Multiple Users (1)
    • STEP 6 – Multiple Entities Partnership (1)
    • STEP 7 – Entering Old Transactions (2)
    • STEP 8 – Speed Buttons (2)
  • HOW TO VIDEOS (54)
  • INVESTOR BOOKS (60)
    • Auto-Billing (1)
    • Bad Checks (1)
    • Borrow Money (7)
    • Capitalized (3)
    • Closing Statements (17)
      • ARMs Adjustable Rate Mortgages (1)
      • Buying (9)
      • Selling (6)
      • ReFinance (1)
      • 1031 Tax Deferred Exchange (1)
    • Depreciation (1)
    • Earnest Money (1)
    • Escrow Accounts (7)
    • Flips (2)
    • Invoices (2)
    • Loan Money (2)
    • Memorized Transactions (3)
    • Multiple Entities (4)
    • Option To Buy (1)
    • Property Taxes (1)
    • Rehab (1)
    • Repairs (4)
    • Tax Updates (9)
    • Troubleshoot (8)
    • Vendors (1)
  • TENANT TRACKING (24)
    • Getting Started (4)
    • New Tenants (6)
      • Section 8 (2)
    • Existing Tenants (12)
      • Work Orders (3)
      • Statements (2)
      • Late Charges (4)
      • Move Out (4)
      • Discounts (1)
    • Collections (1)
    • Auto-Billing (1)
    • QB Upgrade (1)
  • OTHERS (5)
    • Free (2)
    • Tools (2)
    • Reviews (1)
  • YEAR END STUFF TO DO (9)
    • Year End (7)
  • UPDATES (1)

Search By Topic

Balance Sheet buying Buying RE Buy Real Estate with Loan Capitalized Expenses Cash Expenses Cash From Me Closing Statement Buying Computer Crash Daily Late Charges Depreciation Escrow Accounts escrow analysis Escrow Refunds escrows Getting Started How To Enter HUD 1 INVESTOR BOOKS Investor Books Pro landlording Loan Customers mike grinnan cpa Multiple Entities New Computer New Tenant Notes Paying Bills Post Office Accounting property management Purchase Real Estate quickbooks QuickBooks Basics quickbooks for real estate quickbooks pro for real estate repairs Reports Resident Rewards Retrieving Data selling statements Tax Time tax update TENANT TRACKING Tenant Turnovers wholesale
Saturday, 1:32 pm EST
May 17, 2025

Got a Question? CLICK HERE
QuickBooks
5 Hour Workshop

forOnly $19

24-7 access Zoom Video Recordings from Workshop
includes WorkBook Study Guide and Q&A

includes
-WorkBook Study Guide
-30 day access to Video Recording

FREE for Registered Users
FREE for Platinum Members

FREE Investor Training

30 min Expert Review

Got a Question? CLICK HERE

Copyright since MMII Wealth Building 24-7 LLC 2022 | www.QuickBooksForInvestors.com | All Rights Reserved.
Disclaimer | Terms of Use | Privacy Policy