Distribution Calculation Base Proposal
Bank and Investment Balance (excludes pledges receivable)
Less Grants Payable (dollars already committed & likely held in checking)
Less Spendable Fund Balance (remaining dollars to be spent)
I tried to set this up using the "By Account" setting with the Endowment and Default Fund Balance accounts. Belatedly I discovered that the "Default" retained earnings were only included in the 4th quarter of each FY. This is explained in the online documentation Distributions/Set Up Types in the light blue section. Was it there when I set up Distribution Types 2 years ago? Maybe.
We could use the "Total Net Assets" setting to get most of what we want. That would exclude Grants Payable, but include Pledges Receivable (not a common issue) and the remaining Spendable Fund Balances. We would prefer to not allow additional distributions based on $ amounts that have already been added to the Spendable Fund Balance.