Google Sheets continues to impress me! When I first discovered Google Sheets ~10 years ago, I thought "Really convenient...but it can't do much". Ever since then, Google has continuously improved its product to create a powerful analytics engine.
In this video I demonstrate the immense power of "Slicer" to visualize and filter your data set!
(NOTE - I make mention of a supplemental video on exporting data from QBO into Google Sheets....check that video out here: External Reporting)
Check out Stratafolio here!
Real-time, accurate data is essential to making pro-active decisions for your real estate investing business. If you're really looking to scale, QBO alone isn't enough! Stratafolio adds real-time financial analytics as well as Loan Mgmt, Operations Mgmt and Investor Mgmt...all in one easy-to-use platform.
In this video, I'm joined by Stratafolio Co-founder, Jeri Frank. Jeri demos her super powerful (and I must say, beautiful) Stratafolio platform to show us how we can have all our crucial investment data right at our fingertips.
I hope you enjoy as much as I did! I urge you to visit the Stratafolio site...you can schedule your very own, personal demo! Also, feel free to comment on any questions regarding the product. Jeri and I will be quick to respond!
QBO is invaluable when it comes to prepping for taxes. But what are those weird "Unapplied Cash Payments" all about? In this video, I shed some light on these elusive accounts to help you understand why they occur and how to deal with them.
In direct response to an audience question (thanks Andy from TX!), here’s a step by step guide for setting up Quickbooks Online to track your rehabs. Learn how to set up your Chart of Accounts, utilize “Projects” and ultimately track your construction expenses!
Perhaps the most crucial role of any property manager is corresponding with and collecting rent from tenants. Quickbooks Online has amazing accounts receivable functionality built right in! In this video, I'll show you how I use QBO to track my tenant rent balances, add late fees and send reminders.
Update: Audio has been fixed. Enjoy watching!
Reduce time preparing your taxes...set up your chart of accounts to map directly to your IRS forms! Check out this demo where I show you how to establish your COA for Rental Property Management!
Year end accounting can be a real nightmare...am I right!? In this video I show you how to make Year End journal entries to make sure your capital improvements are accounted for in the right way. This video follows up on the concepts discussed in Real Estate Accounting - Tracking Rehab Expenses (Part 1), where I introduced the concept of using Products and Services to track your rehab expenses in greater detail.
Enjoy...and please let me know what else you'd like to see me do in Quickbooks Online!