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. 

[Keith Aul]

Hello @Rich O'Neill

Thanks for your response. Your information is helpful.  I was wondering if you would be willing to share the workbook by posting a link to a shareable site where I could download it? Of course I'm not asking you include your personal transactions, just an empty workbook, but leave the columns and formulas in for all the sheets - tracking, goal sheet and forecasting sheet. 

Then I could modify it for my needs. If you're not willing to do that, could you share what the formulas are and what the columns are in the other sheets?

Again thank you very much for the response you gave me.

Keith

[Rich O'Neill]

@Keith Aul I also just remembered biggerpockets has one at biggerpockets.com/portfolio

Here is my file that I pulled the info out of. I think in the process of deleting info it messed up some formulas which I tried my best to correct but may have missed some. Hope this helps! 

https://www.biggerpockets.com/files/user/Oneillra/file/goal-tracking-and-forecasting

[Keith Aul]

Thank you again Rich. I got the file

Keith