Exporting soft credits
Hello everyone,
For better or worse, we have a lot of soft credits in our database and it frustrates me that I can't do a query on total giving while at the same time asking to see fund split amount and soft credit name.
I've worked around this by running a query, then putting the query through export, but I'm still encountering issues.
My query is for all constituents with any giving that have an organization relationship on their record, so I ran a query for total giving greater than $0 (and filtered for particular gift types and gift codes) and organization relation organization name not blank. This gave me a list of 591 constituents, with some duplicates because some folks had more than one organizational relationship on their record.
So I took the query and ran it through export, and asked for constituent name, organization name, organization relationship, organization reciprocal relationship, soft credit amount, soft credit name, and total gift amount. I asked for the output to give me one gift per constituent and one soft credit gift per constiuent.
There aren't a lot of soft credits with this list, so I eyeballed a few of these folks to make sure the total giving and soft credit giving amounts were correct. Total giving works fine, but for soft credit, because I only requested one gift per constiuent, I'm only getting the first instance of a soft credit rather than all soft credits. For instance, Bob Jones gave a total of three $100 gifts, all of which were soft credited to his spouse, Sally. I see $300 total giving for Bob, but only $100 as the soft credit amount.
Are they any options for seeing all soft credits, or a better way to approach this? Thanks very much for any and all advice!
Comments
-
Amy Disch:
Since you're doing the analysis outside of RE anyway, could you start with a gift query and sum things up in Excel or Access? That way you'd have one line per gift, with the gift amount, the donor name and the soft credit name and amount in separate columns.Hello everyone,
For better or worse, we have a lot of soft credits in our database and it frustrates me that I can't do a query on total giving while at the same time asking to see fund split amount and soft credit name.
I've worked around this by running a query, then putting the query through export, but I'm still encountering issues.
My query is for all constituents with any giving that have an organization relationship on their record, so I ran a query for total giving greater than $0 (and filtered for particular gift types and gift codes) and organization relation organization name not blank. This gave me a list of 591 constituents, with some duplicates because some folks had more than one organizational relationship on their record.
So I took the query and ran it through export, and asked for constituent name, organization name, organization relationship, organization reciprocal relationship, soft credit amount, soft credit name, and total gift amount. I asked for the output to give me one gift per constituent and one soft credit gift per constiuent.
There aren't a lot of soft credits with this list, so I eyeballed a few of these folks to make sure the total giving and soft credit giving amounts were correct. Total giving works fine, but for soft credit, because I only requested one gift per constiuent, I'm only getting the first instance of a soft credit rather than all soft credits. For instance, Bob Jones gave a total of three $100 gifts, all of which were soft credited to his spouse, Sally. I see $300 total giving for Bob, but only $100 as the soft credit amount.
Are they any options for seeing all soft credits, or a better way to approach this? Thanks very much for any and all advice!
0 -
Amy Disch:
Hello everyone,
For better or worse, we have a lot of soft credits in our database and it frustrates me that I can't do a query on total giving while at the same time asking to see fund split amount and soft credit name.
I've worked around this by running a query, then putting the query through export, but I'm still encountering issues.
My query is for all constituents with any giving that have an organization relationship on their record, so I ran a query for total giving greater than $0 (and filtered for particular gift types and gift codes) and organization relation organization name not blank. This gave me a list of 591 constituents, with some duplicates because some folks had more than one organizational relationship on their record.
So I took the query and ran it through export, and asked for constituent name, organization name, organization relationship, organization reciprocal relationship, soft credit amount, soft credit name, and total gift amount. I asked for the output to give me one gift per constituent and one soft credit gift per constiuent.
There aren't a lot of soft credits with this list, so I eyeballed a few of these folks to make sure the total giving and soft credit giving amounts were correct. Total giving works fine, but for soft credit, because I only requested one gift per constiuent, I'm only getting the first instance of a soft credit rather than all soft credits. For instance, Bob Jones gave a total of three $100 gifts, all of which were soft credited to his spouse, Sally. I see $300 total giving for Bob, but only $100 as the soft credit amount.
Are they any options for seeing all soft credits, or a better way to approach this? Thanks very much for any and all advice!
If you want to stick with your export, just change the # of gifts you want to see in the export. If you put "5" and they only have 1, you'll just get 1.
0 -
JoAnn Strommen:
If you want to stick with your export, just change the # of gifts you want to see in the export. If you put "5" and they only have 1, you'll just get 1.
Thank you JoAnn. I'll try adjusting the number of gifts. Picking a number is a bit tricky for me because I don't want to go too low and miss any soft credits. Some of the gifts in our database have several people soft-credited.
0 -
James Andrews:
Since you're doing the analysis outside of RE anyway, could you start with a gift query and sum things up in Excel or Access? That way you'd have one line per gift, with the gift amount, the donor name and the soft credit name and amount in separate columns.Thank you James. I'll try a gift query and running it through export as well, and will see how that works when I'm back in the office tomorrow.
0 -
Did you find a solution? We are having the same problem with soft credits.
I want to run one report that lists all donors with a) total giving/pledged to a certain campaign b) how much has been paid on that pledge and c) the balance on the pledge.
Since we have many individuals listed as soft credits for private company gifts, both the individual and the company are on the report...therefore we are double counting.
0 -
Did you find a solution? We are having the same problem with soft credits.
I want to run one report that lists all donors with a) total giving/pledged to a certain campaign b) how much has been paid on that pledge and c) the balance on the pledge.
Since we have many individuals listed as soft credits for private company gifts, both the individual and the company are on the report...therefore we are double counting.
0 -
Kristin, Not quite sure if I am missing something here, but for your report the canned "Pledge Status report" under "Reports/ Pledge and Recurring gift reports" should work, it has the option to choose soft credit gift to: the Donor. That would avoid the double counting.0
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™
- 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
- 3 Blackbaud Staff Discussions
- 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