Hi all, I’m new here, and so far loving it.
I’ve searched the archives and haven’t found this yet - or not exactly.
I make investments in private LLCs (venture capital if you must know, but some are real estate too). I have a wealth manager, but he only tracks his investments, not the ones I personally make, so I’m trying to have a more holistic view of my finances.
Anyway - I’m trying to figure out the best way to track private investments. For clarity, these investments usually do a capital call (I write a check) between 1-4x per year for a certain number of years, and then pray that they return more than I’ve invested. I’d like to be able to see a report of all transactions in and out of that investment vehicle, so that when I get the annual K1, I can confirm what they say is true AND when the whole thing is said and done, I can see how I’ve done on that particular investment.
I was thinking of doing it this way:
- Set up each investment as a manual account, label it as asset/investment.
- Any cash investment is coded as a transfer on both sides of the transaction (with a name the same as the manual account - will that mess it up?).
- Any cash in would be also coded as a transfer, until I start to get close to 1x, and then spilt the transaction when it hits 1x, then anything over that is recorded as income (let’s hear it for long term cap gains).
- Where I’m getting stuck - how can I see all the transactions for that account? Just simply filter the transactions tab by account? It would be cool if there were a tab where I could set the date range, filter by account and see totals for that date range. Does this exist and I just haven’t found it yet?
Am I thinking about this the right way?
Also - I need a class in tiller spreadsheet scripts and formulas. THAT would be awesome, because I don’t mind tinkering around making this stuff on my own but I don’t know where to start. I know my way around basic spreadsheet functions but as soon as we hit vlookups and pivot tables, I am curious but incompetent.