Core Nonprofit Reports
General Overview of Various Nonprofit Reports:
http://www.nonprofitaccountingbasics.org/sites/default/files/FinancialReportsInventoryExample.pdf
Financial & Core Management Reports
Statement of Activities
http://www.nonprofitaccountingbasics.org/reporting-operations/statement-financial-activities
Preparing the Statement of Activities in NetSuite
The following instructions are for preparing a statement of activities in the format here: http://www.cof.org/files/Documents/WebNotebook/December2003/ABC_Sample_FS.pdf
It is assumed that the financial dimensions are configured in the preferred NetSuite structure.
In general, most nonprofits use the comparative income statement with column set to "Fund" for operational management of activities. This is native & real time inside of NetSuite & can be emailed to executives and board members on a regular basis if so desired.
- Unrestricted, temporarily restricted and permanently restricted columns
- Run the NetSuite income statement for the current period
- Set column to "Fund" (NetSuite Class)
- Export to Excel, transfer key values to your Statement of Activities in your preferred format.
- Run the NetSuite income statement for the current period
Current year and prior year columns
Run the NetSuite comparative income statement for the current period
- Do not set the report column
- Export to Excel, transfer key values for the prior year to your Statement of Activities in your preferred format
- Net Assets beginning of the year
- Run the NetSuite balance sheet for the beginning of the year
- Modify so Equity is broken out from Liabilities
- Set column to "Fund" (NetSuite Class)
- transfer key values for the prior year to your Statement of Activities in your preferred format
- Run the NetSuite balance sheet for the beginning of the year
- Net Assets end of year
- Run the NetSuite balance sheet for the end of the year
- Modify so Equity is broken out from Liabilities
- Set column to "Fund" (NetSuite Class)
- transfer key values for the prior year to your Statement of Activities in your preferred format
- Run the NetSuite balance sheet for the end of the year
- Change in Net Assets
- Calculate in your your Statement of Activities in your preferred format
Statement of Financial Position
http://www.nonprofitaccountingbasics.org/reporting-operations/statement-financial-position
The following instructions are for preparing a statement of financial position in the format here: http://www.cof.org/files/Documents/WebNotebook/December2003/ABC_Sample_FS.pdf
It is assumed that the financial dimensions are configured in the preferred NetSuite structure.
Preparing the Statement of Financial Position in NetSuite
- Run the NetSuite balance sheet for the end of the year
- Modify so Equity is broken out from Liabilities
- Set column to "Fund" (NetSuite Class)
Statement of Functional Expenses
The following instructions are for preparing a statement of functional expenses in the format here: http://www.cof.org/files/Documents/WebNotebook/December2003/ABC_Sample_FS.pdf
It is assumed that the financial dimensions are configured in the preferred NetSuite structure.
In general, most nonprofits modify the standard income statement to display only expense information with column set to "Fund" for operational management of functional expenses. This is native & real time inside of NetSuite & can be emailed to executives and board members on a regular basis if so desired.
- Program, Management & General, and Fundraising columns
- Run the NetSuite income statement for the current period
- Set column to "Fund" (NetSuite Class)
- Export to Excel, transfer key values to your Statement of Functional Expenses in your preferred format.
- Discard revenue information
- Run the NetSuite income statement for the current period
Current year and prior year columns
Run the NetSuite comparative income statement for the current period
- Do not set the report column
- Export to Excel, transfer key values for the prior year to your Statement of Functional Expenses in your preferred format
Statement of Cash Flows
The following instructions are for preparing a statement of financial position in the format here: http://www.cof.org/files/Documents/WebNotebook/December2003/ABC_Sample_FS.pdf
It is assumed that the financial dimensions are configured in the preferred NetSuite structure.
- Use the NetSuite native cash flow statement.
Samples:
http://www.philanthropynewyork.org/s_nyrag/bin.asp?CID=15583&DID=36800&DOC=FILE.PDF
http://www.cof.org/files/Documents/WebNotebook/December2003/ABC_Sample_FS.pdf
Other Management Reports
Activity Reporting
Funding Source/ Grant Reporting
Project Reporting
Revenue Detail Reporting
Location / Geography Reporting
Subsidiary Reporting