Best Of

This is something I've been wanting to investigate further, as I'm not happy with some of our grouping but I think it was set up this way in FIMS and I've been in my role for a year and a half and haven't changed anything yet. But we have ours set up as follows:

Group - typically the type of fund (DAF, designated, FOI, scholarship) but is further split out in some respects (donor or org founded for designated and scholarship funds, endowed vs nonendowed for DAFs).

Subgroups - this is where I struggle, as it appears the subgroups are a mixture of asset types that we now ultimately track through investment strategies in CSuite (Community Foundation Pools is our most common, but we do also have outside managed investments as well as subgroups for individual complex assets like annuities, trusts, etc). We also track fiscal sponsorship/project funds in subgroup as well. Ultimately, some funds could fall into multiple subgroups, which is why I don't like our setup.

Division - used to group funds by whether they are part of one of our geographical affiliates, our supporting org (gifts/maintenance of property), or our main org. I don't like this because if I want to run a 1099 or 990 report in CSuite, I can only pick all or none for the divisions (i.e. not a checkbox) so I can't always use it.

Segment - used for scholarship funds only to track how the scholarship is awarded (school directly, foundation-managed, etc). I don't like this one either, but I'm told nobody else had a use for it at the time so the scholarship team decided to use it.