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 for a single date for funds, fund types, fund groups, year over year, month, year, future). Income Statement (Statement of Activities) - shows Revenue and Expense Accounts for a date r...
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*
Do you need the detail for ALL transactions ? Go to Financials Select Detail Trial from the left side of the screen Choose a date range The system will generate a report that shows your Fund(s), associated Account(s), Post Date(s), Debits, Credits and the Balance(s) for a specified date range....
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...
Export Financials*
Go to Financials Run any financial report Select the proper dates Choose Export located on the left side menu The information you see along with additional data will be downloaded to your computer as a .CSV file. You can import the CSV file into any spreadsheet program like Excel or Google Spreadsheets to see the data. Select Automatic import or Com...
Financial Quarters*
Basic calendar year quarters are: 1st quarter: 1 January – 31 March 2nd quarter: 1 April – 30 June 3rd quarter: 1 July – 30 September 4th quarter: 1 October – 31 December Fiscal or financial year calendar quarters can vary. Examples: 1st quarter: 1 October – 31 December 2nd quarter: 1 January – 31 March 3rd quarter: 1 April – 30 June 4th quarter: 1...
Audit Report (Archived)*
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...