Page Comparison

...

1. Implementation
   
   1. Orientation to resources
      
      1. NetSuite.org Implementation Guide
   2. Homework
2. Training
   
   1. Orientation to resources
      
      1. Grantee Training Resources
   2. Homework
3. Anatomy of the Fundraising Bundle
4. Householding
   
   1. Householding
5. Preparing your 990
   
   1. Use the UCOA methodology
6. Entering Bulk Transactions
7. In-kind donations

Grantee Questions

These questions have been submitted in advance 

...

For example, you run an event and you know have a hand written sign up sheet and a stack of checks.

NetSuite provides a few tools to help you with this:

• Quick Add (Customers (donors) only, not transactions (donations, pledges)
• CSV import. Create an excel file to upload your mass transactions
• Memorized transactions. Create a memorized transaction & then just change the customer name.
• Mass update. If transactions already exist in NetSuite, they can be updated en-mass.

In general, the csv upload is the best way to bulk upload transactions for most nonprofit use cases.   Donation and pledge templates are included in the SuiteDonor bundle.

Third party tools can also ease this process greatly. 

• http://celigo.com/products/netsuite/excel-smartclient/
  
  

How do I prepare my 990?

We recommend you follow the Unified Chart of Accounts (UCOA) methodology (http://nccs.urban.org/projects/ucoa.cfm). UCOA provides an excel file that maps their standard chart of accounts to the 990 line numbers.

1. Each account in the chart of accounts is associated with the appropriate line of the IRS form 990. Create a custom field the account record [view account, click customize, then new field] for the 990 line number. 
2. Expose the line number in an income statement or other financial report organized by account.
3. Export report to Excel
4. Total values using Excel's subtotal functionality for each IRS 990 line item
5. It is also possible to built a NetSuite financial report that does this directly by grouping the accounts by IRS 990 line number. This requires  financial report builder skills.

How do I record different in-kind donation values on the fundraising & accounting sides?

Since a donor transaction always has an accounting impact, the amount you enter associated with the in-kind item record (Charity Accounting Classification Best Practices) will be that accounting impact. If you need to record an additional or alternative amount for that in kind donation, it should be recorded in a custom field on the item record. The Suite Donor bundle automatically includes a field for deductible value on item records, but that field would need to be exposed in the transaction form (i.e. the user interface).