Campaigns, Appeals, Packages and Funds Coding
We are cleaning up our coding in Campaigns, Appeals, Packages, and Funds. It has never been used consistently (unfortunately). We are a Children's Health Foundation who fund three main Health Care Partners, plus an "Undesignated" fund.
What I am proposing is:
Campaign = Health Care Partners (i.e. Hospital, Children's Research Centre, Children's Rehab Centre, Undesignated)
Appeal = Solicitation type (so, FTF, Signature Event, Direct Mail, Radiothon, etc)
Package= specific to the appeal (segmentation of DM program, etc)
Fund = Designation - which is tied to the Campaign, (so Cancer Research would be tied to the Children's Research Centre, if "General Fund" then that would be tied to "Undesignated")
I would track the giving level in the "Gift Code" field which would talk directly to our budget line, i.e. Major Gift, Annual Gift, Signature Events, Legacy, Tribute, etc)
The one piece missing is the coding of the fund to the grant, I'm not sure how that would be done unless I re-create the funds to the grant bucket(s), or is this where we need the Grants Module.
Any alarm bells with the above? Any advice on this would be greatly appreciated!
Thanks Rita
Comments
-
Not sure exactly what you are desiring for coding fund to the grants, but you do still have the 'gift sub-type' field on every gift record that you can link to GL accounts or not. We have a mix, some gift sub-types link to GL account, others are for informational purposes.
Everyone uses RE differently. Your C/F/A/P structure makes sense to me.
Don't know much about RE & Grants.1 -
I agree with everything JoAnn said: it looks pretty good from an outsider's perspective and, yeah, every organization will be unique.
If specific funds are tied to specific grants (I'm not entirely sure if I understand that, either) then you may want to simply change the Fund type, category or include an attribute on funds to designate the grant. We have learned to use Fund Attributes pretty well, to the point where we can slice-and-dice our data in reports based on the gifts given to hundreds of different funds.Rita Nicholson:
Hello,
We are cleaning up our coding in Campaigns, Appeals, Packages, and Funds. It has never been used consistently (unfortunately). We are a Children's Health Foundation who fund three main Health Care Partners, plus an "Undesignated" fund.
What I am proposing is:
Campaign = Health Care Partners (i.e. Hospital, Children's Research Centre, Children's Rehab Centre, Undesignated)
Appeal = Solicitation type (so, FTF, Signature Event, Direct Mail, Radiothon, etc)
Package= specific to the appeal (segmentation of DM program, etc)
Fund = Designation - which is tied to the Campaign, (so Cancer Research would be tied to the Children's Research Centre, if "General Fund" then that would be tied to "Undesignated")
I would track the giving level in the "Gift Code" field which would talk directly to our budget line, i.e. Major Gift, Annual Gift, Signature Events, Legacy, Tribute, etc)
The one piece missing is the coding of the fund to the grant, I'm not sure how that would be done unless I re-create the funds to the grant bucket(s), or is this where we need the Grants Module.
Any alarm bells with the above? Any advice on this would be greatly appreciated!
Thanks Rita
3 -
thanks Tom and JoAnne.
Here's an example of what I'm trying to do. We want to track down to the grant level. We have 38 grants across 3 health care partners. So for instance: Children's Hospital has 5 granting areas, Clinical Support, Patient & Family Assistance, Research, Education, and Equipment. Within each area we have multiple grants, so for Clinical Support we have 3 different grants. If a donor makes a major gift and wants to split the gift into multiple grants how could I do that. Is it possible in RE? How could attributes work for this example? Really appreciate your help.
Donor A:
Amount: $50,000
Campaign: Children's Hospital
Appeal: Personal FTF
Package: N/A
Gift Code: Major Gift
Fund: Split: Clinical Support ($25,00) and Equipment ($25,000)
Grant: Clinical Support, $12,500 to Mental Health, $12,500 to Mobile Applications for Mental Health
Grant: Equipment - $25,000 to Special Beds.
*************************************************************************************************************************
Tom Klimchak:
I agree with everything JoAnn said: it looks pretty good from an outsider's perspective and, yeah, every organization will be unique.
If specific funds are tied to specific grants (I'm not entirely sure if I understand that, either) then you may want to simply change the Fund type, category or include an attribute on funds to designate the grant. We have learned to use Fund Attributes pretty well, to the point where we can slice-and-dice our data in reports based on the gifts given to hundreds of different funds.Rita Nicholson:
Hello,
We are cleaning up our coding in Campaigns, Appeals, Packages, and Funds. It has never been used consistently (unfortunately). We are a Children's Health Foundation who fund three main Health Care Partners, plus an "Undesignated" fund.
What I am proposing is:
Campaign = Health Care Partners (i.e. Hospital, Children's Research Centre, Children's Rehab Centre, Undesignated)
Appeal = Solicitation type (so, FTF, Signature Event, Direct Mail, Radiothon, etc)
Package= specific to the appeal (segmentation of DM program, etc)
Fund = Designation - which is tied to the Campaign, (so Cancer Research would be tied to the Children's Research Centre, if "General Fund" then that would be tied to "Undesignated")
I would track the giving level in the "Gift Code" field which would talk directly to our budget line, i.e. Major Gift, Annual Gift, Signature Events, Legacy, Tribute, etc)
The one piece missing is the coding of the fund to the grant, I'm not sure how that would be done unless I re-create the funds to the grant bucket(s), or is this where we need the Grants Module.
Any alarm bells with the above? Any advice on this would be greatly appreciated!
Thanks Rita
1 -
Rita, So, if I understand you correctly each Fund (Clinical Support) might have sub-components/grants that designate what the money is to be spent on (clinical support, mobil app, etc.)
Right?
In our organization we would probably do that with multiple funds (essentially what you said about tying funds to grant buckets)... So we might have something like this:
Fund ID 1000 1050 1100 2000 2050
This is what it might look like if you made a separate Fund record for each grant, and use the Fund Type field (or category or an attribute field) to designate the overall "fund" in your case.
Depending upon your situation you may need to also coordinate all this with your accounting office.
That's how we would approach the problem, but I'm sure there are other clever solutions...
0 -
AWESOME, thanks so much Tom. I actually started down that path yesterday afternoon but didn't get very far. This is great help and very much appreciated.
Rita
Tom Klimchak:
Rita, So, if I understand you correctly each Fund (Clinical Support) might have sub-components/grants that designate what the money is to be spent on (clinical support, mobil app, etc.)
Right?
In our organization we would probably do that with multiple funds (essentially what you said about tying funds to grant buckets)... So we might have something like this:
Fund ID 1000 1050 1100 2000 2050
This is what it might look like if you made a separate Fund record for each grant, and use the Fund Type field (or category or an attribute field) to designate the overall "fund" in your case.
Depending upon your situation you may need to also coordinate all this with your accounting office.
That's how we would approach the problem, but I'm sure there are other clever solutions...
1 -
Rita Nicholson: Just discovered an issue. Donors are giving to Clinical Support or Equipment, not necessarily down to the actual grant level, we make the decision which grant to apply the funds to in some cases, so I'm wondering if I can reverse this, so the Fund ID = Clinical Support, and the category or type = Mental Health, or Mobile Applications, but the issue with this is it's one-to-one, one fund to one category. I can't choose which grant the actual donation gets applied to.
AWESOME, thanks so much Tom. I actually started down that path yesterday afternoon but didn't get very far. This is great help and very much appreciated.
Rita
Tom Klimchak:
Rita, So, if I understand you correctly each Fund (Clinical Support) might have sub-components/grants that designate what the money is to be spent on (clinical support, mobil app, etc.)
Right?
In our organization we would probably do that with multiple funds (essentially what you said about tying funds to grant buckets)... So we might have something like this:
Fund ID 1000 1050 1100 2000 2050
This is what it might look like if you made a separate Fund record for each grant, and use the Fund Type field (or category or an attribute field) to designate the overall "fund" in your case.
Depending upon your situation you may need to also coordinate all this with your accounting office.
That's how we would approach the problem, but I'm sure there are other clever solutions...
0 -
Hmm... You have a a couple options (I think):
1. You could create general funds (Clinical Support, Equipment, Etc) and just track the "grant" for each gift in a Gift Attribute. So the overall Fund would just be Clinical Support, but each and every gift to Clinical Support would have to have an attribute assigned to it showing the Grant area. That seems pretty straight-forward in my mind.
2. You could stick with the example I gave and just have a "Clinical Support - General" fund for things that don't go to specific grants. If you have someone who gave $50,000 to two grants you could list the Fund CATEGORY on the acknowledgement letters and the donor would see "Clinical Support" but in your records it would be Clinical Support - Mental Health" and "Clinical Support - Mobile Apps"....
I don't know if you split gifts (use one gift with multiple funds) or do single gift records (two gift records, one for each designation) at your shop. This all might work a little better if you did NOT split gifts.
Not sure if that helps or just makes things trickier
Rita Nicholson:
Hello,
We are cleaning up our coding in Campaigns, Appeals, Packages, and Funds. It has never been used consistently (unfortunately). We are a Children's Health Foundation who fund three main Health Care Partners, plus an "Undesignated" fund.
What I am proposing is:
Campaign = Health Care Partners (i.e. Hospital, Children's Research Centre, Children's Rehab Centre, Undesignated)
Appeal = Solicitation type (so, FTF, Signature Event, Direct Mail, Radiothon, etc)
Package= specific to the appeal (segmentation of DM program, etc)
Fund = Designation - which is tied to the Campaign, (so Cancer Research would be tied to the Children's Research Centre, if "General Fund" then that would be tied to "Undesignated")
I would track the giving level in the "Gift Code" field which would talk directly to our budget line, i.e. Major Gift, Annual Gift, Signature Events, Legacy, Tribute, etc)
The one piece missing is the coding of the fund to the grant, I'm not sure how that would be done unless I re-create the funds to the grant bucket(s), or is this where we need the Grants Module.
Any alarm bells with the above? Any advice on this would be greatly appreciated!
Thanks Rita
0 -
Rita Nicholson: funny, I just me with our director of finance and we discussed your option 1 as the way to go. Question: I dont' usually do split gifts, never worked in the other software I used, but I'm new to Raiser's Edge. What are the downfalls to splitting gifts, other than duplicates in reporting. I've been using the giftsplit table amount which actually splits the total amount donated, which seems to solve the duplication issue. Is there another issue I should be aware of?
Rita Nicholson: Just discovered an issue. Donors are giving to Clinical Support or Equipment, not necessarily down to the actual grant level, we make the decision which grant to apply the funds to in some cases, so I'm wondering if I can reverse this, so the Fund ID = Clinical Support, and the category or type = Mental Health, or Mobile Applications, but the issue with this is it's one-to-one, one fund to one category. I can't choose which grant the actual donation gets applied to.
AWESOME, thanks so much Tom. I actually started down that path yesterday afternoon but didn't get very far. This is great help and very much appreciated.
Rita
Tom Klimchak:
Rita, So, if I understand you correctly each Fund (Clinical Support) might have sub-components/grants that designate what the money is to be spent on (clinical support, mobil app, etc.)
Right?
In our organization we would probably do that with multiple funds (essentially what you said about tying funds to grant buckets)... So we might have something like this:
Fund ID 1000 1050 1100 2000 2050
This is what it might look like if you made a separate Fund record for each grant, and use the Fund Type field (or category or an attribute field) to designate the overall "fund" in your case.
Depending upon your situation you may need to also coordinate all this with your accounting office.
That's how we would approach the problem, but I'm sure there are other clever solutions...
0 -
Rita Nicholson:
Rita Nicholson: funny, I just me with our director of finance and we discussed your option 1 as the way to go. Question: I dont' usually do split gifts, never worked in the other software I used, but I'm new to Raiser's Edge. What are the downfalls to splitting gifts, other than duplicates in reporting. I've been using the giftsplit table amount which actually splits the total amount donated, which seems to solve the duplication issue. Is there another issue I should be aware of?
Rita Nicholson: Just discovered an issue. Donors are giving to Clinical Support or Equipment, not necessarily down to the actual grant level, we make the decision which grant to apply the funds to in some cases, so I'm wondering if I can reverse this, so the Fund ID = Clinical Support, and the category or type = Mental Health, or Mobile Applications, but the issue with this is it's one-to-one, one fund to one category. I can't choose which grant the actual donation gets applied to.
AWESOME, thanks so much Tom. I actually started down that path yesterday afternoon but didn't get very far. This is great help and very much appreciated.
Rita
Tom Klimchak:
Rita, So, if I understand you correctly each Fund (Clinical Support) might have sub-components/grants that designate what the money is to be spent on (clinical support, mobil app, etc.)
Right?
In our organization we would probably do that with multiple funds (essentially what you said about tying funds to grant buckets)... So we might have something like this:
Fund ID 1000 1050 1100 2000 2050
This is what it might look like if you made a separate Fund record for each grant, and use the Fund Type field (or category or an attribute field) to designate the overall "fund" in your case.
Depending upon your situation you may need to also coordinate all this with your accounting office.
That's how we would approach the problem, but I'm sure there are other clever solutions...Rita - I am using split gifts when it applies. The main thing I had to adjust in reporting was to be sure to use the output field "Fund Split Amount" found in the funds section of queires/exports in order to get the correct amount when exporting gift amounts. If you use the "gift amount" for a split gift - it will show the FULL GIFT AMOUNT in the output field. If you use "fund split amount" in the output, it will show the appropriate amount for split and non-split gifts. This works well in RE database view well - not sure about RE NXT analysis since I haven't tried that yet.
1 -
As Gina said you need to remember to use different output field for correct reporting. Not sure if it's an option for all canned reports.
Where splits gets messy is if it's a pledge for split gift/multiple funds and you want to apply gift to certain fund. RE will automatically spread percentages to all the funds recorded in the pledge. I found it also messed up a report of anticipated revenue prepared for our auditors. We choose not to use the split gift option.
My 2 cents....2
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board