Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime
×
Take Your Forum Experience
to the Next Level
Create a free account and join over 3 million investors sharing
their journeys and helping each other succeed.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
Already a member?  Login here
Starting Out
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 almost 9 years ago on . Most recent reply

User Stats

3
Posts
0
Votes
Keith Aul
  • Fox River Grove, IL
0
Votes |
3
Posts

Tracking Your Transactions

Keith Aul
  • Fox River Grove, IL
Posted

I'm not too sure if I'm posting this question in the right forum.  So if this is not the right place just let me know where to post it. 

I don't know if anyone is using Microsoft Excel  but I was wondering what investors are using to track their transactions?

Everyone buys and sells multiple properties and  during the process they have to be able to track  they're spending their expenses, what location, etc.

Are you using Microsoft Excel to track your transactions or any other part of your business? If so I was wondering if someone was willing to provide a template for me to start with so I don't have to reinvent the wheel?

Thank you in advance 

Keith

Most Popular Reply

User Stats

567
Posts
459
Votes
Rich O'Neill
  • Contractor
  • Chadds Ford, PA
459
Votes |
567
Posts
Rich O'Neill
  • Contractor
  • Chadds Ford, PA
Replied

Hi @Keith Aul welcome to the site! I use Excel to keep track of my transactions for my buy and hold properties. It will depend on your intention with the properties on what columns to put in. I actually put my tracking sheet in the same workbook as my goal sheet and my forecasting sheet because they are all linked. My columns are as follows: 

  1. Property # (chronological)
  2. Address
  3. # of Units
  4. Purchase Price
  5. Down Payment
  6. Renovation cost
  7. Note Rate
  8. Closing Date
  9. Cumulative Principal paid (formula driven)
  10. Monthly Rent
  11. Monthly Cash Flow (expected)
  12. Recent Appraisal
  13. Appreciation (Recent appraisal - Purchase)
  14. Appreciation % (formula)
  15. Equity
  16. Equity %
  17. Notes

I also put some formulas along the top that give me totals. I am sure this is not complete and may be different for you but this has worked for me so far. 

Loading replies...