This is the preferred model for configuring NetSuite to manage nonprofit operations.
Solution Overview
A charity classifies income and expenses on multiple dimensions:
- Functional accounts
- Chart of Account: Standard financial account. (NetSuite Account)
- Organizational Activities
- Activity: Functional categorization of income and expenses. (NetSuite Department)
- Funds & Funding Sources (restrictions, grants, etc.)
- Restriction: Categorization of income by restriction. (NetSuite Class)
- Funding Source
- : Categorization by funding source. (NetSuite
- Class)
- Revenue Detail
- Items: Items represent the types of things you sell ― sell including donations, pledges, grants, inventory items and much more (NetSuite Items)
Many charities use chart of accounts segments to track a wide variety of additional information. NetSuite provides the capability to add two additional dimensions which can be used for its native
purpose or another purpose unique to your situation.
- NetSuite Location (or: <your renaming of location>)
- Natively tracks the geographic location of offices and/or activities.
- NetSuite Subsidiary (or: <your renaming of subsidiary>)
- Natively tracks separate legal, tax or other entities that automatically roll up into a summary financial statement.
Functional Accounts (NetSuite Account)
- We recommend the UCOA standard (http://nccs.urban.org/projects/ucoa.cfm)
Funds (NetSuite Classes)
- Unrestricted Revenue
- Temporarily Restricted Revenue
- Time Restricted Revenue
- Use Restricted Grant Revenue
- Grant A
- Grant B
- Grant C
- Grant D
- Other Time Restricted Revenue
- Other Use Restricted Revenue
- Permanently Restricted Revenue
Activities (NetSuite Departments)
- Fundraising Expenses
- Special Events
- Professional Fundraising Fees
- Management & General Expenses
- Executive
- Information Technology
- Human Resources
- Legal
- Program Expenses
- Program A
- Activity 1
- Activity 2
- Activity 3
- Program B
- Activity 4
- Activity 5
- Program C
- Activity 6
- Program A
Locations (NetSuite Locations)
- North America
- Latin America
- Europe
...
- dd
- d
- d
- d
- d
- d
...
- Africa
- Congo
- South Africa
- Senegal
- Asia
Revenue Detail (NetSuite Items)
- Gift
- Donation
- Annual Campaign
- Matching Gift
- Online Donation
- Regular Donation
- Grant
- In Kind
- Major Gift
- Pledge
- Planned Gift
- Regular Pledge
- Recurring Donation
- Donation
- Earned Income
- Product Sales
- Consulting Sales