11 results found
-
Inception to Date Report with Fund Balances
It would be beneficial to be able to create a report (similar to that of the audit report) that shows a funds beginning balance, the change in the fund balance for the time period (donations, grants, expenses, investment earnings, etc). ending balance. The key here would be for it to be just 1 report with 1 fund showing all of the years that the fund has existed or at least data is in CSuite. This is possible with the audit report but only for 1 year at a time. A year over year income statement gets the year over year…
45 votesFinancials: Added an Inception Report for funds. This will be a new left hand menu option in Financials, Inception Report. This report is similar to the audit report, but it will calculate from the first general ledger transaction to an selected end date. There will not be a beginning balance column since, all funds start with a zero dollar balance at inception. This will display closed funds. This report will be allowed for closed periods only. In the raw export, users will see that fund created date
-
Include Fund Custom Fields in "Add Financial Filter".
Please add Custom Fields to the list of filters available for
Financial reporting. We maintain custom fields on funds.44 votes8/7/2024: Financials: Updated Financial reports to allow for Fund Custom Fields as filters. Users will not be able to use custom fields that are nested list and multiselect.
-
Add Fund Open Date and Investment Strategy to Underwater Funds Report
Adding the fund open date and investment strategy fields to the Underwater Funds Report would make this report more useful and informative.
73 votes- 5/7/2024: Summit Idea Lab Live-Financials: Enhanced Financial Reporting to include fund attributes in the raw export. These fields include: fund groups, subgroups, division, segments, agency, with donor, supporting org, DAF, affiliate, investment strategy, investment strategy id, created date, close date, endowed and track spendable.
-
+Add Filter = Investment Strategy to Financials
It would be VERY helpful to be able to Filter on all the Financial reports by Investment Strategy to assist with reviewing fund activity via Trial Balances for special group of funds that do not participate in the pool. It is very easy to book donations, grants and vouchers to incorrect funds.
4 votes3/6/2024: Financials: Added Investment Strategies as an edit option for Balance Sheet and Income Statement Reports.
-
annualized budget percentage on income statement
On the Income Statement budget format, the variance amount and percentage only shows the variance stated in proportion to the current month. My board and I would prefer to see this amount as a percentage of the annualized rather than month to month budget. Can you please add an option for this such as a "budget ann" or "budget ytd"? Selecting the option "this year" will give me the annualized amounts, but there is no way to change the effective date and retain that format as it reverts back to the month over month.
73 votesThe Year over Year column option for an income statement does return accurate data when a site has a Fiscal Year set in System Data.
-
AP Aging report as of a Specific date
Would like an AP Aging report as of a specific date to provide to auditors.
Historical AP doesn't work for this because there are no dates in the AP section.
4 votes9/22/2023: Accounts Payable: Added the Voucher number and Voucher date to the Historical AP report. This will allow clients to more easily reconcile and audit at month or year-end.
-
DAF Payout % Report
There needs to be a report that calculates each Donor Advised Fund's percent payout year over year. With the proposed legislation, it is important for community foundations to be able to show the active philanthropy of their DAFs as well as to encourage more active grantmaking in DAFs that are below a certain threshold.
37 votesFunds: Added a Fund Payout Report. Once a filtered list of fund is selected, this option will be located in left hand menu with bulk actions. Once the Fund Payout Report is selected user will select a calculation date and Payout formula. Grant payout formulas: Candid Method is based on grants made this year divided by assets held at the end of last year. One Year Method is this year’s grants divided by this year’s end-of-year assets plus this year’s grants, on the assumption that all money in a DAF at any point of the fiscal year was available for grantmaking. 3-Year Averaging of Assets to Last Year (LY) is grants this year divided by the average value of assets last year, the year before last, and two years ago. 5-Year Averaging of Assets to Last Year (LY) is grants this year divided by the average value of assets from five year ago to last year. For 2024, this means grants made…
-
Creating a Custom Expense Report
For various events our organization holds we must provide an expense breakdown which we can export from CSuite but it includes unnecessary information that we must remove. Having the ability to create custom expense reports based upon specific accounts and/or campaigns we select would save time and allow the focus to remain on only pertinent data.
8 votesOctober Monthly Release: Financials: Added a new Account Activity report. This will allow clients to create a report based on any accounts from the chart of accounts that they want to display. This report will have the same column options as the income statement
-
Titles on Income Statement
We would love to have the name (title) of the report at the top when viewing and printing and the column titles visible when viewing and printing i.e. Month Over Month May Over June - Year Over Year - 2021 Over 2022. Our investment chair is not happy that we are required to hand write the titles stating "very unprofessional". The titles look identical on all reports.
5 votesReleasing 9.23.2022
-
YOY Income Statement
Fiscal Year Comparison on Income Statement -
Please allow a way to show YOY fiscal comparison on this report. I can go in and edit date, but for calendar only.14 votesChoosing the year over year column option in an income statement will return Year over Year fiscal comparison.
-
Quarter End Balance (QEV)
It would be helpful to have the QEV available for all funds and not just the ones with the spendable coding.
Right now, we are being told to have the QEV show we need to edit the fund and give it the spendable code and distribution type then we need to go to the GL and run "rebuild QEV". It's either this or run multiple quarterly reports.
4 votesFinancials: Added an Audit Balance report to the left hand menu in financials. This report will allow clients to run quarter ending balances based on bank and investment accounts for a time period and by quarter or year. There is also options for fund balances based on total fund balances, principal, and spendable balances displayed by month, quarter, or year based on the date range selected. Fund filters can also be applied to this report. The default view is by quarter, selecting edit options will allow a User to change the time period. This report will only populate quarter ending values for time periods if the month/quarter/year end is closed.
- Don't see your idea?