I have been helping my development office trying to find a report that will list the year contributions. It has to include soft credits. I found one report but found that not everything showed up - because our CEO does a payroll deduction and it gets processed as a soft credit. Luckily someone caught it but we are all worried that there are other soft credits that aren't showing up. Any help would be appreciated.
Thanks, Sally
Hey Sally,
Unfortunately many reports in Tess don't count soft credits. Current Constituent Giving by List will show you soft credits, but only if your list contains the donors with soft credits. If you create your list with the contribution criteria, donors with only soft credits won't pull into your list. Also, that report is limited in that you can't choose an end date.
However, there is a very helpful view that circulates the forums that combines hard and soft credits. From there, you can create list criteria and output set elements that will allow you to pull out donors' soft credits. I believe the SQL code for the view and the output set elements is in my old folders, but let me know if not and I can email it to you.
Thanks Juliane. I will look. If I can't find it I will send you an email. Sally