Financial Reports Overview
Within Financials, you can access the following Reports: Balance Sheet (Statement of Financial Position): Shows Assets, Liabilities and Equity based on the balance of each account on a single date for the foundation as a whole by default. This report can be configured to show balances by individual fund, fund types, fund groups, year over year comp...
Create Financial Views
Navigate to Accounts from the Home page. Click Financial Views from the left-side menu. Click Create from the left-side menu. Enter a Name for your Financial View. Example: Board Monthly Click Create. Next, add a Financial View Group from your Chart of Accounts. Click Add Group from the left-side menu. Select the Type of Accounting Group: Assets Lia...
Balance Sheet
The Balance Sheet or Statement of Financial Position shows Assets,Liabilities and Equity (based on the balance for a single date for funds, fund types, fund groups, year over year, month, year, future). Some describe the balance sheet as a "snapshot" of the organizations' financial position at a point in time. For example, the amounts reported on a...
Income Statement*
The Income Statement (aka Statement of Activities) measures the change in net assets for a specified time period. To run a Income Statement: Go to Financials Select Income Statement from the left menu Select or enter the desired date range. The statement will generate. Once the Income Statement is generated you may: Change the statement dates b...
Cash Flow
Cash Flow shows a change in the balance for your for Assets, Liabilities and Equity for a specific date range. Edit the date range at the top of the page for cash flow reporting by selecting [edit] highlighted in blue. Choose Show Detail from the left side of the page to get more detail about the Assets, Liabilities and Equity Use the middle drop-d...
Cash Balance
The Cash Balance financial report will show you the assets you have for that particular period of time. Run a Cash Balance to see Foundation Assets, Liabilities and Equity for a date or a date range. The Cash Balance financial report Includes Daily, Monthly, Quarterly and Yearly reporting. This report is similar to running a Balance report for each ...
Fund Balance
Fund Balance is a report in Financials that shows the total, the principal and the spendable balance for specified Funds. The balances are initially set up during your implementation. This data will show you the Fund, Fund Group (eg. Fiscal sponsorship, Unrestricted, Agency, etc). The columns include Permanently Restricted (PR), Temporarily Restric...
Trial Balance*
This financial report will show you the total amounts by account. You can view the debits and credits that make up the totals. Go to Financials Select Trial Balance from the left side of the screen Select the date (don't worry you can edit this at any time) The system will generate a report with the balance for the date you choose for all the line i...
Detail Trial Balance
The detail trial balance report will generate a report that shows your accounts' beginning and ending balances. To generate a detail trial balance report: Go to Financials Select Detail Trial from the left side of the screen Choose a date range Once a date range has been selected, the data within that date range will populate the table. For more inf...
Example Financial View*
Here is an example of one way to create a comprehensive Financial View Account called "Operating Expenses." All of the accounts will be rolled up and the total will be displayed as one number in the subsequent financial report as “Operating Expenses”. Compare the difference between a “Default” View Income Statement and an Income Statement or Statem...
Run a Financial Report using Financial Views
After creating one or more “Financial Views” you can use the view in Financial Reports. A Financial report generated using Financial Views is generally more streamlined. Click Financials along the top menu or from the Core section of the Home screen. Select the type of financial report you want to run from the left side menu On the left side menu of...
Run a Financial Report with Sub Funds
Make a Fund a Sub-Fund of another Fund in order to roll up both Funds into one line item on your Financial reports. Go to Financials Select a financial report from the left menu Select the Date Range The financial report will show the parent fund only but the assets of both funds will be combined. Notice that you can break out and show the subfunds...
Audit Report
The Audit Report shows the Fund Balance Change in a table with the Beginning Investment Income total, Support (total donations/grants), Administration fee total, Other Expenses, Program Expenses (like grants/scholarships paid out) and the Ending Balance for each Fund. This report is the same as a Columnar Report. It includes totals for all income an...
Investment Report
Overview The Investment Report can be used to report on investment activity by investment account and level. Components Investment Accounts Setup First, you'll need to define the investment level for each investment account that you want to report on. Select Accounts from the Home page. Select an investment account. Click Edit. Select an Investmen...
