General Real Estate Investing

User Stats

13
Posts
8
Votes
Adrian Clapp
8
Votes |
13
Posts

RE Syndication Investor Tracking Software for LPs?

Adrian Clapp
Posted Jan 27 2022, 13:11

Hi.  In 2021 I invested in 15 different RE Syndications and was wondering how LP investors keep track of quarterly distributions and other performance metrics vs. what was originally presented in the original pro forma or updates.  Right now I am using a large excel spreadsheet but I was thinking someone must have developed a better system?  Thanks!

User Stats

26
Posts
4
Votes
Drew T Heberer
  • New to Real Estate
  • Davenport, IA
4
Votes |
26
Posts
Drew T Heberer
  • New to Real Estate
  • Davenport, IA
Replied Jan 27 2022, 13:31

Hey Adrian,

We currently use Excel as well. But, we've been considering buying a tool or having one created for us. I'm interested to see what kind of feedback you get here! Best of luck and if nothing else, maybe we can work together to develop something!

User Stats

13
Posts
8
Votes
Adrian Clapp
8
Votes |
13
Posts
Adrian Clapp
Replied Jan 27 2022, 13:55
Hi Drew, I was unable to find anything that would work from the LP investor side of things.  Hopefully someone has figured something out otherwise I'd love to team up!  Thanks!

User Stats

26
Posts
4
Votes
Drew T Heberer
  • New to Real Estate
  • Davenport, IA
4
Votes |
26
Posts
Drew T Heberer
  • New to Real Estate
  • Davenport, IA
Replied Jan 28 2022, 06:39

@Adrian Clapp,

I have never looked into it until now and wasn't able to directly find anything either. I'll send you a connection and we can brainstorm ideas and I can reach out to my tech friends to see if they know of anything or if they would be willing to collaborate and create something that can track the projections vs actuals in a nice, clean, consistent way.

User Stats

1,005
Posts
588
Votes
Brock Mogensen
  • Real Estate Syndicator
  • Milwaukee, WI
588
Votes |
1,005
Posts
Brock Mogensen
  • Real Estate Syndicator
  • Milwaukee, WI
Replied Jan 28 2022, 07:51

Most syndicators use an investor portal software.  The one we use will show LP's the actual vs proforma stats in a dashboard.  If they don't have that built into their portal, they should at least be outlining it in the quarterly reporting.  The hard part is if you are investing with several different operators the odds that they are all using the same investor portal software is pretty low. In that case your best bet is to just create your own spreadsheet to track it..

User Stats

13
Posts
8
Votes
Adrian Clapp
8
Votes |
13
Posts
Adrian Clapp
Replied Jan 28 2022, 10:16

Hi Brock, Thanks for sharing your thoughts. I've spread my initial investments in 2021 over about twelve different syndicators that all report and distribute on different timeframes so far so I was hoping to find a more elegant solution than my current spreadsheet system that is getting a bit unweildy.

User Stats

235
Posts
218
Votes
Zachary Inman
  • Specialist
  • Indianapolis, IN
218
Votes |
235
Posts
Zachary Inman
  • Specialist
  • Indianapolis, IN
Replied Feb 3 2022, 13:20

Hi @Adrian Clapp. I bet your excel sheet looks monstrous while keeping track of 15 different investments! I've seen LPs get very creative with their tracking. The most interesting I've seen is an LP who drops her monthly bank statement data into an excel sheet that automatically categorizes each distribution. 

User Stats

13
Posts
8
Votes
Adrian Clapp
8
Votes |
13
Posts
Adrian Clapp
Replied Feb 3 2022, 13:28

The spreadsheet with 15 investments would be fine if I were not planning on adding any additional investments in 2022 and beyond. I might need to start a separate tab for each year and then have a summary tab that ties it all together.  Unless someone has a different solution.