Import Historical Revenue and Expenses for Accounting Migration

Prior to migrating your accounting data into NonprofitCore, you will need to clean and organize your historical revenue and expense data for import. To help make the import process smooth, there are some standard fields that need to be included. 

To import your historical revenue and expenses, you will need to have two separate Excel files.

Below is a list of necessary fields with descriptions for each of the import files. There are also screenshots that show example data for each field within each import file.

File 1: Revenue

The fields listed below are required for your revenue import.

• Record ID - The number the system assigned to the incoming revenue.
• Date - The date of the incoming revenue.
• Account Number - This is the account number for a credit account.
• Service Name - The type of service the program is providing.
  • Examples: Education, Emergency Services, and Senior Services.
• Amount - The amount of the revenue received from the profile.
• Category - Can include Donation, In-Kind Donation, Program Fees, Grant, Event, and Dues.
• Profile GUID - Unique identifier containing a long series of letters and numbers.
• First Name 
• Last Name
• Organization
• Email - Email address associated with the individual or organization profile.

The fields listed below are optional for your revenue import.

• Description
• Debit Account Number
• Opportunity Name
• Payment Method - Method of payment used. 
  • Can include Check, Credit Card, Cash, EFT/ACH, or Other. 
• Payment Method Details
• With Restrictions - True/False. Restrictions on where the donation(s) should be applied.
• Historical - True/False
  
  • If True, the revenue entry will not impact general ledger.
• Receivable - True/False
  
  

   

The fields listed below are optional honoree and soft credit fields for your revenues import.

• Honoree Name - Individual being honored. 
• Honoree Message - Message for the honoree.
  • Limited to 255 characters per message.
• Notifyee ID
• Notifyee First Name - First name of the individual being notified.
• Notifyee Last Name - Last name of the individual being notified.
• Notifyee Email - The email address associated with the individual or organization profile.
• Notifyee Organization - Organization associated with the notifyee.
• Notify By Email - True/False
• Notify By Physical Mail - True/False
• Soft Credit Profile ID
• Soft Credit First Name
• Soft Credit Last Name
• Soft Credit Email
  

File 2: Expenses

One of the fields listed below is required for your expenses import.

• First Name and Last Name
• Organization/Household Name
• Email

The additional fields listed below are required for your expenses import.

• Record ID - The number the system assigned to the outgoing expense.
• Date - The date of the outgoing expense.
• Amount - The amount of the expense paid to the profile.
• Email - The email address associated with the individual or organization profile.
• AccountNumber - This is a credit account.
• Payable Account - The payable account associated with the outgoing expense.
• Program Service - The type of service the program is providing.
  • Examples: Education, Emergency Services, and Senior Services.

The fields listed below are optional for your expenses import.

• Description
• Due Date
• Opportunity
• Historical - True/False
  
  • If True, the revenue entry will not impact general ledger.
• Invoice Number - The invoice number associated with the outgoing expense.