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 activity but no fund balances. It would be beneficial to have it all in a single report for 1 fund to share with the fund holders as an overview document.
Laura Kruse
shared this idea
Financials: 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
-
Susan Lotreck
commented
Yes! We would run this report often! Showing the power of endowment is frequently what our donors/agencies want to see with their own data. Our agencies have many funds thus having options/filters to run this report would be essential as well.
-
Tiffany Peterson
commented
Would greatly appreciate the option to run it for a group of funds as well. One organization may have many funds and showing the power of endowment over time in this way would be helpful for our development teams.
-
RHONA MORGAN
commented
This is very necessary for reporting to our Agencies.
-
Susan Lotreck
commented
Yes!! This report is critical for our Foundation. We used the FIMS Columnar Financial report for our agency fundholders I am currently in the process of seeing if I can do this with the audit report. So far I am learning that I have to add a multiply by -1 formula in the exported Excel file in order to make the expense values appear as negative. And then need to format the report before I could send out to agencies. And you can't select a set group of funds for with to run this for soe also need to figure out how I can split out the groups of fund by each agency. We have 28+ agencies that are accustomed to this report from our organization 4x a year.
-
The audit report should give you that information.
-
Kenneth Daniel Wiandt
commented
Would love to see a fund report that gives Beginning balance, detailed transactions for donations, investment income, grants, vouchers, and ending balance. Similar to the Fund activity report in FIMS software.
Thanks for your vote!