Annual Statement Letters for donors?

Elizabeth Shafer
Elizabeth Shafer
Fourth Anniversary Name Dropper Participant Facilitator 1
in Blackbaud Altru® General Discussions

Hi, All!

If there are already threads about this, I'd appreciate being directed to those!

Otherwise, I need to send Annual Statement letters to certain donors, with their Total Giving, and the (receipt) amount of tax-deductible giving.

I've followed a couple of KB articles, but the output shows more than just last calendar year giving (the SUM Revenue Amount is off by THOUSANDS), and Membership Benefits are subtracted in the actual statments (run under Revenue), but not form the Revenue in the query output.

How do you all do these?

THANK YOU FOR YOUR HELP!

Tagged:

Comments

  • Tami Goertzen
    Tami Goertzen
    Seventh Anniversary Kudos 3 Altru Fall 2025 Product Update Briefing Badge Name Dropper

    @Elizabeth Shafer I'm not sure if this helps, but I use Smart Fields to pull those reports. I have a Smart Field for 2023 donations, then I pull the report on that Smart Field.

  • Elizabeth Shafer
    Elizabeth Shafer
    Fourth Anniversary Name Dropper Participant Facilitator 1

    @Tami Goertzen Thank you, Tami!

    I tried a Constituent Revenue Amount Smart field, but got numbers that didn't resonate with anything else – I do wonder if I set it too broadly.

    I settled (so far) on the KB article about sending letters, and the query for that, but am using a spreadsheet for a merge, so I can spot-check and update any odd amounts.

    Can you tell me which Smart Field you use?

    Thanks again!!!!!!

    I knew how to do this in Raiser's Edge, but Altru is “just” different enough to make it nearly impossible! ?

  • Tami Goertzen
    Tami Goertzen
    Seventh Anniversary Kudos 3 Altru Fall 2025 Product Update Briefing Badge Name Dropper

    @Elizabeth Shafer It is the Constituent Revenue Amount. We only check Donation and Recurring Gifts. If you have more selected, it might give different amounts.

    f93cf11a65eda64fa9bbbbe7942f3460-huge-sm


  • Elizabeth Shafer
    Elizabeth Shafer
    Fourth Anniversary Name Dropper Participant Facilitator 1

    @Tami Goertzen
    That is so helpful! (and probably a “duh” on my part ?)

    I'll give that a try ~~ thank you!

Categories