Hi again Kelly,
I'm happy to see all of the feedback you have received! I'm encouraged by your willingness to jump into this without the conventional accounting/law background by the way :). I was interested in circling back one more time to your original reply:
Yes, for these dynamic calculations (capital infusions/draws, etc.), it may be in your best interest to set up the waterfall tranches in Microsoft Excel. You will be in good company, as many institutional investment companies in real estate portfolio management still perform these kinds of calculations in Excel. And if you are maintaining the income statement in Quickbooks, you will be able to "close out" net income to current year retained earnings once per year, or more often if you prefer (in other words - move net income from the income statement to the balance sheet).
I do have a general question for you: are your partners subscribing to the fund, or LP, via a Private Placement Memorandum, and/or do you have an LPA (limited partnership agreement)?
Please feel free to send me a PM or reply here if you prefer. The setup of this on an informational level in Quickbooks can be made simple. We just need to ensure the income statement is structured to work in tandem with the balance sheet, not completely separately. A wise man used to ask me, "does your balance sheet balance?" ;)
Thank you!
All the best,
Daniel Reyes