17 results found
-
Admin Fee Report in Funds
When running an admin fee report within a fund, it only includes fees that were charged in the quarterly process or done manually. It does not include transactional admin fees charged for each donation, grant, etc. in this report. This can make it difficult to get a complete picture of the fees charged to a fund. It would be ideal if this report included ALL admin fees charged to the fund. Thanks!
16 votes -
Archive Old Admin Fee Schedules
Please make it possible to archive old and unused admin fee types. This has been proposed many times and it keeps getting closed because it's already been implemented, which is incorrect.
The only way to get rid of an admin fee type is if it's never been applied to a fund or used. This is the error message you get when you try to delete one: This fee type was used in 2 admin fee calculations and cannot be deleted.
A clean list makes it easier to process admin fees and would also help when setting up new funds -…3 votes -
spendable internal grant gl account edits
For spendable internal grants, have the ability to edit the gl revenue account instead of posting to the default. The gl expense account can be edited, but not the revenue gl account.
9 votes -
Distribution Rounding
It would be helpful if we could select more rounding options for distributions, particularly a $500 round. A $250 round might also be beneficial.
2 votes -
Do Not Allow Admin Fee to make a Fund Balance Negative
Admin Fees should not make a fund balance negative. The situation we recently had was that a fund was set for closure, the final grant had been made and the balance was $0. However, the fund had not yet officially been closed in Csuite (we wait for the final check to clear.) Quarterly Admin Fees were posted which included this fund. It then made the fund balance negative. It seems an alert should pop that there are not sufficient balance to cover the fee. .....and yes, ideally we should remove the admin fee type on a fund when it is…
25 votes -
Minimum Yearly Fee
We would like to able to assess a yearly minimum fee that is not at the end of the calendar year but at the end of Q2. If we could adjust the dates for minimum fees that would be very helpful for our process.
1 vote -
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…
3 votes -
Fund Fee transaction export
After posting fund fees, please allow for an export of the transaction detail. Currently once can only copy the detail and paste into excel in order to then be able to sort and analyze the data for volume of income from different fund types - an important part of my analysis, as I want to see how much partially-endowed funds are providing in comparison to fully endowed & non-endowed funds, as it's the most popular segment but the most active & unpredictable in terms of contributions and granting. Have an export will help immensely.
1 vote -
Distributions - do not create transactions on $0.00 calculated amounts
We round the distribution calculation the the $1.00 (rounding behavior: Normal). When an amount of.49 cents or less is calculated a transaction posts to the fund for $0.00. I know there is the option to uncheck the distribution calculation in the preview stage but we have over 1,600 funds to comb through and we have many agency funds with minimal fund balances that we keep open upon agency request.
4 votes -
Spendable distributions scheduling
The ability to schedule when spendable grants are to be made would be very helpful. We currently maintain a spreadsheet that lists funds, grantees, and timing of grants to know when to go "grant spendable" each year. Being able to set the date to be granted on the beneficiary would be most helpful. I'm thinking something along the lines of the recurring grants process.
19 votes -
Admin Fees: choose more than one donation type for an Admin Fee
It would be great to be able to choose more than one donation type to charge an Admin Fee to. I have an Admin Fee for 2.5% on each donation that comes into the fund. But it does not pick up internal donations or stock donations. I had to add two more Admin Fee Types to get this done, rather than being able to choose all three from a drop down list.
22 votes -
Admin Fees: We'd like to be able to add fees as an option to each donation, promise, pledge
Not all donations going to a particular fund have the same fee associated so we aren't able to set an admin fee to the fund. We'd like the ability to set fees on each donation, pledge, or promise we receive.
1 voteThere is a current option to create an admin fee type per each donation. Here is a link to the support article to help with Admin Fee options: https://support.foundant.com/hc/en-us/articles/11911006062615-Admin-Fees-Overview
-
Admin Fee Edit
It would be very helpful to be able to edit the calculated admin fees prior to posting. Similar to how distributions/spending calculations can be edited prior to posting.
33 votes -
set distribution amount
For those funds that specify a dollar distribution (ex: $6,000/year), it would be nice to have the ability to create and apply that distribution type. I understand it can be modified during review but could be easily missed, particularly by newer staff. If there's a good work around I'd appreciate suggestions.
19 votes -
Admin Fee Report/Audit Support
When generating the admin fees, I would like to see the total calculation that the fee is being processed on. It shows in a description box but not in a column on it's own (nor does it show the total). Would be very helpful to make sure fees are calculating on portfolio balances accurately. This was something that FIMS included on their admin fee report, it showed both the full portfolio balance along with the fee column.
28 votes -
Distribution Audit Details - Make available prior to posting
It would be highly beneficial for the Audit Details export information to be available prior to posting distributions. Without posting distributions first, the quarter ending values used to calculate distributions are not available. This makes it difficult to compare year over year data to ensure accuracy. Having the quarter ending values used in the distribution calculations prior to posting distributions would negate the need to run all distributions in Sandbox first. We discovered 2 errors in cSuite calculations due to posting in the sandbox where cSuite was not calculating QEV correctly. Access to these values first is paramount to quality…
13 votes -
Spendable amounts - rather than running a report, can an area in the fund be created to capture the yearly spendable?
Once a grant has been distributed, the spendable is reduced. We would love a quick visual that gives us a link to the full annual spendable by year for the fund(s).
15 votes
- Don't see your idea?