Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Nuts & Bolts: Bookkeeping for Real Estate Investors
Resources
Resource- Depreciation Schedule Worksheet Walkthrough (if you're factoring in depreciation monthly) (11:35)
Resource- Amortization Schedule Worksheet Walkthrough (Loan/Finance Charges) (6:23)
Resource- Recording Opening Balances - Video 1 - Overview (22:05)
Resource- 1031 Exchange: What is it & How do we code it? (17:53)
Resource- Coding Year-End Equity Adjusting Journal Entries (14:18)
Resource- To Capitalize or Not Cheat Sheet for Rental Properties (18:18)
Resource - Real Estate Investing Lingo Cheat Sheet (3:24)
Resource - Seller Finance Notes Receivable Scenario (Land)
Module 1 - Welcome!!!
Welcome & Introduction!!! (3:38)
Course Execution Outline & Timeline (1:57)
What's Unique About Serving Real Estate Investors as a Bookkeeper (15:53)
Real Estate Investing Lingo Cheat Sheet (3:24)
Module 1 Quiz
Module 2 - Common Real Estate Investor Documents
HUD Statements Overview (8:40)
Loan Statements Overview (6:21)
Promissory Note Overview (6:24)
Amortization Schedule Overview (9:14)
Line of Credit Statements Overview (HELOC in this example) (4:37)
Property Management Statements Overview (6:56)
Venmo/Cash App/Paypal/etc Exports Overview (8:22)
AirBnb & VRBO Exports Overview (9:49)
W9 Form Overview (2:57)
Receipts Overview (3:28)
Cost Segregation Study (15:48)
Module 2 Quiz
Module 3 - Setup
Modifying All Settings in QuickBooks Online (11:52)
Coding Flips versus Rentals Introduction (5:45)
Custom REI Chart of Accounts Walkthrough (13:45)
How to Import Custom Real Estate Investing Chart of Accounts into QuickBooks Online (9:32)
Freeing up accounts within the Chart of Accounts (if more accounts are needed) (7:33)
Linking A Bank Account & Credit Card Account to the Bank Feed (10:13)
Creating Rental, Flip, & Wholesale Properties using the Customer Feature (16:09)
Creating Recurring Vendors & Customers (4:45)
How to Create & Delete Businesses, Classes, etc (5:15)
Creating PITI Escrow and Loans by Property Custom Reports (great for reconciling) (6:40)
Depreciation Schedule Worksheet Walkthrough (if you're factoring in depreciation monthly) (11:35)
Amortization Schedule Worksheet Walkthrough (Loan/Finance Charges) (6:23)
Module 3 Quiz
Module 4 - Clean-Up & Monthly Maintenance
Recording Opening Balances - Video 1 - Overview (22:05)
Recording Opening Balances - Video 2 - Form 1040 (Personal Tax Return) (17:45)
Recording Opening Balances - Video 3 - Form 1120S (S Corporation Tax Return) (22:15)
Recording Opening Balances - Video 4 - Form 1065 (Partnership Tax Return) (24:39)
To Capitalize or Not Cheat Sheet for Rental Properties (18:18)
Understanding Earnest Money Deposits & Common Scenarios (9:53)
How to code a Flip property Purchase HUD statement (16:22)
How to code a Flip property Sale HUD statement (14:39)
How to Record the Adjusting Journal Entry after a Flip property has been Sold (11:40)
Coding a Flip Profit "Split" Distribution to a Partner (10:32)
How to code a Rental property Purchase HUD statement (24:11)
How to code a Rental property Refinance HUD statement (21:15)
How to code a Rental property Sale HUD statement (25:20)
How to code a Wholesale (3:55)
Coding a Property Management Owner Statement (including Balances that carry over from month to month) (20:56)
Coding Venmo/Cash App/Paypal/etc Exports (11:36)
Coding AirBnb & VRBO Transactions from Exports (13:41)
Coding Rental Income through bank feed (2:11)
Coding & Splitting a Loan Payment between Principal, Interest, & Escrow (PITI) (9:41)
Coding a Rehab/Construction Draw from a Lender (6:17)
Purpose of "Ask My Accountant" accounts & How to export them (10:16)
How to Record/Review Receipts (4:09)
How to Categorize Travel Costs in Different Scenarios (6:09)
Module 4 Quiz
Module 5: Odd Scenarios Encountered with Real Estate Investors
How to code Two Properties on One Sale HUD statement (22:45)
1031 Exchange: What is it & How do we code it? (17:53)
Seller Finance Notes Receivable Scenario (Land) (23:45)
Property-Type Change: Flip to Rental & Rental to Flip (15:40)
Subject-To Financing: What is it & How do we code it? (11:52)
Splitting a Contractor's Receipt/Bill (3 Common Scenarios) (18:53)
Joint Ventures - Video 1 - What is a Joint Venture in Real Estate Investing? (6:55)
Joint Ventures - Video 2 - Flip Property Joint Venture Scenarios (26:07)
Joint Ventures - Video 3 - Rental Property Joint Venture Scenarios (29:46)
Module 6 - Month-End
Month-End Documents You Need (7:10)
Coding Cash on Hand transactions (7:38)
Coding Month-End Depreciation & Month-End Amortization (13:03)
Coding a Loan (PITI) Escrow Property Insurance and/or Property Taxes payment (Lender-paid) (7:03)
Coding Payroll Statements & Transactions (14:19)
Reclassify Feature Within QBO (6:23)
Reconciling Financial Accounts at Month-End (8:34)
Reconciling Notes Payable & PITI Escrow balance per Property (9:11)
Producing Financial Reports & Saving Custom Reports (5:12)
Producing Financial Reports per Property or Multiple Properties (9:50)
How to read a Real Estate Investor's Statement of Cash Flows (SOCF) (16:30)
How to Calculate Cash on Cash Return on Investment (CoCROI) for a Rental Property in QBO (15:46)
Module 5 Quiz
Module 7 - Year-End
How To Stay Proactive for Tax Season (8:02)
Pulling a 1099 Form List from QuickBooks Online (19:02)
Coding a Cost Segregation Study Results (10:46)
Coding Year-End Equity Adjusting Journal Entries (14:18)
Coding the Tax Professional's Year-End Adjusting Journal Entries (13:05)
Reconcile Property Balance Sheet Accounts to Previous Tax Return (& All Other Balances) (16:25)
Module 6 Quiz
Module 8 - Congratulations & Thank You!!!
Congratulations & Next Steps! (1:20)
Welcome & Introduction!!!
Email change:
[email protected]
Coming June 13, 2025 -> Bookkeeping for REI Community of Communities
Complete and Continue
