How to query on soft credit recipients, who are head of household

When querying on constituents, who have been soft credited for a gift, sometimes a user will want to further filter the query to only use the head of household soft credits. This can then be pulled into an export. 
  1. Create a Gift Query to filter on the head of house hold soft credits: (Criteria: Soft Credit Recipient ID not blank AND This individual is head of household equals No AND This Individual is Spouse equals Yes).Be sure to change the soft credit options in Tools > Query Options > Gift Processing.
  2. Create a Constituent Query for gifts that have a soft credit. If you have other criteria that you want to use to limit the constituents being included, you would do that here. (Soft Credit Recipient ID not blank AND <any other criteria desired>).
  3. Create a Constituent Export and pull in the Query from Step #2.
  4. In the Export output, when you select the Gift information, set the Soft Credits to Donor. On the filters tab, you will use the Query created in Step #1.
  5. Additional Output to show the donor and soft credit names and amounts would be: Constituent Information > Name; Gifts > Gift Amount; Gifts > Soft Credits > Constituent Name; Gifts > Soft Credits > Amount.

This will show you the donor's name, the gift amount, the soft credit's name and the soft credit amount.

Environment

 Raiser's Edge

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.