Remember, these are just the most commonly used, and you may have fields in addition to this that you want to send to us which is not a problem!
For a downloadable version of this list, click here.
* Required Fields
Contact Field | Account ID (Contact ID) → If your previous system has an ID present, you will want to include it here to help reduce duplicates. We will import it as the External ID.
Contact Field | Contact Type → Is your contact an Individual or an Organization? i.e. John Smith versus Smith Foundation.
Donation Field | Donation Date* → All donations require an individual donation date in YYYY/MM/DD format. If this is missing, it may slow your import. Don't know the exact date? You can always assign January 1st of the respective year.
Donation Field | Amount* → What is the amount of the donation?
Donation Field | Payment Method* → How did the donor pay for the donation? If you're unsure, we will place Other into the field.
Donation Field | Fair Market Value → Is there an amount of the donation that is not tax-deductible? If so you can use this to detail that, i.e. Ticket Price $100 with $50 of it covering food.
Donation Field | Campaign → How did you raise the donation? This is typically something such as Giving Tuesday, Year-End Campaign, Spring Gala.
Donation Field | Designation → Often called Fund in other system, this is where the donor has designated the funds to go. i.e. Building Fund, Child Sponsorship, etc…
Contact Field | Full Name* → When adding a contact, you'll see the only required field is Full Name. Donor management then breaks the name down into Prefix, First, Middle, Last Names, and Suffix. Always make sure you have at least the First Name for every contact.
Contact Field | Email → While email is not required, we do recommend putting an email on all of your contacts as it will aid you in communicating with your contacts and donors. The email address is used as a unique identifier in our donor management system so each contact record must have a unique primary email address. You can check that by using conditional formatting in excel to highlight duplicate values in the email column and decide which of the records should keep that as their primary email address
Contact Field | Receive Emails? → This lets donor management know if the contact is subscribed to your emails. Simply put a True or False value for each contact.
Contact Field | Mobile Phone → This is the primary phone number for your contacts. If you're unsure if the number is mobile, put it in this field so you can test it out with the Text Messages feature.
Contact Field | Gender → Helps you understand your contact's demographics.
Contact Field | Date of Birth → Allows you to track your contact and donor's birthdays. Sending a birthday note is a great way to keep them engaged with your organization. Remember, all dates imported must be in YYYY/MM/DD format.
Contact Field | Home Phone → One of the multiple phone fields this will be their home phone, not used in the Text Message feature.
Contact Field | Formal Greeting → This allows you to assign a formal greeting to your contact, and it is used as a Merge Field when sending out a communication. i.e. Mr. and Mrs. Smith.
Contact Field | Informal Greeting → This allows you to assign an informal greeting to your contact, and it can be used as a Merge Field when sending out a communication. i.e Arlene and Jack. After import, this field can be accessed from the 'Household Details' section of a contact. Even if a contact is not part of a household, you can add an informal greeting in this area and it will be used for future communications.
Contact Field | Household Name → This field is important when you have multiple contacts in a household, and it allows you to specify what you would like their household called. This is particularly important for mailing labels when using the Direct Mail feature.
Contact Field | Home Address → This is the contact's full home address.
Contact Field | Head of Household? → Head of household designation applies formal greeting, informal greeting, and household name stored on this contact record to all other contacts that share the same address.
Contact Field | Employer → Store the contact's employer as part of their contact information.
Contact Field | Job Title → List out the contact's title at their place of employment. Important when you're working on partnering with businesses.
Contact Field | Work Email → Allows you to store a secondary email for the contact. Not used for the Email Blast feature.
Contact Field | Work Phone → Store the contact's direct work number for outreach.
Contact Field | Work Address → Store the contact's work address. Not used for the Direct Mail feature.