Is investor ops usually handled in QuickBooks or something else?

Question

Quick question for the private lenders in here:

When you're managing investor capital (deposits, withdrawals, interest calculations, statements), are you typically handling that in QuickBooks? Or is that a separate system entirely?

I'm trying to understand the typical tech stack for a small lending office that has, say, 20-100 investors in a pooled fund.

What I'm hearing so far:

- QuickBooks for business accounting (expenses, taxes, etc.)

- Excel for investor tracking and interest calculations

- Separate system for loan servicing

Is that the standard setup? Or are people doing it differently?

Markus Shobe · Answer

You pretty much nailed it. Most small lending offices are running exactly what you described, and honestly it works until it does not. Excel starts falling apart fast once you get past 20 or 30 investors, especially when everyone has different entry dates and contribution amounts. When that happens most operators bring in a dedicated investor portal like Juniper Square or InvestNext to handle statements and distributions, and those connect to QuickBooks so you are not doing double entry. The loan servicing piece is almost always its own separate system and that is totally fine. The real question is how much time you are spending manually reconciling everything, because that is usually what pushes people to finally upgrade.

Chris Seveney · Answer

The answer is, it depends. If the investors are just getting a straight return and have no upside in the deal, then it could be done in QuickBooks. If there is some type of waterfall structure or other means, you could use Excel or other software such as app folio investor management, investnext, juniper square, and a host of other fund administrative platforms.

Jay Toluganti · Answer

Following

Is investor ops usually handled in QuickBooks or something else?

Is investor ops usually handled in QuickBooks or something else?

Most Popular Reply

4 Replies