21 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
-
Income Statement column options
I would love the ability to have both monthly and YTD figures on a single report, as this is the preference of my Board. Currently, the only way to achieve this is to run two separate reports, export them as csv, then merge them together. This works okay-ish so long as both reports have the same account line items, otherwise the raw data doesn't line up. THere is also a fair amount of formatting involved.
Any way to be able to pull monthly and YTD income figures together?
3 votes- 12/4/2024:Financials: Updated the printing of Financials. This update will allow users to add headers and footer content to printed financial statements along with customizing report titles and columns. In Financials, users will find Content in the left-side menu. This will allow for financial_publish_header and financial_publish_footer. These content areas will be html compatible with the following merge fields: report date, title (this will pull the title from the Financials Settings), filter values, report timestamp, and report title. Settings is also a new left-side menu that will allow users to rename their reports. For example, Balance Sheet can be changed to Statement of Financial Position. When processing a financial report, users will see a new left-side menu option called Publish. Print will be a print option with the header and footer content areas added. Print will remove all lines on the report and it will print on a white background.…
-
Balance sheet comparison over years
Much like one can run an Income Statement for a fund over several years, and choose 'Financial Year' to see the individual year activity, it would help to have that same functionality for the balance sheet. Currently one can only choose 'Year over Year' and thus has to run the report several times to provide the same view that is easily available with the Income Statement.
7 votesIn Financials, there is a Balance Trend report in the left side menu. Selecting that option will allow you to enter a static start and end date. Choose the range of years you would like to see in columns, then show date. After the report populates, select Edit Options and select financial year. That will give you each year in a column view. Please contact support if you have any further questions.
-
current year over next year budget report
Leading up to the new year, when we are setting our budget for next year, it would be ideal for us to be able to generate a report that will compare the two years and show current year actuals as well. I can export an income statement for the current year with the budget option and then in Excel combine that with our next year budget, but I'd like it to be a built in feature in the budgeting module.
1 vote12-13-2024:Financials: Added YTD Budget with Prior Year actual to Edit Options on the Income Statement. This report will show the date range of the report in the actual column, budget for the date range, YTD Actual, YTD, Budget, YTD difference, Year Actual, Difference, and Prior Year Actual.
-
Qtrly Income Statement over longer periods needs to show older quarters first
Somehow, when I just ran a quarterly income statement since 2000, the most recent quarter showed up in the most left-hand column. NOT HELPFUL! Please rearrange so that the oldest period appears first so that proper flow appears and analysis can be done, AND it can be shared with the donor who can more easily understand the real-world activity of their fund and not a funky audited-financial-based view. I've not seen this before; someone must have thought they were 'helpful' but, sadly, no - especially for anything longer than 1 quarter. (OR please provide a toggle to allow one view…
1 voteBecause we know that all foundations present their financials differently, a new print option has been added. This will allow you to determine the order of the columns. The recommended presentation per the AICPA is most recent column first. That is why financials default to newest period first.
-
Financial Report Editing - Add heading to each page & rounding option
Allow options when printing reports directly from C Suite to show headings on multiple pages and remove decimal points.
4 votes12/16/2024:Financials: Added the ability to round financial reports. Users can find this new option in Edit Options, Round. Default will remove rounding, Rounding options are to the nearest: One, Ten, Hundred, Thousand, Ten Thousand, Hundred Thousand, Million. This will be using normal rounding rules. The rounding follows standard rounding rules (rounding up if 5 or more, rounding down if less than 5).
Important Notes:
Potential Imbalance: When using rounding, totals in reports may become unbalanced due to rounding differences across individual items.
- 12/4/2024:Financials: Updated the printing of Financials. This update will allow users to add headers and footer content to printed financial statements along with customizing report titles and columns. In Financials, users will find Content in the left-side menu. This will allow for financial_publish_header and financial_publish_footer. These content areas will be html compatible with the following merge fields: report date, title (this will pull the title from the Financials Settings), filter…
-
Display zero balance and unused accounts as zeros
PLEASE consider including all accounts in balance sheet and income statement reports. The condensed view is nice on screen but it would be infinitely more helpful either to see them, or at least to have them export as zeros. It would save so much time in multi-fund reporting to accurately copy and paste columns of figures including zeros and unused accounts knowing they would all land in their respective cells in a spreadsheet containing the full GL. If this functionality exists, please let me know how to produce it!
1 vote12/16/2024:Financials: Added two new options in the Edit Options on several of the financial reports. This will be the ability to Include Zero Balances and Include Closed Accounts. When Including Closed Accounts users will also want to show Include Zero Balances.
These options will not be available when using Financial Views or on these financial reports: Audit Report, Fund Balance, Audit Balances, Underwater Report, Functional Expense, Investment Report, or the Inception Report.
-
Date and time created added to all financial reports
It would be nice to have the date and time you created a financial report to be printed on them. I may have printed two reports and needs to see which one was first.
19 votes12/4/2024:inancials: Updated the printing of Financials. This update will allow users to add headers and footer content to printed financial statements along with customizing report titles and columns. In Financials, users will find Content in the left-side menu. This will allow for financial_publish_header and financial_publish_footer. These content areas will be html compatible with the following merge fields: report date, title (this will pull the title from the Financials Settings), filter values, report timestamp, and report title. Settings is also a new left-side menu that will allow users to rename their reports. For example, Balance Sheet can be changed to Statement of Financial Position. When processing a financial report, users will see a new left-side menu option called Publish. Print will be a print option with the header and footer content areas added. Print will remove all lines on the report and it will print on a white background.…
-
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.
-
Column Options and Order for Financial Statements - SOA & SFP
Could you please consider updating financials to include easier options as to which columns to pull in and it what order when you need a number of columns on the report? (e.g., monthly amounts for current year/prior year/budget, year-to-date amount for current year/prior year/budget, and associated dollar and % variances between any two columns)? For our board report, we currently have to pull together three templates into another custom report, then extract numbers from that custom report, delete various columns, and then drop that into an Excel file. Overall, your software is great, but the limitations with column setup in…
13 votes- 12/4/2024:Financials: Updated the financial reporting to roll up the left-side menu once a report is selected. This will allow for options in the left-side menu to be more visible to users. We have updated the columns for Month over Month, Year over Year, and etc. to display the date range of the column header. If the financial report is over 2 time periods, the Change and Percent columns will display.
- Financials: Added Fund Custom fields to as an Edit option. This will allow for users to have columns based on fund custom fields.
- Financials: Renamed the Cash Flow report to Balance Change. This report shows balances over a time frame. This will help when tracking change in balances for the Balance Sheet accounts.
- Financials: Renamed the Cash Balance Report the Balance Trend report. This will allow users to track trends of the balance sheet accounts. Because…
-
Budget to actual reporting
Have the ability to customize financial reports with funds across the top for the budget to actual reports.
3 votes12/18/2024:Financials: Added YTD Budget with Prior Year actual to Edit Options on the Income Statement. This report will show the date range of the report in the actual column, budget for the date range, YTD Actual, YTD, Budget, YTD difference, Year Actual, Difference, and Prior Year Actual.
-
+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
-
YTD Budget view comparison of two different years
I would like to be able to pull a financial report that would give me current month actual, annual budget, ytd actual and prior year month actual, and prior year ytd actual. We currently give our board current year information and prior year information to determine how we are doing.
24 votes12-13-2024:Financials: Added YTD Budget with Prior Year actual to Edit Options on the Income Statement. This report will show the date range of the report in the actual column, budget for the date range, YTD Actual, YTD, Budget, YTD difference, Year Actual, Difference, and Prior Year Actual.
-
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.
- Don't see your idea?