Tracking Your Transactions

[Keith Aul]

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

[Rich O'Neill]

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.