Is internal reporting at most funds really so Excel & PPT heavy still?
Hi there,
I spent some time at a BB before moving into Big Tech. Did a variety of data roles, with my last 4 years running a Finance team (FP&A and Sales Finance). In Big Tech, we used a ton of SQL and other automation so that slides & reports on operational performance were fully automated. This is not rocket science, but scales really well.
I moved to a PE to be head of data there this year, and my mind is blown how manual and old-school the reporting is. I understand that DD on a deal is ad-hoc, but quarterly portfolio updates and the data for LP reporting is just a shitload of Excel, PPT and willpower by the employees. You can build a setup once (takes a few hundred hours altogether) for a fund where repetitive reporting is 90%+ less shitty.
Is this really the norm in the industry?
Yes.
Tbh we’ve tried to automate these processes over and over and every time we try some new high tech solution the outputs are riddled with errors. Cross checking them ends up taking the same amount of time as just doing it manually.
It's analogous to asking a summer analyst to spread comps... you're still going to end up doing it anyway
I hear that the out-of-the-box packages blow, just like you can’t buy an excel template and be done with it.
My point is that data eng + sheets works for companies at 200bn+ in rev; you can automate quarterly portfolio slides or at least 90% and tidy with sheets.
Every solution we've tried to implement for this has ended up taking more time than it saved in data input and checking. There's no standard across portcos in how they report / send us data plus each quarter there's typically a myriad of PFs and adjustments to make. Add to that most PE associates are using excel/PPT every day and are pretty efficient / comfortable with them it's difficult to switch.
Also some software(s) like iLevel used at funds that port cos upload financials to and are aggregated for the firm to view
iLevel and Dynamo are an ok starting point, but checking & transforming the data to then get it into sheets and slides still is 80% of the job after. In bigtech it’s code, vs software, that does a lot of that work and then sheets + slides. Just surprised because I know how this stuff can work, but funds don’t do it.
I moved last year*, and some of the stuff I built has already automated 50-70% of portfolio reporting crap away.
If anything is curious, drop me a PM.
I heard Oakley Capital were hiring a Portfolio Associate c.6M ago to do this exact job - just checked their website as doesn't look like they've made the hire so may have pulled out of this strategy too
Aspernatur sint dolores iusto voluptate id asperiores quam. Culpa voluptas sit eos quia corporis quia maiores minima. Perspiciatis assumenda blanditiis id ut. Quia eos et et ad. Suscipit culpa quis pariatur quis dolor voluptatem. Accusantium ut est quo tenetur ea magni ipsum.
Quis commodi sunt omnis exercitationem fugiat. Nam et facere quam eveniet qui consequatur. Voluptas voluptatum qui earum sequi est. Velit sit similique eos voluptates. Quia aut perspiciatis velit molestias sit suscipit beatae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...