Financial reporting is a key component of managing any Foundation. CommunitySuite offers a variety of reporting tools to assist with monitoring financial activity.
Default Reports
Default reports are listed on the Financials page in the left-side menu.
Balance Sheet
The Balance Sheet or Statement of Financial Position shows assets, liabilities, and net assets (known as equity in the for-profit world). It shows a "snapshot" of an organization's financial position at a certain point in time. By default, it will show the consolidated numbers of all funds in the organization, but there are several filters available to further refine the results. The basic accounting equation that shows on the balance sheet is assets (what the foundation has or is owed) minus liabilities (what it needs to pay), which equals the foundation's net assets.
Resource: Balance Sheet Report
Income Statement
The Income Statement Report, also know as the Statement of Activities, shows revenue and expense accounts for a time period for the foundation as a whole by default. This report also allows for configurations to specific funds and fund groups.
Resource: Income Statement Report
Cash Flow
The Cash Flow Report shows a net change in the balance for assets, liabilities, and net assets for a specific date range.
Resource: Cash Flow Report
Cash Balance
The Cash Balance Report lists the assets you have for that particular period of time. Run a cash balance report to see foundation assets, liabilities, and net assets for a date or a date range. This report includes daily, monthly, quarterly and yearly reporting. It is similar to running a balance report for each month to see ending balances.
Resource: Cash Balance Report
Audit Report
The Audit Report shows the fund balance change with the beginning investment income total, support(R), expense(E), program(E), other expense(E), payroll expense(E), net assets(OE), and the ending balance for each fund. This report is the same as a columnar report. It includes totals for all income and expenses. The change in fund balance from one date’s beginning balance to the ending balance and the total amounts that make up the change are available.
Resource: Audit Report
Fund Balance
The Fund Balance Report shows the fund balance, principal, spendable, and default balances for specified funds. If the restrictions (PR [permanently restricted], TR [temporarily restricted], U [unrestricted]) are set on funds, it will also list amounts broken into each balance. This report also allows for configurations to fund group and subgroup.
Resource: Fund Balance Report
Trial Balance
The Trial Balance Reports shows the total debit and credit balances for each account on a given day.
Resource: Trial Balance Report
Detail Trial
The Detail Trial Balance Report shows the beginning balance, total debits, total credits, and ending balance of each account over a date range.
Resource: Detail Trial Balance
Under Water
The Underwater Report, also known as the Fund Underwater Report, subtracts the principal balance of a fund from the total balance of a fund to calculate the underwater amount. Funds are only listed in this report if their underwater amount is negative.
Func Expense
The Func Expense Report, also known as Statement of Functional Expenses, shows the amounts of expenses by both their natural classification and their functional classification.
Resource: Statement of Functional Expenses Report
Investment Report
This report will display data account by account based on the investment level. The report lists beginning and ending investment balance, all revenue share activity, deposits, and withdrawals.
Resource: Investment Report
Additional Reports
990 Report
Form 990 is required by law from tax-exempt organizations and nonexempt charitable trusts. It provides the IRS with information on the organization's mission, programs, and finances.
Resource: 990 Report
Donations Exceeding Report
The Donations Exceeding Report provides helpful information when completing the 990 report. Generate the report for a list of individual or organization donors who gave more than a specified amount.
Resource: Donation Exceeding Report
Grantees Exceeding Report
The Grantees Exceeding Report provides helpful information when completing your 990 report. Generate the report for a list of individual or organization grantees who received more than a specified amount.
Resource: Grantees Exceeding Report
Public Support Report
A Public Support Report provides helpful information when completing your 990 report. This report is generally used by auditors.
Resource: Public Support Report
Use Budget for Reporting
The Budget Report shows a comparison of budget versus actual on a Statement of Activities. There are different options to report on budget such as consolidated view, by fund, or year to date.
Resource: Use Budget for Reporting