If you’re a real estate investor learning for the easiest way to keep track of all the real estate bookkeeping and accounting for your rental properties, LLCs and investing activities then you’ve found the right place.
Class Recording:
Bookkeeping and Accounting for Real Estate Investors
In this special real estate seminar recording, Brian walks you through how to get your entire real estate investing business organized and how to quickly and easily keep the books for your real estate investing business using the bookkeeping spreadsheet.
Real Estate Bookkeeping Spreadsheet Download
To access the real estate bookkeeping spreadsheet Brian is teaching in the classes above, use the big blue button below to download it and then open it using Microsoft Excel.
It will allow you to enter in each property and/or LLC to keep track of income and expenses for each one. Create a copy of the spreadsheet for each new year.
Then, see a year of income and expenses for all properties and entities as shown above in one easy to read report.
Or, see the an itemized list for each property (not shown).
You can also see a summary of the total income, expense, profit (yearly and monthly) as well as profit % and actual cash on cash return on investment for each property. Plus much more.
See an itemized break-out of each income and expense category for your each property in your portfolio as shown above. Copy and paste this into an email for your tax preparer or reference it for yourself as you do your own taxes.
Or, see a summary of all itemized income and expenses by category for all properties and entities combined in one quick report (shown above).
Watch the video of the real estate seminar recording above to have Brian teach you how to use this spreadsheet and download the real estate bookkeeping spreadsheet using the link below.
Download Bookkeeping Spreadsheet
IMPORTANT NOTE: The spreadsheet is available in Microsoft Excel format (.xlsx).
Deal Analysis Spreadsheet
If you arrived here thinking you were going to download the real estate deal analysis spreadsheet, you’re off by just one page. Visit the The World’s Greatest Real Estate Deal Analysis Spreadsheet™ instead to download that.
More Powerful Than A Deal Analysis Spreadsheet:
The Real Estate Financial Planner™
If you want to go beyond simple deal analysis and begin to analyze your entire portfolio and investment strategy including real estate as well as stocks, bonds and other investments then there is nothing more powerful than the Real Estate Financial Planner™ software for that.
Other Class Topics
Interested in learning about other real estate investing topics, check out classes organized into the following topics.
Love this bookkeeping spreadsheet! Thanks for sharing! Is there any chance you can share the pw so I can utilize it fully? TIA
Thanks Steven. Glad you’re enjoying Brian’s bookkeeping spreadsheet. You’re welcome. You should be able to utilize it fully already since the password is not required in any way to use it. Was there something in particular that was wrong that you needed me to tell Brian about? To specifically address the password to be able to modify the spreadsheet… we lock it down so that non-expert Excel users don’t accidentally change/alter the formulas. Expert Excel users already know how to circumvent the password and so don’t even need the password at all to modify it. Let me know if there was something in particular that needs addressing.
Hi James,
For me, the password is needed to expand the Columns on the Property report tab so that the larger totals can be viewed rather than “####”.
Thanks!
Hi Samantha… you won’t need the password for that. Just drag the edge of the column over or double click on it to expand it. No password needed. Enjoy!
Hi
I just came across your website looking for a bookkeeping spreadsheet for real estate investing. I really enjoy the spreadsheet you created and watched the video presentation on how to utilize that spreadsheet. I was curious regarding expenses, where would you record expenses for fee-based items such as a dropbox account or Microsoft office. If there isn’t a specific category, can I add one in the drop-down lists and have it imported into the property. I believe I need a password to access this Excel sheet to make that modification if that is the case. I also would like to possibly import a feature to create a pie chart on the property tab, so having access would be great for this spreadsheet.
Thanks Gary. Glad you’re liking the spreadsheet Brian made. For Dropbox and Office, I’d personally put that in Supplies. Thanks!
Hey I like the way the spreadsheet is setup but I’m having trouble on how to use it with out the protected password.
Thanks Najee. The spreadsheet is completely usable without a password. Do you have a specific question? Did you watch the video?